[FX.php List] Running a FM script from PHP/FX on more than one PC

[Chris Hansen]

John,

The answer is: yes, mostly =)

Basically, you can run THREE FileMaker scripts on each query that you perform:

1) PerformFMScriptPrefind($scriptName) - A script run here isn't run on the found set as there isn't one yet (so NO on this one);

2) PerformFMScriptPresort($scriptName) - This script is run after you have a found set, but before it is sorted (so YES here);

3) PerformFMScript($scriptName) - This is the main one that people use and runs just before data is returned (YES here too).

HTH

--Chris

On Jul 18, 2014, at 2:50 PM, csinfo <csinfo at criticalsolution.com> wrote:

> I have a script that runs from the windows command line of a client, it inserts data and processes the data to turn it into a job.
> Now my client wants a few PC to be able to run it but in initial tests, the scripts are stepping on each other and the Jobs are a mixture of data from multiple sources.
> Does anyone know if when I call a FileMaker script with FX, it will run on only the found set.?
> If so, I would do it flag records by a PC identifier and find them while running the script. 
> 
> Sample code:
> $request = new FX($ServerIP, $Port,$dataSourceType );
> $request->SetDBData($fmdb,$Layout, $Group);
> $request->SetDBUserPass($fmAccount, $fmPass);
> $request->AddDBParam( 'InUseBy', $InUseBy );   //$InUseBy = PC1..PC2..PC3 etc
> $request->AddDBParam('-script', 'FMScriptToRun' );
> 
> I will be testing this onsite but I thought some input is always helpful.
> John
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20140721/c2ec84dc/attachment-0001.html