>I'm trying to update a MS-SQL table by using the VFP INSERT statements once a view is opened.
>
>Also, Do I need to make the connection with ODBC? Or, is there another way to do it.
>
>Any help is greatly appreciated.
>
>Craig
If you're using a view, then you're already using ODBC - or do you mean should you be using a view?
In VFP, I like views for data mods (insert,update,delete) and SPT for calling stored procs.
So, what's the problem? Is the record not inserted into MSSQL? If not, check that the view has SendUpdates set to .T. and all appropriate fields are marked Updatable, and the key fields are set as well.
Also, the record won't be updated to MSSQL until TableUpdate() is issued either expressly or implicitly (by moving the record pointer - row buffering only).
Insanity: Doing the same thing over and over and expecting different results.