SELECT return error data

Sapiem · 2018-01-08 18:36:58

I am trying to recode my app, migrating the SQLite usage code from ZeosLib to mORMot. All right, until I realize that sometimes, when there are empty fields, the SQL SELECT returns the value of that empty field, with the value of the following fields, example:

Suppose:
Field1 = 'Value 1'
Field2 = ''
Field3 = 34
Field4 = 'Blue'

SELECT Field1, Field2, Field3, Field4 FROM Table 1

Field1 = 'Value 1'
Field2 = '34Blue'
Field3 = 34
Field4 = 'Blue'

Sometimes, when the number of records returned by the SELECT is greater than one, the empty fields remain correctly empty.

ab · 2018-01-09 08:24:50

Weird. Never seen it in practice.
Could you post on PasteBin some code to reproduce it?

Sapiem · 2018-01-09 11:37:50

The code is the same of example # 17, the only change is the database that I open. I still working with example # 17 until I hace all that I need and then migrate all my original code to mORMot. I'll try to extract some piece of databse and try to reproduce this error. I use Delphi Berlin.

ab · 2018-01-09 12:28:49

With which cbbDataSource item?

Sapiem · 2018-01-09 17:22:52

I don't understand you. I use the same code of example # 17. It use this datasource (ds1: TDataSource;)

Junior/RO · 2018-01-09 20:09:49

Please give us some screen shot of this

Sapiem · 2018-01-10 03:16:06

Screenshot?

Sapiem · 2018-01-11 03:26:26

How can I send you a screenshot from my PC?

Sapiem · 2018-01-15 21:06:24

Hello?

ab · 2018-01-16 08:44:58

Use a picture upload web site, e.g. https://imgur.com/ or any other, then put a "img" link in the forum.

Sapiem · 2018-01-16 12:56:04

Look at the Caption bar. This is the result of showing the content of the field that is really empty, but it shows me the union of the previous field next to the next one. Look at the Grid: I am showing the field "Equipo" and it shows me the union of the "CI" field next to the following "DatosClin".

Last edited by Sapiem (2018-01-16 13:04:26)

ab · 2018-01-16 13:38:59

Difficult to tell with just a screenshot.

Try to use the debugger to find out where the problem may be in the mORMotVCL.pas unit.

Sapiem · 2018-01-16 13:45:31

Ok, I'll check at home. Sorry, but I'm doctor and I have a lot of professional work. Thanks for all.

Sapiem · 2018-01-17 04:34:53

I try but the mORMotVCL.pas unit never si used by code.

Sapiem · 2018-01-25 12:35:36

Using Table (sample 12 - SynDB Explorer) plus ToDataSet function solve the problem.

mORMot Open Source

#1 2018-01-08 18:36:58

SELECT return error data

#2 2018-01-09 08:24:50

Re: SELECT return error data

#3 2018-01-09 11:37:50

Re: SELECT return error data

#4 2018-01-09 12:28:49

Re: SELECT return error data

#5 2018-01-09 17:22:52

Re: SELECT return error data

#6 2018-01-09 20:09:49

Re: SELECT return error data

#7 2018-01-10 03:16:06

Re: SELECT return error data

#8 2018-01-11 03:26:26

Re: SELECT return error data

#9 2018-01-15 21:06:24

Re: SELECT return error data

#10 2018-01-16 08:44:58

Re: SELECT return error data

#11 2018-01-16 12:56:04

Re: SELECT return error data

#12 2018-01-16 13:38:59

Re: SELECT return error data

#13 2018-01-16 13:45:31

Re: SELECT return error data

#14 2018-01-17 04:34:53

Re: SELECT return error data

#15 2018-01-25 12:35:36

Re: SELECT return error data

Board footer