Nov 5, 2007 #1 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.
("Update Mas90Data Set Result = 'REVRSL' Where CheckNumber = '" & Mas90CheckNumber, dbconnection) I hate SQL... Thanks for Helping feed my family.
Nov 5, 2007 #2 elsenorjose Technical User Oct 29, 2003 684 US What's your question? Upvote 0 Downvote
Nov 5, 2007 #3 PHV MIS Nov 8, 2002 53,708 FR Lack of space before Where. Hope This Helps, PH. FAQ219-2884 FAQ181-2886 Upvote 0 Downvote
Nov 5, 2007 #4 JarlH Programmer Jul 26, 2002 365 SE RESULT is a reserved word, double quote it (i.e. "RESULT"). Upvote 0 Downvote
Nov 6, 2007 Thread starter #5 JFrog IS-IT--Management Nov 5, 2007 9 US THANKS to everyone... The Problem turned out to be I had varible defined as text when it should have been number in my database. Upvote 0 Downvote
THANKS to everyone... The Problem turned out to be I had varible defined as text when it should have been number in my database.