Getting Multiple-Step...Errors on SY00500

[colttaylor]

Hi,
I'm a programmer trying to create an unposted g/l journal batch in Dynamics under Microsoft Sql. My customer does not have Integration Manager, so I have been writing directly to the files using ADO.
I've almost got my interface running, but I get a "Multiple-Step operation generated errors. Check each Status value" error whenever I try to insert a new record into the SY00500 table. I have read elsewhere on the web that this might be caused by one of my string fields being too long so I am checking them now.
Anybody have any other ideas on what I should do next?
Thanks in advance!
P.S. When I finally get this posting working, I am planning to post an outline of it (and maybe the delphi source code) as a tip on tek-tips. If it's stupid but it works, it isn't stupid

 

[DaveXYZ]

You find out if the error is in your ADO code or a database error. Use SQL Profiler (part of the Microsoft Sql tools) and monitor all exception events. It will tell you the specific error (key violation, type exception, etc.) so you can fix your code.

 

[colttaylor]

Thanks, I will try it later today.
Peace,
Colt. If it's stupid but it works, it isn't stupid