Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Beginner
Mar 24, 1997

SQL parsing error

Question:
I have been having a lot of trouble with a SqlLookup() function. Whenever I use a WHERE clause, I get a parse error.

The offending WHERE clause is "WHERE SW_LICENSE = " & SWL_NUMBER.Value. The SW_LICENSE field is a VARCHAR datatype. Help!

Answer:
The problem comes from an incorrect SQL statement. The SW_LICENSE field is a character field, but, for a value of "25", the WHERE clause parses out to WHERE SW_LICENSE = 25. Since the column is expecting a string, the parsed WHERE clause should be WHERE SQL_LICENSE = '25'", and the WHERE clause should read "WHERE SW_LICENSE = '" & SWL_NUMBER.Value & "'".

It's can be dangerous to give your objects or columns misleading names, such as calling a string field "SWL_NUMBER".

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date