I have a Sybase (15) Lc connector.
With that connector I want to execute 2 stored procedures, using connector.Excute(statement, MyDestinationFieldlist).
My first stored procedure creates an inquiry entry in an externel system, and returns a single result set containing an inquiry number for that entry.
The second stored procedure creates a work order on the entry I created with my first stored procedure. I get back a result set contiainin a work order
number.
My problem is that this only works 100% sometimes. I get no error messages at all, the stored procedures always returns a result set with the inquiry no and work order no
that is supposed to be created, only sometimes the work order is not really created. The inquiry entry is always working.
My question is, if there is a problem executing more than one stored procedure using the same connector. I have tested to split them using deifferent connectors but get the same
reult. I have also tried using the method Call instead oc Execute, but that worked even worse.
(If I execute my stored procedures outside from Notes, for example in ASE isql it always work, using the exact same data.)
Does anyone have a clue?