Difference in the Resulting DataSet of ToClientDataSet and ToDataSet

itSDS · 2014-11-18 15:21:29

Hi AB,

i got the following DataSet Result

In DB there are 2 Records

the first has no Empty Fields, the second has some empty fields.

with ToDataset some of the Empty Fields of the second record are filled with memory - fragments
with toClientDataset they are empty as expected.

if you need more help ask pls.

Last edited by itSDS (2014-11-18 15:22:06)

itSDS · 2014-11-18 15:31:41

ToDataset output:

ID	UniqueID	CreationDate	LastEditDate	Anzeigename	Beschreibung	KontaktID	Logonname	HashedPassword	Verified	Rechte
1	{6F454FFA-0C97-4780-BA69-6E98202B2B3E}	135201358696	135201358696	Administrator	Automatisch angelegt beim Erstellen der Datenbank	{6AEFDCD2-4A5F-469B-A1BB-E4B3949DFFB2}	Admin	0b7fc485eb399bdde9e1c09cddceb2c396290dc23278831be4e242981d119ed3	1	7
2	{CC516404-53BC-4D4D-BC64-0B7E8A3DDA69}	135201386037	135201386037	My Name	&{8E746F41-F824-4236-8D73-83A5CB8356BC}stefan@2a	{8E746F41-F824-4236-8D73-83A5CB8356BC}	My	2ad1b0748453272d8e73cbfe0869910b716d03f5bbd9da2d09849d6fa925aedf	0	0

ToClientDataSet Output

ID	UniqueID	CreationDate	LastEditDate	Anzeigename	Beschreibung	KontaktID	Logonname	HashedPassword	Verified	Rechte
1	{6F454FFA-0C97-4780-BA69-6E98202B2B3E}	135201358696	135201358696	Administrator	Automatisch angelegt beim Erstellen der Datenbank	{6AEFDCD2-4A5F-469B-A1BB-E4B3949DFFB2}	Admin	0b7fc485eb399bdde9e1c09cddceb2c396290dc23278831be4e242981d119ed3	1	7
2	{CC516404-53BC-4D4D-BC64-0B7E8A3DDA69}	135201386037	135201386037	My Name		{8E746F41-F824-4236-8D73-83A5CB8356BC}	My	2ad1b0748453272d8e73cbfe0869910b716d03f5bbd9da2d09849d6fa925aedf	0	0

Last edited by itSDS (2014-11-18 15:32:03)

itSDS · 2014-11-18 15:35:26

In SynDBExplorer the Output looks like ToDataset

I forgot the Connection is made with the new SynDBRemote.
If i connect directly to the Database the trash is not shown.

Last edited by itSDS (2014-11-18 15:37:08)

ab · 2014-11-18 16:11:56

What do you call an "empty field"?
A column containing NULL?

In SynDBExplorer, what is the corresponding JSON?

itSDS · 2014-11-19 11:06:38

Hi AB, sorry for the litte delay,

AB wrote:

What do you call an "empty field"?
A column containing NULL?

In this case Empty means value = '' (Empty String, not null) dumped with sqlite3

AB wrote:

In SynDBExplorer, what is the corresponding JSON?

where can i get this ?

itSDS · 2014-11-19 13:43:15

Hi AB i startet SynDBExplorer with the Debugger and analyzed the Result from Rows.FetchAllAsJSON.
The JSON contains the wrong content in the Field.
May be the Error is in the Server - Code of SynDBRemote.

I'll try to debug this also.

ab · 2014-11-19 14:38:14

Weird AFAIK the remote connection should use the FetchAllAsJSON() directly from the original provider, then transmit the JSON directly (after signature and compression) to the SynDBExplorer client.
I do not understand why there is a difference...

itSDS · 2014-11-19 14:41:46

Hi AB i think the Problem is somewhere in function TSQLDBRemoteConnectionPropertiesAbstract.Process on the Client.

The received compressed String is like that:

