Watch, Follow, &
Connect with Us

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


Welcome, Guest
Guest Settings
Help

Thread: Error opening FireDac Mem Table


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


Permlink Replies: 2 - Last Post: Apr 18, 2018 5:30 AM Last Post By: Francisco Arman... Threads: [ Previous | Next ]
Zane Leo

Posts: 55
Registered: 12/29/09
Error opening FireDac Mem Table  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Apr 14, 2018 1:03 AM
Does anyone know what this error is and how to fix it:

.
.
exception class : EFDException
exception message : [FireDAC][DatS]-2. Object [__MT__DEFAULT_] is not found.
 
thread $11498 (TInThreadWithTask):
00d19ed9 +0119 ODY.exe FireDAC.Stan.Error 189 +26 FDException
00d1bf0b +00d7 ODY.exe FireDAC.Stan.Error 535 +8 FDException
00d4394c +002c ODY.exe FireDAC.DatS 2723 +1 TFDDatSNamedList.ErrorNameNotFound
00d43991 +0021 ODY.exe FireDAC.DatS 2733 +3 TFDDatSNamedList.ItemByName
00d5c392 +000a ODY.exe FireDAC.DatS 14686 +1 TFDDatSViewList.ViewByName
00d7dc6b +0157 ODY.exe FireDAC.Comp.DataSet 2673 +26 TFDDataSet.SwitchToIndex
00d7e6fa +00ea ODY.exe FireDAC.Comp.DataSet 2983 +17 TFDDataSet.InternalOpen
008a8916 +000e ODY.exe Data.DB 12682 +2 TDataSet.DoInternalOpen
008a89c6 +0016 ODY.exe Data.DB 12711 +3 TDataSet.OpenCursor
00d7e454 +0310 ODY.exe FireDAC.Comp.DataSet 2919 +57 TFDDataSet.OpenCursor
008a887d +0055 ODY.exe Data.DB 12663 +12 TDataSet.SetActive
00d7b4b3 +002b ODY.exe FireDAC.Comp.DataSet 1609 +7 TFDDataSet.SetActive
008a86b9 +0009 ODY.exe Data.DB 12619 +1 TDataSet.Open
.
.

The error occurs when I perform [TFDMemTable].Open at run-time.

At design-time [TFDMemTable].Open does not generate the error.

TIA

Michael Sawyer ...

Posts: 9
Registered: 9/10/17
Re: Error opening FireDac Mem Table  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Apr 17, 2018 2:56 AM   in response to: Zane Leo in response to: Zane Leo
Apparently you are setting the "IndexName" Property to "__MT__DEFAULT_" somewhere in your code, if it doesn't happen in design-time.
Maybe setting the "IndexesActive"-Property of your Memtable to "false" can help you for now, cause it ignores all index-settings. If it succeeds, inspect the values of IndexName and IndexFieldNames.
Francisco Arman...

Posts: 11
Registered: 3/3/01
Re: Error opening FireDac Mem Table  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Apr 18, 2018 5:30 AM   in response to: Zane Leo in response to: Zane Leo
Zane Leo wrote:
Does anyone know what this error is and how to fix it:

.
.
exception class : EFDException
exception message : [FireDAC][DatS]-2. Object [__MT__DEFAULT_] is not found.
 
thread $11498 (TInThreadWithTask):
00d19ed9 +0119 ODY.exe FireDAC.Stan.Error 189 +26 FDException
00d1bf0b +00d7 ODY.exe FireDAC.Stan.Error 535 +8 FDException
00d4394c +002c ODY.exe FireDAC.DatS 2723 +1 TFDDatSNamedList.ErrorNameNotFound
00d43991 +0021 ODY.exe FireDAC.DatS 2733 +3 TFDDatSNamedList.ItemByName
00d5c392 +000a ODY.exe FireDAC.DatS 14686 +1 TFDDatSViewList.ViewByName
00d7dc6b +0157 ODY.exe FireDAC.Comp.DataSet 2673 +26 TFDDataSet.SwitchToIndex
00d7e6fa +00ea ODY.exe FireDAC.Comp.DataSet 2983 +17 TFDDataSet.InternalOpen
008a8916 +000e ODY.exe Data.DB 12682 +2 TDataSet.DoInternalOpen
008a89c6 +0016 ODY.exe Data.DB 12711 +3 TDataSet.OpenCursor
00d7e454 +0310 ODY.exe FireDAC.Comp.DataSet 2919 +57 TFDDataSet.OpenCursor
008a887d +0055 ODY.exe Data.DB 12663 +12 TDataSet.SetActive
00d7b4b3 +002b ODY.exe FireDAC.Comp.DataSet 1609 +7 TFDDataSet.SetActive
008a86b9 +0009 ODY.exe Data.DB 12619 +1 TDataSet.Open
.
.

The error occurs when I perform [TFDMemTable].Open at run-time.

At design-time [TFDMemTable].Open does not generate the error.

TIA


Did you changed that object from TkbmMemtable to TFDMemtable?, IIRC '__MT__DEFAULT_' is an autocreated index kbmmemtable uses for Master detail relationship. If it so, check the DFM text (ALT+F12) of the Form or Datamodule where your TFDMemtables are, maybe in property IndexName.

Regards
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02