RE: [OT] Obama Tax Pledge Up In Smoke

2009-04-02 Thread Adam Buckland
As an ex smoker... great, if you can't afford to smoke, give up. -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Bob Calco Sent: 02 April 2009 00:20 To: 'ProFox Email List' Subject: [OT] Obama Tax Pledge Up In Smoke http://bit.ly/2QP2cg

RE: [OT] Obama Foobars First Stop On European Trip

2009-04-02 Thread Adam Buckland
Three points... He has to do most of his work while America is asleep - If he's in the UK then it's the UK's even and even he has to work according to the UK's timezone, not the US's Parenthetically: he gave the queen an iPod. - Very bad research, she already has one and has for a few years.

Re: [OT] Obama Foobars First Stop On European Trip

2009-04-02 Thread Pete Theisen
Adam Buckland wrote: Parenthetically: he gave the queen an iPod. - Very bad research, she already has one and has for a few years. Brown DVDs as a present - due to regional coding they won't play in the UK's DVD players anyway! Hi Adam! I would have given them each presentation grade

Re: [OT] Obama Foobars First Stop On European Trip

2009-04-02 Thread Pete Theisen
Pete Theisen wrote: I would have given them each presentation grade handguns. custom engraved for the occasion. Something they can't get in the UK, and one-of-a-kind with the historic engraving. Would have cost less than one of Michelle's gowns.

Re: [NF] - Arf!

2009-04-02 Thread Alan Bourke
baddumm-tish! I'm here till Friday, try the fish. On Thu, 02 Apr 2009 11:24 +0100, Adam Buckland adam.buckl...@eurohill.com wrote: UK Students Die In Safari Crash I bet they wished they'd just stuck with Internet Explorer now. --- StripMime Report -- processed MIME parts ---

RE: Connecting To MySql

2009-04-02 Thread Richard Kaye
Per Rick's comment, see if you can telnet to the remote server on the MySQL port. If you don't get a response, it's most likely a firewall issue. Richard Kaye -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions

[OT] NOW they tell us

2009-04-02 Thread Pete Theisen
Hi Everybody! http://www.nytimes.com/2009/04/02/us/politics/02stevens.html?ref=us The application to throw out the conviction of Mr. Stevens will almost certainly be ratified by the court at a hearing scheduled for next Tuesday. But it will do nothing to undo the loss of his Senate seat.

RE: [OT] NOW they tell us

2009-04-02 Thread Bob Calco
The Democrats staged the most elaborate---and successful---bloodless coup ever attempted by electoral means last year. On every level, with uncanny coordination, determination and manipulation, whether rifling through Joe the Plumber's private files, or manufacturing a phoney scandal about

[NF] Top 10 list for the next 10 years

2009-04-02 Thread Stephen Russell
http://blogs.techrepublic.com.com/10things/?p=643 Even though it was released yesterday I don't think it's an April Fools piece. -- Stephen Russell Sr. Production Systems Programmer Web and Windows Development Independent Contractor Memphis TN 901.246-0159

Object Member Removed - Cannot complete the save

2009-04-02 Thread Cathy Pountney
I've gotten this strange error a few times over the last week and I'm baffled. I'm working on a form and I'll make some changes, run the app and test it, make some more changes, test it, and continue in this manner. When the error happens I have the form open, I have made some changes, and I

RE: Object Member Removed - Cannot complete the save

2009-04-02 Thread Tracy Pearson
Do you have another container class of the same name in a different class library? Remembering Christof's Dark Side talk at SWFox, it might have to do with how the base class is stored in memory and it's template is copied when instantiated or edited. The base template might be getting corrupt.

Save fails sometimes Vfp9 Sp1

2009-04-02 Thread Ajoy Khaund
Hi All, I am using a view in a form for a order entry screen. The form works fine but sometimes a 'Save' of the view fails. Then the view is rebuilt the 'Save' works again. I cannot reproduce it. Should I close and open the view when user clicks on the 'Add' button. TIA Regards Ajoy Khaund

RE: Object Member Removed - Cannot complete the save

2009-04-02 Thread Cathy Pountney
Hmmm ... interesting concept to explore. I have three new classes .. that are all very similar and have objects with the same name within them. The form has a few instances of each of those classes. Maybe the fact that Class A has object txtName .. and Class B has object txtName .. and Class A is

RE: Object Member Removed - Cannot complete the save

2009-04-02 Thread Tracy Pearson
Do you run your testing in the same VFP session as you are coding? I'm curious because that might have some affect on the memory I referred to. I changed to have a separate VFP IDE open to run testing. It doesn't allow for setting break points in the code session, but there are ways to find a near

RE: Save fails sometimes Vfp9 Sp1

2009-04-02 Thread Rick Schummer
The form works fine but sometimes a 'Save' of the view fails. Have you checked the result of the TABLEUPDATE() to see if it fails, and then check AERROR() to see what the internal reason is? Sounds like you have a data conflict. Rick White Light Computing, Inc. www.whitelightcomputing.com

[NF] 3 biggest lies we tell as developers

2009-04-02 Thread Stephen Russell
3 Biggest Software Lies I ran across the following quote today and thought it was pretty funny… 3 Biggest Software Lies: 1. The program’s fully tested and bug-free 2. We’re working on the documentation 3. Of course we can modify it! Do you have any other items to add

Re: [NF] 3 biggest lies we tell as developers

2009-04-02 Thread mike
At my work we have self checkout and every now and then it will either count to ten in spanish or say uh-oh. When i asked my boss about this she said that it's not a bug, its a feature! Let me say I was laughing my ass off for the rest of the day! Mike Sent from my Verizon Wireless BlackBerry

RE: Object Member Removed - Cannot complete the save

2009-04-02 Thread Eurico Chagas Filho
I have a setup with two computers with VFP 9.2 one has all the files. The other computer has only the project file, but it refers everything to the first computer. It happens the same to me everytime if I try to change anything in a class, using the second computer, only with classes. HTH, E.

Re: Save fails sometimes Vfp9 Sp1

2009-04-02 Thread Ajoy Khaund
Thankz. Since it does not happen always and I cant reproduce it how do I trap the error and save it to somewhere. Regards Ajoy Khaund Neamati Road Near Bhogdoi Bridge Jorhat 785001-21 Assam, India Tel: 91-376-2351288 Cell: 91-94350-92287 Mail: akha...@hotmail.com Mail: akha...@gmail.com

RE: [NF] 3 biggest lies we tell as developers

2009-04-02 Thread Gil Hale RR
Item 0 (tops the list), All you have to do is... Item 4, This won't take but about 2 weeks. Item 5, It will be done by (name month 4 weeks out, neglect to say you meant next year in said month)... Gil -Original Message- From: profoxtech-boun...@leafe.com

RE: [NF] 3 biggest lies we tell as developers

2009-04-02 Thread Adam Buckland
The user interface was designed with the user, they wanted all the menus arranged alphabetically Nah, it's just coincidence that your password is moron-dickhead Sure it's only a small change -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf

Re: [NF] 3 biggest lies we tell as developers

2009-04-02 Thread Bill Anderson
On Thu, Apr 2, 2009 at 8:41 AM, Stephen Russell srussell...@gmail.comwrote: 3 Biggest Software Lies I ran across the following quote today and thought it was pretty funny… 3 Biggest Software Lies: 1. The program’s fully tested and bug-free 2. We’re working on the

Re: [NF] 3 biggest lies we tell as developers

2009-04-02 Thread mike
Wheres items 1, 2, 3 on your list? Sent from my Verizon Wireless BlackBerry -Original Message- From: Gil Hale RR mrgmh...@rochester.rr.com Date: Thu, 2 Apr 2009 12:01:41 To: profoxt...@leafe.com Subject: RE: [NF] 3 biggest lies we tell as developers Item 0 (tops the list), All you

Doing a code audit

2009-04-02 Thread Casey McGuire
This procedure is used once or twice a month. On the day that it does get used it can be run multiple times that day with the procedure taking at least a few minutes to complete. The procedure can only be ran by a single user at a time The procedure updates a table that is indexed on a

RE: [NF] 3 biggest lies we tell as developers

2009-04-02 Thread Gil Hale RR
You provided 1, 2, 3 already. I did not ant to trounce your list! Gil -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com]on Behalf Of m...@mikewohlrab.com Sent: Thursday, April 02, 2009 12:44 PM To: profoxt...@leafe.com Subject: Re: [NF] 3

Re: [NF] 3 biggest lies we tell as developers

2009-04-02 Thread MB Software Solutions General Account
m...@mikewohlrab.com wrote: Wheres items 1, 2, 3 on your list? Sent from my Verizon Wireless BlackBerry -Original Message- From: Gil Hale RR mrgmh...@rochester.rr.com Date: Thu, 2 Apr 2009 12:01:41 To: profoxt...@leafe.com Subject: RE: [NF] 3 biggest lies we tell as developers

Re: Save fails sometimes Vfp9 Sp1

2009-04-02 Thread MB Software Solutions General Account
Rick Schummer wrote: The form works fine but sometimes a 'Save' of the view fails. Have you checked the result of the TABLEUPDATE() to see if it fails, and then check AERROR() to see what the internal reason is? Sounds like you have a data conflict. Agreedwhat's your WhereType for the

Re: [NF] 3 biggest lies we tell as developers

2009-04-02 Thread mike
The customer asks you about the random program crashes so you tell them it is a bonus feature you built into the software! Mike Sent from my Verizon Wireless BlackBerry -Original Message- From: Bill Anderson billan...@gmail.com Date: Thu, 2 Apr 2009 09:28:37 To: profoxt...@leafe.com

Re: Save fails sometimes Vfp9 Sp1

2009-04-02 Thread Ajoy Khaund
SELECT Lineitems.seq, Lineitems.prodname, Lineitems.orderqty, Lineitems.punit, Lineitems.unitprice, Lineitems.taxrate, Lineitems.ordertax, Lineitems.orderprice, Lineitems.linecost, Lineitems.remarks, Lineitems.recdqty, Lineitems.orderdisc, Lineitems.others, Lineitems.productid,

Re: Save fails sometimes Vfp9 Sp1

2009-04-02 Thread Ajoy Khaund
Sorry its key modified fields Regards Ajoy Khaund Neamati Road Near Bhogdoi Bridge Jorhat 785001-21 Assam, India Tel: 91-376-2351288 Cell: 91-94350-92287 Mail: akha...@hotmail.com Mail: akha...@gmail.com Walking on water and developing software from a specification are easy if both are

RE: Save fails sometimes Vfp9 Sp1

