Re: [NF] Very strong set of issues in Are You a Bad Programmer.

2012-02-17 Thread Grigore Dolghin
alanpbou...@fastmail.fmwrote: On Thu, Feb 16, 2012, at 11:37 AM, Grigore Dolghin wrote: bending design to use sqlparameters should be read as doing it right in the first place. It has to be said, the use of parameters is pretty well accepted as best practice as far as I know, and I also agree

RE: [NF] Very strong set of issues in Are You a Bad Programmer.

2012-02-16 Thread Grigore Dolghin
I will not insist anymore on this subject. You're defending your approach fiercely and bending design to use sqlparameters should be read as doing it right in the first place. Anyway, good luck duplicating an already existing, fail proof, industry proven code. How would you know you found them

Re: [NF] Very strong set of issues in Are You a Bad Programmer.

2012-02-15 Thread Grigore Dolghin
On Wed, Feb 15, 2012 at 5:19 AM, Ken Dibble krdib...@stny.rr.com wrote: You are correct. You can enter stuff into a textbox in VFP that cannot be inserted into a variable in code. As it turns out, my app's login code actually defends against login input that contains troublesome characters,

Re: [NF] Very strong set of issues in Are You a Bad Programmer.

2012-02-14 Thread Grigore Dolghin
On Tue, Feb 14, 2012 at 3:56 AM, Ken Dibble krdib...@stny.rr.com wrote: Right, which in turn proves that if you use macro substitution to execute concatenated SQL statements in VFP, you cannot construct a statement that can damage your data. Which in turn supports my contention that one size

Re: [NF] Very strong set of issues in Are You a Bad Programmer.

2012-02-14 Thread Grigore Dolghin
Finally, someone that understands what the hell I'm talking about. On Tue, Feb 14, 2012 at 1:17 PM, Paul Hill paulroberth...@gmail.com wrote: On Tue, Feb 14, 2012 at 1:56 AM, Ken Dibble krdib...@stny.rr.com wrote: You can't concatenate anything containing to a string in VFP. That surprised

Re: VFP Pos printing

2012-02-14 Thread Grigore Dolghin
Is that printer online? On Wed, Feb 15, 2012 at 1:48 AM, Sytze de Boer sytze.k...@gmail.com wrote: There's something wrong with me today, forgive me In my system, all reports come out of the default printer But I want the Point of Sale docket to come out of specific printer So.. I

Re: VFP Pos printing

2012-02-14 Thread Grigore Dolghin
On a new report (or an existing report) you can modify the printer? On Wed, Feb 15, 2012 at 3:06 AM, Sytze de Boer sytze.k...@gmail.com wrote: Yup On Wed, Feb 15, 2012 at 2:05 PM, Grigore Dolghin gdolg...@gmail.com wrote: Is that printer online? On Wed, Feb 15, 2012 at 1:48 AM, Sytze

Re: VFP Pos printing

2012-02-14 Thread Grigore Dolghin
, Grigore Dolghin gdolg...@gmail.com wrote: On a new report (or an existing report) you can modify the printer? On Wed, Feb 15, 2012 at 3:06 AM, Sytze de Boer sytze.k...@gmail.com wrote: Yup On Wed, Feb 15, 2012 at 2:05 PM, Grigore Dolghin gdolg...@gmail.com wrote

Re: [NF] Very strong set of issues in Are You a Bad Programmer.

2012-02-14 Thread Grigore Dolghin
I am sorry, you have no idea what you're talking about. I don't know how you're doing your tests, but in last 10 minutes I have created an example which can be downloaded from here: www.class-software.eu/sqlparameters.zip Username: admin Password: adminpass The program will show how many

Re: VFP Pos printing

2012-02-14 Thread Grigore Dolghin
an option OK Cancel Printer On Wed, Feb 15, 2012 at 2:16 PM, Grigore Dolghin gdolg...@gmail.com wrote: If you start VFP with vfp.exe /A, does the situation improves? You can change the printer from any other application, let's say Word? On Wed, Feb 15, 2012 at 3:15 AM, Sytze de Boer sytze.k

RE: [NF] Very strong set of issues in Are You a Bad Programmer.

2012-02-13 Thread Grigore Dolghin
Ken, Your code is proving that macrosubstitution cannot execute multiple lines of code. As long as you execute commands on VFP data AND the literal value does not implies multiple lines that's ok. As soon as any of the above conditions is not met something bad will happen if you use

