Search found 7 matches

by andreass
05.01.2007, 10:01
Forum: MySQL
Topic: Zeos 6.6 Beta and Mysql 5.0 and Stored Procedures
Replies: 4
Views: 2078

Hello Zippo,

I tried this , but I got problems with "OUT PARAMETERS", "IN PARAMETERS" are working fine.

I already put a question concerning this in
Zeos 6.6.0 beta and MySQL 5.0 Stored Procedures

If you could help me it would be great.

Andreas
by andreass
02.01.2007, 11:16
Forum: MySQL
Topic: Zeos 6.6 Beta and Mysql 5.0 and Stored Procedures
Replies: 4
Views: 2078

Hi Mark,
mdaems wrote:Bad news Andreas,

Mysql stored procedures are not supported by the StoredProc component yet.
That's are really bad news.
by andreass
02.01.2007, 11:11
Forum: MySQL
Topic: MySQL5 - Stored procedures
Replies: 17
Views: 8492

Hi, I'm using mysql 5.0 and the newest beta components. I tried to use a stored procedure using the tzquery.sql property. But If I have an OUT Variable in the stored procedure I get an error. Out or INOUT argument 2 for NEUER_KUNDE is not a variable. The Code of the storec Procedure is the following...
by andreass
31.12.2006, 15:52
Forum: MySQL
Topic: Zeos 6.6 Beta and Mysql 5.0 and Stored Procedures
Replies: 4
Views: 2078

Zeos 6.6 Beta and Mysql 5.0 and Stored Procedures

Hello, I put a tzconnection an my form connected to the database everything is fine. In tztables I can choose every table I've got in the database. Then I put an tZStoredProc on the form, connected it with the tzconnection, but when I open then dropdownfield of 'StoredProcName' no StoredProcs are li...
by andreass
30.12.2006, 23:09
Forum: MySQL
Topic: ZupdateSQL Boolean fields
Replies: 4
Views: 1866

I got the fault.
I had an char(3) field with 'D' as Default, but you have to write only D as default then everything works fine.

Andreas
by andreass
29.12.2006, 09:55
Forum: MySQL
Topic: ZupdateSQL Boolean fields
Replies: 4
Views: 1866

Hi mdaems, thats the tracefile: 0:22 cat: Connect, proto: mysql-5, msg: CONNECT TO "asreben" AS USER "root" 2006-12-29 09:10:22 cat: Execute, proto: mysql-5, msg: select * from KUNDEN left join land on kunden.land = land.lk order by kdnr 2006-12-29 09:10:22 cat: Execute, proto: m...
by andreass
28.12.2006, 15:22
Forum: MySQL
Topic: ZupdateSQL Boolean fields
Replies: 4
Views: 1866

ZupdateSQL Boolean fields

Hello, I'm working with Delphi 6 and the Zeos 6.6 beta. I've got a table in Mysql 5.0 which has a view fields declared as enum('N','Y') NOT NULL default 'N' The Field editor makes Boolean fields from this which is good. If I insert a row I only want to insert one field with a value all other fields ...