2009-04-02 Thread Rick Schummer
Since it does not happen always and I cant reproduce it how do I trap the error and save it to somewhere. If you cannot reproduce the problem, it likely is a data conflict as I mentioned, but it could be a different bug. I already told you how to determine the problem (check the tableupdate and

[OT] Diplomatic gifts limited to tokens anyway?

2009-04-02 Thread Pete Theisen
Hi Everybody! Interesting notes on how Reagan had to skirt the regs to avoid turning down a couple of horses from King Fahd. If you offer a gift you want it accepted, right? Maybe B-man had to limit himself to DVD/Ipod like gifts? What are the British regs on gifts?

Re: Save fails sometimes Vfp9 Sp1

2009-04-02 Thread Ajoy Khaund
App is single user. Fields of Parent 'Orders' table is on the form. The child records are displayed in a view. On 'Add' or 'Edit' to child records a form appears where productid, qty, remarks etc are written saved. Now sometimes after 'Save' when the form closes the record does not appear in

[NF] Dabo video from PyCon 2009 posted

2009-04-02 Thread Ed Leafe
Due to the fantastic efforts our very own Carl Karsten, the videos from PyCon 2009 have been posted. They did an amazing job with the A/ V, recording directly from multiple cameras as well as the video output of the presenter's laptop. The general URL for all the PyCon videos

Macro Substitution using object/property in SQL

2009-04-02 Thread henry.dagher
Hi all, I use this SQL to create a local view (VFP 9). I need to apply a global filter (say, to limit results to gender = 1) goapp.cFilterVisibility = 'Gender = 1' Select ... WHERE something And goapp.cFilterVisibility This is generating an error (Missing Operand) I've tried Select ...

RE: [NF] Dabo video from PyCon 2009 posted

2009-04-02 Thread Tracy Pearson
I saw an email less than an hour ago. Those videos have already been hit over 10,000 times. -Original Message- From: Ed Leafe Sent: Thursday, April 02, 2009 1:41 PM Due to the fantastic efforts our very own Carl Karsten, the videos from PyCon 2009 have been posted. They did an

RE: Macro Substitution using object/property in SQL

2009-04-02 Thread Tracy Pearson
You are unable to macro substitute an object or cursor. You'll need to put the goapp.cFilterVisibility value into a temp var. tmpAnd = goapp.cFilterVisibility Select ... WHERE something And tmpAnd. But, have you tried Select ... WHERE something And (goapp.cFilterVisibility) -Original

RE: [NF] 3 biggest lies we tell as developers

2009-04-02 Thread Gil Hale RR
I have my machines running so safely they won't run at all! heh-heh -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com]on Behalf Of m...@mikewohlrab.com Sent: Thursday, April 02, 2009 12:59 PM To: profoxt...@leafe.com Subject: Re: [NF] 3

RE: Macro Substitution using object/property in SQL

2009-04-02 Thread henry.dagher
Hi Tracy, Thanks for your reply. (goapp.cFilterVisibility) gives 'Function argument value, type...' As for x = goapp.cFilterVisibility and using x, the problem is that x will not exist later when the view needs to be instantiated. Obviously, I could resort to PUBLIC vars but I've been

RE: Macro Substitution using object/property in SQL

2009-04-02 Thread Tracy Pearson
Henry To work around that you need to macro the sql statement as a whole. tmpSQL = SELECT ... AND + goApp.cFilterVisibility tmpSQL. The drawback is if you change cFilterVisibility after it doesn't update. Have you tried SELECT ... AND goApp.mFilterVisibility() Where

RE: Save fails sometimes Vfp9 Sp1

2009-04-02 Thread Rick Schummer
Your app might be used by a single user, but the app can be effectively multiuser with private datasessions and two instances of the same form or different forms with the same data. The Key and Modified will return a data conflict if the same record is edited in two forms. What happens is each

Re: [NF] 3 biggest lies we tell as developers

2009-04-02 Thread Michael Madigan
how about Sure my program will run on a Pentium 3 running windows 98. --- On Thu, 4/2/09, Stephen Russell srussell...@gmail.com wrote: From: Stephen Russell srussell...@gmail.com Subject: [NF] 3 biggest lies we tell as developers To: ProFox Email List profox@leafe.com Date: Thursday,

Re: [NF] 3 biggest lies we tell as developers

2009-04-02 Thread Michael Madigan
how about Sure my program will run on a Pentium 3 running windows 98. --- On Thu, 4/2/09, Stephen Russell srussell...@gmail.com wrote: From: Stephen Russell srussell...@gmail.com Subject: [NF] 3 biggest lies we tell as developers To: ProFox Email List profox@leafe.com Date: Thursday,

RE: Macro Substitution using object/property in SQL

2009-04-02 Thread henry.dagher
Actually, goApp.mFilterVisibility() would be a much cleaner solution as it would get the latest state of the filter chosen by the user. Are you saying it would NOT try to execute it once per record handled in the SQL statement (and therefore slow things down)? That was my initial fear. My

RE: Macro Substitution using object/property in SQL

2009-04-02 Thread Tracy Pearson
I don't recall if I've actually put this type of behavior into a test scenario. Perhaps someone else on the list has and could chime in. Tracy -Original Message- From: henry.dag...@hrsdc-rhdsc.gc.ca Sent: Thursday, April 02, 2009 3:01 PM Actually, goApp.mFilterVisibility() would be a

RE: [NF] 3 biggest lies we tell as developers

2009-04-02 Thread Gil Hale RR
Actually, my VFP7 compiled core app will run great on 32Mg RAM with a P-II CPU. It runs better with 64Mg, as some lower end machines share base RAM, hence a 32Mg machines may have only 30Mg. But that aside I develped the app on a P-90 Pentium machine with 128Mg RAM, and now test it under

Re: [NF] 3 biggest lies we tell as developers

2009-04-02 Thread Alan Bourke
I know exactly what you want. (How can I, when *you* don't even know despite thinking that you do). -- Alan Bourke alanpbou...@fastmail.fm ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox

RE: Macro Substitution using object/property in SQL

2009-04-02 Thread henry.dagher
I'll play with this and let you know. Thanks again, Tracy! Henry -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tracy Pearson Sent: 2009-04-02 3:01 PM To: profoxt...@leafe.com Subject: RE: Macro Substitution using

Re: [NF] 3 biggest lies we tell as developers

2009-04-02 Thread Ken Kixmoeller/fh
On Apr 2, 2009, at 2:40 PM, Alan Bourke wrote: I know exactly what you want. (How can I, when *you* don't even know despite thinking that you do). ... but being *so* f'in experienced in the information biz, I know what you *really* need, even if you don't know it... yet.

Microsoft release hotfix for report data group bug!

2009-04-02 Thread Cathy Pountney
Read about it in my blog: http://cathypountney.blogspot.com/2009_04_01_archive.html Cathy Pountney --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to:

[OT] Which US diplomat or official gave a nice Shotgun to Leonid Brezhnev?

2009-04-02 Thread Pete Theisen
Hi Everybody! Been google searching all day. Does anyone know. Best guesses have been Nixon or Kissinger, but I haven't been able to confirm it. -- Regards, Pete http://pete-theisen.com/ http://elect-pete-theisen.com/ ___ Post Messages to:

Re: Connecting To MySql

2009-04-02 Thread Bob Lee
Heidi sql is a really good sql tool, for free. http://www.heidisql.com/? No time trial.. very solid. Bob Lee - Original Message - From: Rick Schummer pro...@whitelightcomputing.com To: profoxt...@leafe.com Sent: Wednesday, April 01, 2009 8:53 PM Subject: RE: Connecting To MySql

[NF] Never do this

2009-04-02 Thread Pete Theisen
Hi Everybody! 46k links on one page, LOL! Takes five minutes to load at 764. -- Regards, Pete http://pete-theisen.com/ http://elect-pete-theisen.com/ ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: [NF] Never do this

2009-04-02 Thread Pete Theisen
Pete Theisen wrote: Hi Everybody! 46k links on one page, LOL! Takes five minutes to load at 764. Forgot the link, not that you want to use it. http://hnn.us/google.php -- Regards, Pete http://pete-theisen.com/ http://elect-pete-theisen.com/ ___

RE: [NF] Never do this

2009-04-02 Thread Gil Hale RR
Hmmm... Loaded for me in 7 seconds. Oh, I forgot, I have 15mps downstream, and 1mps upstream g... Gil -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com]on Behalf Of Pete Theisen Sent: Thursday, April 02, 2009 7:10 PM To:

Re: [NF] Never do this

2009-04-02 Thread Pete Theisen
Gil Hale RR wrote: Hmmm... Loaded for me in 7 seconds. Oh, I forgot, I have 15mps downstream, and 1mps upstream g... Hi Gil! I tried some of the links. Every one I tried is dead. -- Regards, Pete http://pete-theisen.com/ http://elect-pete-theisen.com/

RE: [NF] Never do this

2009-04-02 Thread Gil Hale RR
Nuh uh! They go to a place that says the link is no longer valid... Then I get to search the archives, if I want to. Gil -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com]on Behalf Of Pete Theisen Sent: Thursday, April 02, 2009 7:38 PM To:

Re: [NF] Never do this

2009-04-02 Thread Pete Theisen
Gil Hale RR wrote: Nuh uh! They go to a place that says the link is no longer valid... Then I get to search the archives, if I want to. Hi Gil! Like I said, dead. Hmmm... Loaded for me in 7 seconds. Oh, I forgot, I have 15mps downstream, and 1mps upstream g... Hi Gil! I tried some

RE: [NF] Never do this

2009-04-02 Thread Gil Hale RR
I iz jus a joshin wiff y'all g... -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com]on Behalf Of Pete Theisen Sent: Thursday, April 02, 2009 7:52 PM To: profoxt...@leafe.com Subject: Re: [NF] Never do this Gil Hale RR wrote: Nuh uh!

Re: [NF] Never do this

2009-04-02 Thread Pete Theisen
Gil Hale RR wrote: I iz jus a joshin wiff y'all g... Gil Hale RR wrote: Nuh uh! They go to a place that says the link is no longer valid... Then I get to search the archives, if I want to. Like I said, dead. Hmmm... Loaded for me in 7 seconds. Oh, I forgot, I have 15mps downstream,

[OT] Change We Can Believe In -- LOL!

2009-04-02 Thread Bob Calco
http://bit.ly/vGOQp - - - Who says Members are opposed to earmarks? We hear that the earmark computer in the Appropriations Committee - the earmark database member request system, to be exact -- broke down today. Again. This after it was revamped after last year's overwhelming earmarking. We

Re: [OT] Change We Can Believe In -- LOL!

2009-04-02 Thread Pete Theisen
Bob Calco wrote: http://bit.ly/vGOQp Who says Members are opposed to earmarks? We hear that the earmark computer in the Appropriations Committee - the earmark database member request system, to be exact -- broke down today. Again. This after it was revamped after last year's overwhelming

Re: [NF] Never do this

2009-04-02 Thread Mike Wohlrab
Hmmm, interesting. When I clicked on the link it loaded up for me in exactly 30 seconds. I think I am going to bookmark the site on my blackberry so that anytime I want the news I can get it mobile! Mike On Thu, Apr 2, 2009 at 7:07 PM, Pete Theisen petethei...@verizon.netwrote: Hi Everybody!

RE: Connecting To MySql

2009-04-02 Thread W.N. Pew
Hi folks! Thanks for the speedy responses last night. I tried SQLYog and the SQLSTRINGCONNECT method and got no results. Finally I decided to call YAHOO! Support and was informed they block all remote connections and would not 'unblock' any. Too bad, I liked it at YAHOO!. Now, since I'm not going

MySql Insert fro VFP9

2009-04-02 Thread W.N. Pew
Hi, again! Well I overcame the problem with YAHOO! I installed WAMPSERVER on my machine. Dead easy! I can connect and I can select with no problem. However, I'm messing up the formatting of the INSERT command I'm sending through the SQL pass through (SQLEXEC()). Here's what I have:

Re: MySql Insert fro VFP9

2009-04-02 Thread Gianni Turri
HI Bill, instead of macro substitution, anyway done in the wrong way here, use the syntax for parameters passing to SPT, use question marks: try = SQLEXEC(junk, insert into sec values (?mid,?mlnam,?mfnam,?musrnam,?mpzwd,?mlvl)) Gianni On Thu, 2 Apr 2009 19:19:53 -0400, W.N. Pew b...@cogeco.ca

Re: [NF] Dabo video from PyCon 2009 posted

2009-04-02 Thread Ed Leafe
On Apr 2, 2009, at 12:56 PM, Tracy Pearson wrote: I saw an email less than an hour ago. Those videos have already been hit over 10,000 times. Where do they show the number of viewings? -- Ed ___ Post Messages to: ProFox@leafe.com

Re: Save fails sometimes Vfp9 Sp1

2009-04-02 Thread Ajoy Khaund
Thankz for taking so much of your time. I really appreciate it. Well it could be two different forms were opened which have similar views. Let me look into it. I remember the user was going and checking a few things when the Orders form was open. The send form which opens to add child records

Re: [NF] Never do this

2009-04-02 Thread Pete Theisen
Mike Wohlrab wrote: Hmmm, interesting. When I clicked on the link it loaded up for me in exactly 30 seconds. I think I am going to bookmark the site on my blackberry so that anytime I want the news I can get it mobile! Hi Mike! Grumble. It is a little faster now, but it still took a

Re: MySql Insert fro VFP9

2009-04-02 Thread Fred Taylor
Not sure if MySQL supports parameters like SQL Server, but try this instead: try= SQLEXEC(junk, insert into sec values(?mid,?mlnam,?mfnam,?musrnam,?mpzwd,?mlvl)) junk is the connection handle What you provided was all strings with no quoted values so it didn't know what to make of it. try=

RE: Connecting To MySql

2009-04-02 Thread Rick Schummer
Hi Steve, Yes, the tech support people had to move my site to a server that supports remote access. Rick White Light Computing, Inc. www.whitelightcomputing.com www.swfox.net www.rickschummer.com -Original Message- From: profoxtech-boun...@leafe.com

vfp9 Sp1 to Sp2

2009-04-02 Thread Ajoy Khaund
Hi All, Currently I have Sp1 and want to give Sp2 a try. I had read before I must do a clean install of Vfp9 then apply sp2 and then apply hotfix of 2nd April 2009. If I am wrong can anyone correct me. Regards Ajoy Khaund Neamati Road Near Bhogdoi Bridge Jorhat 785001-21 Assam, India Tel:

Re: Macro Substitution using object/property in SQL

2009-04-02 Thread Stephen Russell
On Thu, Apr 2, 2009 at 1:42 PM, henry.dag...@hrsdc-rhdsc.gc.ca wrote: As for x = goapp.cFilterVisibility and using x, the problem is that x will not exist later when the view needs to be instantiated. - What are you saying? your goApp is going out of scope?

Re: MySql Insert fro VFP9

2009-04-02 Thread MB Software Solutions General Account
W.N. Pew wrote: Hi, again! Well I overcame the problem with YAHOO! I installed WAMPSERVER on my machine. Dead easy! I can connect and I can select with no problem. However, I'm messing up the formatting of the INSERT command I'm sending through the SQL pass through (SQLEXEC()).

Re: Connecting To MySql

2009-04-02 Thread Stephen Russell
On Thu, Apr 2, 2009 at 9:17 AM, W.N. Pew b...@msn.com wrote: Hi folks! Thanks for the speedy responses last night. I tried SQLYog and the SQLSTRINGCONNECT method and got no results. Finally I decided to call YAHOO! Support and was informed they block all remote connections and would not

Re: Connecting To MySql

2009-04-02 Thread MB Software Solutions General Account
W.N. Pew wrote: Hi folks! Thanks for the speedy responses last night. I tried SQLYog and the SQLSTRINGCONNECT method and got no results. Finally I decided to call YAHOO! Support and was informed they block all remote connections and would not 'unblock' any. Too bad, I liked it at YAHOO!.

Re: [NF] 3 biggest lies we tell as developers

2009-04-02 Thread MB Software Solutions General Account
Michael Madigan wrote: how about Sure my program will run on a Pentium 3 running windows 98. ...and with Foxpro, that's true! LOL! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox

Re: [NF] Never do this

2009-04-02 Thread Mike Wohlrab
Well it took 30 seconds to fully load it and wait for firefox to stop refreshing, but as soon as i clicked on the link i could start browsing the page. It may be history to you, but it is news from the future one year out for me!! - Mike On Thu, Apr 2, 2009 at 9:06 PM, Pete Theisen

Re: Macro Substitution using object/property in SQL

2009-04-02 Thread Tracy Pearson
No the local variable would. From what I gathered goapp.cFilterVisibility = field = value. Stephen Russell wrote: On Thu, Apr 2, 2009 at 1:42 PM, henry.dag...@hrsdc-rhdsc.gc.ca wrote: As for x = goapp.cFilterVisibility and using x, the problem is that x will not exist later when the

Re: Connecting To MySql

2009-04-02 Thread Steve Ellenoff
Not to defend Yahoo or anyone else, but I would guess from their perspective, the point is: most developers are using php or some other web hosted language to access the mysql database (often on the very same host as the database itself). So from their perspective, remote support is just

Re: [NF] Dabo video from PyCon 2009 posted

2009-04-02 Thread Tracy Pearson
You need an account. And this link, I believe: http://blip.tv/users/stats_by_post/?owner=pycon Tracy Ed Leafe wrote: On Apr 2, 2009, at 12:56 PM, Tracy Pearson wrote: I saw an email less than an hour ago. Those videos have already been hit over 10,000 times. Where do they show

RE: vfp9 Sp1 to Sp2

2009-04-02 Thread Rick Schummer
If I am wrong can anyone correct me. No correction here. It is recommended to start from a fresh install of RTM because of the possible overwriting of some of the sample/FFC classes. You can read the comments to this blog post where Colin Nichols (one of the contractors on the changes in SP2)

Re: Connecting To MySql

2009-04-02 Thread MB Software Solutions General Account
Stephen Russell wrote: On Thu, Apr 2, 2009 at 9:17 AM, W.N. Pew b...@msn.com wrote: Hi folks! Thanks for the speedy responses last night. I tried SQLYog and the SQLSTRINGCONNECT method and got no results. Finally I decided to call YAHOO! Support and was informed they block all remote

Re: Connecting To MySql

2009-04-02 Thread MB Software Solutions General Account
Steve Ellenoff wrote: Not to defend Yahoo or anyone else, but I would guess from their perspective, the point is: most developers are using php or some other web hosted language to access the mysql database (often on the very same host as the database itself). So from their perspective,