• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

invalid SQL sytax?

G

GoingUp

Lifer
WTF? I dont see what my problem is with this code.

sql2 = "SELECT Order_no FROM ORDER WHERE Cust_no ='" & idtext & "'"
cmd2 = New OleDb.OleDbCommand(sql2, Con)


The error I get is: Incorrect syntax near the keyword 'ORDER'

Cust_no is a foreign key in my ORDER tab. Order number is the primary key of the table. The table is populated with data. I dont see what the heck I am doing wrong.

idtext is read off of a text box.

ie. idtext = textbox1.text
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top