I need to update a logical (boolean) field.

Tried 'Update table
set logicalfield = true
where key = mykeyvalue'

this fails with the error:

<<<<<<<<<<<<<<<<<<<<<<<<
[LNA][Pervasive][ODBC Engine Interface]Error in expression: True
>>>>>>>>>>>>>>>>>>>>>>>>

What is the syntax to accomplish this update?

Thanks!

Bill S.

How is the "logicalfield" defined in the DDFs?
You might try:
Update table
set logicalfield = 1
where key = mykeyvalue

i have tried this.

I don't know how to view/edit the DDF's yet.

Thanks, I will look into the DDF situation.

The DDF was the issue.

Thanks.

Bill Slaughter