Dear All,

How to attach SQL Queries to session ? I want to generate session for all SQL Queries that we have. Could someone guide me how to do that ? I try to generate new session and adjust form to SQL Queries input, and add report Queries to session report, but it don't work.

Please help,


h3nry_99@yahoo.com

I don't understand what you mean. You say you try to connect a SQL query to a Baan session. What do you mean with a SQL query? Is this a query created with easy SQL?

Youp

Yes, I mean query that I made through Maintain Query Data (ttadv3180m000) in Baan. Instead of using Execute Query (ttadv3280m000), we want to create new session for calling the Query personally, and we want to give authorization for that new session to different users.

Regards,

I don't think you can link a session to call a SQL Query as it is.

Unless anyone has any better ideas, what I have done in the past to make Queries into sessions is to create a new session. If you are unfamiliar with basic session building post back and I can go into more detail. You can generate a standard session based on the main table you are using in your query. Then, replace the generated session report with the report from your query. Replace the generated main select statement in the session script with the select from the SQL Query. Keep all the print commands, selectdo and endselect statements where they are. Make sure the form has all the variables you need to query, and add them if needed. Add any additional tables you use in your select to the declaration section. You will have to tweek the query to work with the form fields, but that should be the only hassle.

Let me know if you need more detail.

Good luck

Lisa Bencic
RMCis

You could create your own session(function server) that calls ttadv3180m000, and executes a query. You could do several things with you own session, like maybe let them zoom to the query they want and execute it. Or you could create a series of check boxes for the various queries. But even using this session in a function server fashion you have to have permissions to ttadv31800m000. Just a couple more ideas.

Mark

Henry asked for additional detail on converting SQL Queries to Sessions. Here's a word document with screen prints.

Henry - post or email me back if you have any problems or more questions.

Good Luck,

Lisa Bencic
RMCis

Thanks for the documents. I'll try it and hope with your document help, I can solve my problem.

Thanks a lots,

Henry

Henry asked for additional detail on converting SQL Queries to Sessions. Here's a word document with screen prints.
Henry - post or email me back if you have any problems or more questions.
Good Luck,
Lisa Bencic
RMCis

Hi!
Is there any solution for doing the same in ERP LN?

Thank you in advance,
Kitt

ps. This is my first post - so let me present myself.
My name is Krzysiek, I live in Poland, and I've worked with BaaN for a year.
Greets!

Welcome to the board Kitt! That documentation was done by Lisa, I am not sure how often she visits the board today or if she has the same type documentation for Ln. As it is I am on 4c4 for and I find it easier to generate a session and then just modify the report and script to do what I need. Not sure how that is on LN. Good Luck!

What we have done in the past is to add the query to a menu. To the end users it acts like a session and they do not know they are really just running a query.