TvirtualQuery + TTable - two important errors

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Creator
Posts: 17
Joined: Wed 05 Jun 2013 18:33

TvirtualQuery + TTable - two important errors

Post by Creator » Sun 26 May 2019 18:02

Hi
My environment: Windows 10, Delphi 10.3 Update 1, UniDac 7.4.12

Object TTable open with table Dbase 7 "Example.dbf" (important level 7) created by BDE.
Table "Example" has 2 fields: "ID" - AutoIncrement and "Name" - String

TTable (named "T1") is connected with TVirtualQuery (named "VQ").
VQ.SQL.Text := SELECT * FROM T1
VQ.KeyFields := ID

Error 1:
We open whole and across Grid we change content of field "Name".
We receive error (translation from Polish): "Field ID cannot be modified".
Error is result of property "ReadOnly" of field T1.ID However field T1.ID is not modified.
( viewing with DBmonitor: UPDATE main.T1 SET NAME = ? WHERE ID = ? )
This error can be avoided through use of following sequence of code:
T1.Active := TRUE;
T1.FieldByName('ID').ReadOnly := FALSE;
VQ.Active := TRUE;

However such solution is only prosthesis.


Error 2 (FATAL !):
We open whole and across Grid we clean content of field "Name" and we close whole.
Again we open whole and receive error (translation from Polish):
"Cannot make conversion variant of type (NULL) on type "(OleStr)"
I suppose that error can result from way of filling of empty StringField in Dbase 7 (bytes zero).


Regards

MaximG
Devart Team
Posts: 1431
Joined: Mon 06 Jul 2015 11:34

Re: TvirtualQuery + TTable - two important errors

Post by MaximG » Mon 27 May 2019 14:08

Thank you for the information. We will investigate the described issue and let you know the results shortly.

MaximG
Devart Team
Posts: 1431
Joined: Mon 06 Jul 2015 11:34

Re: TvirtualQuery + TTable - two important errors

Post by MaximG » Wed 29 May 2019 11:37

We reproduced the issue and fixed this error. The fix will be included in the next UniDAC build. As a workaround, we can send you a night UniDAC build including the required changes. For this, using e-support form (https://www.devart.com/company/contactform.html) provide us with your license number and IDE version you are interested in

Creator
Posts: 17
Joined: Wed 05 Jun 2013 18:33

Re: TvirtualQuery + TTable - two important errors

Post by Creator » Wed 29 May 2019 12:35

Thank you too quick reaction.
Greetings for entire group Devart.

Regards

Creator
Posts: 17
Joined: Wed 05 Jun 2013 18:33

Re: TvirtualQuery + TTable - two important errors

Post by Creator » Wed 29 May 2019 21:56

Hi,

After testing of received the nightly build "unidac74d26pro_28_05_2019.exe":

Error 2 - was eliminated.
Error 1 - still exists. It is less essential, but confuses.

Regards

MaximG
Devart Team
Posts: 1431
Joined: Mon 06 Jul 2015 11:34

Re: TvirtualQuery + TTable - two important errors

Post by MaximG » Fri 07 Jun 2019 13:16

Can you please specify if the "Field ID cannot be modified" error can be reproduced after the latest night build we sent you is installed? In our test environment, we cannot reproduce the error while using this specific build.

Creator
Posts: 17
Joined: Wed 05 Jun 2013 18:33

Re: TvirtualQuery + TTable - two important errors

Post by Creator » Mon 10 Jun 2019 12:08

Hi,

I did not receive link to latest night build. My test concerns "unidac74d26pro_28_05_2019.exe" In this version error still appears

Regards

MaximG
Devart Team
Posts: 1431
Joined: Mon 06 Jul 2015 11:34

Re: TvirtualQuery + TTable - two important errors

Post by MaximG » Tue 11 Jun 2019 15:12

We emailed you the link which allows you to download the latest UniDAC night build. Please use it to check how your application works and let us know the results.

Creator
Posts: 17
Joined: Wed 05 Jun 2013 18:33

Re: TvirtualQuery + TTable - two important errors

Post by Creator » Wed 12 Jun 2019 10:45

Hi,
I tested night build 11_06_2019 for 5 different Dbase VII tables. Unfortunately error still appears.

Regards

MaximG
Devart Team
Posts: 1431
Joined: Mon 06 Jul 2015 11:34

Re: TvirtualQuery + TTable - two important errors

Post by MaximG » Wed 12 Jun 2019 14:05

For further issue investigation, please send the full source code of your test project (with Example.dbf file), execution of which causes the issue. It is convenient to do it using the e-support form (https://www.devart.com/company/contactform.html)

Creator
Posts: 17
Joined: Wed 05 Jun 2013 18:33

Re: TvirtualQuery + TTable - two important errors

Post by Creator » Thu 13 Jun 2019 01:51

Hi,
Simple test project was sent by contact form.

Regards

MaximG
Devart Team
Posts: 1431
Joined: Mon 06 Jul 2015 11:34

Re: TvirtualQuery + TTable - two important errors

Post by MaximG » Thu 13 Jun 2019 11:58

Thank you for the information. We have reproduced the issue and will investigate its origin. We will inform you about the results shortly.

Post Reply