ADS Client Server (SAP)

[omni]

I will explain a little more, now that I have done more testing.

I am alone testing on my local drive. I did the creating of a work file using DC_ExecuteSQL( cServer, cSql,,,,,,,,,@cErrorString ).

That is working fine. I stopped after that and did not open the new work file and I had ace32 open. It showed the work file open, apparently from the above command, but in another thread(?). The file share error came up and I had your error routine, opened xdot and viewed all open files. Only two are open, and not the new work file.

So the creation of the work file leaves it open as far as ads is concerned from my function.

Does that make sense? I am going to stop it inside the function to see if its open there.

Did one more test inside the function right after the work file is created . Xdot shows only the 2 files open. Ace32 and ads shows the work file open and the 2 files. So ADS is locking the file as open but not accessible to close.
We normally delete these temp files and it will not do that. Finished some ones I already finished that do not open exclusive and all the temp files are still open in ADS.
I have also noticed after a CLOSE ALL some files stay open in ADS, but eventually close. Must be a delay, but not sure why.


Fred

[rdonnay]

Here is a new _DCADS.PRG file.

I added 2 lines of code to be sure to close both the cursor handle and the statement handle.

Copy it to \exp20\source\dclipx.

Run BUILD20.BAT or BUILD19_SL1.BAT to rebuild DCLIPX.DLL.

[omni]

Off the subject a bit but interesting to see that the copy and sort require rewriting but the exporting a file to excel does not...it works without any changes.
We use Alaska's excel.ch ..

Fred