Zeoslib Portal

Posted: **28.04.2006, 20:49**

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...

Zeoslib Portal

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

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