When I run the following update statement, the Bulkline field gets
truncated on any record with the corresponding gift field. Ex:
Bulkine before running statement: CA13 bulkline after running
statement: CA1


Update Orders Set OOS = 'Y' Where Gift = '4200' and BulkLine LIKE 'C%'

The OOS field gets updated correctly, but all records with Gift = 4200
have the bulkline record truncated, even the records that don't
satisfy the LIKE 'C%'

Any ideas as to why this is happening?

Shane -- How's things going!

It is possible (and even likely) that your DDF's are out of sync with the
data files. Use the Check Database Wizard to verify that the DDF
structures match the database structure. If there are any mismatches on
this table, these MUST be fixed before you should ever try to update files
from SQL/ODBC.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: November 16-19, 2004: See our web site for details!


Shane Peterson wrote:

I have already run the Check Database Wizard and the test passed. The
only way around this problem I've found is to add a field between the
OOS and Bulkline fields.

Bill Bach <bbach (AT) cncdsl (DOT) com> wrote

Can you send me your DDF's and a sample data file? I'm interested in this one...
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: November 16-19, 2004: See our web site for details!


Shane Peterson wrote: