cSql = "UPDATE Mytable Set field1 With "+cValue1
nExec = SQLEXEC(nConn,cSQL)
If nExec >= 1
Wait Window "Update successful"
Else
Wait Window "Update unsuccessful"
Endif>before I take the dive.
>
>I need to update a SQL 7 database with the same information from a FoxPro form that updates a FoxPro database. Look at it as a replication effort.
>
>My strategy is to use SQL passthru to open up a connection, and add a record to the SQL database behind the scenes, so the user is not aware of this extra update.
>
>The question I have is what do I do in the case of an update? It's not like I can SEEK and REPLACE here. Any ideas?
>
>DP
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."
