Nov 5, 2007 #1 JFrog IS-IT--Management Joined Nov 5, 2007 Messages 9 Location 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 Joined Oct 29, 2003 Messages 684 Location US What's your question? Upvote 0 Downvote
Nov 5, 2007 #3 PHV MIS Joined Nov 8, 2002 Messages 53,708 Location FR Lack of space before Where. Hope This Helps, PH. FAQ219-2884 FAQ181-2886 Upvote 0 Downvote
Nov 5, 2007 #4 JarlH Programmer Joined Jul 26, 2002 Messages 365 Location 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 Joined Nov 5, 2007 Messages 9 Location 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.