Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Buffer overrun with sql update
Message
From
29/08/2008 01:49:32
Albert Beermann
Piepenbrock Service Gmbh & Cokg
Osnabrück, Germany
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
MySQL
Miscellaneous
Thread ID:
01342533
Message ID:
01342957
Views:
19
Hello Naomi

I can't splitt the table.
If we use less fields in one command, we have to fire 2 update-commands for one record ??
When inserting new records we have to do an insert first with n fields , then read the new automatic generated key and then do an update of the new record with the rest of the fields ??
Very unlucky i think, and a lot more performance problems for the database.

Best regards
Albert
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform