Watch, Follow, &
Connect with Us

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


Welcome, Guest
Guest Settings
Help

Thread: Moving BDE/DBASE to FireDac/Interbase - Stalled for some time.



Permlink Replies: 5 - Last Post: Nov 4, 2016 9:25 AM Last Post By: John MacDonald Threads: [ Previous | Next ]
John MacDonald

Posts: 179
Registered: 3/22/98
Moving BDE/DBASE to FireDac/Interbase - Stalled for some time.
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 13, 2016 9:46 PM
First let me start by saying thanks to everyone who has helped so far.

I used the interbase datapump to move my database over from dbase to interbase.
I am using FireDac and the combination is not giving me the results I thought I would get...

Many of the databases have a blob field. When I run the application the FireDac monitor shows quite a bit of activity dealing with blob fields.
When I first started this the app would finish, very slowly, but it did finish and then display the data in a form. Now it is hitting an error. In either case I think the issue is with the blob conversion. Can someone verify this is what is going on.

Is my issue with FireDac or with the converted file?

I hope its ok to post this information.... This is the activity being output to my monitor.

. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=12]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=13]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=14]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=15]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=16]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=17]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1779]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1677]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=18]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1678]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
<< Fetch [ATable="Build", Command="Select * ...
. TFDCustomCommand.FetchFinished [Command="Select * ...
<< TFDCustomCommand.Fetch [Command="Select * ...
TFDCustomCommand.Fetch [Command="Select * ...
Fetch [ATable="Build", Command="Select * ...
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1679]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1680]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1681]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=19]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=20]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=21]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=22]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=23]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=24]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1467]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=25]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=26]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=104]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1687]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1688]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=105]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1560]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=106]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=107]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=108]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=109]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=110]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=111]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1697]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1587]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=112]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=113]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=114]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=115]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=116]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=117]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1783]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1784]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=118]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1478]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=119]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=120]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1479]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=121]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=122]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=123]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=124]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=125]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=126]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1469]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=127]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=208]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=209]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1799]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=210]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=211]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=212]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1468]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1588]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1589]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1578]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=213]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=214]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=215]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1571]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1769]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1770]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1584]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=216]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=217]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=218]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=219]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=312]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1366]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1475]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1464]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838] .....

It keeps going.

--
JMAC out

Edited by: John MacDonald on Oct 14, 2016 12:46 AM

Jeff Overcash (...

Posts: 1,529
Registered: 9/23/99
Re: Moving BDE/DBASE to FireDac/Interbase - Stalled for some time. [Edit]
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 14, 2016 9:35 AM   in response to: John MacDonald in response to: John MacDonald
John MacDonald wrote:
First let me start by saying thanks to everyone who has helped so far.

I used the interbase datapump to move my database over from dbase to interbase.
I am using FireDac and the combination is not giving me the results I thought I would get...

Many of the databases have a blob field. When I run the application the FireDac monitor shows quite a bit of activity dealing with blob fields.
When I first started this the app would finish, very slowly, but it did finish and then display the data in a form. Now it is hitting an error. In either case I think the issue is with the blob conversion. Can someone verify this is what is going on.

Is my issue with FireDac or with the converted file?

I hope its ok to post this information.... This is the activity being output to my monitor.

FireDAC pulls the blob over when the record is read. The BDE (and IBX) pulls
the actual blob data over when the blob is needed. Unless there was a recent
change in FireDAC you will probably need to rewrite the SQL sections that are
slow to not include the blob field then grab the blob data in a separate query
when needed.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
John MacDonald

Posts: 179
Registered: 3/22/98
Re: Moving BDE/DBASE to FireDac/Interbase - Stalled for some time.
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 14, 2016 1:32 PM   in response to: John MacDonald in response to: John MacDonald
Thanks Jeff:

Too bad they did not include this, or I missed it, in the migration documentation.

I'm convinced that this is one of the biggest issue I have with the migration.

John

John MacDonald wrote:
First let me start by saying thanks to everyone who has helped so far.

I used the interbase datapump to move my database over from dbase to interbase.
I am using FireDac and the combination is not giving me the results I thought I would get...

Many of the databases have a blob field. When I run the application the FireDac monitor shows quite a bit of activity dealing with blob fields.
When I first started this the app would finish, very slowly, but it did finish and then display the data in a form. Now it is hitting an error. In either case I think the issue is with the blob conversion. Can someone verify this is what is going on.

Is my issue with FireDac or with the converted file?

I hope its ok to post this information.... This is the activity being output to my monitor.

. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=12]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=13]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=14]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=15]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=16]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=17]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1779]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1677]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=18]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1678]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
<< Fetch [ATable="Build", Command="Select * ...
. TFDCustomCommand.FetchFinished [Command="Select * ...
<< TFDCustomCommand.Fetch [Command="Select * ...
TFDCustomCommand.Fetch [Command="Select * ...
Fetch [ATable="Build", Command="Select * ...
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1679]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1680]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1681]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=19]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=20]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=21]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=22]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=23]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=24]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1467]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=25]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=26]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=104]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1687]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1688]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=105]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1560]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=106]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=107]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=108]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=109]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=110]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=111]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1697]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1587]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=112]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=113]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=114]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=115]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=116]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=117]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1783]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1784]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=118]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1478]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=119]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=120]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1479]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=121]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=122]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=123]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=124]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=125]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=126]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1469]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=127]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=208]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=209]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1799]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=210]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=211]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=212]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1468]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1588]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1589]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1578]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=213]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=214]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=215]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1571]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1769]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1770]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1584]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=216]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=217]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=218]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=219]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=312]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1366]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1475]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838]
. isc_close_blob [blob_handle=$03F57838]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_dsql_fetch [stmt_handle=$03F57B14, dialect=3]
. isc_open_blob2 [db_handle=$09ED13BC, tra_handle=$03F57C5C, blob_id.high=129, blob_id.low=1464]
. isc_blob_info [blob_handle=$03F57838, items="num_segments;max_segment;total_length;type"]
. isc_get_segment [blob_handle=$03F57838] .....

