one line error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

one line error

Author

Topic

mjimenezh
Yak Posting Veteran

81 Posts

Posted - 2014-03-07 : 15:23:51

Hi, I'm very bad because I cannot found the error in one line of code, I receive an syntaxis error near "prijslst" field, this code is char type, this is my code please help.

Thanks in advance

CON3.Execute "update staffl set prijs83=" & MSFlexGrid1.TextMatrix(RENGLON, 9) & "WHERE artcode=" & "'" & MSFlexGrid1.TextMatrix(RENGLON, 1) & "'" & "prijslijst='SALESPRICE'"

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2014-03-07 : 15:30:13

quote:
Originally posted by mjimenezh

Hi, I'm very bad because I cannot found the error in one line of code, I receive an syntaxis error near "prijslst" field, this code is char type, this is my code please help.

Thanks in advance

CON3.Execute "update staffl set prijs83=" & MSFlexGrid1.TextMatrix(RENGLON, 9) & "WHERE artcode=" & "'" & MSFlexGrid1.TextMatrix(RENGLON, 1) & "'" & "prijslijst='SALESPRICE'"

Make the following changes:
1. Insert a space before WHERE
2. insert a " AND " before prijslijst

CON3.Execute 
"update staffl set prijs83=" & MSFlexGrid1.TextMatrix(RENGLON, 9) 
& " WHERE artcode=" & "'" & MSFlexGrid1.TextMatrix(RENGLON, 1) 
& "'" & " AND prijslijst='SALESPRICE'"

mjimenezh
Yak Posting Veteran

81 Posts

Posted - 2014-03-07 : 15:35:45

Thanks for your help, It works, I was very saturated and I didn't see the error.

Best regards...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources