Questions tagged as 'firedac'

1
answer

How to post a detail record in an FDQuery with the parent record in insert mode?

I'm using two FDQuery with master-detail relationship and found a problem: using the CachedUpdates property and relating both FDQuery to a FDSchemaAdapter . If you call " Insert / Append " in Mestre and then (wi...
asked by 28.11.2017 / 21:27
1
answer

DataSnap with FireDac

In an application with DataSnap, I used SQLConnection : procedure TForm1.Button1Click(Sender: TObject); var ConectaServidor : TUClasseServidorClient; begin ConectaServidor := TUClasseServidorClient.Create(SQLConnection1.DBXConnection); try...
asked by 25.09.2017 / 18:30
1
answer

Multiple transactions with FireDAC?

I would like to work with multiple concurrent transactions in FireDAC , making different decisions and commits ) for each. It's possible? I currently work as follows: try obj_TFDConnection.StartTransaction(); ... obj_TFDConnection.Com...
asked by 08.03.2017 / 18:43
0
answers

How to retrieve the id inserted in sqlserver database using delphi datasnap

How to get the id that has just been inserted into the database on the server side, use Delphi XE10.1 SQlServer and Firedac Bank, I would get the id to use in the child table when it is master detail. as shown below procedure TsrmCadastro.dspP...
asked by 09.01.2017 / 22:27
0
answers

[FireDAC] [Dats] -16. Can not process - no parent. constraint [ForeingnKeyConstraint]

I have a master detail link Using Delphi Mysql and Firedac (adquery) I had a screen with the client / contact data, perfectly saved master detail detail used as the example link everything worked perfectly but with no change at all I started t...
asked by 15.09.2014 / 16:22