It's now time for me to take the jump, and I'm not quite sure of the syntax of SQL Server.
What I know:
Make the connection with SQLCONNECT.
Place the SQL string that I want to happen in the second parameter of SQLEXEC.
Questions:
What's the syntax for SQL UPDATE?
Same as FoxPro? (UPDATE tablename SET field1=field2 WHERE)
How is the tablename referenced in the string? Do I need to specify the database name?
I have the same questions for SQL INSERT - {INSERT INTO tablename () VALUES () }
Thanx.
DP
Live life today - tomorrow will take care of itself.