Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: llyrad atsituab
  Where is llyrad atsituab?
 Tacloban City
 Philippines
 llyrad atsituab
 To: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 Tags
Subject: RE: Passing Parameter
Thread ID: 373342 Message ID: 373346 # Views: 33 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Windows 7 and VFP
Date: Thursday, March 21, 2013 1:32:25 PM         
   


> > I want to simplify my SQL query and I'm planning to put my query in a program then view the data in the calling form but I don't know how to retrieve the data in my program like for ex.
> >
> > sample.prg
> >
> > TEXT TO SQLdata NOSHOW TEXTMERGE PRETEXT 7
> > The quick brown fox jumps over the lazy dog.
> > ENDTEXT 
> > 
> > RETURN SQLdata 
> > 

> >
> > sample.frm
> >
> > cmd1.click()
> > do sample.prg
> >
> >
> > Regards:
> > carbcoder_02
>
>
>
> IF NOT "SAMPLE.PRG" $ UPPER(SET("PROCEDURE"))
>    SET PROCEDURE TO Sample.PRG ADDITIVE
> ENDIF
> WAIT WINDOW Sample()
> 

> -----------------
> Borislav Borissov
>
> Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
> The only thing normal about database guys is their tables.

How will I be able to put it in sqlexec() function???

Regards:
carbcoder_02

ENTIRE THREAD

Passing Parameter Posted by llyrad atsituab @ 3/21/2013 1:17:32 PM
RE: Passing Parameter Posted by Borislav Borissov @ 3/21/2013 1:21:00 PM
RE: Passing Parameter Posted by llyrad atsituab @ 3/21/2013 1:32:25 PM
RE: Passing Parameter Posted by Borislav Borissov @ 3/21/2013 1:38:54 PM
RE: Passing Parameter Posted by llyrad atsituab @ 3/21/2013 1:55:10 PM
RE: Passing Parameter Posted by Cetin Basoz @ 3/21/2013 1:45:51 PM