Nothing easy nor reliable. You're better off putting up some eye candy that just shows that the app is not hung up.
-Mike
>I am working on a VB 6 interface that works with a SQL 2000 back end to perform a data import from a legacy system. I am using VB DTS files and SQL 2000 Stored Procedures to process each incoming table. The interface has a type of progress indicator for the user that uses total number of records and number of records imported to display the progress bar.
>
>I know that stored procedures can return values to calling stored procedures [return(integer)] but, is there any way VB can get an integer back from a stored procedure so that I can update the progress bar?
>
>VB Calling Code:
>
>
>QueryString = "EXECUTE " & strImportSp
>cnImport.Execute(QueryString)
>
>
>Thank for your help
>Rhonda