View Single Post
  #1  
Old 03-15-2003, 07:22 AM
Trumpcard
Demi-God
 
Join Date: Jan 2002
Location: Charlotte, NC
Posts: 2,614
Default 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!
__________________
Quitters never win, and winners never quit, but those who never win and never quit are idiots.
Reply With Quote