FireDAC / Delphi XE7 / Firebird 2.5 + Dialect 3: Key fields turn upper case [Edit] #2
Hi, When working wih a SQL dialect 3 database and field names in upper/lower case, I used to reference those fields in double quotes on my old Delphi 2010 with IBX, which worked well enough. After migrating to XE7 with the latest FireDAC, I set IndexFieldNames to 'Mmm' including the double quotes. 'Mmm' is also my only primary key field. When opening the table, FireDAC executes an SQL statement that ends with {code}ORDER BY A.'Mmm' ASC, A.MMM ASC{code} which of course delivers an exception because there is no field MMM. I hope it is ok if I post some singl...
FireDAC / Delphi XE7 / Firebird 2.5 + Dialect 3: Key fields turn upper case
Hi, When working wih a SQL dialect 3 database and field names in upper/lower case, I used to reference those fields in double quotes on my old Delphi 2010 with IBX, which worked well enough. After migrating to XE7 with the latest FireDAC, I set IndexFieldNames to 'Mmm' including the double quotes. When opening the table, FireDAC executes an SQL statement that ends with {code}ORDER BY A.'Mmm' ASC, A.MMM ASC{code} which of course delivers an exception because there is no field MMM. I hope it is ok if I post some single lines of code here to explain the issue - no copyri...
Converting Delphi 2007 Indy 10.2.3 to Delphi 2009 Indy 10.5.5 [Edit]
Hello, I am currently attempting to port over a Delphi 2007 project that uses Indy 10.2.3 (very successfully) to Delphi 2009 and Indy 10.5.5 (I just got the latest development build this morning). I think I am running into an encoding issue, but am not sure. Specifically, IDHTTP with SSL calls an old CGI and the CGI returns a .zip file and I then save it to the disk. In 2007 and before this worked perfectly. In 2009, it is not. Here is the examples of the 2 different results (though cut way short in the post) I am getting back: 2007: 'PK'#3#4#$14#0#0#0#8#0'rLQ9žrPb€'#0...
FireDAC mobile app error as sqlite as delphi XE7 [Edit] #2
i im trying of connect my app as FireDAC but i have some errors. I follow all steps of Mobile_Tutotils_en_pdf file for delphi XE7. First i add one FireDAConnection compoent, after i in FireDAConnection Edit i set DriverID as Sqlite, in Database parameter i set this existing sqlite database 'shoplist.s3db , and i set lockingmode to normal as this manual tell. I After i follow steps 1,2,3,4 and in the step 5 of the page 265 when i try of to set Connected property to true, i get this error: 1. [FireDac][Comp][Clnt]-340. Driver ID is not defined. Set TFDConnection.DriverName or Add D...
FireDac (XE7) apparently not using Foreign Key indexes in Firebird 2.5
Migrating an application from DBX to FireDac we have found the following: Two Tables: TABLE1: ID1 and ID2 Primary Key TABLE2: ID1, ID2 and ID3 Primary Key , and ID1 and ID2 as Foreign key (FK_TABLE1) pointing to same fields on TABLE1. No more indexes defined. (Firebird creates by default an index with each primary and foreign key) A simple query (SELECT * from TABLE1, TABLE2 WHERE T1.ID1 = T2.ID1 and T1.ID2=T2.ID2) that only retrieves a couple of records took more tan 6 seconds after migrating to FireDac, while with DBX was under 1 sec. Afer investigating we saw that if ...
SEPA components for Delphi with Source Code (Delphi 5
Hi all, in the european union change next year the Bankingformat to the SEPA Format. All peoples and companies must change the bankingssoftware and the costumer data form acountnummers in the new IBAN and BIC numbers. See: http://www.arma-it.de/shop/artikelueber.php?wgruppeid=211&wgruppe_offen=211 Functions: - generate SEPA XML'S - Calc IBAN - BIC Database (DE,AT and CH) Questions: vertrieb@arma-it.de PS: Bankinssoftware for Develpoers (Germany only) http://www.arma-it.de/shop/artikelueber.php?wgruppeid=212&wgruppe_offen=212 El 26/10/13 21:38, A...
FireDAC mobile app error as sqlite as delphi XE7 [Edit]
i im trying of connect my app as FireDAC but i have some errors. I follor all steps of Mobile_Tutotils_en_pdf file for delphi XE7. First i add one FireDAConnection compoent, after i in FireDAConnection Edito i set DriverID as Sqlite, in Database parameter i set this existing sqlite database 'shoplist.s3db i create this database and table as other tool, and i can to add this to DBExpres in data exploer and i can to use it in one mobile delphi project', and i set lockingmode to normal as this manual tell. After as tell in page 269 of this manual when i click over test button, i ...
Caution error in FireDac 8.0.1 to Delphi Xe2 and earlier [Edit] #2
Please note that FireDac 8.0.1 have a bug, Embarcadero refuses to correct an error. In December 2014 I bought FireDac to Delphi XE2, 8.0.1 a few days later it turned out that the program has a bug StrsEmpty2Null not support parameter which makes the component is not useful for me. Although embecedro 8.0.5 patch is available and I bought a legal component, has not made me any corrections. Help addicted from buying Delphi Xe 7.0 Information received from worker embecedro Poland?. Does this attitude is fair. Can someone please help me make a package 8.0.5 or help to improve the error. E...
FireDAC and FetchBlobs with MySQL 5.5 and Delphi XE5
I try to obtain a stream of blob field stored in MySQL Database. With Oracle and MSSQL, it works great but with MYSQL, it doesn't work. I proceed like it's indicated in the documentation: ms-help://embarcadero.rs_xe5/libraries/FireDAC.Comp.DataSet.TFDDataSet.FetchBlobs.html {code} FDQuery1.FetchOptions.Items := FDQuery1.FetchOptions.Items - [fiBlobs]; FDQuery1.Open; ..... FDQuery1.FetchBlobs; oStr := FDQuery1.CreateBlobStream(FDQuery1.FieldByName('image'), bmRead); try // process image finally oStr.Free; end; {code} Does somebody succeed loading blob in ...
FireDAC and Delphi Pro XE4... firedac tab not visible?
I am moving from a very old Borland product (2006) to Delphi XE4 Professional with FireDAC addon. I purchased both from Embarcadero, and have downloaded both. The documentation says the FireDAC components should automagically appear in the tabset for Delphi. They do not. I don't want to fool around too much as my environment is strictly controlled by IT, and they are very slow to do anything. Is there something that I should have done, but did not do? I installed XE4 first, registered it, then used the link in my email from Embarcadero to download the FireDAC components. Then I ra...
Migrating from Delphi 6 to Delphi XE 3! [Edit]
All, I am a Delphi developer working in an windows form application developed using Delphi 6. Now, we are planning to upgrade the development tool. Can anyone provide me information related to major roadblocks that we can face while migrating from Delphi 6 to Delphi XE 3? Should we migrate to Delphi XE 3 or any other preferred version of Delphi based on the fact that our target users will be using Windows 7 or Windows 8? Do we have any tools or utilities to migrate the source code from Delphi 6 to higher version of Delphi? Also, any suggestions related to best practices are welcome....
Text.Write speed
Hi ! I have speed troubles for using Text.Write method in Delphi 2006, particularly with distant files (local network). For example, with the following code ('F' is a text file ; 'Line' is an about 200-character string): ----- AssignFile(F, FileName); try Rewrite(F); for l := 1 to 100 do begin for c := 1 to Length(Line) do Write(F, Line[c]); Writeln(F); end; finally CloseFile(F); end; ----- On a distant file: Delphi 5 -> 0.08 seconds Delphi 2006 -> close to 8 seconds Is there a speci...
ASP 2.0/3.5: How to get Visual Studio Web Developer 2008 Express Edition to use ASP.NET 2.0 rather than 3.5?
Hello, my ISP only supports ASP.NET 2.0. I am using VS Web Dev 2008 Express Edition. I have read somewhere that one can set the IDE to 'target' asp.net 2.0 or 3.5. I can't find this setting anywhere on the menu's. How does one do that?The code I am writing works fine so far. I am worried that I may use a 3.5 feature that is not supported. Thus I want to make sure my code is 2.0 compliant before I upload it.RegardsKhalidLondon You can do this by right click on the project which you want to run as 2.0, and select properties, In properties you can find Target Frame...