Very Weird INSERT Problem

2000-05-01 Thread S R
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

Re: Very Weird INSERT Problem

2000-05-01 Thread Larry Meadors
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

RE: Very Weird INSERT Problem

2000-05-01 Thread mherbene
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

Re: Very Weird INSERT Problem

2000-05-01 Thread S R
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

RE: Very Weird INSERT Problem

2000-05-01 Thread S R
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

RE: Very Weird INSERT Problem

2000-05-01 Thread Clint Tredway
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

Re: Very Weird INSERT Problem

2000-05-01 Thread Josh Black
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

Re: Very Weird INSERT Problem

2000-05-01 Thread Reuben King
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