Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What is missing
Message
De
25/05/1999 06:52:58
 
 
À
25/05/1999 06:50:23
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00222382
Message ID:
00222385
Vues:
23
Hi Colette

In VFP, this would accomplish the task:

SELECT * FROM product_tbl INTO TABLE products_tmp


>I want to create a new table using all fields of another table
>
>create table products_tmp as;
>select * from products_tbl
>
>The syntax is wrong ????????
>I am working from an ansi standard sql book and I'm stuck !!!!!!
>
>any sample code of other sql basic commands would be great and save me many frustrating hours.
>
>Best wishes
>Colette
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform