Hi Alan,

I always misspell most of my observations, it should be : 'Metadata
Constraint Entities'
instead of 'Metadata Integrity Identities'.

I understand and agree with you, and will leave it alone, since it doesn't
affect me anymore,
but I'm still afraid it will pop up somehow later, intermittently if it is a
FB issue and requires
such a special sequence of events :)

Me giving up after 48 years of R&D, not while alive .. lol

Enjoying programming too much
Hans

----- Original Message -----
From: "Alan McDonald" <alan@...>
To: <firebird-support@yahoogroups.com>
Sent: Saturday, January 20, 2007 9:54 PM
Subject: RE: [firebird-support] Where to go or not to go


>> More detail of sequence of events.
>>
>> Case 1:
>> 1. Prepare a MetaDate Integrity Identity Query
>> 2. Use parameter name 'A12345678901234', APIFirst, APINext .. OK
>> 3. Use parameter name 'B123456789012345', APIFirst, APINext .. Fails
>>
>> Case 2:
>> 1. Prepare a MetaDate Integrity Identity Query
>> 2. Use parameter name 'A12345678901234', APIFirst, APINext .. OK
>> 3. Use parameter name 'B123456789012345', APIFirst, APINext .. OK
>>
>> Case 3:
>> 1. Prepare a MetaDate Integrity Identity Query
>> 2. Use parameter name 'A123456789012345', APIFirst, APINext .. OK
>> 3. Use parameter name 'B12345678901234', APIFirst, APINext .. OK
>>
>> Case 4: Work Around
>> 1 Unprepare
>> 2. Prepare a MetaDate Integrity Identity Query
>> 3. Use parameter name 'A12345678901234', APIFirst, APINext .. OK
>> 4. Use parameter name 'B123456789012345', APIFirst, APINext .. Works
>>
>> Looks like I failed to convince anyone and give up :)
>>
>> Hans
>
> I'm not sure how I should have assumed from the text below... that the
> text
> from above should have been interpreted.
> I'm not sure what a "MetaDate Integrity Identity Query" is so you're way
> in
> front of my ability here.
> You shouldn't give up if you think it's an issue that you'll strike all
> the
> time in your operations. Forgive me if it sounds like I'm unconvinced or
> uninterested. I'm neither.
> Alan
>
>> >> >>
>> >> >> Hans
>> >> >>
>> >> >> CREATE TABLE TEST (
>> >> >> A12345678901234 INTEGER NOT NULL
>> >> >> , B123456789012345 INTEGER NOT NULL
>> >> >> ) ====> Fails .. Metadata extract fails with bogus error
>> >> >>
>> >> >> CREATE TABLE TEST (
>> >> >> A12345678901234 INTEGER NOT NULL
>> >> >> , B12345678901234 INTEGER NOT NULL
>> >> >> ) ====> Does not fail
>> >> >>
>> >> >> CREATE TABLE TEST (
>> >> >> A123456789012345 INTEGER NOT NULL
>> >> >> , B12345678901234 INTEGER NOT NULL
>> >> >> ) ====> Does not fail
>> >> >>
>> >> >>
>> >> >
>> >> > I can create this table and extract the metadata without error using
>> >> > IBExpert and ISQL.
>> >> > Are you sure you are not just using a script component in IBO
>> >> to find this
>> >> > error?
>> >> > Alan
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>