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
 Tags
Subject: Passing Parameter
Thread ID: 373342 Message ID: 373342 # Views: 41 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Windows 7 and VFP
Date: Thursday, March 21, 2013 1:17:32 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

if the value is returned in the calling form I will use the SQLExec() function to put the SQLdata in my cursor.

SQLExec(_Screen.sql_connection,SQLData,[sample_cursor])


I hope this is possible,I've already than this in my php program so I'm inspired to implement this concept in vfp..

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