Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Weird scenario with INSERT
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01410932
Message ID:
01411037
Vues:
32
>>The result was very weird. The field MakeID became character 40 and the last field LicenseKey was dropped from the table.
>>
>>May be you have some weird situation like this as well - you think you have some field in the cursor, but you don't.
>
>That's why you should specify the field names as well as the values. Also standard ;-)

You missed the point. I did specify the field values, but the cursor did not contain the MakeID field (it was an extra new field). Rather than making an error, it instead somehow managed to change the structure of the whole table.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform