Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursor Adapter behavior...
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Cursor Adapter behavior...
Miscellaneous
Thread ID:
01433143
Message ID:
01433143
Views:
127
hello...

I am working with the Cursor Adapter, but when the UpdateInsertCmd is generated the table name in the sentence is
lower case converted, the table name is "DEPA(DEPARTMENT)" but is converted to "depa".

The cUpdateInsertCmd(in the AfterUpdate method) show :
UPDATE depa SET NOMB_DEPA=?cadepa.nomb_depa WHERE CODI_DEPA=?OLDVAL('codi_depa','cadepa')

The correct instrucion may be :
UPDATE DEPA SET NOMB_DEPA=?cadepa.nomb_depa WHERE CODI_DEPA=?OLDVAL('codi_depa','cadepa')"

THIS generate a error because the database is case sensitive.

any help is great apreciated!
William Chavez
Next
Reply
Map
View

Click here to load this message in the networking platform