#$D#1#$B#2'ID'#2#0#8'UniqueID'#6#0#$C'Creatio'#0#0#1' nDate'#2#0#$C'LastEdit$`'#$B'Anzeigenamea'#$C'Be'#0#0#$10#8'schreibung'#6#0#9'KontaktÒB'#9'Logon„{'#$E'Has'#0#0#0'@hedPassword'#6#0#8'Verified'#2#0#6'RechtQ&'#0#0#0#0#0#1'&{6F454FFA-0C97-4780-BA69-6E982'#0'@'#0#0'02B2B3E}Ï'#$8D'ˆªï'#7'tT'#$D'Administrator1Au'#$18#0#0#0'toma/Q_ angelegt beim Erstellen de'#4#1#0#0'r "`nbank'#$11'„AEFDCD2-4A5F-469B-A1BB-'#0'@'#0#0'E4B3949DFFB2}'#5's)@0b7fc485eb399bdd'#0#0#0#0'e9e1c09cddceb2c396290dc23278831b'#0#0#0#0'e4e242981d119ed3'#1#$D#0#3'&{CC516404-5'#0#0'€03BC-4D4D-BC64-0B7E8A3DD!]}é¸‹Aý$'#5#$12'S'#0#4#0#0'tefan Dies!;mann'#0'&{8E746F41-F824-'#0#0#0#3'4236-8D73-83A5CB8356BC}'#6'A"'#1'x@2ad1b@'#0'€'#0'074845'#1#$14'2d8e73cbfe086991a'#$14'16d03f5b'#0#0#0#0'bd9da2d09849d6fa925aedf'#0#0#2#0#0#0

after uncompress the buffer is same as on server before compress:

1#$B#2'ID'#2#0#8'UniqueID'#6#0#$C'CreationDate'#2#0#$C'LastEditDate'#2#0#$B'Anzeigename'#6#0#$C'Beschreibung'#6#0#9'KontaktID'#6#0#9'Logonname'#6#0#$E'HashedPassword'#6#0#8'Verified'#2#0#6'Rechte'#2#0#0#1'&{6F454FFA-0C97-4780-BA69-6E98202B2B3E}Ï'#$8D'ˆªï'#7'Ï'#$8D'ˆªï'#7#$D'Administrator1Automatisch angelegt beim Erstellen der Datenbank&{6AEFDCD2-4A5F-469B-A1BB-E4B3949DFFB2}'#5'Admin@0b7fc485eb399bdde9e1c09cddceb2c396290dc23278831be4e242981d119ed3'#1#$D#0#3'&{CC516404-53BC-4D4D-BC64-0B7E8A3DDA69}é¸‹ªï'#7'é¸‹ªï'#7#$12'Stefan Diestelmann'#0'&{8E746F41-F824-4236-8D73-83A5CB8356BC}'#6'stefan@2ad1b0748453272d8e73cbfe0869910b716d03f5bbd9da2d09849d6fa925aedf'#0#0#2#0#0#0

OutputRawUtf8 after SetString SynDB Line 7093 is wrong !

1#$B#2'ID'#2#0#8'UniqueID'#6#0#$C'CreationDate'#2#0#$C'LastEditDate'#2#0#$B'Anzeigename'#6#0#$C'Beschreibung'#6#0#9'KontaktID'#6#0#9'Logonname'#6#0#$E'HashedPassword'#6#0#8'Verified'#2#0#6'Rechte'#2#0#0#1'&{6F454FFA-0C97-4780-BA69-6E98202B2B3E}ύ'#$88#$AA#$EF#7'ύ'#$88#$AA#$EF#7#$D'Administrator1Automatisch angelegt beim Erstellen der Datenbank&{6AEFDCD2-4A5F-469B-A1BB-E4B3949DFFB2}'#5'Admin@0b7fc485eb399bdde9e1c09cddceb2c396290dc23278831be4e242981d119ed3'#1#$D#0#3'&{CC516404-53BC-4D4D-BC64-0B7E8A3DDA69}鸋'#$AA#$EF#7'鸋'#$AA#$EF#7#$12'Stefan Diestelmann'#0'&{8E746F41-F824-4236-8D73-83A5CB8356BC}'#6'stefan@2ad1b0748453272d8e73cbfe0869910b716d03f5bbd9da2d09849d6fa925aedf'#0#0#2#0#0#0

