Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 To: llyrad atsituab
  Where is llyrad atsituab?
 Tacloban City
 Philippines
 llyrad atsituab
 Tags
Subject: RE: Passing Parameter
Thread ID: 373342 Message ID: 373350 # Views: 48 # Ratings: 2
Version: Visual FoxPro 9 SP2 Category: Windows 7 and VFP
Date: Thursday, March 21, 2013 1:45:51 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

local lcSQL
lcSQL = sample()
SQLExec(_Screen.sql_connection,m.lcSQL,'sample_cursor')


Or simpler:

SQLExec(_Screen.sql_connection, sample(),'sample_cursor')





Cetin Basoz

.Net has got better.Think about moving - check my blog:
My Blog


MongoDb Certified Developer
MongoDb Certified DBA


Support Wikipedia

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