asked on August 21, 2014
I have a SQL table that I am trying to extract information to populate Laserfiche Forms. The SQL table has three columns:
| ID | Amount | Date |
| 123 | 12.53 | 8/21/2014 |
| 123 | 12.68 | 8/13/2013 |
| 123 | 12.53 | 8/1/2012 |
My form looks at the ID column for value 123 and I need it to return the most current date like the following SQL statement:
Select top (1) * from table
where ID = '123'
My two questions are:
1. Can Laserfiche Forms perform a lookup off of a SQL Function?
2. If LF Forms cannot perform a lookup off of a SQL Function, how would I call this using a SQl Stored Procedure?
Any help on this matter is greatly appreciated. Thank you in advanced.
0
0