Zeoslib Portal

Dear users, today I have finished the work on our new TZSequence-Component! With this component you have direct access to sequences/generators on your database. You can get the current or next value to initialize key-fields for example. Currently only Interbase/Firebird is supported but others will ...

If not then it can't work in ZEOS. How would you access the different values of x otherwise? If you can then your example is something like a select statement. That is possible in Sybase too, but there this has to be the content of a procedure and you have to call/select it to get the result(s). No...

I do not know exactly what purpose "begin" and "end" fulfill in this example. It could be executed without them but it could also be (PL/SQL): declare y number; begin for y in 1..10 loop select count(*) into :x from dual; end loop; end; There are a lot of amazing things you can d...

I also know this, but would'nt it be "better" to add support for blocks ( begin .. end)? Then it would be possible to skip code delimiters inside those blocks and one wouldn't have to change the delimiter at least in database "languages" where this is possible. For expamle In Sy...

Does it really make sense to create procedures with dynamic code? Erm, dynamic code??? :R1 is the result-param of the stored proc. That's the only use of parameters there i think. And we saw already that the actual solution has some problems. I have written a new protocol for Sybase ASA DBLib. ( I'...

MarkusD wrote:Because there are no (script) parameters used nor filled in the scripts generating the test DB's, i think ParamCheck could and should be disabled there.

Yes, of course! Cause you mentioned this already above I have not repeated this.

Hello,

because the SQLProcessor now has support for Parameters, the ':' cannot be ignored. To solve your problem please set CleanupStatements to True!
Otherwise there must not be any comment before SET TERM ^ ; because parsing this statement does not recognize it if there is one.

Regards
Stevie

rubenjavier wrote:In case I need to upload some files I would be good to have a place even in this same new forum/page to host teh fixed files

Hi ruben,

if you have completed your fixes you can send me these files, so I can check and add them to cvs.
Regards
Stevie

Hi, are you sure MySQL Control Center reads the whole bunch of records??? I don't think so, it only reads the information, that there are x records returned by your sql-statement, but it does not load all the data! Btw. I do not know MySQL well enough to be sure, but try following: WHERE BINARY UPPE...

Did you check if this error occurs with TDBLookupComboBox also?

Please add a little test-project and your table-description-SQL to make it easier to locate the error.

Have you already downloaded and installed the latest snapshot from http://www.de.freepascal.org/lazarus/ ???

Hi,

please take a look at this thread where I already described, how you exclude the ADO stuff.

Regards

Hi jacko,

just open the ZeosDbo.bpg and compile the five packages. If you got the 6.5.1 alpha from download section the install all five packages - if you got the actual cvs snapshot then only install the zcomponent.dpk. That's it

Regards
Stevie

I am new to ZEOS and want to use it in kbm framework to access MSSQL and Firebird. During the installation of ZDBc.bpl, I encountered the error that 'vclado50' was missed. As far as I know, ADO is not included in D5 Pro, how do I solve it? Thanks any advices. Benson. Of course ADO is included in D5...

I install Lazarus-0.9.8-20050719-win32 and the latest zeosdo_rework from cvs (last saturday) and result exactly the same error messages with rubenjavier's. Erm... first try the newest lazarus version and please deinstall your old one to avoid conflicts between old and new files. I have got Lazarus-...