Zeoslib Portal

Thanks misio,

it works.

/Alf

Thanks Mark, your help was very valuable. I have altered my code and now it works well. ........................................................ with Form1 do begin ZQuery1.SQL.Clear; ZQuery1.Close; with ZQuery1.SQL do begin add('insert into MySpatial (EType, Layer, Color, LineType, LTScale, Thickne...

I'm testing the spatial possibilties in MySQL. For this purpose I have defined a table as follows: ................................................................................................. CREATE TABLE `myspatial` ( `ETYPE` varchar(15) default NULL, `LAYER` varchar(100) default NULL, `COLOR`...

Thanks Zippo,
I'm also using the latest Zeos (downloaded yesterday) and MySQL 5.0.13-rc-nt.

This is a new topic to me - can you please give some hint about it?

//Alf

Is it possible to use the new features in MySQL5 eg Stored Procedures, Triggers and so on? If I use a common "SELECT-statement" I get a proper answer from MySQL, but if I call a Stored Procedure containing the same query I get the following: "SQL Error: Procedure db5.p1 can't return a...