Data

Hi I have created a calculated field which determines the average of two sets of figures. Here is my code in the OnCalculatedFields event :   Try    Dataset.FieldByName('calcAverage').AsSingle:=      Dataset.FieldByName('TotalPoints').AsInteger div...

Hello, i have sometting strange in my application.  I wonder what I did wrong or what I did not understand.  The goal is to create 2 functions in the ServerMethodsUnit to modify a variable of the web module. For that, I  used the Datasnap Rest Se...

I am developing an application that is using an embedded iblite database.  Under the IDE the application runs as expected.  I have specified the username and password to the iblite database in the params section of the configuration.  However when I ...

Hi!   In RAD 10.1 I developed code which used an SQL query with calculated fields (SUM). This query is shown in a DBGrid. This functioned quite well. But, running this same code after being compiled and built in RAD 10.2.2 crashes into an error: [Fir...

Why is the following code working flawlessly in Delphi 10.1 Berlin, while 'fdquery2.open' fails in 10.2.1 Tokyo with an error "Commands out of sync; you can't run this command now'. I need similar code in a real program eg. showing records in a dbgri...

Using TPacketDataSet delta to write cached updates to ISAM database record. Using Modified Record pair,  The second delta record marked usModified holds every field, with the unmodified fields carrying NULL as the NewValue. Question:  How can I deter...

The FireDAC component TFDBatchMoveSQLWriter convert ftMemo and ftWideMemo fields/columns with NULL value to empty string. I have already written a Embarcadero Quality report on this in CASE RSP-19731, but wonder if there are some way I can get aroun...

I have a master detail relationship between two datasets. Also I have a form where the user fills data to be inserted into/updated from the master table. I'd like to allow the user to select an item from the detail table and insert its id into the ma...

Hi everybody, I'd like to use case-insensitive data searching (Locate, Lookup) everywhere in my App by default without specifying loCaseInsensitive option. Is there some setting or rule responsible for global case-insensitive data searching in FireD...

Hello,   I'm searching how I can retrieve master/detail dataset form client application to the server with datasnap and firedac components. But I can't get it run properly. Do get data and update data thats working fine. But not for an insert of t...

Hello We have a Delphi Bluetooth Low energy running on Android. When the program ( Master role )  is receiving a big amount of notifications (40000) from a characteristic, we found out that some notifications events are lost. Every time, the first no...

Can someone point me to some good samples/ information on CRUD using SQL Qry and live bindings. I'm hoping to convert a older database application from D6 to firemonkey. I don't seem to be able to find much on how you create, update, delete ect.  I s...

Hi   I have an existing iOS app with complex UI. Swift and objc.   This app must connect to a datasnap server app.   The objc connectors generated by rad studio does not implement the tunneling connection. Only unsecure http REST connection :( ...

I am using PostgreSQL for a database application, and I have been trying to use both PgDAC (devart) and FireDAC as delivered with Delphi 10.1 Berlin.  When I use PgDAC, everything works nicely.  Using FireDAC, things get strange. The UUID fields are ...

Hi, Nobody seems to be answering questions on FireDAC either at https://forums.embarcadero.com/forum.jspa?forumID=502 or https://community.embarcadero.com/index.php/forum. What's happened to the indispensable Dmitry? Any why are there now two sets ...

when executing this sql after a post to an informix table i always get a 0 returned.  It should return the last value of a serial key in that table. I run the sql immediately after the post(it's a post of an insert). Any help would be appreciated. I...

Hello - I'm developing 32-bit Windows applications using Delphi XE7 Enterprise, on a 64-bit Windows 7 machine. I'm in the process of updating an application's data access components from ADO to FireDAC, connecting to MS Access database. All is workin...

Hi I've been digging around the web and trolling the developers network site. I'm trying to read an .ods spreadsheet into a delphi program. It's a table. I needed to do this in R and it was as strieght forward as installing a library and pushing rea...