VISOCO Software  Home | Products | Services | Download | Order | Support | Forum | Resources | Search | About
  RSS feedRSS Feed  FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups  RegisterRegister   ProfileProfile    Log inLog in 
Setting the cursor

 
Post new topic   Reply to topic    VISOCO Software Forum Index -> VISOCO dbExpress driver for Sybase ASE
Author Message
bmarinel



Joined: 03 Apr 2003
Posts: 18

PostPosted: Tue Mar 23, 2004 4:38 pm    Post subject: Setting the cursor Reply with quote

Hi,

I'm setting Screen.Cursor := crSQLWait in the TSQLStoredProc.BeforeOpen event handler. As soon as the stored procedure starts to execute, the cursor returns to the default cursor.

How do I prevent this from happneing? I want my user to know that the procedure is executing, and not just think the application is hung.

Thanks,

Bill
Back to top
View user's profile Send private message
Mat000



Joined: 04 Nov 2003
Posts: 12

PostPosted: Tue Apr 06, 2004 11:59 pm    Post subject: Reply with quote

Hi there,

it seems slightly strange, I tried to do the same.
There are two event handlers:
Code:
procedure TfMain.SQLStoredProc1BeforeOpen(DataSet: TDataSet);
begin
  Screen.Cursor := crSQLWait;
end;

procedure TfMain.SQLStoredProc1AfterOpen(DataSet: TDataSet);
begin
  Screen.Cursor := crDefault;
end;

When I open the stored proc...
Code:
SQLStoredProc1.Open;

... it really works. I'm using Delphi 7.

But I can't do the same, when the stored proc must be executed. I have to use something like:
Code:
Screen.Cursor := crSQLWait;
try
  SQLStoredProc1.ExecProc;
finally
  Screen.Cursor := crDefault;
end;
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    VISOCO Software Forum Index -> VISOCO dbExpress driver for Sybase ASE All times are GMT + 2 Hours
Page 1 of 1

 


©VISOCO Software. phpBB by phpBB Group