Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select records
Message
De
09/09/2004 19:02:39
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
09/09/2004 18:15:22
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00940543
Message ID:
00940879
Vues:
16
>hi,
>
>i have just 2 tables ,table1 with all data1,
>table2, i insert what i choice in table2,
>
>i need to delete just from table1 ,

You can delete from whatever table you like. The table names I provided were just an example.

>about pk,most of all fields duplicated at table1,

Each table should have a primary key, so that you can easily refer to a specific record - as you need to do now.

IIRC, my article on primary keys includes an example of how to assign a sequential number to each record.

You can sometimes use recno() instead of the primary key, but this will cause you numerous problems in the long run. I strongly suggest you create a specific field for the primary key.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform