I have tried everything, changing the name of the query, recreating the
table, Naming the field different names and I still get the error:
Missing semicolon (;) at end of SQL statement.
I even tried adding the semicolon and then it says:
Characters found at end of SqL statement.
It is just a
You don't want a where in your insert. Try this:
INSERT INTO USACopy (BusUnitID, ID) VALUES (8, 3)
Larry
>>> [EMAIL PROTECTED] 05/01/00 11:08AM >>>
I have tried everything, changing the name of the query, recreating the
table, Naming the field different names and I still get the error:
Missi
You can't have a WHERE and a VALUES in an INSERT.
Maybe you want an UPDATE?
-Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 01, 2000 1:09 PM
To: [EMAIL PROTECTED]
Subject: Very Weird INSERT Problem
I have tried everything, changing the name of the
t;
>Reply-To: [EMAIL PROTECTED]
>To: <[EMAIL PROTECTED]>
>Subject: Re: Very Weird INSERT Problem
>Date: Mon, 01 May 2000 11:13:49 -0600
>
>You don't want a where in your insert. Try this:
>
>INSERT INTO USACopy (BusUnitID, ID) VALUES (8, 3)
>
>Larry
>
> &g
That was it! Thank You very much
>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>Subject: RE: Very Weird INSERT Problem
>Date: Mon, 1 May 2000 13:18:08 -0400
>
>You can't have a WHERE and a VALUES in an INSERT.
>
>Maybe you want an
Then what are you trying to accomplish?
-Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 01, 2000 12:27 PM
To: [EMAIL PROTECTED]
Subject: Re: Very Weird INSERT Problem
This didn't work at all. You're telling me to insert on top of ID which
already h
Try this:
UPDATE USACopy SET BusUnitID=8 WHERE ID=3
Josh
- Original Message -
From: "S R" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 01, 2000 10:26 AM
Subject: Re: Very Weird INSERT Problem
> This didn't work at all. You're tell
In <[EMAIL PROTECTED]>, S R (dharkangel333
@hotmail.com) in a fit of unbridled passion, wrote:
> I have tried everything, changing the name of the query, recreating the
> table, Naming the field different names and I still get the error:
>
> Missing semicolon (;) at end of SQL statement.
>
> I
8 matches
Mail list logo