No SQL is a language that works in Access, SQL Server, Informix, DB2,
Oracle, ... and many more. Ben Forta even wrote a little SQL book. Syntax
is sometimes a little different in every implementation, but most conform to
the ANSI SQL-89 or SQL-92 standards.
Any DBA will tell you not to do Alter table statements, as you should never
have to if you write a good schema, but obviously sometimes you have to.
I'm not saying to do it, but sometimes you have to.
-----Original Message-----
From: Consultant [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 11:52 AM
To: CF-Server
Subject: Re: ms access db. table creating
On an Access database?
Isn't that limited to SQL server ?
----- Original Message -----
From: "Jacob Cameron" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Saturday, March 03, 2001 1:36 AM
Subject: RE: ms access db. table creating
> yes, just use SQL Alter Table Statements
>
> -----Original Message-----
> From: Alexander Stepanov [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 02, 2001 10:59 AM
> To: CF-Server
> Subject: ms access db. table creating
>
>
>
> Hi,
>
> Could somebody clarify the following question. I use ms access db [odbc]
> with ColdFusionServer. Is it possible to create/alter tables in Access DB
> using ColdFusionStudio or CFML?
>
> Thank you,
>
> Alexander
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com