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
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 6th December 2001, 08:02
~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: ~*~
Post DEV: Extend Baan code without sources

Trying to work without Baan code has been an issue for quite a while. Those who discovered QKEY know that 4GL sessions can be customized to a good extent without the source code. The idea of creating an equivalent has been in my mind for quite a while now. About a year ago I wrote a little bit of code as a proof of concept. And it has been stagnating ever since. I made an attempt to create a list of volunteer developers through this thread without much success. People just did not say anything after receiving the code. I just do not know if they did not understand what the code did (very possible - I sent it out with practically no documentation - just like now) or they expected me to give a fully working script (this is not true even now - notice the DEV in the heading).

However inadequate the two scripts that I am posting may be, they do work (or atleast did before I made changes :)).

Deliverables expected at the end of this project:
  • a name for this project/product
  • documentation
  • technical design so that the maintenace can be easy
  • added features like ease of use / being not affected by changes to Baan standard object

Please try this program and post changes. Thanks to Krishna Eranki / Praveen Ambekar / Patrick Van der Veken (in chronological order of their contributions) for making this possible.
Attached Files
File Type: zip files.zip (5.5 KB, 1891 views)
__________________
~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.

Last edited by ~Vamsi : 6th December 2001 at 08:06.
Reply With Quote
  #2  
Old 30th December 2001, 05:59
KlayVessel KlayVessel is offline
Member
 
Join Date: Aug 2001
Location: Atlanta, Georgia
Posts: 30
KlayVessel is on a distinguished road
Baan: 3b2, 4(b-c4), 5c - DB: Oracle 7, Oracle 8, MS-SQL, Informix - OS: HP-UX, AIX, Tru64, Sun, NT, Linux
Hmmm...interesting.

I don't think I could contribute to this project...I'm sure that would taint it! Ha!

Don't know whether to be happy about this or not...but I am always glad to see people working on innovative code.
__________________
Kevin Brock, OCP, MCSE / Senior Technical Consultant
Fullscope (formerly RedKlay, formerly QCI)
(Web & Baan Consultants)
Reply With Quote
  #3  
Old 3rd January 2002, 23:20
evesely's Avatar
evesely evesely is offline
Guru
 
Join Date: Dec 2001
Location: Lisle, Illinois USA
Posts: 412
evesely is on a distinguished road
Post DEV: Updated script

I have updated the code for ~Vamsi's main.bc file. I had a couple of problems running the original version. This now works well for me on IVc4. The following changes were made:
  • Extended to handle a larger number of functions (it died trying to handle tdsls4102 before)
  • Now works with functions that return values (e.g., function extern domain tcmcs.long tcedi0052.get.next.btno())
  • Added missing "functions:" statement
  • Fixed problem that occurred when parent had a "before.program" section
  • It is now skipping functions that seemed to be added as part of the compilation process (and hence caused the original compilation to fail) like g.check.input.funcs()

My compliments to MohanaVamsi Potluru and Praveen Ambekar on the original code. Also my apologies regarding my efforts to modify the copyright, disclaimer, etc. I was unsure how to put in my changes and still fit under the protection of the disclaimer. If I should fix this, please let me know -- I will be happy to do so.

A brief test seems to indicate that this works on Baan 5c, too, but I didn't do a lot of testing there. I'm sure others will have more features to add...
Reply With Quote
  #4  
Old 7th January 2002, 21:24
~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: ~*~
Ed,

Could you post the revised main.bc file? The "disclaimers" apply to all authors. If you feel you have rewritten the code you can put your name in the author field while acknowledging the original author(s). Alternatively leave the original authors as such and add your name to the "contributors" (which is not present in the template at this moment).
__________________
~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
  #5  
Old 8th January 2002, 17:23
evesely's Avatar
evesely evesely is offline
Guru
 
Join Date: Dec 2001
Location: Lisle, Illinois USA
Posts: 412
evesely is on a distinguished road
Talking DEV: Updated script

I obviously forgot to attach this last time.
Attached Files
File Type: bc main.bc (8.5 KB, 1173 views)
Reply With Quote
  #6  
Old 16th January 2002, 21:52
toolswizard toolswizard is offline
Senior Member
 
Join Date: Aug 2001
Location: USA
Posts: 292
toolswizard is on a distinguished road
Baan: 4c4, 50b, 50c, ERP ln - DB: Informix, Oracle, Sql - OS: Unix, NT, AIX
I tried to compile the sources and have many errors. Is the a compilable version?
Reply With Quote
  #7  
Old 16th January 2002, 22:46
~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: ~*~
Toolswizard,

