In the Cr8_DMLCode procedure, look for:
lcInsert = lcInsert + [ ] + lcFName
lcUpdate = lcUpdate + [ ] + lcFName + [ =]
Try changing this to:
lcInsert = lcInsert + " [" + lcFName + "]"
lcUpdate = lcUpdate + " [" + lcFName + "] ="
I will look at putting this in a CASE statement so the brackets are not used for VFP or Oracle tables. Let me know if those changes work. Thanks!
>Hi Mark
>
>I have a problem with the system I am working on. Some of the fields in SQLServer are keywords like TABLE and DATE etc. This was from a legacy system I am converting to CS using your CA generator.
>
>I asked the Database Admin to change these fields and his reply made sense. He said that todays fields may become tomorrow's keywords. He has no problem accessing these fields provided he uses square brackets [TABLE] around the field in SQLQueries. He suggested why not I change the CA code so that square brackets went around ALL fields to make it future proof!
>
>This is good thinking, except I dont know how to do this. I know it must be in the _ca_autoupdate section or the _ca_dmlcode section.
>
>Could you point me in the right direction to implement this in your CA builder? I need to be able to query as well as update the table.
>
>TIA
>
>Bernard
Mark McCasland
Midlothian, TX USA