fpsql

Nancy Palmquist nlp at vss3.com
Fri Oct 26 11:11:05 PDT 2007


Richard Kreiss wrote:
> I've been playing with fpsql and thought someone might have an answer before
> I try this.
> 
> Will a query except an environmental variable in the form of %value%.
> 
> This would make it easier to build a query which would take a variable from
> a clerk input and then run it.
> 
> Now I'll grant that using fp's i/o functions the query could be built on the
> fly.  An interesting project.
> 
> Richard Kreiss
> GCC Consulting
>  
> 
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
> 
> 
Richard,

You could run the fpsql from a system command in another filePro 
session.  Then you can ask all the questions.  Write the answer to a 
selection table and then run the query from a command like selecting 
that selection set.

I played with this to offer some security and access protection for the 
Medical Office system.  It worked well.

Nancy


-- 
Nancy Palmquist 		MOS & filePro Training Available
Virtual Software Systems	Web Based Training and Consulting	
PHONE: (412) 835-9417		   Web site:  http://www.vss3.com


More information about the Filepro-list mailing list