Hi list..
It is not MB's Problem i think, it is a syntax
error..
the variables must written
outside of the double-quotes,
like this..
cmd_update = "Update mytable Set Col18 = " + newrecord + "
where rowid = " + selected
Run Command cmd_update
try it ,,
Hope works.....
Consider this....
Update mytable Set Col18 = newrecord where rowid = selected
works quite fine..which of course you would expect, but....
cmd_update="Update mytable Set Col18 = newrecord where rowid = selected"
Run Command cmd_update
produces an error stating that 'Variable or field newrecord is not defined'. I can assure that the variable newrecord is indeed defined...of course the first example wouldn't work were it not.
