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
=====================================================

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


>> Hi Allen,
>>
>> I use IB_SQL. Like I mentioned, a special combination of events
>> made up by how IB_SQL extracts the Metadata and than in
>> addition how the table was created. The interesting part is
>> that it also happens using FB1.5 and FB2.0, all Dialects.
>>
>> I never noticed it with IBOConsole either. IBExpert, alike IB_SQL
>> now, may have a different approach or work around to extract
>> Metadata, but the original 'bug' fact remains. Why should the last
>> two examples work and the first one not ?
>
> but they all work fine for me. I don't use IB_SQL, just IBExpert and ISQL.
> so doesn't they something more specific about IBO/IB_SQL and not fbserver?
> Alan
>
>>
>> ----- Original Message -----
>> From: "Alan McDonald" <alan@...>
>> To: <firebird-support@yahoogroups.com>
>> Sent: Saturday, January 20, 2007 8:27 PM
>> Subject: RE: [firebird-support] Where to go or not to go
>>
>>
>> >> Hello Alan,
>> >>
>> >> After weeks of tracing and debugging, I found out
>> >> it fails only in a special sequence and brought it to
>> >> Jason's attention. I expect it might cause intermittent
>> >> problems somewhere else.
>> >>
>> >> 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
>
>
>