mORMot Open Source

dka1

Member

From: Greece

Registered: 2017-07-25

Posts: 28

AV on TSQLDBProxyStatementRandomAccess.ColumnToVariant

Hello,
I am a new user of framework (started with  MSSQL OLEDB and HTTP server/services).
Palying around (remote OLEDB throught HTTP) I used TSQLDBProxyStatementRandomAccess
to read ISQLDBRows.FetchAllToBinary results, but I get av on call TSQLDBProxyStatementRandomAccess.ColumnToVariant.
Cause is fConnection=nil so when I change your code

function TSQLDBProxyStatementRandomAccess.ColumnToVariant
...
    {$ifndef UNICODE}
    if Assigned(fConnection) and not fConnection.Properties.VariantStringAsWideString then begin
...

everything is ok.
If it is safe please make the fix.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,661

Website

Re: AV on TSQLDBProxyStatementRandomAccess.ColumnToVariant

I've committed https://synopse.info/fossil/info/91600990d3
but I don't understand why fConnection=nil in your case...

dka1

Member

From: Greece

Registered: 2017-07-25

Posts: 28

Re: AV on TSQLDBProxyStatementRandomAccess.ColumnToVariant

Because ColumnToVariant implemented on TSQLDBStatement and not on TSQLDBProxyStatementRandomAccess
so my fix is on function TSQLDBStatement.ColumnToVariant(Col: integer; var Value: Variant): TSQLDBFieldType;
and not on function TSQLDBProxyStatementRandomAccess.ColumnToVariant .

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,661

Website

Re: AV on TSQLDBProxyStatementRandomAccess.ColumnToVariant

Yes, I saw that, and fixed TSQLDBStatement.ColumnToVariant in my previous commit.