You were my El Cholo bud, so i haven't been back. I've been going to another place that has pool tables. But I told these guys at work I can get good drinks at El Cholo, so they will probably want to go there too.
>>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
(On an infant's shirt): Already smarter than Bush