Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Weird scenario with INSERT
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01410932
Message ID:
01411037
Views:
33
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform