I have an application where the SQL tables that it uses are updated fairly consistently as far as fields, field sizes, and things like that goes. So, instead of using a solid view, I wanted to be able to create a cursor at runtime, like this:

=SQLEXEC(lnConnection, 'SELECT * FROM checks WHERE id = ?m.id', 'c_checks')

And then turn that cursor updatable, where I could just use that. Is that possible? This is what I've done so far:

=CURSORSETPROP('tables', 'checks')
=CURSORSETPROP('keyfieldlist', 'id')
=CURSORSETPROP('sendupdates', .T.)
=CURSORSETPROP('buffering', 5)

But when I do a "TABLEUPDATE(1, .T.)", it gives back the following error message:

No update tables are specified. Use the Tables property of the cursor.

I've tried using several versions of naming the table, along with setting the field list as well, to no avail. I'm beginning to think this may not be possible. Any ideas?