Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Quoted identifier equivalent in VFP?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01354077
Message ID:
01354218
Views:
23
>That works!
>
>I can deal with that. It looks like DESC is the only critical field out of the four fields that had reserved word names, so I can start replacing references in code and on the form and make a quick change in the cursoradapter.
>
>Thanks Borislav!

And to be more precise (because you could update not only Desc field) you should define class this way:
DEFINE CLASS ctest AS CursorAdapter

    PROCEDURE BeforeUpdate(cFldState, lForce, nUpdateType, cUpdateInsertCmd, cDeleteCmd)
             cUpdateInsertCmd = STRTRAN(cUpdateInsertCmd,[Desc=crstest.desc1],[tblTest.Desc=crstest.desc1])
    ENDPROC
ENDDEFINE
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform