Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Calling All SQL PassThrough Experts!
Message
De
29/07/2000 10:20:50
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Calling All SQL PassThrough Experts!
Divers
Thread ID:
00398467
Message ID:
00398467
Vues:
55
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform