Hundri,

Interesting.

Your table has a databaseName property:
DatabaseName = 'd:\test\test.gdb'

Your Database has a ParamsSettinge:
Params.Strings = (
'PATH=d:\buskettib\buskett.gdb'
'SYSDBA=sysdba'
'USER NAME=sysdba')

I wonder which database is valid now and which database has the changed
boolean definition now.

Luc.



Hundri Magusin schrieb:

>
> I've fixed my boolean definition, which now reads:
>
> CREATE DOMAIN BOOL AS
> VARCHAR(1) CHARACTER SET NONE
> DEFAULT 'F'
> NOT NULL
> CHECK (VALUE IN ('T','F'))
> COLLATE NONE
>
> but still I get the same effect. TIBOQuery triggers the same error.
>
> The funny part is that, if you look at my previous post, after the failed
> locate if I read IBOTable1NAME.asString again (i.e. the 2nd time) I still
> get the same result as if the cursor never moved. But then when I say
> edit/post the cursor has moved to the end.... I can attach a demo project if
> need be.
>
> For all it's worth, here's a snip from the dfm:
>
> object IBOTable1: TIBOTable
> Active = True
> DatabaseName = 'd:\test\test.gdb'
> GeneratorLinks.Strings = (
> 'ID=COUNTRIES_GEN')
> IB_Connection = IBODatabase1
> RecordCountAccurate = True
> BeforePost = IBOTable1BeforePost
> TableName = 'COUNTRIES'
> FieldOptions = []
> Left = 36
> Top = 40
> object IBOTable1ID: TIntegerField
> FieldName = 'ID'
> Required = True
> end
> object IBOTable1NAME: TStringField
> FieldName = 'NAME'
> Size = 60
> end
> object IBOTable1X: TStringField
> FieldName = 'X'
> Required = True
> Size = 1
> end
> end
> object IBODatabase1: TIBODatabase
> Params.Strings = (
> 'PATH=d:\buskettib\buskett.gdb'
> 'SYSDBA=sysdba'
> 'USER NAME=sysdba')
> Left = 124
> Top = 28
> SavedPassword = '.JuMbLe.01.432B0639073E0E4B49'
> end
>
> Regards,
> Hundri