On Thu, 24 Aug 2000, Andy Ewings spake thusly:
> Thats because you are using Access......the suyntax I sent is for SQL
> Server.....never done it with Access
I wonder if it is even possible with Access....
>
> -----Original Message-----
> From: Jon Tillman [mailto:[EMAIL PROTECTED]]
> Sent: 24 August 2000 11:20
> To: [EMAIL PROTECTED]
> Subject: RE: checking for tables?
>
>
> 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/[email protected]/
> > 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/[email protected]/
> > 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/[email protected]/
> 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/[email protected]/
> 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/[email protected]/
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.
