Zeoslib Portal

update
I downloaded snapshot ZEOSLIB_TRUNK_REV803.zip.
Here I found a lot of reading stuff, which, I guess, I'd better work through. This is going to keep me busy for a little while.
Guido

Ok, that's a good start. Especially step 0. Now I know where to start. Thanks.
Guido

would this work?

for I := 0 to SrcLength -1 do
begin
shx := IntToHex( ord(SrcBuffer),2 );
result[1+i*2] := shx[1];
result[1+i*2] := shx[2];
end;
// result := 'x'+QuotedStr(result); // since result is Hex string
end;

Mark, I really want to contribute. But there is no /test directory. I feel like annoying. Maybe we should first of all set up a clear HOW-TO for newbies like me to get into the testing. Once you got me that far, I am willing to write that how-to. i.e. : windows, lazarus-fpc, firebird. (I could, for ...

Mark, It seems to be not that easy. I set up lazarus on another xp pc, installed zeos 6.6.6 and tried to run th ZTestAll project. Failed because it needs presence of all the testunits : ZTestSysUtils, ZTestVariant, ZTestTokenizer, ZTestList, ZTestFramework, ZTestExprToken, ZTestExpression, //parsesq...

afaik, the sql standard does not allow for non-values, they should raise an error.

you can use zquery, make op your sql in any way you want, filter and group by and whatever; and then you can sort the resultset in the component itself once more and re-sort again;
do you still want more?
Guido

if you have fields on which you have an secondary index, you can use those for indexfield; sequencefield is for a ( for example :autoincrement) field on which you have a sequence (trigger for autoincrement), so zeos knows how to handle it; Sort fields is the fields on which to sort the data if you w...

I didn't try this, but you could override the default fetch size, by setting the statement.fetchsize to a small value. Then you can pos the cursor anywhere, but if you do it by scrolling your dbtreeview window it will run through the data anyway. and maybe take a look at : http://zeos.firmos.at/view...

just do a separate query :
select * from foo where recno = 6000000;

Guido

Or you could use a TZSqlProcessor to execute the statements in a script...
Guido

from the postgresql doc's : <quote> In addition to ordinary numeric values, the numeric type allows the special value NaN, meaning "not-a-number". Any operation on NaN yields another NaN. When writing this value as a constant in a SQL command, you must put quotes around it, for example UPD...

just an idea :
why not read the output, and step up your progressbar with each CR/LF?

Guido

This works with Firebird...

begin
TBlobField(fieldbyname('foto')).Clear;
TBlobField(fieldbyname('foto')).LoadFromFile(OpenPictureDialog.FileName);
end;

Guido