Re: [NF] Very strong set of issues in Are You a Bad Programmer.

2012-02-12 Thread Grigore Dolghin
Actually, it is easy, just don't declare the variables as local in the place where are they created. The calls for the method that does the save (even if it's in a different class) will see those variables. On Mon, Feb 13, 2012 at 2:40 AM, Ken Dibble krdib...@stny.rr.com wrote: On Sat, Feb 11,

Re: [NF] Very strong set of issues in Are You a Bad Programmer.

2012-02-12 Thread Grigore Dolghin
Not true. If the variable is delete from table (it's too late here to compose a real dangerous variable, but you got the idea), passing it as literal string will delete the records, while passing it as ?varName will not. Try it. On Mon, Feb 13, 2012 at 3:06 AM, Ken Dibble krdib...@stny.rr.com

Re: NCHAR and NVARCHAR fields in TXT/CSV files

2012-02-10 Thread Grigore Dolghin
What about names containing accents? On Fri, Feb 10, 2012 at 11:53 PM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: Provider has sent me raw data files, plus layouts. Schema defined in layout files indicates that some fields are NCHAR and NVARCHAR. Looking

Re: [NF] Yahoo a spam factory

2012-02-06 Thread Grigore Dolghin
Same here. Whenever sites ask for my email address, I give them the yahoo one. On Mon, Feb 6, 2012 at 6:25 PM, Fred Taylor fbtay...@gmail.com wrote: I still have a rocketmail account that goes through Yahoo. I've had the rocketmail account since '94 and Yahoo took them over about 6 or 7 years

RE: [NF] To Split an MPG File

2012-01-18 Thread Grigore Dolghin
WinRar, set it to no compression and set the size to 4.7gb (it's one of the predefined options). It will just split the file, as fast as a simple copy. You don't want to compress that file anyway. -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com]

Re: [NF] Wordpress / CSS Problem

2012-01-18 Thread Grigore Dolghin
Kevin, add me as an admin user to that website and I'll fix it. Send credentials to my private email address: gdolghinATgmail.com On Thu, Jan 19, 2012 at 5:48 AM, Kevin Cully kcu...@cullytechnologies.comwrote: I'm not sure I understand though. If I do a view-source, the p/p and the br tags

Re: Hexbinary format (for the sake of better password storage comparison)

2012-01-11 Thread Grigore Dolghin
I need to jump in here. VFP isn't unicode, but the OS is. In some circumstances VFP is tricked by the OS and does some translation by its own so you have to make absolutely sure this doen't happen. Storing the binary encoded as hexbinary is one way to do it; another would be to define the

Re: VFP9 64bit SQL Server

2012-01-05 Thread Grigore Dolghin
http://connectionstrings.com/sql-server-2008 lcConnectionString = Provider=SQLNCLI10;Server=myServerAddress;Database=myDataBase;Uid=myUsername; Pwd=myPassword; nHandle = SQLStringConnect(lcConnectionString) That should be all. On Thu, Jan 5, 2012 at 6:57 PM, Jeff Johnson j...@san-dc.com wrote:

Re: What's the trick to get an exe not to blink off?

2012-01-05 Thread Grigore Dolghin
READ EVENTS immediately after Do myMenu.mpr, and a CLEAR EVENTS somewhere in the menu's Exit pad. On Fri, Jan 6, 2012 at 1:28 AM, Michael Madigan mmadi10...@yahoo.comwrote: I'm thinking a dummy modal form that executes the menu From: desmond.ll...@gmail.com

Re: Scientists vindicated

2012-01-02 Thread Grigore Dolghin
And this is foxpro related because...? On Mon, Jan 2, 2012 at 9:03 PM, Nicholas Geti ng...@optonline.net wrote: http://www.nytimes.com/2012/01/02/science/earth/new-speculation-on-who-leaked-climate-change-e-mails.html?_r=1nl=todaysheadlinesemc=tha22 Article gives history of attack on

Re: How can I learn what email client software a client has?

2011-12-29 Thread Grigore Dolghin
Look for CDOSYS in archives. This allows you to send mails without relying on their mail client (you need to know the smtp server, port, username and password though, but alternatively you could set a free gmail account and use that one to send their mails. On Fri, Dec 30, 2011 at 2:16 AM,

RE: Alternatives to storing a user's password in your database

2011-12-21 Thread Grigore Dolghin
I wonder when people will learn that there are guys whose only job is to think on these things. And the outcome cannot be beaten by in-house solutions no matter what, first because they do that 8 hours a day, 5 days a week. An inhouse solution simply cannot compete. Not to mention that usually the

RE: Alternatives to storing a user's password in your database

2011-12-21 Thread Grigore Dolghin
Since I wrote my last message (1h 10 minutes ago) I wrote a quick'n'dirty program that looks for alternate strings. Guess what, it finds the string as fast as even by SET DECIMALS TO 18 I couldn't measure the execution time. I used my name as a password and padded it with ABCDE up to 20 chars

Re: [NF] font on techcrunch.com

2011-12-01 Thread Grigore Dolghin
Um... it's Arial, 10. What do you mean by difficult to read? On Thu, Dec 1, 2011 at 11:21 PM, MB Software Solutions General Account mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: Has anyone noticed (and/or can verify) that the font used on http://techcrunch.com/ is difficult to read?

Re: [NF] font on techcrunch.com

2011-12-01 Thread Grigore Dolghin
This is what I see: http://www.class-software.eu/IE9.png http://www.class-software.eu/Firefox8.png On Fri, Dec 2, 2011 at 1:07 AM, MB Software Solutions General Account mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On Thu, December 1, 2011 4:41 pm, Grigore Dolghin wrote: Um... it's Arial

RE: knockknock Testing...

2011-11-30 Thread Grigore Dolghin
I have received this message, though. Let's see if you get something back. :) -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ken Kixmoeller (ProFox) Sent: Wednesday, November 30, 2011 5:59 PM To: profoxt...@leafe.com Cc: Ed Leafe

Re: knockknock Testing...

2011-11-30 Thread Grigore Dolghin
Pete You won't convince me to follow the [OT] section :) On Wed, Nov 30, 2011 at 6:28 PM, Pete Theisen petethei...@verizon.netwrote: Ken Kixmoeller (ProFox) wrote: Hm --- I haven't received a message for several days. Looking at the archives, there is activity, so I guess Ed's server

Re: sql server express debugging

2011-11-23 Thread Grigore Dolghin
The correct syntax is Create Procedure InsertData @Account, @CompanyName, @Province As Begin Insert Into Customers (Account, CompanyName, Province) Values (@Account, @CompanyName, @Province) End The idea is to use parameters (in both VFP and MSSQL), otherwise sooner or later someone would enter

Re: sql server express debugging

2011-11-23 Thread Grigore Dolghin
with the quotes. Rafael El 23/11/2011 16:22, Grigore Dolghin escribió: The correct syntax is Create Procedure InsertData @Account, @CompanyName, @Province As Begin Insert Into Customers (Account, CompanyName, Province) Values (@Account, @CompanyName, @Province) End The idea is to use

RE: [NF] Neutrino race

2011-11-20 Thread Grigore Dolghin
I always believed that speed of light is just our limitation. Also I don't believe in that big-bang crap - a theory that tries to explain why the color of galaxies its' shifted to red. they must be moving away from us. Really? Doppler effect isn't the only one that makes the light shift. This

Re: http://etecnologia.net/

2011-10-24 Thread Grigore Dolghin
23, 2011 at 5:34 PM, Grigore Dolghin gdolg...@gmail.com wrote: The entire project is down for nearly 2 years by now --  .~. Might, Courage, Vision. SINCERITY! / v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3) /( _ )\ http://sites.google.com/site/changmw ^ ^ May the Force and farces

RE: http://etecnologia.net/

2011-10-24 Thread Grigore Dolghin
The best way to build .NET applications is to build them in .NET from scratch. Anything else is just improvisation. Same rationale applies to conversion from FPD to VFP and I'm pretty sure you guys agree with me here. Although FPD apps run under VFP, all you get is FPD performance and features.

RE: Access to VFP

2011-10-24 Thread Grigore Dolghin
You could REPLACE them with {}, 0, , and so on, after getting the result cursor. However, I would suggest to keep the nulls, they have meaning. Why you want to get rid of them? -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff

Re: http://etecnologia.net/

2011-10-23 Thread Grigore Dolghin
The entire project is down for nearly 2 years by now On Sun, Oct 23, 2011 at 12:33 PM, Man-wai Chang chan...@gmail.com wrote: What's happening to dotNet Extender's website? It's been offline for nearly a week... --  .~. Might, Courage, Vision. SINCERITY! / v \ 64-bit Ubuntu 9.10 (Linux

Re: [NF] List of table and column naming conventions/abbreviations, common prefix/suffixes, etc.

2011-10-18 Thread Grigore Dolghin
I would add something about PK notation convention. I've seen a lot of CustomerId, ProductId and so on as PK column name. The argument for this was it makes easier to spot the join columns (CustomerId in parent table, CustomerId in child table). Yeah right. In my oppinion, Customer.Id =

Re: [NF] List of table and column naming conventions/abbreviations, common prefix/suffixes, etc.

2011-10-17 Thread Grigore Dolghin
Hehe, the best parser ever is DB2's parser. It can chew the following line and spit out the correct records: Select From From From Where From On Tue, Oct 18, 2011 at 5:58 AM, Paul McNett p...@ulmcnett.com wrote: On 10/16/11 5:53 AM, Malcolm Greene wrote: Has anyone published guidelines on

Re: Hide VFP Command Window

2011-10-04 Thread Grigore Dolghin
Hide Window Command On Wed, Oct 5, 2011 at 7:55 AM, Fred Taylor fbtay...@gmail.com wrote: 1) Use the runtime for your app, probably needs to be an .EXE, at least as the starting program that can call your .APP. 2) READ EVENTS (#1 above will need this ,too) The Command Window is only visible

Re: [NF] Format .tar.gz

2011-10-03 Thread Grigore Dolghin
WinZip. On Mon, Oct 3, 2011 at 2:56 PM, Eurico Chagas Filho e28cha...@yahoo.com.br wrote: Is this a UNIX format ? What program opens this file ? TIA, E. --- StripMime Report -- processed MIME parts --- multipart/alternative  text/plain (text body -- kept)  text/html --- [excessive

RE: Ah memories ...

2011-10-02 Thread Grigore Dolghin
Unless you're Romanian. Romania is the country where even the boomerangs don't come back... Slightly off-topic, I know, I apologize ;) -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke Sent: Sunday, October 02, 2011 11:24

Re: Composite Key in Sql Server 2008

2011-09-21 Thread Grigore Dolghin
I would create three indexes, one for each column, and use a WHERE clause in SELECT, similar to this one: WHERE empno = ?m.empno AND kdate = ?m.kdate AND shiftno = ?m.shiftno Note: using functions in expressions used in where is a performance killer because those functions get evaluated for each

RE: Composite Key in Sql Server 2008

2011-09-21 Thread Grigore Dolghin
...@leafe.com Subject: Re: Composite Key in Sql Server 2008 On Wed, Sep 21, 2011 at 8:22 AM, Grigore Dolghin gdolg...@gmail.com wrote: I would create three indexes, one for each column, and use a WHERE clause in SELECT, similar to this one: WHERE empno = ?m.empno AND kdate = ?m.kdate

Re: Cannot resolve backlink

2011-08-30 Thread Grigore Dolghin
Seems the table cannot find the DBC or the information about that table doesn't exist in the DBC. You should try free the table then add it back to DBC. The problem is the long names will be lost. On Tue, Aug 30, 2011 at 4:07 PM, James E Harvey jhar...@hanoverpa.com wrote: We installed a new

Re: Cannot resolve backlink

2011-08-30 Thread Grigore Dolghin
I highly doubt. VMWare is a stable product; Win 2008R2 is stable too (assuming the service pack is applied). I am using this combination and had no problems with it at all. On Tue, Aug 30, 2011 at 6:25 PM, James E Harvey jhar...@hanoverpa.com wrote: I'm starting to see all kinds of crazy

Re: [NF] - Steve Jobs...

2011-08-29 Thread Grigore Dolghin
http://i.imgur.com/WV5Y0.jpg On Mon, Aug 29, 2011 at 10:50 AM, Adam Buckland adam.buckl...@eurohill.com wrote: This does not look good Such a shame... http://www.dailymail.co.uk/news/article-2031100/Gaunt-frail-cancer-battl e-takes-toll-Steve-Jobs-picture-left-Apple.html ---

Re: ACT ID Status Control

2011-08-29 Thread Grigore Dolghin
The control you're looking for doesn't exist in VFP. You could use a grid containing two columns: a checkbox and the option. User can check as many records as they want. Save more than one option in the control source is not possible. In fact, those controls save as many records/items/whatever as

Re: ACT ID Status Control

2011-08-29 Thread Grigore Dolghin
Fred, while I agree with you, I wouldn't use the multi-select. Selecting multiple options requires the user to ctrl+click the options. Some of the users have problems with this (a single wrong click deselects all the options, and so on). From the usability point of view, checkboxes are better. The

Re: ACT ID Status Control

2011-08-29 Thread Grigore Dolghin
On 08/29/2011 08:36 AM, Grigore Dolghin wrote: Fred, while I agree with you, I wouldn't use the multi-select. Selecting multiple options requires the user to ctrl+click the options. Some of the users have problems with this (a single wrong click deselects all the options, and so on). From

Re: ACT ID Status Control

2011-08-29 Thread Grigore Dolghin
I was thinking an ActiveX control would be too much of a hassle, though. On Mon, Aug 29, 2011 at 6:51 PM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 8/29/2011 11:36 AM, Grigore Dolghin wrote: Fred, while I agree with you, I wouldn't use the multi-select

Re: ACT ID Status Control

2011-08-29 Thread Grigore Dolghin
which ones are checked.  With this you can see the options at a glance. Jeff --- Jeff Johnson j...@san-dc.com (623) 582-0323 www.san-dc.com On 08/29/2011 08:51 AM, Grigore Dolghin wrote: Hehe, Jeff, cool find ;) On Mon, Aug 29, 2011 at 6:40 PM, Jeff Johnsonj...@san

Re: ACT ID Status Control

2011-08-29 Thread Grigore Dolghin
empty ones at runtime.  The checkboxes would not be bound and the selected boxes would be stored in a delimited list. Jeff --- Jeff Johnson j...@san-dc.com (623) 582-0323 www.san-dc.com On 08/29/2011 09:32 AM, Grigore Dolghin wrote: What if the list is dynamically built

RE: [NF] spam funny

2011-08-17 Thread Grigore Dolghin
I usually log in and enter f*ck you, motherf*cker as username and something similar as password. Let'em try logging in. -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Wendt Sent: Wednesday, August 17, 2011 9:01 PM To:

Re: [NF] Seeking Free .docx to .doc Conversion Software

2011-08-12 Thread Grigore Dolghin
There is a patch that allows earlier Office versions to open docx files. Is that ok for you? On Fri, Aug 12, 2011 at 4:25 PM, Ken Dibble krdib...@stny.rr.com wrote: Hi All, I'm looking for free installable software that converts .docx files to .doc files (it would be nice if it also converted

RE: [NF] Extra Windows Folders

2011-08-05 Thread Grigore Dolghin
Those are old Windows installations. Can be safely deleted if you don't have anything useful which would want to save first (which I strongly doubt). Look for old Program Files folders too. -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On

