Making databases portable from one version to the next

[Trumpcard]

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!