Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

sql statem to return data

 1 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
yvonne
Basic Member
Posts: 14
Basic Member
10/8/2010 3:51 PM

    Hi,

    Has anyone devised a method to call in an SQL from Lawson and return data?  We are trying to create an iquiry form for the end user to look up data.  For example the manufacture # but we would like to query stripping the special characters such as hyphens, etc... Often the periods and hyphens are wrong.

    Thanks

    Yvonne

     

    Jimmy Chiu
    Veteran Member
    Posts: 641
    Veteran Member
    10/8/2010 6:56 PM
      I would just create a C# page and call to SQL query/sp and display the information. Mimic it like lawson page > bookmark it in lawson > distribute to the groups. Maybe quicker and easier this way since you will be able to strip the special characters in your query/sp.