Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 21st November 2002, 02:21
NPRao's Avatar
NPRao NPRao is offline
Guru
 
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,032
NPRao will become famous soon enough
Baan: iBaanERP-5.2a(Reger),SSA-ERP-LN-6.1,Infor LN-10.x - DB: Oracle-10g,11g,12c,MS-SQL - OS: HP-UX, Linux, Windows
Count Number of Records by Tables and Companies

Here I start my list of things To Do (Enhancement Requests) for the BaaN guys

The standard session count number of records by table - ttaad4222m000 takes only one company at a time.

We had our requirement to determine the table counts for a set of tables across all the companies.

Hence I made this sessions which gives the output to a Excel sheet.
Attached Images
File Type: jpg count-number-of-records-by-table-and-company.jpg (25.1 KB, 423 views)
__________________
The art of perfection does not lie in doing extraordinary things but, doing ordinary things extraordinarily well. [-N. Prashanth Rao]
How To Ask Questions The Smart Way,BaaNBoard,NPRao
Reply With Quote
  #2  
Old 21st November 2002, 02:23
NPRao's Avatar
NPRao NPRao is offline
Guru
 
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,032
NPRao will become famous soon enough
Baan: iBaanERP-5.2a(Reger),SSA-ERP-LN-6.1,Infor LN-10.x - DB: Oracle-10g,11g,12c,MS-SQL - OS: HP-UX, Linux, Windows
Excel Output

Here is the output in excel sheet.

Pat, it seems I cannot attach excel sheets so I have to zip to upload here.
Attached Files
File Type: zip table-counts.zip (1.0 KB, 146 views)
__________________
The art of perfection does not lie in doing extraordinary things but, doing ordinary things extraordinarily well. [-N. Prashanth Rao]
How To Ask Questions The Smart Way,BaaNBoard,NPRao
Reply With Quote
  #3  
Old 21st November 2002, 09:59
patvdv's Avatar
patvdv patvdv is offline
Board Master
 
Join Date: Aug 2001
Location: Belgium
Posts: 2,167
patvdv is on a distinguished road
Baan: n/a - DB: n/a - OS: AIX, HP-UX, Linux
NPrao,

I added 'xls' to the list of allowed file extensions. Still a ZIP is equally good as it saves database space
__________________
Regards,

Patrick Van der Veken - Admin & Founder - (c) 2001-2017 baanboard.com/baanforums.com
Reply With Quote
Sponsored Links
  #4  
Old 4th March 2004, 09:30
savitr's Avatar
savitr savitr is offline
Member
 
Join Date: Apr 2002
Posts: 48
savitr is on a distinguished road
Baan: BaaN IV C4, SSA Ln6.1 - DB: Oracle,SQL - OS: unix,Win2003
hi

Mr.NPR

Can u please post the source code

Thanx
Reply With Quote
  #5  
Old 23rd March 2004, 12:53
markom's Avatar
markom markom is offline
Junior Member
 
Join Date: Jul 2002
Location: Slovenia
Posts: 24
markom is on a distinguished road
Baan: B40c4 - DB: Oracle 8i - OS: Win NT
Can you please post me source code

Hello!

Can you please post me source code
__________________
Lp Mare
Reply With Quote
  #6  
Old 12th June 2004, 07:15
learner's Avatar
learner learner is offline
Guru
 
Join Date: Dec 2002
Location: New zealand
Posts: 562
learner is on a distinguished road
Baan: BaaN Vc with sp 28 - DB: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit - OS: HP-UX B.11.31
has the source code being posted at some other forum ??

Regards

Learner
Reply With Quote
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
Number of tables in one database richard Operating Systems & Databases 3 27th August 2004 16:15
un-sharing text tables nick_rogers Tools Administration & Installation 3 5th December 2002 01:54


All times are GMT +2. The time now is 23:33.


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