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

2012-02-17 Thread Grigore Dolghin
: > > > 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 be

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 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, by setting up the

Re: VFP Pos printing

2012-02-14 Thread Grigore Dolghin
Page setup, page setup > I get an option OK Cancel Printer > > > On Wed, Feb 15, 2012 at 2:16 PM, Grigore Dolghin > wrote: > > > If you start VFP with vfp.exe /A, does the situation improves? You can > > change the printer from any other application, let'

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 records

Re: VFP Pos printing

2012-02-14 Thread Grigore Dolghin
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 wrote: > No > Not on an existing, nor a brand new report > > > On Wed, Feb 15, 2012 at 2:09

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 wrote: > Yup > > > On Wed, Feb 15, 2012 at 2:05 PM, Grigore Dolghin > wrote: > > > Is that printer online? > > > > On Wed, Feb 15, 2012

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 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 modify the report

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 wrote: > On Tue, Feb 14, 2012 at 1:56 AM, Ken Dibble wrote: > > You can't concatenate anything containing "&&" to a string in VFP. That > > surprised me, frankly, but you can't. It won'

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 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 > does not fit all

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 macrobustituti

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 wrote: > There is no

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 wrote: > > >On Sat, Feb 11, 2012 at 8:55 PM,

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. Lookin

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 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 > ago. Since th

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 wrote: > I'm not sure I understand though. If I do a view-source, the and > the tags aren't there. Is there some malfor

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] O

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 encrypt

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 wrote: > I'm thinking a dummy modal form that executes the menu > > > > From: "desmond.ll...@gmail.com" > To: ProFox

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 wrote: > I guess wh

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 wrote: > > http://www.nytimes.com/2012/01/02/science/earth/new-speculation-on-who-leaked-climate-change-e-mails.html?_r=1&nl=todaysheadlines&emc=tha22 > > Article gives history of attack on integrity of global-w

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, Michael

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 leng

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: [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: >

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: 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 wrote: > 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 has come to > > its

RE: 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 Su

Re: sql server express debugging

2011-11-23 Thread Grigore Dolghin
ec(nHandle,cCmd1) > > and using the debugging tool suggested by Gianni I found that the SP > gets confused with the quotes. > Rafael > > > El 23/11/2011 16:22, Grigore Dolghin escribió: >> The correct syntax is >> >> Create Procedure InsertData >> @Acco

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 R

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 big

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-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. If

Re: http://etecnologia.net/

2011-10-24 Thread Grigore Dolghin
n, Oct 23, 2011 at 5:34 PM, Grigore Dolghin 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

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 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 kernel 2.6.3

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 = childt

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 wrote: > On 10/16/11 5:53 AM, Malcolm Greene wrote: >> Has anyone published guidelines on table and column na

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 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 when running

Re: [NF] Format .tar.gz

2011-10-03 Thread Grigore Dolghin
WinZip. On Mon, Oct 3, 2011 at 2:56 PM, Eurico Chagas Filho 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 quoting

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
ofoxt...@leafe.com Subject: Re: Composite Key in Sql Server 2008 On Wed, Sep 21, 2011 at 8:22 AM, Grigore Dolghin 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 AND shi

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: 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 wrote: > I'm starting to see all kinds of crazy behavior with the database.

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 wrote: > We installed a new server running Win 2008R

Re: ACT ID Status Control

2011-08-29 Thread Grigore Dolghin
or hide 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/

Re: ACT ID Status Control

2011-08-29 Thread Grigore Dolghin
CT > because you have to view the list to see 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

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 wrote: > On 8/29/2011 11:36 AM, Grigore Dolghin wrote: >> Fred, while I agree with you, I wouldn't use the multi-select. >> Selecting multiple

Re: ACT ID Status Control

2011-08-29 Thread Grigore Dolghin
> (623) 582-0323 > > www.san-dc.com > > > 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 w

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
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: [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 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 > > > > > > > > --- StripMime Report

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: profoxt

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 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 other .___x file

RE: [NF] "Extra" Windows Folders

2011-08-04 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 Behal

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 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 selections. >

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 wrote: > On Thu, Jul 28, 2011 at 6:34 AM, Jean Laeremans > wrote: >> http://www.washingtonpost.com/blogs/ezra-klein/post/obamas-and-bushs-effect-on-the-deficit-in-one-graph/2011/07/25/gIQAELOrYI_blog.html?wprss=

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 con

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 de

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 wrote: > Clever get someone to repair it for you. neat plan :) > still remains costly per seat though. I mu

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 sh

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 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. Is there a way > or hav

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 f

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 f

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 wrote: > A sidebar question to my original post - am I the only one that found > the Lightswitch screenshots and short videos (eg. user interface 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 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

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

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-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-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 w

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 a

RE: Private Data Session

2011-06-25 Thread Grigore Dolghin
works 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 i

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: profoxt...@leafe.c

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 migrat

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 kic

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 Vartype(tnData

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 ru

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 querie

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 usernam

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
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 >Rig

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 VF

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 Sent:

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 [mailto:profoxtech-bou

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 wrote: > On 6/22/11 10:28 PM, Grigore Dolghin wrote: >> I don't know

RE: [NF] Firefox 5.0 gone black?

2011-06-22 Thread Grigore Dolghin
e.com [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

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: 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: 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 [mailto:profoxtech-boun...@l

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 -Origi

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

2011-06-13 Thread Grigore Dolghin
izing 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 [exce

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 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 via > the Anchor property or must I use c

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 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 Professional box. > > Thank

RE: XML

2011-05-12 Thread Grigore Dolghin
seems 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 mes

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: Virus

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 Co

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: profoxt.

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: [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: F

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 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 was at Sylvan, I di

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 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 function or property to f

  1   2   3   4   5   >