Noobs need help..
i need some help, in my company we use Baan with bw client to view customer's request.. but the client's interface is painfull and i would like to make a simple client (a webui) just to list each requests in a smarter aspect.
But.. i don't know anything about Baan : I tried to make sql queries in vbs but i don't know field's names, i even don't know what kind of database it is ! Where can i find some clue to begin my project ?
Here is my bwc config :
command=-- -set USER=xxx
Thanks a lot..
With only the bw client information I am not sure you can even get started. If you have the tools module you can at least look up tables and maybe see what they have for setup information. In our company that would not give you enough information to connect into the database to even read tables. Now what I could do is get enough information to use to connect into baan with the client (when you configure it there is an automation tab) and run sessions thru something like excel or VB. You can search this forum http://www.baanboard.com/baanboard/f...splay.php?f=59 for OLE and information around that. But that was even more cumbersome to me than the client itself. It might work better for you, but I no longer even look at it.
Also if you log into baan using the client and bring up a session usually you can hit the help button and click on field to see its name. Without the tools module I am not sure how you could look up the tables see what is available and how they all link together. Someone else might have a better idea on how to poke around and see what is out there.
Thanks for your answers Mark !
So with the help button i grab few things but i miss something :
my session is tssocc511m000 my first field show tssocc511m000dtssoc210.orno, so i guess field's name is dtssoc210.orno but olesql_parse return an error if try a query (but i works with ttaad200.user)..
Biv / Ln Fp????ß
without knowing your System:
LN Featurepack a.s.o.
Used Database ?
it will be difficult to give some hints.
Table tssoc210 is Service-Order-Control Workorders
The index of this table is orno, pono
You gave me a big hint Bernd ! I tried query on dtssoc210.orno but you point it it's in fact tssoc210.orno ! So it works but it doesn't qive me all tables.. you know this table's name are they all common ? I don't know what kind of database it is ! I've got no other tools.. just bw.exe and i would like to extract all data from my session tssocc511m000 just to make a webui !
Not sure - but in 4c4 I know I could query table ttadv420 in company 000 to get the table names - not sure that would help you. Then I could query ttadv422 to get the field for that table, or ttadv421 to get the index columns. I am not sure about LN or if you can even get to tables like that. On our unix systems I can shell out and run like bic_info6.1 on a session to get more information - not sure that is available to you. Once upon a time I had a tool that did something like this from Gfasbender - not sure if another company has tool like that or not.
tssoc-tables for service orders
for Service orders These tables are used:
If your company uses baan you must have someone that is the administrator for it. suggest you start by asking them your questions.
It's a big company and nobody will understand why i'm doing that..
So i tried :
I'm not sure, but i think your query is wrong, try:
you're right. but i don't know how to list all fields, this works but "getstring" from what ?
|All times are GMT +2. The time now is 16:47.|
©2001-2017 - Baanboard.com - Baanforums.com