>Hi All,
>
>I was wondering something. In VFP, using a standard '.DBC' database. If I create a cursor with several records in my program. Set all the required properties. Then after I have made changes to these records. Even add records to that cursor. All I have to do is issue a TABLEUPDATE(.T.) and all the changes are sent to the database. Done & Done. My question is: In Oracle can I still do this kind of batch processing? I assume there will be some syntax differances, but can the concept still be done? Or must I send the changes back with INSERT & UPDATE statements record by record?

Both ways will work becuase your cursor was created using the MS or Oracle ODBC driver when executing the SPT. Of course either method will only work as long as you maintain the connection during all this.

If you terminate the connection, then you can only use INSERT & UPDATE via SQLExec() after re-establishing a connection.