Zeoslib Portal

Thanks zippo.

I found the problem.

I had loaded the tables using an exported sql script from another database that did not include any key values.

As soon as I set the primary keys everything works as expected.

Thanks again,

Ed

Using 6.6x

I have a set of table controls connected to our MySQL server. The table controls are linked to DBGrid controls and the contents display OK.

If I makea change it is not saved to the database when the app closes although it shows while running.

Any thoughts?

Thanks,
Ed

Mark,

I created the "easy test project" and couldn't reproduce the problem. ARGGGGH!

Still haven't found the source of the problem but have worked around it using a TBookmark before and after appending to the table.

It will show up at some point...

Thanks for your help.

Ed

I am using 6.6.2 with Delphi-5, sqlite3. Ztable.First; while not ZTable.Eof do begin ... ZTable.Next; end; In the course of ... the current record might get edited. This messes up the cursor position and Eof never happens. It seems to bounce back and forth between the first and second record if the ...

That was the problem. I was using an old MySQL dll. changed to 4.x and all is well.

Thanks for the quicl reply.

Hi,

I tried to use this method today after getting SVN 241.

The call: dbMySQL.GetColumnNames(TableName,'',qFields);
raises an exception "Column with name "Field" was not found."

Any thoughts?