Posts Tagged ‘sql’

Delphi, ADO: update/modify and delete from a join recordset

Monday, August 10th, 2009

It’s been a while since I’ve written a Db-app from scratch and a few days ago I started writing an invoice-like app for myself.
At one point I needed to insert/update/delete into/from a resultset of a join. I was getting this error:
“Row cannot be located for updating. Some values may have been changed since it was last read.”
After googleing for a little while I found the following golden piece of information on ADO programming on the web archive which was posted here

Now everything works like a charm 🙂

Related posts

MySQL – Data Provider Or Other Service Returned An E_FAIL Status

Friday, August 7th, 2009

I spent quite soem time on this error until I managed to figure it out.
My problme was different from what you can usually find on the net. I had a table with 1 autoinc integer column and the rest all varchars fo various lengths. So no date field.
What I ended up doing was to install the latest mysql odbc connector (5.1 as of this writing) which offered me some options (I don’t knoiw if they are required as I set them, I used my common sense when setting them absed on my needs). I cheked on the flags pages the following:
– Don’t prompt when connecting (flags 2)
And that’s it 😀 so nothing spectacular.
Before this I was using the 5.0 connector. So it appears there was some problem there because this is the only thing I changed.

Enjoy 🙂

Related posts