Zeoslib Portal

Hello,

Use a TZSQLProcessor component to run multiple SQL statements.

Bye,

Josimar

Hello ism,

The problem is not in the Zeos Lib.

When a STORED PROCEDURE in MySQL returns a Result Set, you must specify this using the directives READS SQL DATA or MODIFIES SQL DATE.

More details: http://dev.mysql.com/doc/refman/5.0/en/ ... edure.html

Best regards,

Josimar

Hello,

Another way to solve the problem is to enable the property CleanupStatements of TZSQLProcessor.

When this property is enabled the tokenizer removes all comments from the script.

Greetings,
Josimar

Hello tarnschaf , I checked the SQL script to understand the problem. Until a solution is available, I suggest to solve the problem another way: use the same delimiter throughout the length of the script. Example: CREATE TABLE L4PARTS ( ID Integer NOT NULL, "Nummer" VarChar(22), "Arti...

EgonHugeist , The solution is change the ResultSetConcurrency property to rcUpdatable : var Conn: IZConnection; Stmt: IZStatement; Rs: IZResultSet; begin {...} Stmt := Conn.CreateStatement; Stmt.SetResultSetConcurrency(rcUpdatable); // solution Rs := Stmt.ExecuteQuery('SELECT A FROM T'); Rs.Last; W...

Hello, I'm using the ZDBC API to execute queries. Like this: var Rs: IZResultSet; begin Rs := ZConn.DbcConnection.CreateStatement.ExecuteQuery('SELECT A FROM T'); while Rs.Next do begin // end; At one point I wish to return to the top of the resultset, before the first record: Rs.BeforeFirst; But do...

Though our language is Portuguese, I suggest using English for what others may benefit from the information. For your case I suggest using the TZSQLMonitor component. Just add it to your project, preferably in the same place the TZConnection component. Change the TZSQLMonitor Active property to True...

Hello elidorio2

Use the ParamByName to retrieve the value setted up to parameters of TZQuery. Example:
Bye, bye

Josimar

Hello jpnuage,

Try use the OR operator:
More about filters:

http://zeos.firmos.at/viewtopic.php?t=3 ... ght=filter

Josimar.

Hi,

Verify your MySQL version. "Before 5.0.3, BIT is a synonym for TINYINT(1).".
Source: http://dev.mysql.com/doc/refman/5.0/en/ ... rview.html

Josimar

Hello,

I always use the form showed by mparak. The name of the detail parameter must be equals of the name of field in the master query.



Bye bye,

Josimar

Hello, I have the following table in the database: PERSON { CODE INTEGER (PRIMARY KEY), NAME VARCHAR } I'm using the interface ZDBC to insert records: function NewPerson(const Name: string): Integer; var Stmt: IZPreparedStatement; Rs: IZResultSet; begin Stmt := Conn.PrepareStatement('SELECT CODE, NA...

hello krisleech, I know the post is old, but to solve this problem you must register the MySQL driver in DriverManager with this code: DriverManager.RegisterDriver(TZMySQLDriver.Create); Another way is to include the unit ZDbcMySQL USES section. The initialization section of ZDbcMySQL be responsible...

Hello! I'm using the TZSQLMonitor component for implement a SQL debugger to my application. I was wrong in thinking that the component does not replace the query parameters. I take this opportunity to ask: has provision for release version 7 stable? As for the topic, consider it solved! Tanks! Josimar

Hello amarildolacerda ! I have experience in converting applications using the BDE to Zeos. I recently worked on the conversion of a large system. I can assure you that there are few properties available in the BDE is not Zeos. Moreover, the Zeos offers far more features than the BDE and has the adv...