Your right - what works works. Appreciate all the help here and have learned a lot for future tasks - we can close this issue now

Just looked up scope_identity. Nice, except for one thing - no yelling now, I did not right the program, there tables DO NOT seem to have any identity fields...

waht is scope_identity()

sorry - the psuedo code was an example of what I wanted to do, the actual code is all in one procedure

understood. BTW EXISTS works nicely so far

I will look into the EXISTS you mention. I was usign the @@ERROR test to also decide what information I would add to the return mesage. There are...

You are almost correct. It is not an all or nothing in all situations. The fatal errors will of course never get to the commit section anyway.

I only...

Are you saying I need to start all this over again in another forum?

by passing 2 parameters from Visual Foxpro [VFP9] procedure to SQL thru SQL passthru

I create one header record, one edit record, one setup record, one revenue code record and one...

Can't use try catch - still in SQL 2000 :(.

Don't know what a CTE is - my bad.

I check to see if the record was inserted or not by testing...

Everything is already in one stored procedures. Not real familiar with the term SET BASED OPERATIONs but assume it means handling flow with mem vars.

The stored procedure has become huge...

Been programming in Foxpro for many years, never heard of GOTO before. SQL is so picky that I just wanted to be certain before I blew something up that...

Then I am to understand - when one of the stored procedures has completed it's task, it will return to the calling procedure.?

I usually try to follow the principle that...

SO how is an SSIS job created - I cna find nothing so far in the way of examples

I basicaly want to download a csv file from a webstie and...

can anyone advise on how to do this from within VFP9?