!command to return a value

[benjoyner]

Can the !command be used to pass info from an external
program into a VFP variable or array? Any examples?

 

[MrFancyteeth]

I guess what you want to know is the success of the ! run (whether program has opened or not).

Looking at Foxpro help it doesn't appear to return a value.

If this is the issue I would probably use one the examples detailed in the FAQ section to cycle through open Window captions and look for the Application name.

mrF

 

[MrFancyteeth]

Sorry - forgot to add

why not use shellexecute? instead if ! run?

mrF

 

[benjoyner]

Thanks. I've used VFP in the past. A few years ago I moved
into Sybase SQL Anywhere under unix and developed data apps
using PHP under Apache. But now I need to move back to VFP
(7.0). I'm rusty.

I am unable to get an update via odbc to work properly in VFP (an insert works fine). So what I had in mind was to
pass the query to an external php script, and return its
results (yea/nay) back so I can tell if the query worked.

I would prefer to the the ODBC update to work properly.
e.g. I have a grid of a view, if the data is changed on the
grid, it 'looks' okay. But when I exit the form and reload
it, the data has not changed.