Making databases portable from one version to the next
For any database creators:
Try to use the following syntax when creating your inserts, it will make your databases much more portable between releases. INSERT INTO TABLENAME (cola,colb,colc,cold) VALUES (valuea,valueb,valuec,valued); Using this format will make the source usable if we add fields to the exisitng structure in a later release. Most new fields end up with a DEFAULT VALUE, so they will be automaticlly filled in if they are not specified. Using the above format will help greatly with the widely feared (columns dont match) errors. Thanks! |
All times are GMT -4. The time now is 10:11 AM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.