SQLlookup

Q:
Why is a wrong field shown in column “groep”.
choices: SELECT omschrijving FROM groep WHERE bedrijf = 234 AND periode = 2015
Get data mapping : sqllookup(“groep”,”where bedrijf = 234 AND periode = 2015 AND groep = ‘{}'”, “”,”omschrijving”,”0″)
Swt data mapping : sqllookup(“groep”,”where bedrijf = 234 AND periode = 2015 AND omschrijving = ‘{}'”, “”,”groep”,”0″)
A:
What are the datatypes of groep and omschrijving?
If they are character, the final parameter (notfound) in SQLLOOKUP() should be in quotes within quotes “‘0′”



 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s