Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Primary Key Problem
Message
 
 
À
23/11/1999 17:25:35
Jimmy Ditta
Twin City Electronics
Monroe, Louisiane, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00294634
Message ID:
00294783
Vues:
21
Check file attributes to see that they are not read-only. Can you Append blank to the tables? Do you have proper rights to the directory where the tables are located.


>they all have the same name, all are integers, all have input masks of 9999.
>the only differences are that 1 is primary, and 2 and 3 are regular; and that the default of the primary calls a getkey().
>
>
>>The number of fields does not matter. What does matter is that you match field names and types. Compare the structures between the tables you are trying to append from and to.
>>
>>>actually now that I look at it, None of the tables will append. no errors either. the 1st table has quite a few more fields than the other two. what do you need to see as far as table structure?
>>>
>>>
>>>>>I have 3 tables - table 1 has a primary key that i linked in my data environment to regular keys of the same name in the other tables. the problem is that the third table will not append new records and i don't understand why.
>>>>>
>>>>>HELLPPP!!!!
>>>>>JD
>>>>
>>>>Do you get an error message? If so, what is it? If not, are you getting just blank records appended? Providing partial table structures for the 1st and 3rd tables would probably be helpful as well.
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform