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