[OT] School for role confusion

2011-06-27 Thread Pete Theisen
Hi Everybody, http://www.heraldtribune.com/article/20110627/ARCHIVES/106271023/-1/todayspaper?Title=School-avoids-words-like-him-and-her- "STOCKHOLM - At the "Egalia" preschool, the staff members avoid using words like "him" or "her" and address the 33 child

[OT] What the libs really want for you - but not for them

2011-06-27 Thread Pete Theisen
Hi Everybody, Green, now - green I tell you . . . http://www.heraldtribune.com/article/20110627/ARCHIVES/106271041/-1/todayspaper?p=1&tc=pg Of course, Gorehole still has his SUV. Hypocrite. -- Regards, Pete http://pete-theisen.com/ http://elect-pete-theisen

Re: VFP automation

2011-06-27 Thread MB Software Solutions, LLC
On 6/26/2011 9:57 AM, Ted Roche wrote: > Sytze: > > Warning: Legacy knowledge follows, as my last significant VFP app dev > was in 2004. And we're very grateful that you've hung around to help since then! Kudos and special thanks to so many like you who still help despite VFP not being your reg

Re: passing vfp object as parameter to sql server

2011-06-27 Thread Stephen Russell
On Mon, Jun 27, 2011 at 8:48 AM, Rafael Copquin wrote: > Is it possible to pass a VFP 9 object as a parameter to a SQL Server > stored procedure? > > The idea is something like this: > > select mycursor > scatter name oMyCursor > > cCmd = [exec sp_mysp oMyCursor] > --- Not sure how this h

Re: passing vfp object as parameter to sql server

2011-06-27 Thread Rafael Copquin
Thank you both, Tracy and Ted. I'll read about passign XML Rafael El 27/06/2011 11:16, Tracy Pearson escribió: > Rafael Copquin wrote on 2011-06-27: >> Is it possible to pass a VFP 9 object as a parameter to a SQL Server >> stored procedure? >> >> The idea is something like this: >> >> s

Re: passing vfp object as parameter to sql server

2011-06-27 Thread Ted Roche
On Mon, Jun 27, 2011 at 9:48 AM, Rafael Copquin wrote: > Is it possible to pass a VFP 9 object as a parameter to a SQL Server > stored procedure? This is FoxPro. Everything is possible. Is it wise? No. You could, in theory, construct a DCOM (Distributed COM) object and matching server on the S

RE: passing vfp object as parameter to sql server

2011-06-27 Thread Tracy Pearson
Rafael Copquin wrote on 2011-06-27: > Is it possible to pass a VFP 9 object as a parameter to a SQL Server > stored procedure? > > The idea is something like this: > > select mycursor > scatter name oMyCursor > > cCmd = [exec sp_mysp oMyCursor] > > SQLExec(nHandle,cCmd) > > and g

Re: [NF] Questions on migrating VFP app

2011-06-27 Thread Grigore Dolghin
IMO, you succeeded proving your point. On Mon, Jun 27, 2011 at 4:13 PM, Stephen Russell wrote: > On Mon, Jun 27, 2011 at 6:56 AM, Grigore Dolghin wrote: >> Sorry, I pressed send to early. It also executes the select with Exec. >> So much about query optimizer, data exection plan, built-in >> sta

passing vfp object as parameter to sql server

2011-06-27 Thread Rafael Copquin
Is it possible to pass a VFP 9 object as a parameter to a SQL Server stored procedure? The idea is something like this: select mycursor scatter name oMyCursor cCmd = [exec sp_mysp oMyCursor] SQLExec(nHandle,cCmd) and get the SQL Server SP process all fields from the VFP cursor passed inside

Re: [NF] Questions on migrating VFP app

2011-06-27 Thread Stephen Russell
On Mon, Jun 27, 2011 at 6:56 AM, Grigore Dolghin wrote: > Sorry, I pressed send to early. It also executes the select with Exec. > So much about query optimizer, data exection plan, built-in > statistics. Frankly, if I'd be his boss I'd fire him ON THE SPOT. -- Plans are overrated

RE: Mulitple Table Browses in the in the Same FORM

2011-06-27 Thread Richard Kaye
Like Jerry mentioned, you can set up your tables with relations, assuming the data supports that, and create a grid, etc. But you can keep it relatively low tech and just use table.field notation in your BROWSE command (i.e. BROWSE FIELDS table1.column1, table3.column2, table2.column10, etc.). M

Re: [NF] Questions on migrating VFP app

2011-06-27 Thread Stephen Russell
On Mon, Jun 27, 2011 at 6:55 AM, Grigore Dolghin wrote: > I watched the video. While I agree that works, it still sucks. "DROP" > can be LEGIT data. I just don't understand why people avoid a built-in > fail-proof method readily available and use instead all sorts of > improvisations. WTF. What if

RE: VFP automation

2011-06-27 Thread Richard Kaye
GETOBJECT with the syntax you're using is supposed to retrieve a reference to an existing object. For example, you want to perform some kind of DOC manipulation and want to use a running instance of Word. If it can't find one, it returns an OLE error. Depending on what I'm trying to accomplish,

Re: [NF] Questions on migrating VFP app

2011-06-27 Thread Ed Leafe
On Jun 27, 2011, at 7:55 AM, Grigore Dolghin wrote: > I watched the video. While I agree that works, it still sucks. "DROP" > can be LEGIT data. I just don't understand why people avoid a built-in > fail-proof method readily available and use instead all sorts of > improvisations. WTF. What if @Fi

Re: [NF] Questions on migrating VFP app

2011-06-27 Thread Grigore Dolghin
Sorry, I pressed send to early. It also executes the select with Exec. So much about query optimizer, data exection plan, built-in statistics. Frankly, if I'd be his boss I'd fire him ON THE SPOT. On Mon, Jun 27, 2011 at 2:55 PM, Grigore Dolghin wrote: > I watched the video. While I agree that wo

Re: [NF] Questions on migrating VFP app

2011-06-27 Thread Grigore Dolghin
I watched the video. While I agree that works, it still sucks. "DROP" can be LEGIT data. I just don't understand why people avoid a built-in fail-proof method readily available and use instead all sorts of improvisations. WTF. What if @Filters is longer than 200 chars? On Mon, Jun 27, 2011 at 2:49

Re: [NF] Questions on migrating VFP app

2011-06-27 Thread Stephen Russell
On Sun, Jun 26, 2011 at 8:19 PM, Ken Dibble wrote: > >> > 2. Many search engines strip out punctuation of all kinds, and sometimes >> > even spaces, in user input, before submitting the search term to a query. >> > This is what Google does, in essence (though I'm sure they're much more >> > sophis

Re: FPW26 Freezing

2011-06-27 Thread Alan Bourke
We have some corporate machine inventory software (can't remember the name) that would do this with my FPW, until I killed the relevant process. -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com Subscription M