>I do not remember how to use a reserved word, such as Order, in a SQLUpdate command. I am trying to do this:
>
>
>UPDATE ForumCli SET Enabled=?,Order=?,NewMes=?,Expand=? WHERE Numero=?
>
Is this executed against VFP table or some other backend?
I asked because of question marks used.
If it is SQL Server
UPDATE ForumCli SET Enabled=?,[Order]=?,NewMes=?,Expand=? WHERE Numero=?
If is is against VFP table, that works for me:
CREATE CURSOR ForumCli (a1 int, order int)
APPEND BLANK
UPDATE ForumCli SET a1 = 1, ForumCli.Order = 2
BROWSE
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
