Couple of Qs

[FredS]

Is there anything more detailed that explains SmartFetch other than:
Smart fetch options are used to set up the behavior of the SmartFetch mode

Is there anything for the Interbase Provider uniTable that fetches Server side IDs like QueryIdentity for SQL Server? I know a Insert SQL can use Returning..

Thanks

Fred

[ViktorV]

1. The SmartFetch mode allows to speed up navigation through the DataSet with a big amount of data. To enable this mode, it is enough to set the Enabled property to True. In this case, when opening the DataSet, only key field values will be read out, our the values of the fields specified in the PrefetchedFields property. Data of other fields will be read out on demand when accessing a record.
2. To return the value of an auto-incremental field generated on the server-side, you should set the TUniTable.DMLRefresh property to True. See more details about this property in the UniDAC help: https://www.devart.com/unidac/docs/?dev ... efresh.htm

[FredS]

That helps a lot, thanks.

[FredS]

..you should set the TUniTable.DMLRefresh property to True. See more details about this property in the UniDAC help: https://www.devart.com/unidac/docs/?dev ... efresh.htm

Having some issues with DMLRefresh, it worked at first but now returns garbage.
Then I thought I'd strip it out of the DB Monitor log but the Monitor log is wrong, here is the entry from that log:

Code: Select all

2015-09-23 11:21:05 AM 0.000 SQL Execute: INSERT INTO FETCHLOG
  (DOMAINID, MESSAGE, ALERTLEVEL, SERVER, EVENTTIME)
VALUES
  (?, ?, ?, ?, ?)
RETURNING 
  ID, DOMAINID, MESSAGE, ALERTLEVEL, SERVER, EVENTTIME

:DOMAINID(LargeInt,IN)=3 
:MESSAGE(WideString[26],IN)='Processing Server: VMHOME ' 
:ALERTLEVEL(Integer,IN)=0 
:SERVER(WideString[6],IN)='VMHOME' 
:EVENTTIME(DateTime,IN)=2015-09-23 11:21:05 AM 
:RET_ID(LargeInt,OUT)=<NULL> 
:RET_DOMAINID(LargeInt,OUT)=<NULL> 
:RET_MESSAGE(WideString[0],OUT)=<NULL> 
:RET_ALERTLEVEL(Integer,OUT)=<NULL> 
:RET_SERVER(WideString[0],OUT)=<NULL> 
:RET_EVENTTIME(DateTime,OUT)=<NULL> Complete
  2015-09-23 11:21:05 AM 0.000 CommitRetaining:  Complete

But the GUI shows this:

[ViktorV]

Thank you for the information. We have reproduced the problem. We are investigating this behavior of UniDAC, and we will inform you about the results.