Re: [NF] Folder Encryption on a USB Device
I'm using v. 6.0a which I have on a memory stick, it works fine on 32 bit and 64 bit versions of windows. Having it on the same stick as the encrypted folder(s) does mean that if the stick is intercepted the bad guys know what encryption you used, but with a very strong password (NOT on the stick!) it's still secure. [P.S. My last post was copied to me, which is the first time for a long time - despite it having been set in my preferences for many months.] On 20/01/2015 23:20, John Weller wrote: Thanks Andy, I looked at TrueCrypt but the setup file said it was for the wrong version of Windows, I assume it was 32 bit and my system is 64 bit. Regards John John Weller 01380 723235 07976 393631 -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of AndyHC Sent: 20 January 2015 17:20 To: profoxt...@leafe.com Subject: Re: [NF] Folder Encryption on a USB Device TrueCrypt - the warnings you'll see on websites are probably 'political', but there are older * definitely * safe versions out there. [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/54bf2bfa.2020...@hawthorncottage.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Web page animation or flow of graphics
For some reason, it doesn't work yet in Chrome or Safari, but Firefox and IE are good. Working on it http://information-architecture.com/ncel/LogoScroll.html On Mon, Jan 19, 2015 at 4:49 PM, Ken Kixmoeller (ProFox) < foxh...@information-architecture.com> wrote: > Thanks, all! Some interesting and likely-sounding roads for me to stumble > down. (Ah, another theme, since I was talking about beer previously.) > > On Mon, Jan 19, 2015 at 3:04 PM, Alan Bourke > wrote: > >> >> >> I search. I see Action Script in Flash. I see possible Java approaches. >> > Maybe JavaScriipt? >> >> These days the tendency is to avoid plugins like Flash and Silverlight. >> This sounds to me sort of like a Boostrap or JQuery UI job. >> >> -- >> Alan Bourke >> alanpbourke (at) fastmail (dot) fm >> >> On Mon, 19 Jan 2015, at 07:20 PM, Ken Kixmoeller (ProFox) wrote: >> > Hi - --- - >> > >> > Please some help on getting me started on this. I have a client for web >> > work who is stuck on this idea: >> > >> > -- the client is a membership association. They want the logos of their >> > members to scroll on their web site "home" page, sort of like a marquee. >> > The staff folks have already gathered the logos and made them all the >> > same >> > size. >> > >> > -- ideally, they come up randomly, so one member isn't highlighted more >> > than another. >> > >> > So, this is a programming situation, as opposed to some static Flash >> > object >> > or something. So far, the logo files are just in a folder, but I could >> > add >> > the file names and paths into a table. >> > >> > I search. I see Action Script in Flash. I see possible Java approaches. >> > Maybe JavaScriipt? >> > >> > Ideas? Suggestions? Search terms? (Searching is hard as I just get a >> > bunch >> > of links showing how to create an animated gif.) >> > >> > I would deeply appreciate any ideas you have to get me kicked down the >> > road >> > a couple of blocks. >> > >> > Ken >> > >> > >> > --- StripMime Report -- processed MIME parts --- >> > multipart/alternative >> > text/plain (text body -- kept) >> > text/html >> > --- >> > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAFyV=LkzET_QyB6b1f=Rfi9Lc=yy9e_xfhgqkpeq8hy7dvq...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Folder Encryption on a USB Device
I didn't read the whole thread so forgive me if this is a repeat. I have been using: https://diskcryptor.net/wiki/Main_Page and it is incredibly easy to use. It only encrypts entire volumes but that works for me. On 1/20/2015 8:21 AM, John Weller wrote:I occasionally have to carry files containing name and address information from one location to another on a USB memory stick. To comply with the UK Data Protection Act those files should be encrypted or protected in some way. I am looking for a utility that will allow me to do that - any suggestions? It should be cheap, preferably free :-) and be stand-alone; I want to be able to plug it into any computer and after entering a suitable password be able to copy the files in an unencrypted state on to that PC. I know there are several apps about that claim to do something similar but the ones I have seen don't seem to be stand-alone. Has anyone any experience of this and can recommend a suitable app? Regards John John Weller 01380 723235 07976 393631 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/003301d034c4$cfc2aa20$6f47fe60$@johnweller.co.uk ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious. Report [OT] Abuse: http://leafe.com/reportAbuse/003301d034c4$cfc2aa20$6f47fe60$@johnweller.co.uk -- Jeff Jeff Johnson j...@san-dc.com SanDC, Inc. (623) 582-0323 SMS (602) 717-5476 Fax 623-869-0675 www.san-dc.com www.cremationtracker.com www.agentrelationshipmanager.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/54bee622.2080...@san-dc.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Folder Encryption on a USB Device
TrueCrypt et al require a driver to be installed so that the TrueCrypt files can be mounted and used as drives. So you're in trouble there too on these locked-down machines. -- Alan Bourke alanpbourke (at) fastmail (dot) fm On Tue, 20 Jan 2015, at 10:19 PM, Ted Roche wrote: > On Tue, Jan 20, 2015 at 3:01 PM, Paul Hill > wrote: > > > > > Others have suggested TrueCrypt, which is great, but wouldn't an > > archive utility do the job? > > I use 7-Zip. Free and good encryption. I use it for backups to > > portable hard drives. > > > > But wouldn't 7-Zip need to be installed on the target machines? I have > clients whose machines are completely locked down. > > Unless, I suppose, you were carrying a PortableApps USB tab, too. ( > http://portableapps.com/apps) > > -- > Ted Roche > Ted Roche & Associates, LLC > http://www.tedroche.com > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1421792964.3337946.216467161.45d04...@webmail.messagingengine.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Folder Encryption on a USB Device
On Tue, Jan 20, 2015 at 3:01 PM, Paul Hill wrote: > > Others have suggested TrueCrypt, which is great, but wouldn't an > archive utility do the job? > I use 7-Zip. Free and good encryption. I use it for backups to > portable hard drives. > But wouldn't 7-Zip need to be installed on the target machines? I have clients whose machines are completely locked down. Unless, I suppose, you were carrying a PortableApps USB tab, too. ( http://portableapps.com/apps) -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CACW6n4tS+z3vYtLPC=+vqzpb8abgc1migcnep1ngnrhbccz...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] Folder Encryption on a USB Device
An excellent idea which I hadn't thought of! Thank you. John Weller 01380 723235 07976 393631 > Others have suggested TrueCrypt, which is great, but wouldn't an archive > utility do the job? > I use 7-Zip. Free and good encryption. I use it for backups to portable hard > drives. > ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/001001d034fa$e7978680$b6c69380$@johnweller.co.uk ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Folder Encryption on a USB Device
On Tue, 20 Jan 2015, at 08:01 PM, Paul Hill wrote: > Others have suggested TrueCrypt, which is great, but wouldn't an > archive utility do the job? > I use 7-Zip. Free and good encryption. I use it for backups to > portable hard drives. > Yes, 7-Zip is great (produces archives around half the size of ZIP) and supports AES256 -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1421789332.3322842.216442925.17b94...@webmail.messagingengine.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Folder Encryption on a USB Device
On 20 January 2015 at 15:21, John Weller wrote: > > I occasionally have to carry files containing name and address information > from one location to another on a USB memory stick. To comply with the UK > Data Protection Act those files should be encrypted or protected in some > way. Others have suggested TrueCrypt, which is great, but wouldn't an archive utility do the job? I use 7-Zip. Free and good encryption. I use it for backups to portable hard drives. -- Paul ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cadwx0+jalgzdffmqmkxmpai63zep0ycp61xstz8ltumbf8r...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Folder Encryption on a USB Device
We are using v7.1a and we believe it is safe (at least for now). Here is a link that we trust: https://www.grc.com/misc/truecrypt/truecrypt.htm (DO NOT USE V7.2) On 1/20/2015 9:19 AM, AndyHC wrote: TrueCrypt - the warnings you'll see on websites are probably 'political', but there are older * definitely * safe versions out there. On 20/01/2015 20:51, John Weller wrote: I occasionally have to carry files containing name and address information from one location to another on a USB memory stick. To comply with the UK Data Protection Act those files should be encrypted or protected in some way. I am looking for a utility that will allow me to do that - any suggestions? It should be cheap, preferably free :-) and be stand-alone; I want to be able to plug it into any computer and after entering a suitable password be able to copy the files in an unencrypted state on to that PC. I know there are several apps about that claim to do something similar but the ones I have seen don't seem to be stand-alone. Has anyone any experience of this and can recommend a suitable app? Regards John John Weller 01380 723235 07976 393631 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/54bea3b6.9070...@gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: using select in a case
I didn't say you should use a UDF; I said you can use a UDF. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Allen Sent: Tuesday, January 20, 2015 12:50 PM To: profoxt...@leafe.com Subject: RE: using select in a case Doing away with a UDF for this case was what I was after. I'm not anti UDF. I do use them elsewhere Why do you say use a UDF? I don't need the pointer to remain in my case. Al -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: 20 January 2015 18:34 To: profoxt...@leafe.com Subject: RE: using select in a case It can if you use a VFP UDF. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cy1pr10mb02182259f840a65f8e8a5079d2...@cy1pr10mb0218.namprd10.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: using select in a case
If I understand the question, no, you can't use a VFP UDF in a SQL passthrough query. I was just replying back to Man-Wai to clarify that a VFP SQL statement can call VFP UDFs and they can potentially be moving record pointers or changing work areas or anything else data related you might do with pure VFP. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of AndyHC Sent: Tuesday, January 20, 2015 12:44 PM To: profoxt...@leafe.com Subject: Re: using select in a case Can you use a UDF in a *SQL* select statement? On 20/01/2015 23:04, Richard Kaye wrote: > It can if you use a VFP UDF. > > -- > > rk > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Man-wai > Chang > Sent: Tuesday, January 20, 2015 12:20 PM > To: profoxt...@leafe.com > Subject: Re: using select in a case > > A SQL SELECT also doesn't move the record pointer... :) > > On Tue, Jan 20, 2015 at 10:09 PM, Jean MAURICE wrote: >> I think that LOOKUP() can solve your issue ... > -- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cy1pr10mb0218b2158525a67ae5b195b3d2...@cy1pr10mb0218.namprd10.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] Folder Encryption on a USB Device
Thanks Andy, I looked at TrueCrypt but the setup file said it was for the wrong version of Windows, I assume it was 32 bit and my system is 64 bit. Regards John John Weller 01380 723235 07976 393631 > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of > AndyHC > Sent: 20 January 2015 17:20 > To: profoxt...@leafe.com > Subject: Re: [NF] Folder Encryption on a USB Device > > TrueCrypt - the warnings you'll see on websites are probably 'political', but > there are older * definitely * safe versions out there. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/005c01d034d9$91d86550$b5892ff0$@johnweller.co.uk ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: using select in a case
Doing away with a UDF for this case was what I was after. I'm not anti UDF. I do use them elsewhere Why do you say use a UDF? I don't need the pointer to remain in my case. Al -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: 20 January 2015 18:34 To: profoxt...@leafe.com Subject: RE: using select in a case It can if you use a VFP UDF. --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/00b001d034d9$7bf05540$73d0ffc0$@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] Folder Encryption on a USB Device
No, it merely needs to be protected. John Weller 01380 723235 07976 393631 > > Do you need a registered encryption algorithm/tool to abide to the Act? :) > ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/005b01d034d9$4be26460$e3a72d20$@johnweller.co.uk ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: using select in a case
Can you use a UDF in a *SQL* select statement? On 20/01/2015 23:04, Richard Kaye wrote: It can if you use a VFP UDF. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Man-wai Chang Sent: Tuesday, January 20, 2015 12:20 PM To: profoxt...@leafe.com Subject: Re: using select in a case A SQL SELECT also doesn't move the record pointer... :) On Tue, Jan 20, 2015 at 10:09 PM, Jean MAURICE wrote: I think that LOOKUP() can solve your issue ... -- .~. 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 be with you! [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/54be93c9.3060...@hawthorncottage.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: using select in a case
It can if you use a VFP UDF. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Man-wai Chang Sent: Tuesday, January 20, 2015 12:20 PM To: profoxt...@leafe.com Subject: Re: using select in a case A SQL SELECT also doesn't move the record pointer... :) On Tue, Jan 20, 2015 at 10:09 PM, Jean MAURICE wrote: > I think that LOOKUP() can solve your issue ... -- .~. 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 be with you! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cy1pr10mb0218423b7abeeb1c23c16870d2...@cy1pr10mb0218.namprd10.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] Folder Encryption on a USB Device
Thanks Alan, they look as though they will do the job. Regards John John Weller 01380 723235 07976 393631 > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of > Alan Bourke > Sent: 20 January 2015 15:45 > To: profoxt...@leafe.com > Subject: Re: [NF] Folder Encryption on a USB Device > > http://www.howtogeek.com/203708/3-alternatives-to-the-now-defunct- > truecrypt-for-your-encryption-needs/ > > ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/005001d034d7$52d04be0$f870e3a0$@johnweller.co.uk ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Folder Encryption on a USB Device
Do you need a registered encryption algorithm/tool to abide to the Act? :) On Tue, Jan 20, 2015 at 11:21 PM, John Weller wrote: > I occasionally have to carry files containing name and address information > from one location to another on a USB memory stick. To comply with the UK > Data Protection Act those files should be encrypted or protected in some > way. I am looking for a utility that will allow me to do that - any > suggestions? It should be cheap, preferably free :-) and be stand-alone; I -- .~. 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 be with you! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAGv=mjbrr4uc4wknlgjzdyvjdkl8a5b1jnjwmxfjpsen1k0...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Folder Encryption on a USB Device
TrueCrypt - the warnings you'll see on websites are probably 'political', but there are older * definitely * safe versions out there. On 20/01/2015 20:51, John Weller wrote: I occasionally have to carry files containing name and address information from one location to another on a USB memory stick. To comply with the UK Data Protection Act those files should be encrypted or protected in some way. I am looking for a utility that will allow me to do that - any suggestions? It should be cheap, preferably free :-) and be stand-alone; I want to be able to plug it into any computer and after entering a suitable password be able to copy the files in an unencrypted state on to that PC. I know there are several apps about that claim to do something similar but the ones I have seen don't seem to be stand-alone. Has anyone any experience of this and can recommend a suitable app? Regards John John Weller 01380 723235 07976 393631 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/54be8e3d.10...@hawthorncottage.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: using select in a case
A SQL SELECT also doesn't move the record pointer... :) On Tue, Jan 20, 2015 at 10:09 PM, Jean MAURICE wrote: > I think that LOOKUP() can solve your issue ... -- .~. 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 be with you! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAGv=mjdf-z0vgw29atpt53i8oq7zst6vga2h+-urmjcmaa0...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Do you pre-process data for a report?
In my case I had monster joins many times to make only 5 #tables. The refactor gets the bare minimum of rows from the primary table with only a few joins to make my primary #temp_bal table. I then verify if I need to get amounts for the first numeric column, opening balance, or not depending on period chosen. I then sum the amount column to cover between the periods. Last bit is to bring non expense opening bals from other table. For period 13 it use to take 7-15 min to run. Now under 1 min, returns 16,000 rows on average. On Tue, Jan 20, 2015 at 10:42 AM, Ken Kixmoeller (ProFox) < foxh...@information-architecture.com> wrote: > I always pre-select, too, but I often do it in two steps. Pre-select query > #1 is the simplest, fastest SQL which eliminates the obvious 99% of data > not needed for this answer. The second refines the raw results into the > precise ones. I find that two queries like this can run in 2-3 seconds, > where a single SQL statement to get the precise results can take 5x the > time. Plus, the two statements are easier to write! > > FWIW, > > Ken > > On Mon, Jan 19, 2015 at 7:13 PM, Gene Wirchenko wrote: > > > At 13:39 2015-01-16, Stephen Russell wrote: > > > > [snip] > > > > I can select the raw rows in a Select * from Where t_yer = 2014 and get > >> them in just over 2 min. > >> > >> Or I Pre-Sum the bastards with a group by and only bring back 48 > thousand > >> rows in 20 seconds. > >> > > > > Yes, I preprocess. Why grovel through more data than needed? > > > > Sincerely, > > > > Gene Wirchenko > > > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJidMYLRh+j6bOzA9XRYP=MuTz5KfbbsU80CBzA+0GV01Z=n...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Do you pre-process data for a report?
On 2015-01-20 11:42, Ken Kixmoeller (ProFox) wrote: I always pre-select, too, but I often do it in two steps. Pre-select query #1 is the simplest, fastest SQL which eliminates the obvious 99% of data not needed for this answer. The second refines the raw results into the precise ones. I find that two queries like this can run in 2-3 seconds, where a single SQL statement to get the precise results can take 5x the time. Plus, the two statements are easier to write! I use this approach too. I absolutely hate these colossal must-all-be-done-in-one-super-huge-SQL statements, even if it's slightly faster because I design things to be easily maintainable, rather than uber-geek. If I'm having to work on these apps later, I don't want to be cursing my previous show-off SQLs that I then have a hard-time understanding all those years later. Likewise, if somebody has to maintain my code, I want it to be easy for them too. Honestly, 2 seconds extra is not gonna make a world of difference for most reports. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/8ea0bd185d8d01cdd8dcef6d76ca7...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Do you pre-process data for a report?
I always pre-select, too, but I often do it in two steps. Pre-select query #1 is the simplest, fastest SQL which eliminates the obvious 99% of data not needed for this answer. The second refines the raw results into the precise ones. I find that two queries like this can run in 2-3 seconds, where a single SQL statement to get the precise results can take 5x the time. Plus, the two statements are easier to write! FWIW, Ken On Mon, Jan 19, 2015 at 7:13 PM, Gene Wirchenko wrote: > At 13:39 2015-01-16, Stephen Russell wrote: > > [snip] > > I can select the raw rows in a Select * from Where t_yer = 2014 and get >> them in just over 2 min. >> >> Or I Pre-Sum the bastards with a group by and only bring back 48 thousand >> rows in 20 seconds. >> > > Yes, I preprocess. Why grovel through more data than needed? > > Sincerely, > > Gene Wirchenko > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAFyV=lnr03t1u+d1ui+c5maxh_fgzck4czwdtumphdwrg0w...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Folder Encryption on a USB Device
http://www.howtogeek.com/203708/3-alternatives-to-the-now-defunct-truecrypt-for-your-encryption-needs/ -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1421768692.3470128.216288649.7ee94...@webmail.messagingengine.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] Folder Encryption on a USB Device
I occasionally have to carry files containing name and address information from one location to another on a USB memory stick. To comply with the UK Data Protection Act those files should be encrypted or protected in some way. I am looking for a utility that will allow me to do that - any suggestions? It should be cheap, preferably free :-) and be stand-alone; I want to be able to plug it into any computer and after entering a suitable password be able to copy the files in an unencrypted state on to that PC. I know there are several apps about that claim to do something similar but the ones I have seen don't seem to be stand-alone. Has anyone any experience of this and can recommend a suitable app? Regards John John Weller 01380 723235 07976 393631 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/003301d034c4$cfc2aa20$6f47fe60$@johnweller.co.uk ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: using select in a case
I've just checked. It does not change table. That ok. It does move pointer. So you can use Lookup(table2.field2,2,table2.field1) while being in table 1 and it stays on table1 but the pointer in table2 moves. Al -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 20 January 2015 15:58 To: profoxt...@leafe.com Subject: RE: using select in a case Tracy, Yes it does say that but must admit I used it before I noticed that and it always performed faultlessly. Either I was lucky or the doc may be incomplete. Dave --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/009f01d034c2$951b04a0$bf510de0$@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: using select in a case
Tracy, you are right : lookup moves the record pointer. There is a parameter in INDEXSEEK to say 'no move of record pointer'. LOOKUP returns a field value; INDEXSEEK a logical The Foxil Le 20/01/2015 15:55, Tracy Pearson a écrit : Dave, I don't think I've ever used the LOOKUP() function. Reading the help states it DOES move the record pointer. Even moves the related child tables records. Tracy Pearson PowerChurch Software [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/54be6e28.8080...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: using select in a case
On Tue, Jan 20, 2015 at 8:00 AM, Allen wrote: > Hi Foxgang > > I have a need in a case to read a field and select case depending on the > result. > Normally I would just make a UDF and locate and return the field value. > I am wondering though if there is a simple way avoiding extra methods. > > Example > > Case GetVal(2) = 6 > > > Function GetVal > LParameters LookFor > Select MyTable > Locate for Field1 = LookFor > Return Field2 > > Simplified but the idea is there. > > I'm wondering if the case can handle that in the line rather than the > separate proggy. > > Sort of case select Field2 from MyTable where Field1 = 2 = 6 > > Al > --- Why not an iif() -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJidMY+2tYPfkf=jcpq3xq6w33cnj_iw6uh1zs-vu6e_vsv...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: using select in a case
Tracy, Yes it does say that but must admit I used it before I noticed that and it always performed faultlessly. Either I was lucky or the doc may be incomplete. Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Tracy Pearson Sent: 20 January 2015 14:55 To: profox@leafe.com Subject: RE: using select in a case Dave Crozier wrote on 2015-01-20: > I agree with Jean, > Lookup() doesn't move the record pointer. In fact I have used it in a > sql statement to define a field using icase(). That may well be the way to accomplish what you are doing - or is the reason you need the case because you are involved in lots of inline code > > Dave > Dave, I don't think I've ever used the LOOKUP() function. Reading the help states it DOES move the record pointer. Even moves the related child tables records. Tracy Pearson PowerChurch Software [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/18725b8cd2d5d247873a2baf401d4ab2468ad...@ex2010-a-fpl.fpl.LOCAL ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: using select in a case
Dave Crozier wrote on 2015-01-20: > I agree with Jean, > Lookup() doesn't move the record pointer. In fact I have used it in a sql statement to define a field using icase(). That may well be the way to accomplish what you are doing - or is the reason you need the case because you are involved in lots of inline code > > Dave > Dave, I don't think I've ever used the LOOKUP() function. Reading the help states it DOES move the record pointer. Even moves the related child tables records. Tracy Pearson PowerChurch Software ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/01d034c1$138a5630$3a9f0290$@powerchurch.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: using select in a case
Aint that the truth. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 20 January 2015 15:37 To: profoxt...@leafe.com Subject: RE: using select in a case Never too old to learn but often too old to remember! Dave --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/009401d034be$d204e0b0$760ea210$@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: using select in a case
Look what you've done now Al...he's all excited.. LOL A+ jml On Tue, Jan 20, 2015 at 3:31 PM, Allen wrote: > Lamballe, 26/01 15:21 to Montparnasse train 8646 > Back 28/1 19:06 train 8665 > Al > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jean > MAURICE > Sent: 20 January 2015 15:19 > To: profoxt...@leafe.com > Subject: Re: using select in a case > > from where ? when ? train number ?!!? ;-) > > Jean à Grenoble > > > > --- > This email is free from viruses and malware because avast! Antivirus > protection is active. > http://www.avast.com > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/capqlobziaexfjhr0zvz+p7h1ble_u8goihnt_cdsgto-zf4...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: using select in a case
Never too old to learn but often too old to remember! Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Allen Sent: 20 January 2015 14:35 To: profox@leafe.com Subject: RE: using select in a case Yes Dave, a long list of Case in this instance. I do use icase elsewhere. I was more worried it moved to the table though I would probably select what I want anyway. Anyway it works a treat. Don't know why I have never used it before. Another VFP gem. Al -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 20 January 2015 15:12 To: profoxt...@leafe.com Subject: RE: using select in a case I agree with Jean, Lookup() doesn't move the record pointer. In fact I have used it in a sql statement to define a field using icase(). That may well be the way to accomplish what you are doing - or is the reason you need the case because you are involved in lots of inline code Dave --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/18725b8cd2d5d247873a2baf401d4ab2468ad...@ex2010-a-fpl.fpl.LOCAL ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: VFP6: Two Sided Printing
I have to say I prefer an empty tag and allow the selection box to come up so the user can decide. Al -Original Message- ...and I forgot to say, doing it yourself will involve changing the EXPR field contents in the report layout header record and clearing TAG2. If you set up a duplex report then have a look into these fields to see what VFP puts in there once you have defined duplex printing in the printer properties. You can change these just before runtime ... I would advise copying the report to t temporary report before you mod the expr field. Dave --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/009001d034be$6c1265c0$44373140$@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: using select in a case
Yes Dave, a long list of Case in this instance. I do use icase elsewhere. I was more worried it moved to the table though I would probably select what I want anyway. Anyway it works a treat. Don't know why I have never used it before. Another VFP gem. Al -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 20 January 2015 15:12 To: profoxt...@leafe.com Subject: RE: using select in a case I agree with Jean, Lookup() doesn't move the record pointer. In fact I have used it in a sql statement to define a field using icase(). That may well be the way to accomplish what you are doing - or is the reason you need the case because you are involved in lots of inline code Dave --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/008f01d034be$406536f0$c12fa4d0$@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: using select in a case
Lamballe, 26/01 15:21 to Montparnasse train 8646 Back 28/1 19:06 train 8665 Al -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jean MAURICE Sent: 20 January 2015 15:19 To: profoxt...@leafe.com Subject: Re: using select in a case from where ? when ? train number ?!!? ;-) Jean à Grenoble --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/008e01d034bd$d265e1e0$7731a5a0$@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: VFP6: Two Sided Printing
...and I forgot to say, doing it yourself will involve changing the EXPR field contents in the report layout header record and clearing TAG2. If you set up a duplex report then have a look into these fields to see what VFP puts in there once you have defined duplex printing in the printer properties. You can change these just before runtime ... I would advise copying the report to t temporary report before you mod the expr field. Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 20 January 2015 14:14 To: ProFox Email List Subject: RE: VFP6: Two Sided Printing Also, look at Sys(1037) and prtinfo() Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Desmond Lloyd Sent: 20 January 2015 13:31 To: ProFox Email List Subject: VFP6: Two Sided Printing Has anyone had experience printing two documents out of VFP6? Common sense says I can manually set the printer to print on both sides. However if I do it out of the report writer, how to turn on and turn off? Save printer environment perhaps? Any input would be greatly appreciated... Regards, Desmond --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/18725b8cd2d5d247873a2baf401d4ab2468ad...@ex2010-a-fpl.fpl.LOCAL ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: using select in a case
INDEXSEEK() will also return .t. or .f. if a matching row is found without moving the record pointer, allows you to pick the index to use, and is Rushmore aware. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier Sent: Tuesday, January 20, 2015 9:12 AM To: profoxt...@leafe.com Subject: RE: using select in a case I agree with Jean, Lookup() doesn't move the record pointer. In fact I have used it in a sql statement to define a field using icase(). That may well be the way to accomplish what you are doing - or is the reason you need the case because you are involved in lots of inline code Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Allen Sent: 20 January 2015 14:01 To: profox@leafe.com Subject: using select in a case Hi Foxgang I have a need in a case to read a field and select case depending on the result. Normally I would just make a UDF and locate and return the field value. I am wondering though if there is a simple way avoiding extra methods. Example Case GetVal(2) = 6 Function GetVal LParameters LookFor Select MyTable Locate for Field1 = LookFor Return Field2 Simplified but the idea is there. I'm wondering if the case can handle that in the line rather than the separate proggy. Sort of case select Field2 from MyTable where Field1 = 2 = 6 Al --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cy1pr10mb02186866237071c28f3da8cbd2...@cy1pr10mb0218.namprd10.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: using select in a case
from where ? when ? train number ?!!? ;-) Jean à Grenoble Le 20/01/2015 15:12, Allen a écrit : Thanks Jean Maurice Al PS I will be taking to your favourite transport next week. Train to Paris and back. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/54be63d8@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: VFP6: Two Sided Printing
Also, look at Sys(1037) and prtinfo() Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Desmond Lloyd Sent: 20 January 2015 13:31 To: ProFox Email List Subject: VFP6: Two Sided Printing Has anyone had experience printing two documents out of VFP6? Common sense says I can manually set the printer to print on both sides. However if I do it out of the report writer, how to turn on and turn off? Save printer environment perhaps? Any input would be greatly appreciated... Regards, Desmond --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/18725b8cd2d5d247873a2baf401d4ab2468ad...@ex2010-a-fpl.fpl.LOCAL ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: using select in a case
I agree with Jean, Lookup() doesn't move the record pointer. In fact I have used it in a sql statement to define a field using icase(). That may well be the way to accomplish what you are doing - or is the reason you need the case because you are involved in lots of inline code Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Allen Sent: 20 January 2015 14:01 To: profox@leafe.com Subject: using select in a case Hi Foxgang I have a need in a case to read a field and select case depending on the result. Normally I would just make a UDF and locate and return the field value. I am wondering though if there is a simple way avoiding extra methods. Example Case GetVal(2) = 6 Function GetVal LParameters LookFor Select MyTable Locate for Field1 = LookFor Return Field2 Simplified but the idea is there. I'm wondering if the case can handle that in the line rather than the separate proggy. Sort of case select Field2 from MyTable where Field1 = 2 = 6 Al --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/18725b8cd2d5d247873a2baf401d4ab2468ad...@ex2010-a-fpl.fpl.LOCAL ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: using select in a case
Thanks Jean Maurice Al PS I will be taking to your favourite transport next week. Train to Paris and back. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jean MAURICE Sent: 20 January 2015 15:10 To: profoxt...@leafe.com Subject: Re: using select in a case Hi Allen, I think that LOOKUP() can solve your issue ... The Foxil --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/008901d034bb$1254a410$36fdec30$@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: using select in a case
Hi Allen, I think that LOOKUP() can solve your issue ... The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/54be61a7.9050...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: VFP6: Two Sided Printing
I have tried this myself and it is a nightmare! My suggestion would be to buy XFRX where you can do this quite easily out to a pdf file and then print out the PDF. If you try it yourself and you get out of phase then you can use up lots of paper and convert it to waste quite easily. Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Desmond Lloyd Sent: 20 January 2015 14:04 To: ProFox Email List Subject: Re: VFP6: Two Sided Printing Interesting solution, two printers. Makes sense (if you don't mind me saying so).Yeah, my two sides will be two different layouts... Appreciate your help! Regards, Desmond On 20 January 2015 at 07:38, Peter Cushing wrote: > Desmond Lloyd wrote: > >> Has anyone had experience printing two documents out of VFP6? Common >> sense says I can manually set the printer to print on both sides. >> However if I do it out of the report writer, how to turn on and turn >> off? Save printer environment perhaps? >> >> >> >> > I have some experience of printing duplex but using one report layout. > Are you talking about using two layouts - one either side? > I also just create two versions of the printer, one defined as normal and > the other duplex. I can then send to either. > > HTH > > Peter > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/18725b8cd2d5d247873a2baf401d4ab2468ad...@ex2010-a-fpl.fpl.LOCAL ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: VFP6: Two Sided Printing
Interesting solution, two printers. Makes sense (if you don't mind me saying so).Yeah, my two sides will be two different layouts... Appreciate your help! Regards, Desmond On 20 January 2015 at 07:38, Peter Cushing wrote: > Desmond Lloyd wrote: > >> Has anyone had experience printing two documents out of VFP6? Common >> sense >> says I can manually set the printer to print on both sides. However if I >> do it out of the report writer, how to turn on and turn off? Save >> printer >> environment perhaps? >> >> >> >> > I have some experience of printing duplex but using one report layout. > Are you talking about using two layouts - one either side? > I also just create two versions of the printer, one defined as normal and > the other duplex. I can then send to either. > > HTH > > Peter > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/caajxvanatordorczjsdvcs3viagztm6wgoahgxc4itxtk44...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
using select in a case
Hi Foxgang I have a need in a case to read a field and select case depending on the result. Normally I would just make a UDF and locate and return the field value. I am wondering though if there is a simple way avoiding extra methods. Example Case GetVal(2) = 6 Function GetVal LParameters LookFor Select MyTable Locate for Field1 = LookFor Return Field2 Simplified but the idea is there. I'm wondering if the case can handle that in the line rather than the separate proggy. Sort of case select Field2 from MyTable where Field1 = 2 = 6 Al --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/008701d034b9$80305670$80910350$@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: VFP6: Two Sided Printing
Desmond Lloyd wrote: Has anyone had experience printing two documents out of VFP6? Common sense says I can manually set the printer to print on both sides. However if I do it out of the report writer, how to turn on and turn off? Save printer environment perhaps? I have some experience of printing duplex but using one report layout. Are you talking about using two layouts - one either side? I also just create two versions of the printer, one defined as normal and the other duplex. I can then send to either. HTH Peter ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/54be5a5f.6040...@whisperingsmith.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
VFP6: Two Sided Printing
Has anyone had experience printing two documents out of VFP6? Common sense says I can manually set the printer to print on both sides. However if I do it out of the report writer, how to turn on and turn off? Save printer environment perhaps? Any input would be greatly appreciated... Regards, Desmond --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/caajxvamnefkuwc3pmbfq5avlggttwtqu1yfvjw2_ee9aq3r...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.