Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > ION

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
15%
200 - 500 GB
27%
500 - 800 GB
4%
800 - 1200 GB
4%
1200 - 1500 GB
12%
1500 - 2000 GB
15%
> 2000 GB
23%
Total votes: 26

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 11th May 2018, 09:39
LukeMa LukeMa is offline
Junior Member
 
Join Date: May 2018
Posts: 3
LukeMa is on a distinguished road
Baan: LN 10.5.2 - DB: SQL - OS: Windows
Post Connect the database to select Oracle and how to output the statement

Hi All
Create a Oracle database connection point(Connection point > connection > database >oracle),How SQL statements output results?
thanking you in advance
Attached Images
File Type: png Example.png (63.5 KB, 17 views)
Reply With Quote
  #2  
Old 14th May 2018, 15:57
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,356
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
Can you please post your script rather than the message box? It will help people understand the problem better.
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
  #3  
Old 15th May 2018, 08:01
LukeMa LukeMa is offline
Junior Member
 
Join Date: May 2018
Posts: 3
LukeMa is on a distinguished road
Baan: LN 10.5.2 - DB: SQL - OS: Windows
Quote:
Originally Posted by bhushanchanda View Post
Can you please post your script rather than the message box? It will help people understand the problem better.
thanks!This problem has been solved!Create functions in the database, and then query the function, you can generate documents.
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


All times are GMT +2. The time now is 02:07.


©2001-2018 - Baanboard.com - Baanforums.com