>Unfortunately, doing a batch load the way you are, once an error is hit, the process stops. Same as running a VFP program, unless you're trapping the error somehow, as soon as you hit an error, the process stops.
>
>>Hey and you are correct my friend, ;-), it is only kind of extrange that
>>only the first row will get commiteed into SQL, when there is 99 more to go

Niceeee!! okey,, yes,,I am trapping the conenction error now, I had about 15 tables to update, I am parsing a daily report , a summary report, and I had to
create around 16-17 tables on VFP and then move them into SQL for management
to query.
And yes trapping the error is what is helping me debug this thing, at least
I have only to append into the remote view and waouuhh!! there it goes the
update , I was afraid to issues single INSERTS statements if this process
did not work.

thanks guys,, thanks PF

PS how's el Cholo