Working against MySql I am getting error codes 7 and 42000.

I have 'selected' approx 4500 rows and then convert change one field and update back .. Approx every other row fails.

My guess is that this is something to do with the odbc drivers .. though I am not sure of that.

I have do very large bulk inserts against Mysql from other tools and have not had any problems .. so I am trying to get some Idea as to what is happening here.

Ideas are appreciated

Thanks

[email protected] onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"

David Tod Sigafoos ~ SigSolutions

Phone: 503-639-4240

1) The 42000 error *seems* to be update/insert errors due to the data .. some of the items have a ' internal to the data which is throwing things off.

2) The Error 7 is still an oddity ..

I am changing file names .. so I select all the rows with file names starting with e:

select filename from songlist where filename like 'E:%'

The first pass this might return 1000 rows. The update process then simply swaps the e: with a g:

But during the loop it only completes approx every other one. If I then repeatedly do the process it select fewer and fewer and updates them (every other one …)

This is very like a binary search .. but in reverse

Still looking for ideas ..

Thanks

[email protected] onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"

David Tod Sigafoos ~ SigSolutions

Phone: 503-639-4240

View this thread on the forum...