Re: FORMAT AND INPUTMASK IN WITH TEXTBOX

2011-08-04 Thread Grigore Dolghin
Use a combobox instead. On Thu, Aug 4, 2011 at 7:02 PM, Jerry Foote jerryfo...@bellsouth.net wrote: I am trying to use the M in format with a string in the inputmask to restrict data entry in 1 particular field. If I have LIQUOR,BEER,WINE as a literal the selection is limited to one of the

Re: [OT] Obama’s and Bush’s effects on the deficit in one graph

2011-07-28 Thread Grigore Dolghin
Um why I am getting [OT] mails? On Thu, Jul 28, 2011 at 4:11 PM, Stephen Russell srussell...@gmail.com wrote: On Thu, Jul 28, 2011 at 6:34 AM, Jean Laeremans laeremans.jeanma...@gmail.com wrote:

Re: [NF] Best file format for video playback on web site

2011-07-25 Thread Grigore Dolghin
Download a trial version of camtasia studio. Do a screen recording and encode it as .MP4. Then publish your recording and Camtasia will generate a similar code with what you already have. Those .MP4 don't want to download - they are played as soon 10% of the video is downloaded (this percent is

RE: Help, my debug window will not open

2011-07-13 Thread Grigore Dolghin
The resource file is corrupted, most probably. Try deleting it - it will be recreated. -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Michael Savage Sent: Thursday, July 14, 2011 5:42 AM To: profoxt...@leafe.com Subject: Help, my

RE: Win7 adn you want one place to go for everything?

2011-07-08 Thread Grigore Dolghin
Tools/Options/ctrl+shift+click on OK, if I remember correctly. -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke Sent: Friday, July 08, 2011 11:56 AM To: profoxt...@leafe.com Subject: RE: Win7 adn you want one place to go

Re: pageframes

2011-07-08 Thread Grigore Dolghin
Um... what do you mean? Clicking on a page should bring that page in front. On Fri, Jul 8, 2011 at 12:35 PM, Allen pro...@gatwicksoftware.com wrote: Hi foxgang In earlier versions of vfp there was a way to easily move to pages on a pageframe in design mode. VFP9 does not appear to have that.

Re: pageframes

2011-07-08 Thread Grigore Dolghin
10 I have a hell of a job to get there. Am I missing something? Al -Original Message- From: Grigore Dolghin Sent: Friday, July 08, 2011 10:36 AM To: profoxt...@leafe.com Subject: Re: pageframes Um... what do you mean? Clicking on a page should bring that page in front. [excessive

Re: Intro to Servoy for Visual FoxPro ISVs - with Ken Levy

2011-07-08 Thread Grigore Dolghin
10k per server per year? that's insanely expensive for a logical evolution for Visual FoxPro, given the fact VFP was about 600 USD, royalty free. On Fri, Jul 8, 2011 at 3:48 PM, Allen pro...@gatwicksoftware.com wrote: Clever get someone to repair it for you. neat plan :) still remains

RE: Win7 adn you want one place to go for everything?

2011-07-07 Thread Grigore Dolghin
WHOA! That is WAY cool! :) Thanks ;) -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Friday, July 08, 2011 12:49 AM To: profoxt...@leafe.com Subject: Win7 adn you want one place to go for everything? add this

Re: [NF] Your thoughts on MS Visual Lightswitch 2011?

2011-07-05 Thread Grigore Dolghin
Nope, you're not alone. The pictures are reduced in size, somehow and the text is hard to read. On Tue, Jul 5, 2011 at 3:18 PM, Malcolm Greene pro...@bdurham.com wrote: A sidebar question to my original post - am I the only one that found the Lightswitch screenshots and short videos (eg. user

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 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 gdolg...@gmail.com wrote: I watched the video

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 srussell...@gmail.com wrote: On Mon, Jun 27, 2011 at 6:56 AM, Grigore Dolghin gdolg...@gmail.com wrote: Sorry, I pressed send to early. It also executes the select with Exec. So much about query optimizer

RE: [NF] Questions on migrating VFP app

2011-06-26 Thread Grigore Dolghin
Simply put - because it is impossible to define invalid input. Some applications need to allow input what other applications define as invalid (ask Mike - I believe he knows this very well, especially when double quotes IS a valid input.) Look at it from a SQL Server point of view. I've seen an

RE: [NF] Questions on migrating VFP app

2011-06-26 Thread Grigore Dolghin
And one more thing: I am still waiting for your answer on this: what your application does if the user wants to search for Mom and Pop shop (double quotes included, because that's the real name of the shop)? I really hope you won't tell me I do not allow double quotes in the name or that will

RE: [NF] Questions on migrating VFP app

2011-06-26 Thread Grigore Dolghin
I agree with you in all these points. Regarding #6, I ran in the same problem. The trick was (in my case) to not declare the variables LOCAL. Specifically, the code looked like this: *-- No LOCAL lcUserName, lcPassword, just declare them as-is lcUsername = ThisForm.txtUsername.Value lcPassword =

RE: [NF] Questions on migrating VFP app

2011-06-25 Thread Grigore Dolghin
Open your application, please, and in any textbox that is used for a SELECT operation, enter this: '] (exactly as I typed - double quote, single quote, close square bracket). And please let me know what happened. -Original Message- From: profoxtech-boun...@leafe.com

RE: [NF] Questions on migrating VFP app

2011-06-25 Thread Grigore Dolghin
How come? You don't have any textbox that allow strings? Or you specifically prohibit those characters? If you prohibit, how do they search for a customer named O'Hara? -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ken Dibble

RE: [NF] Questions on migrating VFP app

2011-06-25 Thread Grigore Dolghin
Right. I'm your user and I enter '] as my name. what you gonna do? -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ken Dibble Sent: Saturday, June 25, 2011 5:34 PM To: profoxt...@leafe.com Subject: Re: [NF] Questions on migrating

RE: [NF] Questions on migrating VFP app

