Page 1 of 1

delphi 7 mysql data inserting problem help me?

Posted: 04.11.2006, 01:03
by capella
firstly hello everybody because I am new member...
I want to add record to database but I can't make it...before I try to take to record to database I succeed. I wrote to string list editor select * from table name.It was work..but I cant add a new record outside to database
ı think I need a command...What is this? help me please

I use mysql4.1

Image

Posted: 04.11.2006, 01:53
by fduenas
Well for first i see you're using a very old version of zeoslib (look at the icons :D )
I recommend you to download latest 6.6 version, it is available from the start page of this site.

In the windows you're showing you have to write a select clause that will browse the records from your table as you want.

for example:

select * from mytable

Make sure you assing to TZQuery's Connection property to you TZConnection component.

Also make sure that TZQuery's property 'ReadOnly' is set to false, or in your case for your zeoslib version 'RequestLive' is set to true, if not, you will onyl browse a readonyl query and you will not be able add, edit or delete new records.

I recommend you to update to latest ZeosLib 6.6 because it has a lot of bugfixes and improvements. It will be very difficult to help you if you still use old zeoslib versions.

Posted: 04.11.2006, 09:01
by capella
thanks for helping. my problem solved...Because RequestLive is set false so program give me error...Now the program worked...thanks fduenas