Thanks for trying the code. I have not worked on this code for a long time. My client does not have a need for such a product as they have source code. Hence it is not a priority on my list of things right now :(. I have posted the code I have in hopes that others will be able to extend it further and make it useful.

Since Ed posted revisions to main.bc I think he must have been successful in compiling the code. Please post your compilation errors to the thread and may be we can find out what the problem is.
__________________
~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
  #8  
Old 16th January 2002, 23:02
toolswizard toolswizard is offline
Senior Member
 
Join Date: Aug 2001
Location: USA
Posts: 292
toolswizard is on a distinguished road
Baan: 4c4, 50b, 50c, ERP ln - DB: Informix, Oracle, Sql - OS: Unix, NT, AIX
I am taking a chance and changing the "options" variable and changing it to opt. It would seem baan has a macro (#define) for the work options and it is trying to expand it. It now compiles with a unrelated warning.

BTY did you get an email from me in the last few days asking more questions?
Reply With Quote
  #9  
Old 16th January 2002, 23:22
toolswizard toolswizard is offline
Senior Member
 
Join Date: Aug 2001
Location: USA
Posts: 292
toolswizard is on a distinguished road
Baan: 4c4, 50b, 50c, ERP ln - DB: Informix, Oracle, Sql - OS: Unix, NT, AIX
ok, I have it compiled and did run it against a small display session. I have a new file created by rush. Now does this file take place of the user script in the session, replacing the original script? Is it supposed to run stand alone? Please explain how I should test this out. Once I have a working model, I should be able to continue on more advanced development.
Reply With Quote
  #10  
Old 16th January 2002, 23:56
evesely's Avatar
evesely evesely is offline
Guru
 
Join Date: Dec 2001
Location: Lisle, Illinois USA
Posts: 412
evesely is on a distinguished road
This file that is generated should be used as the program script for the session in question. It can be modified just like any other Baan 4GL program script. The one caveat is that you can't have the same section name as an external function call. For example, this is not allowed:
Code:
choice.cont.process:
on.choice:
	code
...
function extern on.choice.cont.process()
{
	other code
}
You can put things in either place, but not both.

Once you have attached this program script to the session, you should be able to run that session and access all of the functionality of the parent (i.e., standard Baan) script plus or minus any changes you desire. Unfortunately, you don't have the ability to modify the underlying functionality, but rather only decide if and when that code runs. If you want more flexibility, getting the Baan source code would help. ;-)
Reply With Quote
  #11  
Old 17th January 2002, 00:28
toolswizard toolswizard is offline
Senior Member
 
Join Date: Aug 2001
Location: USA
Posts: 292
toolswizard is on a distinguished road
Baan: 4c4, 50b, 50c, ERP ln - DB: Informix, Oracle, Sql - OS: Unix, NT, AIX
Thanks ED,

I am not trying this for my regular job. This is more of a curiosity. I would like to help get this into a usefull open source product. As your post states, you can use the call in either syntax, but not in both. I was already thinking of how this can be used to make the code more readable for the user.

I have access to development systems and source code to test all of this out. I can see where knowing the fuctionality of the standard is going to be needed to do any kind of development. Expecially to test it out fully. A programmers guide is surely going to be needed for those new to Baan.

If anyone is planning to try a development effort please let me know.

Bill Prokurat
aka toolswizard@spire.com
Reply With Quote
  #12  
Old 20th February 2002, 17:27
klixy23's Avatar
klixy23 klixy23 is offline
Senior Member
 
Join Date: Feb 2002
Location: Germany
Posts: 116
klixy23 is on a distinguished road
Baan: BaaN IVc4 - DB: Informix - OS: Windows Sever 2003
Thumbs up

I tested the program. I made the changes from toolswizard in this thread (variable "options" to "opt"). I compiled and run it.



IT WORKS.

Thanks for this great idea.
Reply With Quote
  #13  
Old 22nd February 2002, 17:16
klixy23's Avatar
klixy23 klixy23 is offline
Senior Member
 
Join Date: Feb 2002
Location: Germany
Posts: 116
klixy23 is on a distinguished road
Baan: BaaN IVc4 - DB: Informix - OS: Windows Sever 2003
In my last post I wrote "IT WORKS", but somthing is wrong.
I tested the session tisfc0202m000 (Report Complete Order and Adjust Stock) and add an information field.
The session did the work, but the field tisfc001.cmdt wasn't update correctly, it was blank. This is always happen, if the form field cmdt.frm leave blank and the user press the continue button.
If the user fill the field, then all is ok.

So I changed back to the original session. I tested in the same way and the field is updated correctly. I think there is something in the original baan code, that fill the field automatically if it is blank or there is an internal function call.

Can someone check this? Or do you need more information?

Thanks.

klixy
Reply With Quote
  #14  
Old 22nd February 2002, 21:09
~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: ~*~
What version of Baan? Once klixy responds could someone who has that version with code check to see what is really happening. I have access only to Baan 5b.
__________________
~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
  #15  
Old 22nd February 2002, 22:24
toolswizard toolswizard is offline
Senior Member
 
Join Date: Aug 2001
Location: USA
Posts: 292
toolswizard is on a distinguished road
Baan: 4c4, 50b, 50c, ERP ln - DB: Informix, Oracle, Sql - OS: Unix, NT, AIX
I have access to almost all versions of source. But I really would like to see his code also. klixy can you please post your source for that field.
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
Help text code (Baan 5) spartacus Tools Development 0 1st April 2003 12:27
NEW: vbcode CODE extensions patvdv About Baanboard.com 3 13th March 2003 12:19
Baan World Users conference in Orlando chadwickh General Discussion & Chat 7 3rd November 2001 22:55
Availability of Web-Based DEM (Baan Press Release) Pierre B. General Discussion & Chat 0 5th September 2001 06:59
BSP-US (LLC) added as a Baan Education Alliance svandenh General Discussion & Chat 1 20th August 2001 20:44


All times are GMT +2. The time now is 00:19.


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