got a raise when using TSqlDBClientDataSet

songshuang · 2023-07-04 06:19:21

sql :
SELECT ''All'' as field1, count(*) as field2,' sum(case when ret=0 then 1 else 0 end) as field3
in this case , will got a raise :
raise EVirtualDataSet.CreateUtf8('%.GetFieldData ColumnType=%', [self, TSqlDBFieldTypeToString(ColumnType)]);
(in procedure :InternalInitFieldDefs, mormot.db.rad.ui.sql.pas )
I suggest add :
....
mormot.db.core.ftNull,
mormot.db.core.ftUnknown:
dbtype := ftWideString;
....

ab · 2023-07-04 06:29:29

With which DB backend?

songshuang · 2023-07-04 06:36:44

aslite=TSQLModel.Create([
TSQLAuthor...],'root');
arest=TSQLRestServerDB.create(aslite,filename);
TSqlDBClientDataSet.Connection=TSQLDBSQLite3ConnectionProperties.Create(arest.DB);

songshuang · 2023-07-04 06:53:39

Above is my project: unigui+rest.
Besides, I hit a pit. field:Text ,As records added，Sometimes it's a widestring, and later it's a widememo.
IgnoreColumnDataSize of TSqlDBClientDataSet has no effect.becase using create（AOwner: TComponent）...
so,i changed default value of IgnoreColumnDataSize in mormot.db.rad.ui.sql.pas
...

songshuang · 2023-07-04 07:12:08

geting a raise when query empty,but normal when not empty.

songshuang · 2023-07-04 08:23:01

to assigned a datetype use cast ,Can be regarded as a good idea

mORMot Open Source

#1 2023-07-04 06:19:21

got a raise when using TSqlDBClientDataSet

#2 2023-07-04 06:29:29

Re: got a raise when using TSqlDBClientDataSet

#3 2023-07-04 06:36:44

Re: got a raise when using TSqlDBClientDataSet

#4 2023-07-04 06:53:39

Re: got a raise when using TSqlDBClientDataSet

#5 2023-07-04 07:12:08

Re: got a raise when using TSqlDBClientDataSet

#6 2023-07-04 08:23:01

Re: got a raise when using TSqlDBClientDataSet

Board footer