Hello Peter:
I'm not sure if you were able to get this sorted out.
I am also new to firedac. I'm moving a large project to interbase and firedac.
I have also dropped into this situation.
I am opening a form appending a record and filling in the record.
When I hit the post then the system appears to be in some kind of loop.
I have used the firedac monitor to see....
. isc_close_blob [blob_handle=$035EB188]
. isc_dsql_fetch [stmt_handle=$035E0434, dialect=3]
. isc_open_blob2 [db_handle=$096E13B8, tra_handle=$035D3B8C, blob_id.high=171, blob_id.low=13842]
. isc_blob_info [blob_handle=$035EB188, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$035EB188]
. isc_close_blob [blob_handle=$035EB188]
. isc_dsql_fetch [stmt_handle=$035E0434, dialect=3]
. isc_open_blob2 [db_handle=$096E13B8, tra_handle=$035D3B8C, blob_id.high=171, blob_id.low=13843]
. isc_blob_info [blob_handle=$035EB188, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$035EB188]
. isc_close_blob [blob_handle=$035EB188]
. isc_dsql_fetch [stmt_handle=$035E0434, dialect=3]
. isc_open_blob2 [db_handle=$096E13B8, tra_handle=$035D3B8C, blob_id.high=171, blob_id.low=13844]
. isc_blob_info [blob_handle=$035EB188, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$035EB188]
. isc_close_blob [blob_handle=$035EB188] ....
It just keeps going.
Perhaps when I insert a record I should use a command instead of a simple insert and then fill in from a form that has direct access to the data?
John
Hi all,
Wrote program using Firedac to connect to my tables.
Now they are using that program on several computers and I get into problems.
When they click on button the following action is done :
MainForm->FDQBewerk1->SQL->Clear();
MainForm->FDQBewerk1->SQL->Add("Select * from Klanten where Klantnummer = " + QuotedStr(MemKlantnr));
MainForm->FDQBewerk1->Active = true;
if (!MainForm->FDQBewerk1->IsEmpty())
{
MainForm->FDQBewerk1->Edit();
MainForm->FDQBewerk1->FieldByName("Klantnummer")->AsString = TxtKnr->Text;
MainForm->FDQBewerk1->Post();
}
And as soon as the post is executed my program hangs ...
I think it has something to do with updatesettings but I'm quite new in this ...
Plse you advise ...
Thanks in advance !!!!
Regards,
Peter
--
JMAC out
Connect with Us