I am trying to use OLE from VB to return all fields for a table. I then want to loop through all fields and create the definitions in a locally stored database at runtime. I see that there are functions rdi.table and rdi.table.columns that appear to be what I need for this but they dont seem to be available via ole. Is this correct? If they are available, what dll are they in?

Thanks

I thought the rdi commands were in a library, but I did not see them. So right off-hand I can see two ways to do this. First you can write your own Baan dll using the rdi commands you need. Then call this from VB. Second you can always read table ttadv422 to see the fields and their declarations. Of course you need to know which VRC the table is in - then just query straight against the table.

Second you can always read table ttadv422 to see the fields and their declarations. Of course you need to know which VRC the table is in - then just query straight against the table.
I was trying to avoid this for the obvious performance reasons and was hoping to use a native baan tool so we dont have to worry about upgrades and modifying a custom dll. Let me know if you find the rdi's anywhere because I couldn't find them either.

I was trying to avoid this for the obvious performance reasons and was hoping to use a native baan tool so we dont have to worry about upgrades and modifying a custom dll. Let me know if you find the rdi's anywhere because I couldn't find them either.

There is always other tools (http://www.fasbenderinc.com/xql.html). I have no clue how Gordon wrote this, but it did not have any performance issues. I used this a few times and it looks like he has made some improvements to it. This returned the table structure, references and etc.

Thanks for the reply. I had seen Gordons site previous to posting this. Are these spreadsheets available for download?

PS. by GO Cards, are you talking STL Cardinals?

Sorry, but it does not look like there is a download area anymore. I would recommend contacting him.

I was wondering when someone would ask about that - University of Louisville. I added that to my signature during the start of the NCAA Basketball tournament. :)

Here are some general functions (http://www.baanboard.com/baanboard/showthread.php?t=24217) which does uses rdi functions extensively for all table field . Create a ur own dll and function in Baan and call the same in ole . That can serve ur purpose .