Zeoslib Portal

GetTableNames is implemented in/as ZSqlMetaData

Var List:TStringList;
List:= TStringList.Create;
Connection.GetTableNames('tablename%',string; List);
......
List.Free;

ok, changes have been commited to testing branch

Would you test it a last time, just to be sure, then i will commit
http://cforce.dnsalias.org/files/patch_ ... ev82.patch

1.) I can't click/see a link in your message above 2.) SQLType - Huh? That is something new. I was only talking of "VType" for Value..but ok. The SQLType mybe null if you have eg "vtInteger" or "vtBoolean". Then again the RetValue won't carry any value because never set...

Hmm, that is strange indeed. The code you posted - is it your code or from zeos lib? that would be most strange! If not from zeos maybe you already "Opened" your query somewhere else and didn't closed it again, that would maybe result in internal close for first open and "open" f...

The interface has typ "interface", concrete typ may be set again by using original Value.vtyp, if so the line "case RetValue.VType of" must be to changed to "case Value.VType of". Your fix will also work, but isn't such "secure" and "readable". Tx fo...

If i understood ypu correctly the Value.VTyp is not correctly copied in method GetAsInterface(Value). Here the typ shall be taken from Value and returned together with B. Even i would suggest to add an "else " for branch "case RetValue.VType of" If we would have that already we w...

>RetValue:=Value; ......... B := DefVarManager.GetAsInterface(Value) as IZBlob; ......... DefVarManager.SetAsString(RetValue, B.GetString); ......... DefVarManager.SetAsUnicodeString(RetValue, B.GetUnicodeString); ......... DefVarManager.SetAsString(RetValue, BytesToStr(B.GetBytes)); ......... case...

I just took a look into that file of testing branch and it looks logic how its is used, please supply detailed info what you think is buggy - oldline of code > new line of code. B := DefVarManager.GetAsInterface(Value) as IZBlob; ......... DefVarManager.SetAsString(RetValue, B.GetString); ......... ...

Please complete your bug report.. Which method you are originally calling? What do you do to delete your record? ON which Class you call that method? Which zeos version, which database? Which exception / problem raises at which codeline? Did you already applied a working patch (or what do you think ...

ahh. i meant today in about 7 hours, gn8!

I will have a look tomorrow, its 01.38h in germany

Try to use it that way.. (untested) Var Const FIELDNAME='blaname'; begin Query:= TZquery.create; Query.Connection:= ZConnection; Query.sql.Add('SELECT .. FROM .. WHERE '+FIELDNAME+'= :'+FIELDNAME); Query.ParambyName(FIELDNAME).AsString:= 'xyz'; Query.Open; Query.First; while not Query.EOF do < ........

What is the code line causing exception and what does the exception exactly says?
Furthermore let's see ur sql string.

What does this line do from your opinion?
"if DMSzamla.qSzamlaFejAzon.Eof then"