mORMot Open Source

Bascy

Member

From: The Netherlands

Registered: 2012-06-22

Posts: 108

Compile errors in MormotDB.pas with last commit

After downloading your last commit, implementing ISQLDBStatement i get compile errors in MormotDB:

[dcc32 Error] mORMotDB.pas(881): E2010 Incompatible types: 'TSQLDBStatement' and 'ISQLDBStatement'
[dcc32 Error] mORMotDB.pas(1113): E2010 Incompatible types: 'TSQLDBStatement' and 'ISQLDBStatement'
[dcc32 Error] mORMotDB.pas(1169): E2010 Incompatible types: 'TSQLDBStatement' and 'ISQLDBStatement'
[dcc32 Error] mORMotDB.pas(1211): E2010 Incompatible types: 'TSQLDBStatement' and 'ISQLDBStatement'
[dcc32 Error] mORMotDB.pas(1231): E2010 Incompatible types: 'TSQLDBStatement' and 'ISQLDBStatement'

Cause by variable Query declared as TSQLDBStatement in stead of ISQLDBstatement

Ticket: http://synopse.info/fossil/tktview/4332 … f207c1a1e6

Edit:
After changing all TSQLDBstatement declarations to ISQLDBstatment, I'm also getting lots of access violations in the selftests, part 2.7 External Database  .. maybe you have forgotten to commit one or two changes?

Stacktrace:

SynSQLite3.TSQLRequest.Step
SynSQLite3.TSQLRequest.Execute(0,'',$213BE78,True)
mORMotSQLite3.TSQLRestServerDB.EngineList('SELECT RowID,FirstName,LastName,YearOfBirth,YearOfDeath,LastChange,CreatedAt FROM PeopleExt WHERE RowID=:(1):;',True,nil)
mORMotSQLite3.TSQLRestServerDB.EngineRetrieve(1,1)
mORMot.TSQLRestServer.URI($18FB80)
mORMotSQLite3.TSQLRestClientDB.InternalURI('root/PeopleExt/1','GET',$18FCB8 {''},nil {''},nil {''})
mORMot.TSQLRestClientURI.URI('root/PeopleExt/1','GET',$18FCB8 {''},nil {''},nil {''})
mORMot.TSQLRestClientURI.URIGet(TSQLRecordPeopleExt,1,'',False)
mORMot.TSQLRestClientURI.EngineRetrieve(1,1,False,6,'')
mORMot.TSQLRestClient.Retrieve(1,$21691B0,False)
SynSelfTests.TTestExternalDatabase.Test(True)
SynSelfTests.TTestExternalDatabase.ExternalViaREST
SynCommons.TSynTests.Run
mORMotSelfTests.SQLite3ConsoleTests
TestSQL3.TestSQL3

Last edited by Bascy (2013-01-23 08:21:24)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,240

Website

Re: Compile errors in MormotDB.pas with last commit

Yes one file was missing.
See [9c53131066] commit.

(I committed the file just 5 minutes after you created the ticket)

See also http://synopse.info/fossil/info/17141351ca which makes a huge performance boost when external tables are used.