Zeoslib Portal

If keyfield type is SMALLINT, lookup do not work

I do not know than the mistake is called, has corrected so

function TZAbstractRODataset.InternalLocate(KeyFields: string;
KeyValues: Variant; Options: TLocateOptions): LongInt;


//VISOR line 2263
OnlyDataFields:=false;
//VISOR

But strongly time has increased: (

If you sue MYSQL try to use Integer type. you shouold pst this as a bug in souceforge page. plz specy delphi version, database and ZeosLib version.

and if you can submit a simple test app.

Delphi 6 SP2 RTL1.
ZeosLib 6.5.1-alpha CVS-Version as of 26(23)-09-2005
MySQL 5.0.10 (for test you may use version MySQL 4.1.x or 5.0.x)

Bug introduce in version ZeosLib 6.5.1-alpha CVS-Version as of 23-09-2005

Delphi-source and sql-script in attathment.

+ DBGridEh 3.6 (http://www.ehlib.com/) for visualize resultset, for test you use DbGrid

I fix this bug in module ZDatabaseUtils.pas
function CompareFieldsFromResultSet

CurrentType := ResultSet.GetMetadata.GetColumnType(ColumnIndex);
//VISOR
if CurrentType=stShort then CurrentType:=stInteger;
//VISOR

Hi thanks for this. can you post the fix into Sourceforge site to let know Stevie (one of our Developer team member) to post the correct fixes?.

Thanks

Hi visor,

fduenas wrote:--- cut ---
you shouold pst this as a bug in souceforge page.
--- cut ---

I would appreciate that, too! As long as there is no tool in our forum to manage bugs, we have to use the bug tracker on SF. Maybe annotate a link to your thread when you register this bug.

Regards!

Michael wrote:Hi visor,

I would appreciate that, too! As long as there is no tool in our forum to manage bugs, we have to use the bug tracker on SF.

Michael why not talk to Marko Binic: http://mxs.bergsoft.net/
he had developed an excellet Issue Tracker based on PhpBB, check the website. I remember he asked for a small fee, i think 19 or 29 dlls for the tracker, i can make the donation if needed. but i find a good addon to the Ctracker. check ti out

Michael wrote: Maybe annotate a link to your thread when you register this bug.

Regards!

Well the correct way, for all of us, should be:
1) Post the bug report in SF.net
2) Post the patch in 'patches' section' refering in the title the BUG ID number (generated previously by posting the bug.
3) optionall, post a reply in the bgu section the the bug has a fix in patches section, and plz add the link to it (url to display the patch post).

BTW Michael maybe this can be also a little FAQ of' What to to to report a bug and/or a patch' also when a feature request is needed. it can be sticky post to let know users what to do in this cases when a bug (not a doubt or a simple problem) is found.

Regards

PS: i have read your PM, i'll talk to you later

Hi Visor,

Why not putting the stShort type in the Case Statement ?

replace
with
It is much "cleane"

Certainly and even so:)

-----
case CurrentType of
stInteger,stShort,stLong,stByte://VISOR
----


Because other types too are not converted KeyValues .VString