Watch, Follow, &
Connect with Us

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


Welcome, Guest
Guest Settings
Help

Thread: FireDac and Paradox Tables


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


Permlink Replies: 1 - Last Post: Aug 24, 2015 9:32 PM Last Post By: Dmitry Arefiev
Stefano Fanti

Posts: 7
Registered: 5/13/11
FireDac and Paradox Tables  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 24, 2015 1:36 AM
Hi, I have a problem during the opening of the Paradox tables using Firedac and ODBC.
If the table name is longer than 8 characters it appears an Access Violation error.
To reproduce this error, you can use the code in this White Paper Universal Enterprise Data Connectivity for the Multi-Device World with FireDac Cary Jensen.
Is there a solution to this problem?
Thank you in advance
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: FireDac and Paradox Tables  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 24, 2015 9:32 PM   in response to: Stefano Fanti in response to: Stefano Fanti
I think it is Paradox ODBC driver limitation. From its documentation I see:
SQL_MAX_TABLE_NAME_LEN = 12
Which looks like 8 chars for name, 1 char for period ('.'), 3 chars for extension.

--
With best regards,
Dmitry Arefiev / FireDAC Architect
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02