may be a codesite Problem with SetString ?!

ab · 2014-11-19 21:04:47

Could you try with the http://synopse.info/fossil/info/98535d019c fix?

itSDS · 2014-11-20 11:16:15

i tried but did not fix the problem

I made a little test program from sample 17. I replaced test.db3 with my db3 - File and added my query.
I'll send the file via EMail.

Last edited by itSDS (2014-11-20 11:25:09)

itSDS · 2014-11-20 12:07:21

sry ab don't know how to send a file to you. I made a zip if you need it tell me how pls.

ab · 2014-11-20 13:13:05

You can use webcontact01 at synopse dot info email address.

ab · 2014-11-21 12:50:38

Should be fixed by http://synopse.info/fossil/info/489a4f24f1

It affected only Delphi 2007 and up versions of the VCL.

Thanks for the feedback!

itSDS · 2014-11-21 15:57:36

Hi Arnaud,

i downloaded the last Version and testet both my testprogramm (i sent you) and SynDBExplorer with my SynDBRemote WebService

@testprogramm:
Now only 1 Column and 2 rows are shown. Column 1 is empty.

@SynDBExplorer:
now the 2 rows are shown but the one Field is as before filled with the same trash as before.

I'm using XE7

Last edited by itSDS (2014-11-21 15:58:26)

ab · 2014-11-21 18:21:04

Yes, there was a small issue with XE7.

See http://synopse.info/fossil/info/ac81632ed2

Now it should work as expected.

itSDS · 2014-11-22 10:35:03

TY now its working

mORMot Open Source

#1 2014-11-18 15:21:29

Difference in the Resulting DataSet of ToClientDataSet and ToDataSet

#2 2014-11-18 15:31:41

Re: Difference in the Resulting DataSet of ToClientDataSet and ToDataSet

#3 2014-11-18 15:35:26

Re: Difference in the Resulting DataSet of ToClientDataSet and ToDataSet

#4 2014-11-18 16:11:56

Re: Difference in the Resulting DataSet of ToClientDataSet and ToDataSet

#5 2014-11-19 11:06:38

Re: Difference in the Resulting DataSet of ToClientDataSet and ToDataSet

#6 2014-11-19 13:43:15

Re: Difference in the Resulting DataSet of ToClientDataSet and ToDataSet

#7 2014-11-19 14:38:14

Re: Difference in the Resulting DataSet of ToClientDataSet and ToDataSet

#8 2014-11-19 14:41:46

Re: Difference in the Resulting DataSet of ToClientDataSet and ToDataSet

#9 2014-11-19 21:04:47

Re: Difference in the Resulting DataSet of ToClientDataSet and ToDataSet

#10 2014-11-20 11:16:15

Re: Difference in the Resulting DataSet of ToClientDataSet and ToDataSet

#11 2014-11-20 12:07:21

Re: Difference in the Resulting DataSet of ToClientDataSet and ToDataSet

#12 2014-11-20 13:13:05

Re: Difference in the Resulting DataSet of ToClientDataSet and ToDataSet

#13 2014-11-21 12:50:38

Re: Difference in the Resulting DataSet of ToClientDataSet and ToDataSet

#14 2014-11-21 15:57:36

Re: Difference in the Resulting DataSet of ToClientDataSet and ToDataSet

#15 2014-11-21 18:21:04

Re: Difference in the Resulting DataSet of ToClientDataSet and ToDataSet

#16 2014-11-22 10:35:03

Re: Difference in the Resulting DataSet of ToClientDataSet and ToDataSet

Board footer