Subject RE: [firebird-support] Where to go or not to go
Author Alan McDonald
> 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