Bugs on update status (for delete action) and function table

[youq]

I used
Development tool = Delphi 7
Database = Ms SQL 2000
ZeosDBO(patch 2) = TZQuery with TZUpdateSQL and property CachedUpdates is True


bug #1.
Action : Delete 1 row in the Grid component
The result always False when i used my function ("DSState") after delete action. the syntax of function "DSState" is :

Code: Select all

 Delphi
        function DSState(vDataSet:TDataSet):boolean;
        begin
           result:=(vDataSet.State in [dsInsert,dsEdit])or                                    (vDataSet.UpdateStatus in [usModified,usInserted,usDeleted])  
        end; 
     

bug #2.
Action : Open function table (on MSSQL 2000) with parameter. the syntax of function is :

Code: Select all

 Ms SQL 2000
         Create function Tbl_Transaction (@periode char(6))
         returns table
         as return(select a.* from dbo.T_Transaction a 
                       where a.periode = :@periode)
     

Syntax SQL in TZQuery is :

Code: Select all

Select * from dbo.tbl_transaction('042006')

When get Persisten(Fields description) the result is :
Use ZeosDBO v6.1 : Erorr first ("Row data is not availlable") then not
Use ZeosDBO v6.5 : Always Erorr ("Row data is not availlable")

That is. Please help me ok...javascript:emoticon(':(')
Sad

i love u gays...