Sorry Typo...
cSql = "UPDATE Mytable Set field1 = "+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."