VB.Net, VERY Strange error message!

VERY Strange error message!

Author	Message
elzik #1 / 8	VERY Strange error message! This is my code that will delete a row from a table in a database (I'm using the JET Engine): Dim cmdDelete As New OleDbCommand("DELETE programmequeue WHERE itemnumber = 10", cnNovaPVR) cnPVR.Open() cmdDelete.ExecuteNonQuery() cnPVR.Close() However this breaks on ExecuteNonQuery with the following error message: Syntax error (missing operator) in query expression 'programmequeue WHERE itemnumber = 10' What on earth happened to the DELETE keyword from my SQL statement? I even hardcoded the SQL statement (shown here) to prove that IM not loosing it somewhere. Whats goign on??? Cheers, elziko
Mon, 11 Apr 2005 21:31:00 GMT

jeff #2 / 8	VERY Strange error message! You missing the 'FROM' keyword so it would like this DELETE FROM PROGRAMMEQUEUE WHERE ITEMNUMBER = 10 Quote: >-----Original Message----- >This is my code that will delete a row from a table in a database (I'm using >the JET Engine): >Dim cmdDelete As New OleDbCommand("DELETE programmequeue WHERE itemnumber = >10", cnNovaPVR) >cnPVR.Open() >cmdDelete.ExecuteNonQuery() >cnPVR.Close() >However this breaks on ExecuteNonQuery with the following error message: Quote: >Syntax error (missing operator) in query expression 'programmequeue WHERE Quote: >itemnumber = 10' >What on earth happened to the DELETE keyword from my SQL statement? I even >hardcoded the SQL statement (shown here) to prove that IM not loosing it >somewhere. >Whats goign on??? Cheers, >elziko >.
Mon, 11 Apr 2005 21:54:22 GMT

elzik #3 / 8	VERY Strange error message! Seems like a stupid mistake doesnt it! I'm used to using Oracle which doesnt require the FROM keyword. I thought SQL was standardised until you get into PL/SQL and the likes. Should've noticed it. Thanks though! elziko Quote: > You missing the 'FROM' keyword > so it would like this > DELETE FROM PROGRAMMEQUEUE WHERE ITEMNUMBER = 10 > >-----Original Message----- > >This is my code that will delete a row from a table in a > database (I'm using > >the JET Engine): > >Dim cmdDelete As New OleDbCommand("DELETE programmequeue > WHERE itemnumber = > >10", cnNovaPVR) > >cnPVR.Open() > >cmdDelete.ExecuteNonQuery() > >cnPVR.Close() > >However this breaks on ExecuteNonQuery with the > following error message: > >Syntax error (missing operator) in query > expression 'programmequeue WHERE > >itemnumber = 10' > >What on earth happened to the DELETE keyword from my SQL > statement? I even > >hardcoded the SQL statement (shown here) to prove that > IM not loosing it > >somewhere. > >Whats goign on??? Cheers, > >elziko > >.
Mon, 11 Apr 2005 22:22:02 GMT

Toby Herrin #4 / 8	VERY Strange error message! SQL Server will also accept DELETE without FROM. Just remember, you're working with Jet. It's about as non-standard as database platforms get. -- Toby Herring Software Architects, Inc. MCDBA, MCSD Quote: > Seems like a stupid mistake doesnt it! I'm used to using Oracle which doesnt > require the FROM keyword. I thought SQL was standardised until you get into > PL/SQL and the likes. Should've noticed it. > Thanks though! > elziko > > You missing the 'FROM' keyword > > so it would like this > > DELETE FROM PROGRAMMEQUEUE WHERE ITEMNUMBER = 10 > > >-----Original Message----- > > >This is my code that will delete a row from a table in a > > database (I'm using > > >the JET Engine): > > >Dim cmdDelete As New OleDbCommand("DELETE programmequeue > > WHERE itemnumber = > > >10", cnNovaPVR) > > >cnPVR.Open() > > >cmdDelete.ExecuteNonQuery() > > >cnPVR.Close() > > >However this breaks on ExecuteNonQuery with the > > following error message: > > >Syntax error (missing operator) in query > > expression 'programmequeue WHERE > > >itemnumber = 10' > > >What on earth happened to the DELETE keyword from my SQL > > statement? I even > > >hardcoded the SQL statement (shown here) to prove that > > IM not loosing it > > >somewhere. > > >Whats goign on??? Cheers, > > >elziko > > >.
Mon, 11 Apr 2005 22:56:25 GMT

