Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Syntax Error In String

Status
Not open for further replies.

JFrog

IS-IT--Management
Nov 5, 2007
9
US
("Update Mas90Data Set Result = 'REVRSL' Where CheckNumber = '" & Mas90CheckNumber, dbconnection)

I hate SQL... Thanks for Helping feed my family.
 
Lack of space before Where.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
RESULT is a reserved word, double quote it (i.e. "RESULT").

 
THANKS to everyone...
The Problem turned out to be I had varible defined as text when it should have been number in my database.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top