RE: Updatable local view with multiple tables

Thanks to all who replied. 1- Mike, The view does have primary keys. One per table. It also knows how they join. I figured on tableupdate it would 'know' how to preserve the linkage. 2- I never got Dave Crozier's reply. Weird. 3- Dave, I do set quite a few DBSetProp()s. Didn't want to burden

Updatable local view with multiple tables

I just realized that I never before used updatable views where more than one table needed to be updated. I now see that the joinable fields do not get automatically filled (to maintain the JOIN). In the example below, I need to update all fields except 3: The two PKs (they are AutoInc) and

Updatable local view with multiple tables

I just realized that I never before used updatable views where more than one table needed to be updated. I now see that the joinable fields do not get automatically filled (to maintain the JOIN). In the example below, I need to update all fields except 3: The two PKs (they are AutoInc) and

RE: How to get reference to selected control

Sys(1270) ? -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul McNett Sent: October 2, 2009 4:53 PM To: profoxt...@leafe.com Subject: How to get reference to selected control Ok I'm back at Fox to make a tweak to a legacy

RE: Macro Substitution using object/property in SQL

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

RE: Macro Substitution using object/property in SQL

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

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

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

Macro Substitution using object/property in SQL

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: Macro Substitution using object/property in SQL

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

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

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: Splitting of Distributable VFP System

Kurt, I was not aware that an APP differed from an EXE in that respect. You can ReFox either, no? Can you still see an APP's code even if you tick the 'Encrypt' checkbox? Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kurt Wendt Sent:

RE: Splitting of Distributable VFP System

Kurt, Sorry for the confusion. This is NOT what I said. I meant that APPs, like EXEs can be encrypted in VFP proper (Project Info/Encrypted) so that the contents cannot be viewed in an editor. My reference to ReFox was only to the extent that APPs, just like EXEs, are NOT immune to ReFox. In

RE: Splitting of Distributable VFP System

Hi Kurt, I don't see why you wouldn't split into several APPs called from one central EXE. No FLL or DLL required for splitting. Certainly no registry stuff either. The one challenge I've had with splitting is to be careful with your calls so the project manager does not end up pulling every

RE: VFP9-History file

I loop through various levels of PROGRAM() From HELP: Returns the name of the program at a specified program level, the name of the currently executing program, the current program level, or the name of the program executing when an error occurred. PROGRAM([nLevel]) Henry -Original

RE: Find Dialog buttons disabled

I do rerun the mpr and the Cut/Copy/Paste bars in the top EDIT menu are enabled; The Find... bar is not. The Find bar is enabled on the shortcut (which is run AFTER the modal form loads) but the resulting FIND dialog has the FIND NEXT and REPLACE buttons disabled. Confused... -Original

Find Dialog buttons disabled

Hi, VFP 9 SP1 I just added _med_find to a shortcut on edit boxes. The find dialog comes up but the the FIND and REPLACE buttons are always disabled. My forms are modal. I suspect this is the reason. Any way around this? Or is there another reason? Thanks, Henry

RE: Find Dialog buttons disabled

