Posts

Showing posts with the label Seattle

So I'm back to (trying to) migrate 100% to FireDAC and running into a seemingly stupid/noob/perplexing problem...

-
So I'm back to (trying to) migrate 100% to FireDAC and running into a seemingly stupid/noob/perplexing problem against an IBM iSeries. (Existing software uses variously BDE [yes, I know], DBX or ADO, all fine, but all legacy dependencies that I'd like to get away from.) The basic problem is that basic dataset based update code simply does not work. That is, setting up a TFDConnection, TFDQuery and then attempting to update a table just simply does not work. The dataset is eiter read-only, or if I "force things" (for example by setting "UpdateNonBaseTables" or by unsetting "UpdateOptions.CheckReadOnly") then errors are generated. Specifically, setting "UpdateNonBaseTables" to True allows the dataset to go into edit mode but then generates the following error: EODBCNativeException with message '[FireDAC][Phys][ODBC][IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0104 - Token . was not valid. Valid tokens: , FROM INTO.'...
Post a Comment
Read more

So I'm back to (trying to) migrate 100% to FireDAC and running into a seemingly stupid/noob/perplexing problem against an IBM iSeries. (Existing software uses variously BDE [yes, I know], DBX or ADO, all fine, but all legacy dependencies that I'd like to get away from.)

-
So I'm back to (trying to) migrate 100% to FireDAC and running into a seemingly stupid/noob/perplexing problem against an IBM iSeries. (Existing software uses variously BDE [yes, I know], DBX or ADO, all fine, but all legacy dependencies that I'd like to get away from.) The basic problem is that basic dataset based update code simply does not work. That is, setting up a TFDConnection, TFDQuery and then attempting to update a table just simply does not work. The dataset is eiter read-only, or if I "force things" (for example by setting "UpdateNonBaseTables" or by unsetting "UpdateOptions.CheckReadOnly") then errors are generated. Specifically, setting "UpdateNonBaseTables" to True allows the dataset to go into edit mode but then generates the following error: EODBCNativeException with message '[FireDAC][Phys][ODBC][IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0104 - Token . was not valid. Valid tokens: , FROM INTO.'...
Post a Comment
Read more

Am I missing something here? #Seattle VCL

-
Am I missing something here? #Seattle  VCL I have form2 which inherits  from form1. form1 has font.size = 14. form2 overrides this and sets it to 12. I create form3 which inherits from form2 (using the File/New/Other/Inheritable Items) and form3 is created with font.size = 15. why?
5 comments
Read more

Some strange things are happening in my #Seattle . Yesterday, when I clicked the File Open button it closed the IDE, but the File|Open on the menu was fine. Now even that closes the IDE.

-
Some strange things are happening in my #Seattle . Yesterday, when I clicked the File Open button it closed the IDE, but the File|Open on the menu was fine. Now even that closes the IDE. I've filed this under Code Rants as there isn't a General Rants section.
28 comments
Read more

Anyone else experiencing a slowness in #Seattle Update 1 when closing a unit or the whole project?

-
Anyone else experiencing a slowness in #Seattle  Update 1 when closing a unit or the whole project? Something similar happens when you rename units in the project manager. Closing the Welcome page seems to cure it. In addition I have an incredibly long pause when starting Delphi. The splash screen says "all designtime packages loaded" and IDEFixPack is on 100%. CPU load for bds.exe is 0%. Up to now I wasn't able to get rid of this.
Post a Comment
Read more

Anyone else experiencing a slowness in #Seattle Update 1 when closing a unit or the whole project? Something similar happens when you rename units in the project manager. Closing the Welcome page seems to cure it.

-
Anyone else experiencing a slowness in #Seattle  Update 1 when closing a unit or the whole project? Something similar happens when you rename units in the project manager. Closing the Welcome page seems to cure it. In addition I have an incredibly long pause when starting Delphi. The splash screen says "all designtime packages loaded" and IDEFixPack is on 100%. CPU load for bds.exe is 0%. Up to now I wasn't able to get rid of this.
6 comments
Read more

I am using ClientDataSet.Locate to find a record.

-
I am using ClientDataSet.Locate to find a record. One of the two KeyFields is a "Text" field (SqlLite). However at runtime I get  "EDatabaseError with message 'Field 'Name' is of an unsupported type'."         ItemName := cdsSLItems.FieldByName('Name').AsWideString;         try           if cdsSLItems.Locate('IsleId;Name', VarArrayOf([                          cdsSLItems.FieldByName('IsleId').AsInteger,                          ItemName]),[loCaseInsensitive]) then Can someone show me the right way to do this? #Seattle .
3 comments
Read more