TP-Softwar #5 / 8	VERY Strange error message! Try using the Oracle.NET managed provider instead. Quote: > SQL Server will also accept DELETE without FROM. > Just remember, you're working with Jet. It's about as non-standard as > database platforms get. > -- > Toby Herring > Software Architects, Inc. > MCDBA, MCSD > > Seems like a stupid mistake doesnt it! I'm used to using Oracle which > doesnt > > require the FROM keyword. I thought SQL was standardised until you get > into > > PL/SQL and the likes. Should've noticed it. > > Thanks though! > > elziko > > > You missing the 'FROM' keyword > > > so it would like this > > > DELETE FROM PROGRAMMEQUEUE WHERE ITEMNUMBER = 10 > > > >-----Original Message----- > > > >This is my code that will delete a row from a table in a > > > database (I'm using > > > >the JET Engine): > > > >Dim cmdDelete As New OleDbCommand("DELETE programmequeue > > > WHERE itemnumber = > > > >10", cnNovaPVR) > > > >cnPVR.Open() > > > >cmdDelete.ExecuteNonQuery() > > > >cnPVR.Close() > > > >However this breaks on ExecuteNonQuery with the > > > following error message: > > > >Syntax error (missing operator) in query > > > expression 'programmequeue WHERE > > > >itemnumber = 10' > > > >What on earth happened to the DELETE keyword from my SQL > > > statement? I even > > > >hardcoded the SQL statement (shown here) to prove that > > > IM not loosing it > > > >somewhere. > > > >Whats goign on??? Cheers, > > > >elziko > > > >.
Mon, 11 Apr 2005 22:58:29 GMT

jeff #6 / 8	VERY Strange error message! We use to words here, ORACLE SUCKS! Quote: >-----Original Message----- >Seems like a stupid mistake doesnt it! I'm used to using Oracle which doesnt >require the FROM keyword. I thought SQL was standardised until you get into >PL/SQL and the likes. Should've noticed it. >Thanks though! >elziko >> You missing the 'FROM' keyword >> so it would like this >> DELETE FROM PROGRAMMEQUEUE WHERE ITEMNUMBER = 10 >> >-----Original Message----- >> >This is my code that will delete a row from a table in a >> database (I'm using >> >the JET Engine): >> >Dim cmdDelete As New OleDbCommand("DELETE programmequeue >> WHERE itemnumber = >> >10", cnNovaPVR) >> >cnPVR.Open() >> >cmdDelete.ExecuteNonQuery() >> >cnPVR.Close() >> >However this breaks on ExecuteNonQuery with the >> following error message: >> >Syntax error (missing operator) in query >> expression 'programmequeue WHERE >> >itemnumber = 10' >> >What on earth happened to the DELETE keyword from my SQL >> statement? I even >> >hardcoded the SQL statement (shown here) to prove that >> IM not loosing it >> >somewhere. >> >Whats goign on??? Cheers, >> >elziko >> >. >.
Mon, 11 Apr 2005 22:35:07 GMT

elzik #7 / 8	VERY Strange error message! I normally spell "to" with three letters. Thanks for your advice though. Quote: > We use to words here, > ORACLE SUCKS! > >-----Original Message----- > >Seems like a stupid mistake doesnt it! I'm used to using > Oracle which doesnt > >require the FROM keyword. I thought SQL was standardised > until you get into > >PL/SQL and the likes. Should've noticed it. > >Thanks though! > >elziko > >> You missing the 'FROM' keyword > >> so it would like this > >> DELETE FROM PROGRAMMEQUEUE WHERE ITEMNUMBER = 10 > >> >-----Original Message----- > >> >This is my code that will delete a row from a table > in a > >> database (I'm using > >> >the JET Engine): > >> >Dim cmdDelete As New OleDbCommand("DELETE > programmequeue > >> WHERE itemnumber = > >> >10", cnNovaPVR) > >> >cnPVR.Open() > >> >cmdDelete.ExecuteNonQuery() > >> >cnPVR.Close() > >> >However this breaks on ExecuteNonQuery with the > >> following error message: > >> >Syntax error (missing operator) in query > >> expression 'programmequeue WHERE > >> >itemnumber = 10' > >> >What on earth happened to the DELETE keyword from my > SQL > >> statement? I even > >> >hardcoded the SQL statement (shown here) to prove that > >> IM not loosing it > >> >somewhere. > >> >Whats goign on??? Cheers, > >> >elziko > >> >. > >.
Tue, 12 Apr 2005 16:30:41 GMT

Pat Ales #8 / 8	VERY Strange error message! What are you talking about? Oracle spanks the shit out of sql server's little red ass. Quote: > We use to words here, > ORACLE SUCKS! > >-----Original Message----- > >Seems like a stupid mistake doesnt it! I'm used to using > Oracle which doesnt > >require the FROM keyword. I thought SQL was standardised > until you get into > >PL/SQL and the likes. Should've noticed it. > >Thanks though! > >elziko > >> You missing the 'FROM' keyword > >> so it would like this > >> DELETE FROM PROGRAMMEQUEUE WHERE ITEMNUMBER = 10 > >> >-----Original Message----- > >> >This is my code that will delete a row from a table > in a > database (I'm using > >> >the JET Engine): > >> >Dim cmdDelete As New OleDbCommand("DELETE > programmequeue > WHERE itemnumber = > >> >10", cnNovaPVR) > >> >cnPVR.Open() > >> >cmdDelete.ExecuteNonQuery() > >> >cnPVR.Close() > >> >However this breaks on ExecuteNonQuery with the > following error message: > >> >Syntax error (missing operator) in query > expression 'programmequeue WHERE > >> >itemnumber = 10' > >> >What on earth happened to the DELETE keyword from my > SQL > statement? I even > >> >hardcoded the SQL statement (shown here) to prove that > IM not loosing it > >> >somewhere. > >> >Whats goign on??? Cheers, > >> >elziko > >> >. > >.
Wed, 13 Apr 2005 00:05:34 GMT

Page 1 of 1

[ 8 post ]