Hey Ed, I think you're referring to the menu bars being disabled. I am talking about the Find Dialog itself having the 2 BUTTONS disabled ('Find Next' and 'Replace'). Hope you don't mind but I sent you a screen capture to your personal email. Henry -Original Message- From: [EMAIL

RE: [NF] is there a file limit when copying in windows explorer on XP?

Hi Alan, I use TeraCopy too. I occasionally get a write error when copying to a memory stick. Using another stick does not help. Ever had this problem? Excellent queuing otherwise. Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alan Bourke

SetAll(FontItalic

Hello all, These 4 statements are in the INIT of a grid. Any idea why statements 14 work and 23 do not? Why won't FontItalic take an expression that evaluates to a logical? ERROR: Data type is invalid for this property *1 This.SetAll(DynamicBackColor, ;

RE: SetAll(FontItalic - SOLVED (sorry!)

Of course, as soon as I hit SEND, I notice that it should have been DYNAMICfontitalic. Still, why would 23 fail but not 4? Note: Changing it to Dynamic DID resolve. This is now just a curiosity question. Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On

RE: SetAll(FontItalic - SOLVED (sorry!)

Of course (again), since it is not DYNAMIC, it does not expect an evaluated condition. I hate Mondays... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 2008-07-21 10:56 AM To: [EMAIL PROTECTED] Subject: RE: SetAll(FontItalic -

RE: SetAll(FontItalic

Thanks for the reply, Ted. I had already slapped myself on the head for missing the obvious. Still, your additional slap is appreciated. I would like to note, though, that it only became obvious after I sent the 1st message. There is definite value in formulating one's problem. It helps lift

Writing to a PDF form

The situation: - - There's a 37-page PDF form that someone created - Turns out 1/3 of the fields come from a report my VFP9 application generates - Users think it's normal to re-type my report into the PDF form - I think otherwise... The question: A PDF form must have

RE: Writing to a PDF form

Hi John, I was afraid of speed-readers who will miss the caveat that said: It is not an option to re-generate the PDF form from the app. I simply want to alter an existing PDF file. ;-) Thx Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John

RE: Writing to a PDF form

Dave, Thanks a lot for the reply. YES, I would definitely appreciate a working example if you have it. In the meantime, I've learned a bit more about the PDf just in case it makes a difference: It is created and then run through Adobe LiveCycle (sp?) which makes it editable with Adobe Reader

RE: Program Key

I translate my MD5 hash to an alpha-only string in a second pass. Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kent Belan Sent: 2008-05-06 1:24 PM To: [EMAIL PROTECTED] Subject: RE: Program Key Hello, I am getting closer to a solution but now

RE: Program Key

Hey Kent, Here's the code segment that does it: lcReturn = [] For I = 1 To Len(tcString) lnAscii = Asc(Substr(tcString,I,1)) ln1 = Int((lnAscii-1)/26) + 1 ln2 = Iif(Mod(lnAscii,26)=0,26,Mod(lnAscii,26)) lcReturn = lcReturn + Chr(64+ln1) + Chr(64+ln2) Endfor

RE: Program Key

I use keys that include the client's name. This way, the keys 'brand' the software for the one client and are useless to pass around. Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kent Belan Sent: 2008-05-05 8:10 AM To: [EMAIL PROTECTED]

RE: Program Key

Unfortunately, some places do use the user1, user2 approach of sharing one user ID amopng many same-type users. I try to educate the Admin that all audits and activity logs are useless that way as you cannot pin any activity on a user. The response usually reflects how relevant (or not) this

RE: Program Key

Hi Kent, My activation email contains 3 strings that the user copies and pastes into 3 boxes. There is also a 1-click wizard that parses the email and plugs the 3 strings for you. I do not attach anything as this adds the complexity of WHERE to save the file and how to find it later.

RE: Program Key

I've never been there. I don't sell my software in the private sector (it's mostly government). I've people talk about using dongles. Would that work for you? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pete Theisen Sent: 2008-05-05 11:41 AM To:

RE: Program Key

That's right. My weapon is that the screens but mostly the reports all sport the unchangeable name. Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Hill Sent: 2008-05-05 11:01 AM To: [EMAIL PROTECTED] Subject: Re: Program Key Make sure you

RE: VFP7: Gather memvar fields not working

I agree. SCATTER NAME is more contained and I have never had problems with it. It is also easier for debugging as the MEMVARs don't appear all over the alpha-sorted memory list. Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Coleman

RE: Parametized WHERE clause (VFP9) -SOLVED

Hi Eurico, Thanks for the reply. Why 'remove the inner join', though? I did end up replacing the field with Thisform.nCurrentClient and that resolved it. Thanks to all who replied. Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Eurico

RE: Parametized WHERE clause (VFP9) -SOLVED

Hi Dave, It makes a LOT of sense. I am just surprised that it did work in other views. I agree totally that it must be weird to rely on a value that is affected by scan happening through the table. I have changed to thisform.something and avoided this problem all together. Thank you, as

Parametized WHERE clause (VFP9)

Any idea why this SQL is returning nothing? If I replace '?Client.pk_Client' with its value, 102, I get exactly what I need. I use this ?Client.pk_Client often in other view and have no problem. == Select Client.Lname, Client.Fname, ;

RE: Parametized WHERE clause (VFP9)

Hi Vince, Pk_Client is an Integer field. Thx Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vince Teachout Sent: 2008-01-24 2:05 PM To: [EMAIL PROTECTED] Subject: Re: Parametized WHERE clause (VFP9) [EMAIL PROTECTED] wrote: Any idea why this

RE: Parametized WHERE clause (VFP9)

Two things: 1- I use in various other views and it works fine. E.g. === CREATE SQL VIEW VDIET ; AS SELECT NVL(Client.lname,Space(25)) AS lname, ; NVL(Client.fname,Space(25)) AS fname, ; Diet.fk_client, ; Diet.pk_diet ;

Renaming a DB

I know renaming DBs is a no-no but I need to temporarily rename my DB during a restore from structure changes so I am not using 2 DBs (old and new) with the same name. Can anyone help? NOTE: If I manually rename a database in the project manager, it handles all the backlinks in every member

RE: Renaming a DB

Got it!!! Thanks a lot, Paul. Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Newton Sent: 2008-01-15 5:02 PM To: [EMAIL PROTECTED] Subject: Re: Renaming a DB Henry Google Backlink.PRG - and you'll find what you need at foxite.com HTH

RE: CHR() code for TAB character ?

I think ANSI only works if you use 4 digits. Alt-0196 will give Ä That's what I use! Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Hill Sent: 2007-11-21 2:24 PM To: [EMAIL PROTECTED] Subject: Re: CHR() code for TAB character ? On Nov 21,

FoxSpell v3.0h questions

I have just tried Foxspell in my app. Excellent piece of software indeed. Questions: 1- When it pops up, all controls are dead until you click on the RTF control, then everything works. How can I fix this? 2- Any issues with INTL? I plopped the 4 INTL lines of code in splform.Init() and it

RE: FoxSpell v3.0h questions

Allo Frédéric, Thank you for your generous offer. So, if I understand correctly, what would be needed when in French mode, is to insert a call to your French Soundex instead of the default one and switch the dictionary table property? INTL takes care of all the displays. Am I oversimplifying?

RE: FoxSpell v3.0h questions

Well, if you don't mind sending them my way, I'll gladly share the finished result (assuming, of course, I succeed ;-)) Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Frédéric Steczycki Sent: 2007-11-09 11:09 AM To: [EMAIL PROTECTED] Subject:

RE: FoxSpell v3.0h questions

www.sendthisfile.com? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Frédéric Steczycki Sent: 2007-11-09 11:27 AM To: [EMAIL PROTECTED] Subject: RE: FoxSpell v3.0h questions Mail back with an error... 5MB is too large for the remote host...

RE: FoxSpell v3.0h questions

Hi Dave, Any idea about the RTF clicking being necessary before you can actually select a replacement word? Thx Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Crozier Sent: 2007-11-09 11:37 AM To: [EMAIL PROTECTED] Subject: RE: FoxSpell

RE: [ADMIN] Away for a few days

Good luck, Ed! Give 'em hell!!! ;-)) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ed Leafe Sent: 2007-10-29 10:05 AM To: [EMAIL PROTECTED] Subject: [ADMIN] Away for a few days I will be out of my office until Friday working at a client

RE: [ADMIN] Away for a few days

And being soccer folks, Ed's kids will have no trouble kicking any server into submission. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ed Leafe Sent: 2007-10-29 12:47 PM To: [EMAIL PROTECTED] Subject: Re: [ADMIN] Away for a few days On Oct 29,

VFP9 FTP and SSL

I use BigSpeed to zip files and Robert Abram's FTP.prg to send/receive them. It works well. Now I need to encrypt the zip (128-bit) and secure the FTP transfer. BigSpeed makes no mention of encryption levels (basic encryption??). FTP.prg has no secure options. Can anyone recommend different

RE: VFP9 FTP and SSL

What does Craig have to say about this? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Newton Sent: 2007-10-02 3:26 PM To: [EMAIL PROTECTED] Subject: Re: VFP9 FTP and SSL [EMAIL PROTECTED] wrote: So you dropped BigSpeed for Craig's zipper? No

RE: VFP9 FTP and SSL

Thanks again, Malcolm. Now I have to keep looking for an FTP alternative. Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Malcolm Greene Sent: 2007-10-02 3:19 PM To: [EMAIL PROTECTED] Subject: RE: VFP9 FTP and SSL Henry, So you dropped BigSpeed

RE: VFP9 FTP and SSL

Thanks all for the many options. I'll start digging... Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tracy Pearson Sent: 2007-10-02 3:41 PM To: [EMAIL PROTECTED] Subject: RE: VFP9 FTP and SSL I've not used the product. http://weonlydo.com has

RE: Internet Update

That's what I call positive reinforcement! Thanks, Allen and Michael for sharing your similar approaches. Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MB Software Solutions Sent: 2007-08-22 10:48 AM To: [EMAIL PROTECTED] Subject: Re: Internet

RE: VFP9-Icon

Assuming the forms are based on a class, you add the button once in that class. What do you mean by fpw method? Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sytze de Boer Sent: 2007-08-05 3:28 AM To: [EMAIL PROTECTED] Subject: VFP9-Icon Hi

RE: Pet peeve with debugging a PRG

Cool! Thanks, Dave! Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Crozier Sent: 2007-08-03 11:02 AM To: [EMAIL PROTECTED] Subject: RE: Pet peeve with debugging a PRG Jack, With VFP9 its in there already, just type: ifend space docase

RE: Pet peeve with debugging a PRG

Wasn't ctrl-G - Find Again? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen Sent: 2007-08-03 1:53 PM To: [EMAIL PROTECTED] Subject: RE: Pet peeve with debugging a PRG I thought goto was control G at one time but not now it seems not Allen

Forcing filename case in XP

Is there a way to force filename case when using RENAME? E.g. lcSource = abc.xyz lcTarget = ABC1234.xyz Rename (lcSource) To (lcTarget) Is yielding abc1234.xyz Thx, Henry ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

RE: Forcing filename case in XP - Solved?

Paul, .Name let me change case nicely on 2000 at work. I will try it tonight on XP. Thanks for pointing me to the solution. Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Newton Sent: 2007-07-17 8:45 AM To: [EMAIL PROTECTED] Subject: Re:

Weird one: 1 file not copied

Hi guys, One file out of 272 is not copying to the network. Anyone got any idea why this is happening? (VFP9SP1 on W2000) Please see comments in code. For lnDir = 1 To Alen(laDirs) Thisform.cntThermo1.Set(lnDir) lcCurDir = laDirs[lnDir] If

RE: Weird one: 1 file not copied

_ifis.ini -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ed Leafe Sent: 2007-07-17 12:35 PM To: [EMAIL PROTECTED] Subject: Re: Weird one: 1 file not copied On Jul 17, 2007, at 12:16 PM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: One file out of

RE: Weird one: 1 file not copied - SOLVED

BINGO!! You got it. _ifis.ini was, in fact, in the exe. It should have been EXCLUDED in the project. I only have it there for ease of finding it. Thanks for the help! Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tracy Pearson Sent:

RE: COPY FILE insists on using included file

I am glad to hear this a known 'behaviour'. Thanks for the solution AND the many other calls listed on that page. Very helpful! Thanks, Tracy. Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tracy Pearson Sent: 2007-07-05 10:47 AM To: [EMAIL

COPY FILE insists on using included file

Hi, Does anyone know you can force VFP9 to respect a fullpathed COPY FILE command instead of ignoring the path and insisting on copying from an included file? e.g. Copy File (lcDatSet + lcCurDir + laFiles[I,1]) To (lcPathNet + lcCurDir + laFiles[I,1]) is ignoring an ico file found in

RE: COPY FILE insists on using included file

Thanks for the suggestion, Richard. Tried it and it still goes to the stored path, not the explicitely stated one. Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard Kaye Sent: 2007-07-03 3:35 PM To: [EMAIL PROTECTED] Subject: Re: COPY FILE

How can a long mouse click repeatedly cause an action?

Is there a way to make a prolonged mouse click keep doing something until you release the button? I tried mousedown but it fires only once. Context: next/prev year in a calendar Thx Henry ___ Post Messages to: ProFox@leafe.com Subscription

RE: How can a long mouse click repeatedly cause an action?

Included for backward compatibility For shame... ;-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ted Roche Sent: 2007-05-24 4:41 PM To: [EMAIL PROTECTED] Subject: Re: How can a long mouse click repeatedly cause an action? DO WHILE MDOWN() On

RE: How can a long mouse click repeatedly cause an action?

Works great in MouseDown! Thanks a lot, Ted. Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ted Roche Sent: 2007-05-24 4:41 PM To: [EMAIL PROTECTED] Subject: Re: How can a long mouse click repeatedly cause an action? DO WHILE MDOWN() On

RE: How can a long mouse click repeatedly cause an action?

But seriously, Ted, what is the equivalent if you want to stick to what they consider current code? Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ted Roche Sent: 2007-05-24 4:41 PM To: [EMAIL PROTECTED] Subject: Re: How can a long mouse click

RE: How can a long mouse click repeatedly cause an action?

That's exactly what I did and it works great, Thanks. I only ask because I expected a disgraced function (Included for backward compatibility. Use the Click, MouseDown, MouseUp, and RightClick events instead.) to have a direct replacement. Thanks again for the help, Henry -Original

RE: [NF] Lightweight Task Manager

I like this one http://www.beiley.com/remind-me/index.html Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Jarvis Sent: 2007-05-18 5:23 PM To: [EMAIL PROTECTED] Subject: [NF] Lightweight Task Manager Can someone recommend a nicely

Encrypting zips with Big Speed zip dll

I've been using BSZip for a year with great success. Even though I bought it, I never received any documentation or link thereto. Does anyone know how/if BS can do encryption? Sample VFP code would be greatly appreciated. Here is what I currently use:

RE: Looking For Graphing Ideas

What's the limit of shape objects one can throw on a form? Is it only ram-dependent? If the number of shapes is not an issue, this should be doable in VFP. I've done similar stuff but with much less objects. HTH, Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: Sending mail from VFP w/o mailto

I may be wrong, but I think BLAT will cover any client except OUTLOOK. If I AM wrong, I wouldn't mind learning what to tweak to get BLAT to work without an SMTP server specified. Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ed Leafe Sent:

RE: List of tables in an ODBC Access mdb

Awesome! Thanks, Chet. Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chet Gardiner Sent: 2007-03-22 3:30 PM To: [EMAIL PROTECTED] Subject: Re: List of tables in an ODBC Access mdb I've included a program below that will: 1) Open the MDB 2)

[NF] Simple file uploading on a website

Hi, I need to provide users with the ability to upload large files. Very much like Senduit.com or SendThisFile.com Because of (govt) firewall restrictions, such sites are inaccessible from the office. How can I have a simple Browse/Upload added to my web site? Is it a simple thing to add?

RE: [NF] Simple file uploading on a website

Whil, Thanks for the offer. I do have Web Connect and I would surely appreciate the code. This functionality has been sorely lacking in my app. But this immediate need is not VFP-driven. I simply need to add senduit.com-like functionality to my website. Hopefully by manually plugging some

RE: [NF] Simple file uploading on a website

5 to 15 meg zips Most users can do this very easily with senduit.com The problem is I cannot download their files or upload back to them because our firewall blocks commercial file transfer sites. My provider supports PHP but not ASP. -Original Message- From: [EMAIL PROTECTED]

How is my spinner being populated?

Hi, Is there a way to tell if spinner control is being populated from the Keyboard or through the spinner arrows? Reason: During ARROW entry, I want InteractiveChange to update totals. During KEYBOARD, entry, I should update totals in VALID instead (because of IC code, the spinner will only

RE: How is my spinner being populated?

Duh!! My sincerest apologies and thanks, Michael. I was so stuck on looking exclusively at properties. Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MB Software Solutions Sent: 2007-02-22 10:57 AM To: [EMAIL PROTECTED] Subject: Re: How is my

RE: How is my spinner being populated?

Thanks for the reply, Jack. Any comments on Michael's UpClick/DownClick idea? Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jack Skelley Sent: 2007-02-22 11:05 AM To: [EMAIL PROTECTED] Subject: Re: How is my spinner being populated? Henry: In

RE: How is my spinner being populated?

Thanks for the reply, Jack. For my purposes, using the up/down cursors has the same desired effect as using the mouse on the arrows. I have moved my IC code to Valid and added This.Valid() in UpClik() and DownClick(). The beahaviour is now exactly what I wanted. Thanks to you and to all who

RE: verts on vista

Shot in the dark here: Is there something similar to C:\Documents and Settings\All Users and can you write to it? Henry (who has never seen Vista) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Whil Hentzen (Pro*) Sent: 2007-02-15 1:46 PM To: [EMAIL

RE: Invalid Foxuser File

John, I have had this when the 2 foxuser files are mismatched (i.e. one of them gets updated but not the other). Deleting them both and letting the Launcher replacing them ususally fixes the problem. I thought your scenario could be similar. Henry -Original Message- From: [EMAIL

ODBC to Access

Hi all, I'm having a hard time connecting to Access tables. I get this error no matter variation of ODBC driver I play with: Connectivity error: [Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'tablename' I am using VFP9 and Win2K. Any help would

RE: ODBC to Access - Solved

Nevermind. User permissions in Access. 1st time I have to do this. Weird! Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 2007-02-12 12:58 PM To: [EMAIL PROTECTED] Subject: ODBC to Access Hi all, I'm having a hard time

InDbc and Free Table

INDBC() can tell me if a table is part of this database. FREE TABLE can disconnect the table from a database. How can I tell if this table has a link to a DB that I need to remove? Issuing FREE TABLE blindly will generate an error if no DB link exists. There must be something obvious I'm

RE: InDbc and Free Table

Hi Ted, This is part of an auto-conversion of data from previous versions of the software. Depending on how up to date the app is, users could: - not have the table 'Zardoz'. Setup will copy it and it will be part of the DBC (but their own DBC won't know this yet) - have it as a free table

RE: InDbc and Free Table

Now I see. USE Table would open the DB if one is attached. You're checking before and after. Interesting ;-)) What do you think of the Try/Ctach in my other message? The test went ok. Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tracy Pearson

RE: InDbc and Free Table

But isn't the FINALLY the proper place to evaluate loFreeTable? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tracy Pearson Sent: 2007-01-24 1:55 PM To: [EMAIL PROTECTED] Subject: RE: InDbc and Free Table What do you think of the Try/Catch in my

RE: [NF] Excel custom form question

No, I believe it's who's (who has) You wuz right, Michael! ;-)) Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MB Software Solutions Sent: 2006-12-14 11:15 AM To: [EMAIL PROTECTED] Subject: Re: [NF] Excel custom form question For all you

Why will VFP9 not QUIT?

Anybody knows of a reason why VFP 9 just refuses to QUIT? Tried: ON SHUTDOWN RELEASE ALL CANCEL CLEAR ALL QUIT just does nothing. No error. It happens occasionally, seemingly after I run a PRG generated by GenDbc.prg (to recreate my DB). Thanks, Henry

RE: Why will VFP9 not QUIT?

Now why didn't I think of that? I could also unplug the computer, I guess ;-)) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jean Laeremans Sent: 2006-10-12 9:38 AM To: [EMAIL PROTECTED] Subject: Re: Why will VFP9 not QUIT? On 10/12/06, Hal Kaplan

RE: Why will VFP9 not QUIT?

Not sure I tried CLOSE ALL - stand by File/Close closed the command window (or the active window) File/Exit is ignored H -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Cushing Sent: 2006-10-12 9:51 AM To: [EMAIL PROTECTED] Subject: Re: Why

RE: Why will VFP9 not QUIT?

Actually, hold that 1st thought. The problem does not occur if the debugger was never opened in the session. No code has been changed except I removed a SET STEP ON I had. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Hawksworth Sent:

RE: Why will VFP9 not QUIT?

How quickly a serious question degenerates into global morning silliness ;-)) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hal Kaplan Sent: 2006-10-12 9:53 AM To: [EMAIL PROTECTED] Subject: RE: Why will VFP9 not QUIT? = -Original Message- = 

RE: Why will VFP9 not QUIT?

Ok, here's what I've discovered: This is my code If llChanged MsgSvc([Data Structure Changed]) Set Step On Do HifisDbc--- these 3 programs are DB regenerators Do CusDbc Do CoordDbc On Shutdown Quit Endif If I remove the SET STEP ON, it exits properly. With

RE: Why will VFP9 not QUIT?

Nope. All were equally ignored. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Malcolm Greene Sent: 2006-10-12 9:58 AM To: [EMAIL PROTECTED] Subject: RE: Why will VFP9 not QUIT? Henry, Type the following in the command window: cancel on error set

RE: Why will VFP9 not QUIT?

germane \juhr-MAYN\, adjective: Appropriate or fitting; relevant. New word for me. Thanks, Hal! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hal Kaplan Sent: 2006-10-12 10:10 AM To: [EMAIL PROTECTED] Subject: RE: Why will VFP9 not QUIT? This

RE: Development tool to create tiny loader for VFP app

Malcolm, My loader is in VFP9 and it uses its own libraries which are separate from the libraries that are carried over to the client workstation. This is no match for a 50k exe but it does the job nicely. Henry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On

  1   2   >