Trumpcard
03-15-2003, 07:22 AM
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!
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!