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

"Geoff Worboys" <geoff@...> wrote in message
news:4749954046.20020523225836@......

>
> In the demo I setup for another thread on the list my TIBOQuery does
> not move the selected row after a failed locate. I tried putting in
> some Edit/Post stuff like your first posting but could not reproduce
> your reported problem.
>
> I doubt if TIBOTable would operate differently - other than the fact
> that it is less controllable and so more unpredictable.
>
> Fixup the boolean field and the double quotes etc and try again. If
> you have a choice use TIBOQuery so you can be explicit about the
> configuration.
>
> --
> Geoff Worboys
> Telesis Computing
>
>
>
>

___________________________________________________________________________

> IB Objects - direct, complete, custom connectivity to Firebird or

InterBase

> without the need for BDE, ODBC or any other layer.
>

___________________________________________________________________________

> http://www.ibobjects.com - your IBO community resource for Tech Info

papers,

> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>