nlookup function for R&R SQL

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Lucas_Xavier_(Guest)
Posts: 1
Joined: Tue Oct 10, 2017 12:44 pm

nlookup function for R&R SQL

Post by Lucas_Xavier_(Guest) » Tue Dec 16, 2003 8:52 pm

Hi,____I am trying setup a report that has the main record on the left column and to the right the date value for the that record. (I hope this formats ok, it should look grid like)____ItemName Date||||01/01||01/02||01/03 . . .__Rubber Ducky|||||100|||||||20|||||80__Rubber Chicken|||400||||||150||||500__.__.__.____With the Xbase version I would use nlookup to fill in the values for each date and it would work, though it could get nasty. Here is a simple example: NLOOKUP(DTOC(BaseDate,1)+ MODTYPE+COMPANY+CLASS,"UNITS","PRDRPT.DBF","PRDRPT.CDX","PRDRPT1")____The problem I am having is that there is no nlookup function in R&R SQL. Is there another way to do this or am I stuck?____Regards and thanks for your help.____Lucas__

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: nlookup function for R&R SQL

Post by kfleming » Wed Dec 17, 2003 8:58 am

The SQL version does not support lookup functions.__You would need to build a join to get the information or alternatively export your SQL data files to Xbase table structures and then use the Xbase edition so that you could use NLOOKUP().____Kathleen__R&R Support

Post Reply