Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 23rd March 2017, 10:04
Andrea Rossi Andrea Rossi is offline
Newbie
 
Join Date: May 2016
Posts: 1
Andrea Rossi is on a distinguished road
Baan: FP3 - DB: MS SQL Server - OS: Windows Server 2003
Easy SQL pdf
Baan: Other/Unknown
C/S: None/Unknown

Could you please send me a link with Easy SQL part1&2 pdf?

I'm not able to find it anywhere.

Thanks
Reply With Quote
  #2  
Old 23rd March 2017, 13:28
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,903
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Please only post your question in one place. Moderators will move to the necessary forum. Sorry to say, but we should not share copyrighted material on this forum. I have never seen the documentation myself, but you should be able to ask Infor for the documentation.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #3  
Old 24th March 2017, 07:58
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,639
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
Don't share copyright documents here !

Quote:
Originally Posted by Andrea Rossi View Post
Could you please send me a link with Easy SQL part1&2 pdf?

I'm not able to find it anywhere.

Thanks
Hello,
contact your Infor responsible for Copyright protected documents.

Use docs.infor.com !!
For example: https://docs.infor.com/ln/10.4/en-us/lnolh/default.html

At above search for "easy sql" an you'll get netx and more.
Code:
Defining a query

You can create stand-alone queries with Easy SQL or with the Text Manager. Easy SQL helps users to define queries in a simple, menu-driven way. Text Manager enables you to create more complex queries.

To define a query:
Step 1. Specify basic query properties

    Start the Query Data (ttadv3580m000) session.
    Click New. The Query Data (ttadv3180s000) details session starts.
    Specify the basic properties of the query, such as the owner and the output type. Select one of the following output types:
        Report list
        Report label
        Chart
    To return to the Query Data (ttadv3580m000) overview session, click Save and Close.

Step 2. Define the selection criteria for the query

To define the selection criteria for the query, you can use:

    Easy SQL

    Easy SQL helps users with insufficient knowledge of the structure of the data model to define queries in a simple, menu-driven way. See To define a query with Easy SQL.

    The Text Manager

    You can use the Text Manager to create more complex queries. See To define a query with the Text Manager.

    You can also use the Text Manager to modify queries that were previously defined with Easy SQL.

Step 3. Optionally, generate the query report

Complete this step only if you selected Output Type Report list or Report label.

To generate the query report, complete the following steps:

    Start the Query Data (ttadv3580m000) session.
    Select the query and, on the appropriate menu, select Generate Query Report.

Step 4. Optionally, add query table fields to a chart

Complete this step only if you selected Output Type Chart.

See To add query table fields to a chart.

You can now run the query. See To run a query.

Related topics

    To define a query with Easy SQL
    To define a query with the Text Manager
    To add query table fields to a chart
    To run a query
    The LN SQL section in the ERP Enterprise (LN) Programmer's Guide
Regards
__________________
//Bernd

Last edited by bdittmar : 24th March 2017 at 18:22. Reason: Additional hints
Reply With Quote
Sponsored Links
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Varianten mit Easy SQL auslesen aeschen Blogs and Web links 0 22nd October 2010 16:09
Easy SQL date() Granholm Tools Development 6 23rd June 2009 22:29
USE "Query By Easy SQL..." ,But Run ERROR zhangguowu0506 Tools Development 1 7th October 2008 02:40
Strange error while importing tables: Can not create index 9999 eppesuiG Tools Administration & Installation 8 17th March 2008 04:35


All times are GMT +2. The time now is 11:14.


©2001-2017 - Baanboard.com - Baanforums.com