Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > Code & Utilities

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 12th April 2007, 15:36
gianci's Avatar
gianci gianci is offline
Junior Member
 
Join Date: Oct 2004
Location: Genoa, Italy
Posts: 21
gianci is on a distinguished road
Baan: ERPLN, baanIVc4 - DB: oracle - OS: aix6.1, hp-ux
Referential integrity check

Hi all,
some time ago I developed a session which could be of some interest
to check missing references on DB.
The standard Baan utility refint6.1 already provides check on references,
but as far as I know does the check only for references of type
'restricted with counter'.
This session performs additional checks on fields referenced with
'lookup' referential control.
The session was developed on Baan IV c4 version, and has been tested
on Unix (Aix/HP) platform.
Please ask me if you need further information.
Attached Files
File Type: zip refintcheck.zip (99.5 KB, 41 views)
Reply With Quote
Sponsored Links
  #2  
Old 12th April 2007, 17:07
~Vamsi's Avatar
~Vamsi ~Vamsi is offline
Guru
 
Join Date: Aug 2001
Location: San Diego CA, USA
Posts: 590
~Vamsi will become famous soon enough
Baan: ~*~ - DB: ~*~ - OS: ~*~
Thanks for the contribution. Please post the source code to this utility as well. Users should have the option to see the source without having to import the dump files.

Also having the source files gives users the option of using it on non-Baan IV versions.
__________________
~Vamsi
Vamsi Potluru
Baan XL Yet another tool to format Baan output in Excel from Baan Board
This one just happens to be free :)

Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #3  
Old 12th April 2007, 17:38
gianci's Avatar
gianci gianci is offline
Junior Member
 
Join Date: Oct 2004
Location: Genoa, Italy
Posts: 21
gianci is on a distinguished road
Baan: ERPLN, baanIVc4 - DB: oracle - OS: aix6.1, hp-ux
Red face Source

Sorry for the inconvenience. Here is the programs source.
Regards

PS: I named the source with 'txt' suffix, but of course it is a Baan program script. I don't know if there is a 'standard' suffix to use for such files.
Attached Files
File Type: txt psrvr9210.txt (22.1 KB, 97 views)
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 Off
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to ignore Referential Integrity Constraints iamdnb Tools Development 2 15th January 2004 19:06
How to check referential integrity of tables unicron Tools Administration & Installation 3 31st December 2003 10:19
Check database integrity pitfloner Tools Administration & Installation 4 20th September 2003 12:07
Referential integrity tsanchez Tools Development 5 20th December 2001 12:57


All times are GMT +2. The time now is 05:03.


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