Potential Bug? mormot.db.sql.postgres TSqlDBPostgresStatement.Execute

wxinix · 2021-09-23 12:28:53

mormot.db.sql.postgres, TSqlDBPostgresStatement.Execute

line 624

 fTotalRowsRetrieved := PQ.ntuples(fRes);

Would throw Exception ESqlDBPostgres, with message
"TSqlDBPostgresStatement.ExecutePrepared: result expected but statement did not return tuples'.

The statement being executed is
fSql 'CREATE SCHEMA IF NOT EXISTS test'

ab · 2021-09-23 13:38:42

You should rather try ExecuteNoResult() I guess for such statements with no result.

wxinix · 2021-09-23 14:32:48

ab wrote:

You should rather try ExecuteNoResult() I guess for such statements with no result.

Thank you. Yes - that works.

mORMot Open Source