Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: How to delete a record from a TFDTable (SQLite database)


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 2 - Last Post: Oct 9, 2015 2:06 AM Last Post By: Tom Roberts
Tom Roberts

Posts: 102
Registered: 6/21/05
How to delete a record from a TFDTable (SQLite database)  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 2, 2015 11:28 AM
Apart from the FetchOptions (I've got Mode=fmAll and RecordCount=cmFetched) the table has the default options. When I execute the line

MyFDTable->Delete();

nothing happens. MyFDTable->RecordCount stays the same and the associated SQLite table is untouched after closing the app.
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: How to delete a record from a TFDTable (SQLite database)  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 8, 2015 11:52 AM   in response to: Tom Roberts in response to: Tom Roberts
Do you have CachedUpdates = True ?

--
With best regards,
Dmitry Arefiev / FireDAC Architect
Tom Roberts

Posts: 102
Registered: 6/21/05
Re: How to delete a record from a TFDTable (SQLite database)  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 9, 2015 2:06 AM   in response to: Dmitry Arefiev in response to: Dmitry Arefiev
Dmitry Arefiev wrote:
Do you have CachedUpdates = True ?

I don't Dimitry. From the .dfm

object Settings: TFDTable
IndexFieldNames = 'ID;Name'
Connection = Main.FormbookConnect
UpdateOptions.UpdateTableName = 'settings'
UpdateOptions.KeyFields = 'ID;Name'
TableName = 'settings'
Left = 144
Top = 16
end
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02