sql statem to return data

 1 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
yvonne
Basic Member Send Private Message
Posts: 14
Basic Member

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 Send Private Message
Posts: 641
Veteran Member
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.