Results 1 to 2 of 2

Thread: [Answers] SQLlookup

Threaded View

  1. 2015-09-24, 03:13 #1
    josipradnik
    josipradnik is offline
    Lianja MVP
    Join Date
    Dec 2012
    Location
    Croatia, Zagreb
    Posts
    1,135

    [Answers] 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'"

    ​All topics in [Answers] alphabetically:http://www.lianja.com/community/show...ll=1#post12352
    Last edited by josipradnik; 2017-01-23 at 03:07.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Journey into the Cloud
Join us