Antw: Macro Substitution using object/property in SQL

2009-04-03 Thread Joerg Arand
hi Henry, try goapp.cFilterVisibility = 'Gender = 1' lcWhere=goapp.cFilterVisibility Select ... WHERE something And lcWhere The point in goapp.cFilterVisibility finishs the macro substitition VFP trys to substitiut ohnly goapp! Joerg Arand MD assistant medical director Neonatology

[OT] Budget passes Senate $3.53 Trillion

2009-04-03 Thread Pete Theisen
Hi Everybody! http://www.cnn.com/2009/POLITICS/04/03/us.house.senate.budget.passes/ Looks like a couple of Rs just didn't vote or didn't attend the session in the Senate. 55 - 43. OK, that Saturday Night Live comic isn't seated yet and ... Numbers still don't add up. Article claims that

[OT] We're getting $13 a week?

2009-04-03 Thread Pete Theisen
Hi Everybody! http://www.cnn.com/2009/POLITICS/02/17/cafferty.stimulus/index.html Three and a half gallons of gas, or the newspaper every day and a movie at the cheap screen. -- Regards, Pete http://pete-theisen.com/ http://elect-pete-theisen.com/

[OT] Stimulus checks? No.

2009-04-03 Thread Pete Theisen
Hi Everybody! http://www.wcpo.com/content/news/localshows/dontwasteyourmoney/story/2nd-Stimulus-Coming-How-Much-Youll-Receive/R4nbdsyILUWNMd_q1i9CFQ.cspx or http://tinyurl.com/amxaqk Most economists say last year's checks were just a temporary sugar rush, and did little to stave off the

Re: [NF] Dabo video from PyCon 2009 posted

2009-04-03 Thread Pete Theisen
Ed Leafe wrote: The Dabo video is available at: http://pycon.blip.tv/file/1947542/ Hi Ed! There is no Dabo on Synaptic, and I included ALL the repositories in the search. I am not primarily a geek, and I have only one computer. Before I try to install this by hand I sort-of want to

[OT] Obama Bows to Saudi King

2009-04-03 Thread Bob Calco
http://bit.ly/28hpF3 - - - President Obama greeted the king of Saudi Arabia with a full bow from the waist yesterday, a move one commentator described as a violation of protocol and not worthy of the office he holds. I am quite certain that this is not the protocol, and is most unbecoming a

RE: Microsoft release hotfix for report data group bug!

2009-04-03 Thread Jim Harvey
Hi Cathy, Thanks for the info. I downloaded the hot fix, unzipped it in a temporary folder I created for this purpose, and it extracts the file VFP9SP2-HOTFIX-968409.exe. Will this install properly if I run this file from the temp folder I created, or do I need to move it somewhere first? TIA

RE: Macro Substitution using object/property in SQL

2009-04-03 Thread henry.dagher
No, goapp is never out of scope, 'x' is, unless it is PUBLIC. The only problem with goapp is that the seems to choke on the '.' in goapp.cFilterVisibility. Henry -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell

RE: Macro Substitution using object/property in SQL

2009-04-03 Thread henry.dagher
That is correct, Tracy ;-) Henry -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tracy Pearson Sent: 2009-04-02 10:18 PM To: profoxt...@leafe.com Subject: Re: Macro Substitution using object/property in SQL No the local variable

RE: Antw: Macro Substitution using object/property in SQL

2009-04-03 Thread henry.dagher
Hi Joerg, I have tried this. My problem is that lcWhere does not exist when the view is called later. To clarify to all: All my views are pre-defined in the DBC. I simply add them in the DE of forms when I need them. So, lcWhere would exist at the creation time of the DBC but when you

Re: Macro Substitution using object/property in SQL

2009-04-03 Thread Stephen Russell
On Thu, Apr 2, 2009 at 9:18 PM, Tracy Pearson tr...@powerchurch.com wrote: No the local variable would. From what I gathered goapp.cFilterVisibility = field = value. - I think that I got burned by this before. That is exactly how the statement is

Re: Macro Substitution using object/property in SQL

2009-04-03 Thread Gianni Turri
Hi Henry, I think that there is a big mistake in the initial concept: even if you resolve the problem with your macro, when you first create you view that macro is immediately expanded and saved in the view in the already expanded form. The next time you use your view it is not parameterized

Re: Connecting To MySql

2009-04-03 Thread Stephen Russell
On Thu, Apr 2, 2009 at 9:47 PM, MB Software Solutions General Account This is what I love about using MySQL with VFP...I can develop locally no matter if I'm online/connected or not, and then when done in my dev environment, I just changed the connection string and that's it...that along with

RE: MySql Insert fro VFP9

2009-04-03 Thread W.N. Pew
Michael, Thanks very much. The code worked flawlessly. I haven't tried a date yet but I have no doubt it will work. Very nice solution. Thanks, again! Bill -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions

RE: [OT] Obama Bows to Saudi King

