Even more desparate!!!!

[GeorgeMar]

I posted this last week and have had no response. I have
spent days on this. Can anyone point me in the right
direction at least?

Much appreciated.
*************

I have a procedure in database B (say) that is called from
database A (say). The procedure imports data from a text
file,using TransferText, amongst other things.

When I run the procedure from within database B, the import
works fine.

When I run the procedure from database A, using Run
Method, the data within the table is corrupt. The
imported data is placed in the wrong columns.

This procedure has been working well until now.

Has anyone come across problems with Run Method?

regards
george
..

 

[JohnFol]

presuming you are doing the RunMethod from an instance of the other db, it
could be a number of things. For example, if your transfertext has a
FileSpec, does this exist in both db's?

Can you paste the code that causes the problem? For example if steps A, B &
C give results as expected, but step D corrupts the data, can you also
highlight the line?

Regards

 

[Emilia Maxim]

I have a procedure in database B (say) that is called from
database A (say). The procedure imports data from a text
file,using TransferText, amongst other things.

When I run the procedure from within database B, the import
works fine.

When I run the procedure from database A, using Run
Method, the data within the table is corrupt. The
imported data is placed in the wrong columns.

This procedure has been working well until now.

George,

do you use an import specification? Could be, the procedure would want
to have this from database A. Also, could you post the code?

Best regards
Emilia

Emilia Maxim
PC-SoftwareService, Stuttgart
http://www.maxim-software-service.de