Hi,

Are you running SQL Server on your workstation? If not, you can get an evaluation copy from MS that will run on Win95 and NT workstations. I developed a client server app with VFP using an evaluation copy and then installed it on my client's server.

The Query Analyzer, part of the product, lets you write and test sql statements. SQL Server comes with a parctice database. The help module describes the syntax of the Transact-SQL.

When I'm developing, I get the SQL statement working in the query analyzer and then get it working in as a VFP SQL PassTrough.

I've learned a great deal by running SQL Server locally, not just SQL syntax, but about the database in general.

Good luck,

Paul


>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