hi
Could someone please help me in following:
I need to update Policy status baseupon commencement date and then print
with new Policy status.
I written a stored procedure to update the policy.
Now I need to work out how I can print a report. We already doing the
report manuall in our VB6 program but this is automatic process. So no
users involue here. It would change the status by running the stored
procedure and then print the report.
Would it be possible execute the VB6 program via stored procedure?
Would it be possible SQL 2000 produce a report?
We used active-x dll in our VB6 program, is it any way can call dll file
via stored procedure?
thank you.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Have your VB program call the stored procedure and print out the
results. If you need it to run automatically you can put it on the
Windows Task Scheduler or set it as a Job in SQL Agent.

On 10 Sep 2003 15:52:15 GMT, Khalid Hussain
<khalid.hussain@pinnacle.co.uk> wrote:

>hi
>Could someone please help me in following:
>I need to update Policy status baseupon commencement date and then print
>with new Policy status.
>I written a stored procedure to update the policy.
>Now I need to work out how I can print a report. We already doing the
>report manuall in our VB6 program but this is automatic process. So no
>users involue here. It would change the status by running the stored
>procedure and then print the report.
>Would it be possible execute the VB6 program via stored procedure?
>Would it be possible SQL 2000 produce a report?
>We used active-x dll in our VB6 program, is it any way can call dll file
>via stored procedure?
>thank you.
>
>*** Sent via Developersdex http://www.developersdex.com ***
>Don't just participate in USENET...get rewarded for it!