Search found 3 matches

by MaxMara
26.05.2008, 10:36
Forum: MySQL
Topic: Problem with bulk-insert
Replies: 4
Views: 1370

OK. And this explains everything to me. :)
Thanks for your help Mark.

Regards
Christian
by MaxMara
26.05.2008, 07:14
Forum: MySQL
Topic: Problem with bulk-insert
Replies: 4
Views: 1370

Hi Mark,
the error occurs at 'ZQuery.Open'. The SQL property of ZQuery is empty. I tried my code with a ZTable instead of the ZQuery and everythings is working.
Very strange... :?:

Christian
by MaxMara
24.05.2008, 11:45
Forum: MySQL
Topic: Problem with bulk-insert
Replies: 4
Views: 1370

Problem with bulk-insert

Hi! I have one ADOConnection and one TZConnection in my project. The ADOConnections opens an Excelfile. I want this data to be inserted into my MySQL database. Here's my code: ADOQuery1.Open; ZQuery1.Open; // MySQL-Tabelle while not ADOQuery1.Eof do begin ZQuery1.Append; // neuer, leerer Datensatz Z...