Print Thread
This error occurs correctly?
#53506 05/05/16 07:47 AM
Joined: Aug 2004
Posts: 83
Ukraine
A
Member
OP Offline
Member
A
Joined: Aug 2004
Posts: 83
Ukraine
I try to change the query text without reopening dataset
Code
  OraSes.Connected := true;
  ods.SQL.Text := 'select 1 from dual';
  ods.Open;
  ods.SQL.Text := 'select ''a'' from dual';
  ods.Refresh; // Project Project1.exe raised exception class EConvertError with message ''a' is not a valid floating point value'. Process stopped. Use Step or Run to continue.

Re: This error occurs correctly?
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
You can indeed not change the fields when refreshing a dataset. You will need to reopen it so that the field names and types are refreshed as well.


Marco Kalter
Allround Automations
Re: This error occurs correctly?
Marco Kalter #53509 05/05/16 08:53 AM
Joined: Aug 2004
Posts: 83
Ukraine
A
Member
OP Offline
Member
A
Joined: Aug 2004
Posts: 83
Ukraine
ok, thanks


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.023s Queries: 14 (0.009s) Memory: 2.5041 MB (Peak: 3.0424 MB) Data Comp: Off Server Time: 2024-05-18 16:18:43 UTC
Valid HTML 5 and Valid CSS