Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calling All SQL PassThrough Experts!
Message
From
29/07/2000 10:20:50
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Calling All SQL PassThrough Experts!
Miscellaneous
Thread ID:
00398467
Message ID:
00398467
Views:
46
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.
Next
Reply
Map
View

Click here to load this message in the networking platform