Posted by Jon Sacks on December 04, 2008 at 16:47:30:
In Reply to: Re: A new DbMgr posted by Stephen Auerbach on December 04, 2008 at 14:56:14:
Oracle, MS-SQL, My-SQL are SQL database so you simply tell it:
update customer set customer.name = 'Jons Gift Store' where customer.number = '123456';
The database knows where customer.name is in customer, this is the statement in the compiled program so if you change the definition of customer who cares, the database knows where you moved the field to, applications and the database are two independant things.
The idea of the format statement is so "Q" school. ;)
JSACKS<<
Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.