Take a look at
How to Create Updatable Views by Using SQL Passthrough mskb #
138094 and
How to make SQL Pass-Through cursor updatable FAQ #8153
>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?
--sb--