Watch, Follow, &
Connect with Us

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


Welcome, Guest
Guest Settings
Help

Thread: Migrating from BDE to FireDAC - object TTable


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


Permlink Replies: 6 - Last Post: Mar 17, 2016 1:06 AM Last Post By: John Smith
Paulo Mariano

Posts: 29
Registered: 11/25/12
Migrating from BDE to FireDAC - object TTable  
Click to report abuse...   Click to reply to this thread Reply
  Posted: May 30, 2014 2:18 PM
Hello.

I would appreciate if some assistance could be provided about the process of migrating an application from BDE to FireDAC.

Question #1
Document _http://docwiki.embarcadero.com/Libraries/XE5/en/FireDAC.Comp.Client.TFDTable_Properties_ identifies the properties of FireDAC object TFDTable.
Although listed in the mentioned document, property FieldDefs is not available in the Object Inspector (Delphi XE5).
Is this a bug?

Question #2
Which property of FireDAC object TFDTable corresponds to property StoreDefs of a BDE TTable object?

Thank you in advance.
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: Migrating from BDE to FireDAC - object TTable  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jun 2, 2014 3:00 PM   in response to: Paulo Mariano in response to: Paulo Mariano
Question #1
Document _http://docwiki.embarcadero.com/Libraries/XE5/en/FireDAC.Comp.Client.TFDTable_Properties_ identifies the properties of FireDAC object TFDTable.
Although listed in the mentioned document, property FieldDefs is not available in the Object Inspector (Delphi XE5).
Is this a bug?

FireDAC TFDTable does not have CreateTable method. So, there is no need for published FieldDefs property.

Question #2
Which property of FireDAC object TFDTable corresponds to property StoreDefs of a BDE TTable object?

TFDTable does not have StoreDefs, because FieldDefs is not published.

--
With best regards,
Dmitry Arefiev / FireDAC Architect
S SK

Posts: 2
Registered: 8/3/14
Re: Migrating from BDE to FireDAC - object TTable  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jul 3, 2014 5:49 AM   in response to: Dmitry Arefiev in response to: Dmitry Arefiev
Dmitry Arefiev wrote:
FireDAC TFDTable does not have CreateTable method. So, there is no need for published FieldDefs property.
So, how do you create a table in FD then? (I want to store a DataSnap-DataSet in a SQLite-Table)

Kind Regards
SSK
Robert Triest

Posts: 687
Registered: 3/24/05
Re: Migrating from BDE to FireDAC - object TTable  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jul 3, 2014 5:57 AM   in response to: S SK in response to: S SK
So, how do you create a table in FD then? (I want to store a DataSnap-DataSet in a SQLite-Table)
By using a FDQuery and execute a "create table" statement?

http://blogs.embarcadero.com/stephenball/2014/02/14/creating-an-interbase-database-on-the-fly-with-firedac/
S SK

Posts: 2
Registered: 8/3/14
Re: Migrating from BDE to FireDAC - object TTable  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jul 4, 2014 12:38 AM   in response to: Robert Triest in response to: Robert Triest
Thanks for your reply. I already thought my question was to vague.

Paulo and Dmitry refer to the old TTable and its CreateTable method, which - as far as I understood - is able to create SQL tables from its field defs. No need to craft a SQL statement manually. And that's what I am looking for. If there is still this possibility with FireDAC/TFDTable I really would like to know.

But it's pretty much possible, that I misunderstood the description of TTable.

Edited by: S SK on Jul 4, 2014 12:40 AM
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: Migrating from BDE to FireDAC - object TTable  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jul 4, 2014 7:52 PM   in response to: S SK in response to: S SK
If there is still this possibility with FireDAC/TFDTable I really would like to know.

No.

--
With best regards,
Dmitry Arefiev / FireDAC Architect
John Smith

Posts: 1
Registered: 10/5/09
Re: Migrating from BDE to FireDAC - object TTable  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Mar 17, 2016 1:06 AM   in response to: S SK in response to: S SK
Since XE7 is it possible: TFDTable has a CreateTable method that uses FieldDefs.

S SK wrote:
Thanks for your reply. I already thought my question was to vague.

Paulo and Dmitry refer to the old TTable and its CreateTable method, which - as far as I understood - is able to create SQL tables from its field defs. No need to craft a SQL statement manually. And that's what I am looking for. If there is still this possibility with FireDAC/TFDTable I really would like to know.

But it's pretty much possible, that I misunderstood the description of TTable.

Edited by: S SK on Jul 4, 2014 12:40 AM
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02