Oh no, I spoke too soon:
[Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE',
'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.
Data Source = "health-horizons"
SQL = "IF EXISTS(INSERT INTO 96961133 (productID, productQty) VALUES(54, 1);)"
On Thu, 24 Aug 2000, Andy Ewings spake thusly:
> Yup....if you are using SQL server the syntax is.....
>
>
> IF EXISTS (SELECT * FROM sysobjects WHERE name = "<tablename>" AND type =
> "U")
> BEGIN
> PRINT "Table Exists!."
> END
>
>
> -----Original Message-----
> From: Jon Tillman [mailto:[EMAIL PROTECTED]]
> Sent: 24 August 2000 11:09
> To: [EMAIL PROTECTED]
> Subject: checking for tables?
>
>
> quick question:
> is there any way to check to see if a table exists without querying it, and
> throwing an error if it does not? I want to either CREATE or INSERT a table
> depending on whether or not it already exists....
>
> --
> ***********************************************
> Jon Tillman
> LINUX USER: #141163
> ICQ: 4015362
> http://www.eruditum.org
> [EMAIL PROTECTED]
> ***********************************************
> Help Jon build a network!
> Looking for giveaway computers & parts
> Current Need: Tape Drive & PI/PII processors
> Email me to find out how you can help
> ***********************************************
>
> ----------------------------------------------------------------------------
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> ------------------------------------------------------------------------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
--
***********************************************
Jon Tillman
LINUX USER: #141163
ICQ: 4015362
http://www.eruditum.org
[EMAIL PROTECTED]
***********************************************
Help Jon build a network!
Looking for giveaway computers & parts
Current Need: Tape Drive & PI/PII processors
Email me to find out how you can help
***********************************************
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