2009-04-03 Thread Adam Buckland
Like the Thinker would ever publish a positive or neutral story on Obama when it can try and smear him. -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Bob Calco Sent: 03 April 2009 12:37 To: 'ProFox Email List' Subject: [OT] Obama Bows

RE: Antw: Macro Substitution using object/property in SQL

2009-04-03 Thread Eurico Chagas Filho
Hi I create my views everytime they are needed in a Form, they are removed upon exit, that's not messy. And they are created in the local disk. The parameter ?whatever, works very well. If I need a macro substitution in a view, it means I need to create it in that place everytime, like in a

RE: Antw: Macro Substitution using object/property in SQL

2009-04-03 Thread Tracy Pearson
Do you get local DBC bloat doing that? -Original Message- From: Eurico Chagas Filho Sent: Friday, April 03, 2009 11:02 AM Hi I create my views everytime they are needed in a Form, they are removed upon exit, that's not messy. And they are created in the local disk. The parameter

Re: [OT] Obama Bows to Saudi King

2009-04-03 Thread Leland F. Jackson, CPA
HaHaaHaaaha. I had to laugh we I read the article. LOL. The American Thinker, and most of the articles it publishes, are way out there . . . Regards, LelandJ Bob Calco wrote: http://bit.ly/28hpF3 - - - President Obama greeted the king of Saudi Arabia with a full bow from the waist

Re: [OT] Obama Bows to Saudi King

2009-04-03 Thread Leland F. Jackson, CPA
Whoops, I should have said: I had to laugh when I read the article. Regards, LelandJ Leland F. Jackson, CPA wrote: HaHaaHaaaha. I had to laugh we I read the article. LOL. The American Thinker, and most of the articles it publishes, are way out there . . . Regards, LelandJ Bob

Re: [OT] Obama Bows to Saudi King

2009-04-03 Thread Nicholas Geti
You are easily amused. - Original Message - From: Leland F. Jackson, CPA lela...@mail.smvfp.com To: ProFox Email List profox@leafe.com Sent: Friday, April 03, 2009 11:09 AM Subject: Re: [OT] Obama Bows to Saudi King Whoops, I should have said: I had to laugh when I read the

Re: [OT] Obama Bows to Saudi King

2009-04-03 Thread Leland F. Jackson, CPA
Nicholas Geti wrote: You are easily amused. I found the article phony to the point of being ridiculously hilarious, even considering the slanted nature of The American Thinker, which is a contradiction in terms, if you ask me. Bob Unruh, who wrote the article, ties to outrage the reader

Different SQL Select results from Command line versus an application

2009-04-03 Thread Joe Yoder
I have a .prg with an SQl select statement that builds a table from several others. When I run the .prg from the command line, the output table has the expected data in all fields. When my application calls the same .prg either as an application or as an executable, one of the fields in the

RE: Different SQL Select results from Command line versus an application

2009-04-03 Thread Tracy Pearson
Different Data Source In the DBF world, a corrupt index could be the culprit. -Original Message- From: Joe Yoder Sent: Friday, April 03, 2009 2:58 PM I have a .prg with an SQl select statement that builds a table from several others. When I run the .prg from the command line, the

Re: Microsoft release hotfix for report data group bug!

2009-04-03 Thread Paul McNett
Jim Harvey wrote: I downloaded the hot fix, unzipped it in a temporary folder I created for this purpose, and it extracts the file VFP9SP2-HOTFIX-968409.exe. Will this install properly if I run this file from the temp folder I created, or do I need to move it somewhere first? Why don't you

RE: Microsoft release hotfix for report data group bug!

2009-04-03 Thread Jim Harvey
I was hoping someone else would have paved the way. James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Paul

RE: Different SQL Select results from Command line versus an application

2009-04-03 Thread Joe Yoder
In my case everything is a free table at least I assume it is. I am doing a custom report on data from a system that was done in VFP where the developers tried to mask the fact that it uses VFP tables. (They use a .udb extension but left the .cdx extension alone.) All I needed to do was use

RE: [NF] videos on flash drives

2009-04-03 Thread Tracy Pearson
Depends on the size of the file, and the read speed of the USB stick. Each stick will have different results due to how the data is on the device. Tracy -Original Message- From: Jim Harvey Sent: Friday, April 03, 2009 4:32 PM Is it possible to play flash videos (.flv) from a USB memory

RE: [NF] videos on flash drives

2009-04-03 Thread Jim Harvey
Thanks, sounds reasonable. Another quick question, do I need a player installed on my desktop to view a flash video file stored on a web server that is running Flash Media Server software? James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766

RE: Different SQL Select results from Command line versus an application

2009-04-03 Thread Tracy Pearson
The Path environment setting. Data accidently included in the compiled APP/EXE. To tell if the UDB's are free tables. Visually you can see: When you use one of the UDB files in the IDE. There is a drop down combobox on the standard toolbar. It would be enabled and have the DBC name if it

RE: [NF] videos on flash drives