It keeps going.

--
JMAC out

Edited by: John MacDonald on Oct 14, 2016 12:46 AM


--
JMAC out
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: Moving BDE/DBASE to FireDac/Interbase - Stalled for some time.
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 14, 2016 10:37 PM   in response to: John MacDonald in response to: John MacDonald
I'm convinced that this is one of the biggest issue I have with the migration.

DBase and InterBase are two different worlds. What works well in one case may
not work well in other case. Eg, TTable for DBase is right solution, TFDTable for
InterBase is not. Then InterBase is extremely "sensitive" for transaction handling,
DBase is not.

Regarding your long trace output.

It seems you opened TFDQuery wthout WHERE phrase or with WHERE phrase,
but returning you many records. After that a transaction remains active. It is
InterBase requirement to keep cursor active and do not fetch all records. After
calling Post FireDAC will auto commit current transaction. And to preserve all
records returned by the query, FireDAC will first fetch all records from the query
cursor, then commit transaction. And you see this "fetching all". Possible solutions:
* use explicit transaction control and avoid auto-commiting.
* use SELECT's with restrictive WHERE phrases.
* http://docwiki.embarcadero.com/Libraries/Berlin/en/FireDAC.Stan.Option.TFDFetchOptions.AutoFetchAll

To defer BLOB's fetching, you should exclude fiBlobs from FetchOptions.Items:
http://docwiki.embarcadero.com/Libraries/Berlin/en/FireDAC.Stan.Option.TFDFetchOptions.Items

--
With best regards,
Dmitry
John MacDonald

Posts: 179
Registered: 3/22/98
Re: Moving BDE/DBASE to FireDac/Interbase - Stalled for some time.
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 29, 2016 4:51 AM   in response to: Dmitry Arefiev in response to: Dmitry Arefiev
Thanks Dmitry:

I was adding a new record to the database and the original database had a memo field ( text blob).
I must admit that I overlooked the where clause and it makes sense, but, how do you know which record you are about to use that you have not created yet?

I will look over the articles at the links.

Thanks for your help.

John

Dmitry Arefiev wrote:
I'm convinced that this is one of the biggest issue I have with the migration.

DBase and InterBase are two different worlds. What works well in one case may
not work well in other case. Eg, TTable for DBase is right solution, TFDTable for
InterBase is not. Then InterBase is extremely "sensitive" for transaction handling,
DBase is not.

Regarding your long trace output.

It seems you opened TFDQuery wthout WHERE phrase or with WHERE phrase,
but returning you many records. After that a transaction remains active. It is
InterBase requirement to keep cursor active and do not fetch all records. After
calling Post FireDAC will auto commit current transaction. And to preserve all
records returned by the query, FireDAC will first fetch all records from the query
cursor, then commit transaction. And you see this "fetching all". Possible solutions:
* use explicit transaction control and avoid auto-commiting.
* use SELECT's with restrictive WHERE phrases.
* http://docwiki.embarcadero.com/Libraries/Berlin/en/FireDAC.Stan.Option.TFDFetchOptions.AutoFetchAll

To defer BLOB's fetching, you should exclude fiBlobs from FetchOptions.Items:
http://docwiki.embarcadero.com/Libraries/Berlin/en/FireDAC.Stan.Option.TFDFetchOptions.Items

--
With best regards,
Dmitry

--
JMAC out
John MacDonald

Posts: 179
Registered: 3/22/98
Re: Moving BDE/DBASE to FireDac/Interbase - Stalled for some time.
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 4, 2016 9:25 AM   in response to: Dmitry Arefiev in response to: Dmitry Arefiev
I have investigated the two settings and compared the output on a test application.
There does not seem to be much difference when I change the options you noted.

Sorry to have to ask. It is likely in the select statement.

How do I limit a search to a record I have not created yet?

We are using Select * so we can browse from record to record with a navigator.
When the record is created the form goes blank. When we post we get this.

This is a case of migration and likely my misunderstanding of sql.
In my example I don't wish to use a navigator. I will likely add a button.
This may mean I can use an execSql or something else to create the record and post it.

Thanks

John


Dmitry Arefiev wrote:
I'm convinced that this is one of the biggest issue I have with the migration.

DBase and InterBase are two different worlds. What works well in one case may
not work well in other case. Eg, TTable for DBase is right solution, TFDTable for
InterBase is not. Then InterBase is extremely "sensitive" for transaction handling,
DBase is not.

Regarding your long trace output.

It seems you opened TFDQuery wthout WHERE phrase or with WHERE phrase,
but returning you many records. After that a transaction remains active. It is
InterBase requirement to keep cursor active and do not fetch all records. After
calling Post FireDAC will auto commit current transaction. And to preserve all
records returned by the query, FireDAC will first fetch all records from the query
cursor, then commit transaction. And you see this "fetching all". Possible solutions:
* use explicit transaction control and avoid auto-commiting.
* use SELECT's with restrictive WHERE phrases.
* http://docwiki.embarcadero.com/Libraries/Berlin/en/FireDAC.Stan.Option.TFDFetchOptions.AutoFetchAll

To defer BLOB's fetching, you should exclude fiBlobs from FetchOptions.Items:
http://docwiki.embarcadero.com/Libraries/Berlin/en/FireDAC.Stan.Option.TFDFetchOptions.Items

--
With best regards,
Dmitry

--
JMAC out
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02