var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Update SQL Problem
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?
How is the "logicalfield" defined in the DDFs?
You might try:
set logicalfield = 1
where key = mykeyvalue
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development
I do not answer questions by email. Please post on the forum.
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.