Additional
dbCAP
AnyDAC
ThinDAC
NCOCI8
Topic: Bug in MasterDetail
Bug in MasterDetail
Posted: 2007/05/17 05:54
 
Hello Diman!
Whan i'm get more than one parametr i detail query, then got exception:
EAssertionFailed
Assertion failure (c:softbds4.0libAnyDACSOURCEdaADDatSManager.pas, line 3593).

This exception is raised after master cursor is changed (more than once; after open detail query it's ok, scroll master -> exception).
Without MasterDetail relation everything works fine.
AnyDAC newest version...

regards,
Daniel Grabowski
Re:Bug in MasterDetail
Posted: 2007/05/17 07:58
 
Hello Daniel

I will appreciate, if you will send me small demo application. Best, if it will use AnyDAC ADDemo.mdb.

Regards,
Dmitry
Re:Bug in MasterDetail
Posted: 2007/05/17 08:02
 
OK, no problem, but... MS SQL in Norhwind database?
I got this exception on MSSQL2K...

Regards,
Daniel Grabowski
Re:Bug in MasterDetail
Posted: 2007/05/17 08:25
 
Hello Daniel

Ok, use MSSQL and Northwind.

Regards,
Dmitry
Re:Bug in MasterDetail
Posted: 2007/05/18 03:10
 
Hello Diman!

This exception only raised when detail query have IndexFieldNames <> '' and has >= 2 parameters and parameters type is uniqueidentifier and datetime.
Crazy? Crazy!

File "AnyDac Test script.sql" contains requireds objects and changes in northwind database.

regards,
Daniel Grabowski

Ps. test project in attachment MasterDetailBug.zip
File Attachment:
File name: MasterDetailBug.zip
File size:13039 bytes


Post edited by: wloochacz, at: 2007/05/18 03:11
Re:Bug in MasterDetail
Posted: 2007/05/18 07:56
 
Hello

Thank you and clear. I will fix that.
As workaround add ORDERDATE field to the q2.IndexFieldNames.

Regards,
Dmitry
Re:Bug in MasterDetail
Posted: 2007/05/18 08:08
 
Helllo!

I can't do that, because field (in my real application) OrderDate not in selected list... OrderDate is only parameter for stored procedure for detail query.

BTW - when i set IndexFieldNames for FieldName which field does not exist in dataset, then i got AV exception

Regards
Daniel Grabowski