Hi all,

we are integrating baan with an external java web e-commerce. We need to insert the web orders into the "ttdsls900" table.

We first approach was to insert in the table a new row with an "INSERT" SQL sentence. That doesn't work because we don't know what to put into the "hash" columns.

Then, we are trying to make a DLL as a bridge beetween Java and the baan's DLL. The idea is that our dll we'll call the baan's dll. But have a lot of questions:

- What DLLs baan exposes, and how we can to use them ?
- Exists documentation?

Anyone have an example?

Thanks in advance !!!

Dani.

Dani,
I have used a product developed from Fullscope tha will let you call a Baan DLL from outside application. The ERP adapter itself is in Java and one can do lot of fun stuff with it. Also they have a product - session automator, its like AFS. So one can create a BAAN DLL, pass all the parameter, then use session automator to create sales orders. Call the ERP adapter from an external applications and here is your solution ready that will use the same customization code that you have developed for Baan. Its pretty neat.

Arvind

Thanks Arvind.
Anyway we are looking for an open source solution. Following the forum I interpret that it's possible, but I'm not able to find the solution. Maybe exists one manner to calculate the "hash" values, or another secret way...

I would appreciate that if someone know that NOT exists any "free" way to make this tell me please; and we'll think to use a propietary solution.

Thanks.

from baan help . I haven´t checked it

To call BAAN 4GL functions in a C-program the BAAN functions must
be converted to a C-like format. These functions must be declared with
the keyword EXTERN and usually they are located in a library (so called
Dynamic Link Library (DLL)).

Conversion of a BAAN library to a C-library can be realized with the
program bic_cstub.

SYNOPSIS

bic_cstub6.1 [-s] [-a] -d <library> -o <object>

DESCRIPTION

The program bic_cstub converts a BAAN library with external functions
to a C-source. After conversion the external functions can be called in
a C-program. The BAAN 4GL functions keeps the same name, except the
following rules:
- dots ('.') in function names will be converted into underlines ('_')
- dollar signs ('$') in function names will be removed

Options:

-s : the generated C-source only handles single byte characters
-a : an ANSI-C source will be generated
-d : specifies the BAAN library which must be converted
-o : specifies the name of the C-source; the destination
of the converted library


If the -s option is not specified, string arguments in a BAAN 4GL
function will be converted to a string in TSS (BAAN Super
Set) format. The BAAN Super Set contains both multibyte and
single byte characters.

By default, function arguments in BAAN are passed by value.
When an argument has to be passed by reference it is prefixed by the
keyword 'ref'. In the generated C-function all reference arguments are
pointers. So, when a BAAN 4GL function has two arguments of type long,
one passed by reference and one passed by value, the first argument of
the generated C-function will be of type pointer to long and the second
will be of type long.

Refer to chapter Demo aplicación for more information about the
usage of this program.