2009-04-03 Thread Tracy Pearson
There are SWFs that will play FLV files inside a web browser. I believe there are a few players that can be run from a Flash drive that can play FLV files. -Original Message- From: Jim Harvey Sent: Friday, April 03, 2009 5:02 PM Another quick question, do I need a player installed on my

[OT] We Are All Comrades Now

2009-04-03 Thread Bob Calco
http://bit.ly/pQJ0 - - - The pair also discussed thorny issues including NATO's eastwards expansion, long opposed by Moscow which sees it as a power-grab by the West's former Cold War-era military bloc into former Soviet territory. Yesterday I spoke about this with my new comrade President

RE: Microsoft release hotfix for report data group bug!

2009-04-03 Thread Rick Schummer
Yes, it has been awhile since I ran the install, but I am fairly certain it will install properly from any folder. Rick White Light Computing, Inc. www.whitelightcomputing.com www.swfox.net www.rickschummer.com -Original Message- From: profoxtech-boun...@leafe.com

Re: [NF] videos on flash drives

2009-04-03 Thread Vince Teachout
Tracy Pearson wrote: There are SWFs that will play FLV files inside a web browser. I believe there are a few players that can be run from a Flash drive that can play FLV files. The VideoLan player has a flash drive version, and it plays flv. See www.portableapps.com

Re: [OT] Obama Bows to Saudi King

2009-04-03 Thread Ricardo Aráoz
Nicholas Geti wrote: You are easily amused. - Original Message - From: Leland F. Jackson, CPA lela...@mail.smvfp.com To: ProFox Email List profox@leafe.com Sent: Friday, April 03, 2009 11:09 AM Subject: Re: [OT] Obama Bows to Saudi King Whoops, I should have said: I had

Re: [OT] We Are All Comrades Now

2009-04-03 Thread Ricardo Aráoz
Bob Calco wrote: http://bit.ly/pQJ0 - - - The pair also discussed thorny issues including NATO's eastwards expansion, long opposed by Moscow which sees it as a power-grab by the West's former Cold War-era military bloc into former Soviet territory. Yesterday I spoke about this with my new

Focus and Messagebox

2009-04-03 Thread Jeff Johnson
I have a text box that validates the data entered and if the data is invalid a messagebox pops up. If they say Ok to continue then it should move focus to the next textbox. If they say No then focus should remain on the current textbox. I have this code in the lostfocus of the textbox. It

Re: Focus and Messagebox

2009-04-03 Thread Tracy Pearson
Shouldn't that be called in the Valid event? Then it will return 0/.F. to prevent loss focus. 1/.T. to go to the next focusable object. Tracy Jeff Johnson wrote: I have a text box that validates the data entered and if the data is invalid a messagebox pops up. If they say Ok to continue

Re: Focus and Messagebox

2009-04-03 Thread Tracy Pearson
Just for completeness: Returning 0 in the Valid doesn't show the Wait Window, where .F. does. Tracy Jeff Johnson wrote: That works but you get an invalid input wait window which doesn't make sense. I use the lostfocus all the time, but not usually with a messagebox. Jeff Jeff Johnson

RE: Different SQL Select results from Command line versus an application

2009-04-03 Thread Joe Yoder
? set('path') reported nothing. ?ADATABASES() reported 0. I finally had the system rebuild it's indexes now everything seems solid so I guess you were right but I still don't understand it! Thanks - Joe On Friday, April 03, 2009 3:59 PM, Tracy Pearson wrote: Date: Fri, 3 Apr 2009 15:59:41

Re: Focus and Messagebox

2009-04-03 Thread Jeff Johnson
Now that's what I'm talking about!! Thanks Tracy. It's been a long time since I used that technique. Jeff Jeff Johnson j...@san-dc.com SanDC, Inc. 623-582-0323 Fax 623-869-0675 Tracy Pearson wrote: Just for completeness: Returning 0 in the Valid doesn't show the Wait Window, where .F.

Re: Focus and Messagebox

2009-04-03 Thread Jeff Johnson
The original technique works with a modeless form while it doesn't work with a modal form. That makes sense though. Jeff Jeff Johnson j...@san-dc.com SanDC, Inc. 623-582-0323 Fax 623-869-0675 Jeff Johnson wrote: Now that's what I'm talking about!! Thanks Tracy. It's been a long time

[OT] Obama Voter trapped in car

2009-04-03 Thread Michael Madigan
http://www.chron.com/disp/story.mpl/bizarre/6354195.html * Join the OBAMA RESISTANCE MOVEMENT! http://www.cafepress.com/rightwingmike/6181419 ___ Post Messages to: ProFox@leafe.com Subscription

[OT] Attention Homosexuals - Move to Iowa to get married.

2009-04-03 Thread Michael Madigan
http://www.desmoinesregister.com/article/20090403/NEWS/90403010 * Join the OBAMA RESISTANCE MOVEMENT! http://www.cafepress.com/rightwingmike/6181419 ___ Post Messages to: ProFox@leafe.com Subscription