Prev
Next
Forums Financial Management Lawson S3 Financials

Add ins

 2 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
Kevin Hagan
Advanced Member
Posts: 30
Advanced Member
2/5/2008 2:11 PM
    We just got the below response from Lawson regarding a number of our queries which stopped working. Has this issue effected anyone else if so how are you getting around the change. Using related tables in your criteria is no longer allowed. The only exception to this that you can use a single related field, and then it must be the only criterion. So you can use multiple criteria if they are not to related tables.
    k-rock
    Veteran Member
    Posts: 142
    Veteran Member
    2/5/2008 6:17 PM
      Stop using Add-ins! A simple Access query is much more powerful. LBI can do queries. Any query tool or BI tool will do it as well.
      John Henley
      Posts: 3353
      2/5/2008 6:31 PM
        k-rock, b careful w/ Access queries...as with some databases / query types, they can lock the entire table. Also, if you are using linked-tables and multiple joins, etc. (i.e. not pass-thru queries) you can bring a system to it's knees since Access brings all data over the wire prior to doing the joins. In other words, Access queries (as well as any SQL) needs to be done properly so as to not introduce performance issues......
        Thanks for using the LawsonGuru.com forums!
        John