Page 1 of 1

TZ*DatabaseMetadata.UncachedGetProcedureColumns seem useless?

Posted: 23.01.2018, 16:28
by Fr0sT
TZ*DatabaseMetadata.UncachedGetProcedureColumns methods are not called by any method in Zeos. Is it incomplete implementation or caller code was removed?

Re: TZ*DatabaseMetadata.UncachedGetProcedureColumns seem useless?

Posted: 23.01.2018, 21:10
by marsupilami
Hello Fr0sT,

erm - UncachedGetProcedureColumns gets called by TZAbstractDatabaseMetadata.GetProcedureColumns - or do I miss something obvious here?

Best regards, Jan

Re: TZ*DatabaseMetadata.UncachedGetProcedureColumns seem useless?

Posted: 24.01.2018, 07:54
by Fr0sT
Yep, you're right :) But when it is executed? I tried dropping TZStoredProc on a form and making it active but this method won't be called.

Re: TZ*DatabaseMetadata.UncachedGetProcedureColumns seem useless?

Posted: 24.01.2018, 10:54
by marsupilami
Did you set the the stored procs name while it was hooked up to some working connection? ;)

grep search says, that GetProcedureColumns is called three times on the component layer by these callers:
function TZSQLMetadata.CreateResultSet(const SQL: string; MaxRows: Integer): IZResultSet;
function TZStoredProc.CreateStatement(const SQL: string; Properties: TStrings): IZPreparedStatement;
procedure TZStoredProc.SetStoredProcName(const Value: string);

If it wan't called by anyone, it would be more like a not finished function because it exposes meta data about the databases in a uniform way.