Search found 4 matches

by QPRocky
19.10.2008, 20:43
Forum: MySQL
Topic: Data from insert
Replies: 5
Views: 852

That SELECT LAST_INSERT_ID() saved my day. :)
Thanks a lot for both answers.
by QPRocky
19.10.2008, 17:47
Forum: MySQL
Topic: Data from insert
Replies: 5
Views: 852

Data from insert

Hi. Is it possible get data during insert? +-------+------------------+-----+-----------------+ | Field | Type | Key | Extra | +-------+------------------+-----+-----------------+ | id | int(10) unsigned | PRI | auto_increment | | name | varchar(15) | | | +-------+------------------+-----+----------...
by QPRocky
23.08.2008, 11:24
Forum: MySQL
Topic: unknown MySQL Datatype
Replies: 10
Views: 3118

I have same problem. When I try showmessage(ZConnection1.ClientVersionStr + '-'+ZConnection1.ServerVersionStr); I get access violation error. But I have MySQL 5.0 and zeos 6.3.3. This is what I have added to ZQuery.SQL.text: SELECT * FROM kissa; and here's table which I added on MySQL http://pp.kpne...
by QPRocky
23.08.2008, 09:36
Forum: MySQL
Topic: Problem with connecting
Replies: 2
Views: 834

Problem with connecting

Hi. I'm having problem to get connected to database. I have MySQL 5.0 server and Zeos 6.6.3. I added ZConnection to form, added to properties username and password and selected protocol mysql-5. When I try to change connected property, i get following message: "Client does not support authentic...