2011-06-25 Thread Grigore Dolghin
And THAT is sql injection. It crashes your application. -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ken Dibble Sent: Saturday, June 25, 2011 6:06 PM To: profoxt...@leafe.com Subject: RE: [NF] Questions on migrating VFP app

RE: [NF] Questions on migrating VFP app

2011-06-25 Thread Grigore Dolghin
Well, I'm going to stop now - it seems you just don't want to see the obvious. The idea is if you use data entered by user in your SQL strings, something bad will happen. Fortunatelly, VFP doesn't allow multiple commands per line, and that prohibits dropping the tables or deleting the records, but

RE: [NF] Questions on migrating VFP app

2011-06-25 Thread Grigore Dolghin
That works even in VFP, in a scenario similar to this: The application ask for user and password, then executes a query similar to this: 'SELECT loginfield, passwordfield From users where login==' + login + ' And Password ==' + password + '' So far so good. And the user enter this as username:

RE: [NF] Questions on migrating VFP app

2011-06-25 Thread Grigore Dolghin
Yes. -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Mike Copeland Sent: Saturday, June 25, 2011 10:49 PM To: profoxt...@leafe.com Subject: Re: [NF] Questions on migrating VFP app Wow, if it's that simple (using parameterized

RE: [NF] Questions on migrating VFP app

2011-06-25 Thread Grigore Dolghin
It will also solve another issue - if you have legit data containing double quotes, or single quotes, or backslashes (which are treated as escape chars in MySQL), the data will be properly stored in server. For example, some people store the reports definitions on server; users download them and

RE: Private Data Session

2011-06-25 Thread Grigore Dolghin
The cursor is created in the session where the object that creates the cursor was instantiated. I would suggest to change the method that creates the cursor to receive the datasessionid as parameter: Procedure CreateCursor Lparameters tnDataSessionId Private SessionHasBeenChanged If

RE: [NF] Questions on migrating VFP app

2011-06-25 Thread Grigore Dolghin
You're more than welcome, Mike :) -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Mike Copeland Sent: Saturday, June 25, 2011 11:08 PM To: profoxt...@leafe.com Subject: Re: [NF] Questions on migrating VFP app Grigore...THAT is a

RE: [NF] Questions on migrating VFP app

2011-06-25 Thread Grigore Dolghin
You're right, Mike. They'll go to server as entered. Give it a try ;) -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Mike Copeland Sent: Saturday, June 25, 2011 11:20 PM To: profoxt...@leafe.com Subject: Re: [NF] Questions on

RE: [NF] Questions on migrating VFP app

2011-06-25 Thread Grigore Dolghin
On the funny side: http://www.grigore.dolghin.ro/wp-content/uploads/2011/02/for_traffic_cameras .jpg hehehe ;) -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ken Dibble Sent: Saturday, June 25, 2011 11:37 PM To:

RE: Private Data Session

2011-06-25 Thread Grigore Dolghin
perfectly Now back to coding ... Thanks so much -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Grigore Dolghin Sent: Saturday, June 25, 2011 4:12 PM To: profox@leafe.com Subject: RE: Private Data Session The cursor is created

Re: [NF] Firefox 5.0 gone black?

2011-06-23 Thread Grigore Dolghin
the drain in 6 months. I replaced the battery and still works. My current laptop (Dell XPS 1730) is 3 years old and still has the original battery which performs normally. On Thu, Jun 23, 2011 at 5:02 PM, Paul McNett p...@ulmcnett.com wrote: On 6/22/11 10:28 PM, Grigore Dolghin wrote: I don't know

RE: Universal Thread is slowing down????

2011-06-22 Thread Grigore Dolghin
I believe that's because Michel is too greedy. I ceased logging in to UT a long while ago because if you want to search, you need to pay. What kind of a forum is that? People are answering the questions and Michel is making a buck out of it. WTF. I'm not going back there ever again. -Original

RE: [NF] Firefox 5.0 gone black?

2011-06-22 Thread Grigore Dolghin
The battery has a limited number of charge/discharge cycles. Each Standby will consume one cycle, so if you do this often, the battery life time is pretty short. Been there, done that. I managed to kill a battery in less than 6 months. The next one is still performing normally after 3 years.

RE: [NF] Firefox 5.0 gone black?

2011-06-22 Thread Grigore Dolghin
[mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul McNett Sent: Thursday, June 23, 2011 6:30 AM To: profoxt...@leafe.com Subject: Re: [NF] Firefox 5.0 gone black? On 6/22/11 2:42 PM, Grigore Dolghin wrote: The battery has a limited number of charge/discharge cycles. Each Standby will consume one

RE: Web Development

2011-06-14 Thread Grigore Dolghin
ASP is dead and buried. -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Allen Sent: Tuesday, June 14, 2011 10:13 PM To: profoxt...@leafe.com Subject: RE: Web Development I made one test site with VFP9 and one asp page Al

RE: Web Development

2011-06-14 Thread Grigore Dolghin
That's good for you. However, I see it like old FPD application. They're fast, performant, do their job, etc, etc. Until OS will stop supporting them. As for ASP - until next IIS version will not support it. -Original Message- From: profoxtech-boun...@leafe.com

Re: Want grid to stay in middle of page when resizing

2011-06-13 Thread Grigore Dolghin
Set the Grid's anchor value to 768. On Mon, Jun 13, 2011 at 3:22 PM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: VFP9SP2 I have a grid on a page in a pageframe.  Pageframe has anchor property set to 15 (width and height resizable).  Can this be done for the

RE: Want grid to stay in middle of page when resizing

2011-06-13 Thread Grigore Dolghin
On 6/13/2011 8:50 AM, Grigore Dolghin wrote: Set the Grid's anchor value to 768. Perfect...thanks, Grigore! -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 [excessive quoting

Re: [NF] Move All From Windows XP to System 7 With Ease

2011-05-18 Thread Grigore Dolghin
http://www.makeuseof.com/tag/how-to-upgrade-from-xp-to-windows-7-in-4-easy-steps/ Does this helps? On Wed, May 18, 2011 at 8:10 PM, G Gambill gwgamb...@gmail.com wrote: I am looking for suggestions on a way to easily move everything (except tne OS) from a Windows XP box to a System 7

RE: XML

2011-05-12 Thread Grigore Dolghin
that there is an XML 6 now and I was not sure if to put that on. Anyway thanks Grig, that worked and I have VFP working ok. Al -Original Message- From: Grigore Dolghin Sent: Thursday, May 12, 2011 9:24 PM To: profoxt...@leafe.com Subject: RE: XML Sorry, after sending my previous message I saw

RE: transact sql

2011-05-11 Thread Grigore Dolghin
This is working on MSSQL 2008 and up; SQL Server 2005 doesn't have a DATE datatype, so the only choice is using a BETWEEN. -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Fred Taylor Sent: Wednesday, May 11, 2011 8:48 PM To:

RE: transact sql

2011-05-11 Thread Grigore Dolghin
There's something wrong; either you're using 2005 or earlier, either you didn't find it yet in 2008, because it's there. http://msdn.microsoft.com/en-us/library/bb630352.aspx -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rafael

RE: Virus Phone Scam

2011-05-11 Thread Grigore Dolghin
Then I bet you'll love this. Fun to watch: http://www.youtube.com/watch?v=rBfsdkGeMc8 -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Wednesday, May 11, 2011 11:30 PM To: profoxt...@leafe.com Subject: Re:

RE: [NF] T-SQL Last day of the month

2011-05-10 Thread Grigore Dolghin
I am using this, in good old VFP style: Declare @CurrentDate Date Set @CurrentDate = GetDate() Select Cast(DateAdd(D, -1 , DateADD(mm, DateDiff(m, 0, @CurrentDate) + 1, 0)) As Date) -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of

Re: Flashing Text

2011-05-06 Thread Grigore Dolghin
As far as I know, VFP shows just the first frame. On Fri, May 6, 2011 at 4:35 PM, Kevin Cully kcu...@cullytechnologies.com wrote: Just thinking out of the box here, but could you create an animated GIF and display that on the form? On 05/06/2011 06:48 AM, Jerry Foote wrote: Is there a vfp

Re: Flashing Text

2011-05-06 Thread Grigore Dolghin
I stand corrected, then, thanks, Mike :) On Fri, May 6, 2011 at 5:18 PM, MB Software Solutions, LLC mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 5/6/2011 9:35 AM, Grigore Dolghin wrote: As far as I know, VFP shows just the first frame. No, I think that's incorrect.  When I

RE: [NF] Joomla themes anyone?

2011-05-06 Thread Grigore Dolghin
I'm doing Joomla too, Steve. There are tons of free themes and free components for joomla, doing almost anything you can think of. http://extensions.joomla.org. -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent:

  1   2   3   4   5   >