[thelist] Learning SQL

Oliver Lineham oliver at lineham.co.nz
Thu, 06 Jan 2000 10:36:18 +1300


At 22:24 4/01/00 +0100, you wrote:

>If you define these critters in the Database Structure you can prevent this
>kind of "error" from occuring. In other words assigning an incorrect ID will
>return a simple error.
>mSQL & MySQL do _not_ support this, Oracle _does_ and I don't _know_ about
>MS SQL and other SQL servers.

But surely this isn't a problem?  As long as whatever interface you are 
providing to the database is properly written (eg. CGI, PHP, text menu ..) 
it won't cause a problem.

Ol.

___________________________________________________
      oliver.lineham   http://vox.vibe.co.nz/
                 mind over pixel