I have done several VFP and SQL Server conversions and found that I can access SQL Server tables using VFP and the ODBC drivers for SQL Server, including the running...

I have done several VFP and SQL Server conversions and found that I can access SQL Server tables using VFP and the ODBC drivers for SQL Server, including the running...

Responding to your question about examples to work thru -- I found Joe Celko's "SQL Puzzles and Answers" will give your brain a good workout -- it also gives more...

I am finding that the "The Best of SQLSeverCentral.com 2002" book to be of great value -- and by buying it you can show your support for this site too.

...

Need to study your code more closely and learn, but the SQL code that I implemented turned out to be quite simple

SELECT * FROM IMS

WHERE...

Thanks for your help -- I should have been able to figure that out all by my lonesome -- too late at night I guess (lame excuse).

I understand the where clause usage (I think). See pseudo code to hopefully clarify the intent of the condition query.

IF mUSER_ID = IMS.CREATE_BY THEN

SELECT * FROM IMS

ELSE

...

Think you want to use the update construct but do not include the ID field in the update list and then use the "where fldStudentID = @ID" clause to hit...

Are you sure you are running Win2k "Server" and not just the Professional Edition.

I had the same problem -- to solve it I bought the Developer Version of SQL Server...

Because SQL Server service packs are cumulative, you do not need to install previous service packs. Each service pack includes all fixes from previously released service packs, and can be...