Hi,

I have 2 queries which are linked to the VB Shell function:

I am using Shell function to execute a foxpro executable program.

The VB program code is as follows:
----------------------------------
:
:
:
RetVal = Shell("C:\ipo_funding\del_hld.exe", 6)

Set adoipo = New Connection

adoipo.ConnectionString = "Provider=MSDASQL.1;Persist Security
Info=False;Extended Properties=" & "Driver={Microsoft Visual FoxPro
Driver};UID=;SourceDB=C:
\ipo_funding\ipo.dbc;SourceType=DBC;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;"

adoipo.Open

mastagr.Open "select lonagrno, name11, acctno, add01, add02, add03, city01,
pin01, pin01, ophone01, mobno01, faxno01, rphone02, email01, dob1, add11,
add12, add13, city11, pin11, ophone11, rphone11, faxno11, mobno11, email11
from mastagr", adoipo

mastagr.Requery
:
:
:

The VFoxpro progrma code is as follows:
---------------------------------------
use c:\ipo_funding\holder1
delete all
pack

1. How do I capture the program's task id,
2. I want the VB program to halt execution till the time foxpro program
completes its execution.

Regards,
Lata M.



---
You are currently subscribed to pro_vb as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-pro_vb-$subst('Recip.MemberIDChar')@p2p.wrox.com