Re: RE: Data not updating -> [OT]

2012-01-25 Thread AndyD
thanks, yes, very well. Been retired 5 years now (where does time go?) - so decided to stir up the little grey cells by having a 3rd (and final) attempt at Python** so I've been following profox to help get my programming head on again. cheers - AndyD 8-)₹ P.S. ** tried a book c

Re: NF Windows XP and Domains

2012-01-26 Thread AndyD
ipstream the OS, there is supposed to be an Advanced option to drop the domain/ workgroup. N.B. I haven't tried it. enjoy! AndyD 8-)₹ On 19:59, Mike Copeland wrote: > > > My question is: > If I set a Windows XP workstation to no longer use a domain...but to go > the ne

Re: RE: NF Windows XP and Domains

2012-01-27 Thread AndyD
It has been some time since I worked on this, but I think that "administrator with privileges " has to be a *domain* administrator, which is no help when the domain server isn't there and/or you don't have domain admin login! AndyD 8-)₹ On 19:59, Hammer wrote: > If

Re: Re: NF Windows XP and Domains

2012-01-27 Thread AndyD
*Catch22* " it may ask you for a password to remove yourself from the domain. The password should be that of an administrator account on the domain." AndyD 8-)₹ On 19:59, Mike Copeland wrote: Thanks, Andy! You've confirmed what I suspected. As I read my 4,532nd Google hit, I

Re: An SQL Select poser.

2012-01-30 Thread AndyD
DTOS(transdate) AS akey, SUM(value) as tottrans, value>0 as Cr; FROM actrans GROUP BY akey, Cr HAVING Cr = .T. INTO CURSOR Debits SELECT * FROM Credits WHERE aKey NOT in (SELECT akey FROM debits) UNION select * FROM Debits WHERE aKey NOT in (SELECT aKey FROM Credits) a start (there may be a tid

Re: RE: An SQL Select poser.

2012-01-30 Thread AndyD
The Foxil said: Paul, it seems very clever and a lot more simple than my solution. Best regards and than mine AndyD 8-)₹ On 19:59, Paul Newton wrote: > Jean > > Thank you. However my approach will only return one row for each invalid > transaction. Each row will

Re: Re: USAGE Of Memos, Stability & an Error!

2012-02-10 Thread AndyD
lable somewhere- but I forget where AndyD 8-)₹ On 19:59, Sytze de Boer wrote: > 1 Beware of babies and bathwater > 2 Memos can be very useful and to avoid them can be more effort than > they're worth > 3 There are some extremely good data recovery tools out there > 4 Why not lo

Re: Re: USAGE Of Memos, Stability & an Error!

2012-02-10 Thread AndyD
that's good news about ODBC (Paul, do you have a link?) - but I presume the blessing doesn't go as far as offering a VFP driver? AndyD 8-)₹ On 19:59, Paul McNett wrote: > On 2/8/12 12:50 PM, Kurt Wendt wrote: >> Any advice? Should I re-write their systems to NOT use Memo fiel

Re: Re: Any way to alter the time returned by windows for DATETIME()?

2012-02-10 Thread AndyD
I assume this is some sort of time-stamp stored in a dbf so how are you suggesting the UTC is saved? (DateTime does not recognise time zone or milliseconds according to Help! ) AndyD 8-)₹ On 19:59, Dan Covill wrote: > > I'm with Ed, any solution has to start with saving the UTC

Re: Re: [NF] Wireless network SYSFU

2012-02-10 Thread AndyD
one - but either way you may need to know the factory default IP address). Finally I have found that problems on my network sometimes just go away overnight - maybe DHCP leases expiring and clever switches and routers discovering things for themselves. hth AndyD 8-)? On 19:59, Jerry Wolp

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

2012-02-11 Thread AndyD
cle though for a C++ head . AndyD 8-)? On 19:59, Stephen Russell wrote: > http://www.yacoset.com/Home/signs-that-you-re-a-bad-programmer/ > --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- k

Re: Re: Any way to alter the time returned by windows for DATETIME()?

2012-02-11 Thread AndyD
OK - thanks for the reply - I already posted a link to a win API call for getting the time zone (and saving flag). AndyD 8-)₹ On 19:59, Dan Covill wrote: > On 02/10/12 01:17, AndyD wrote: >> I assume this is some sort of time-stamp stored in a dbf so how are you >> suggesting t

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

2012-02-15 Thread AndyD
n' & +[&] " ?xuser &lvar ? _TALLY && 0 SELECT * FROM users WHERE user = ?xuser AND password = ?xpass ? _TALLY && 0 USE IN query CLOSE ALL CLEAR ALL So &mySQLstring and ?xvar both seem safe, although ?vars *feel* like better code. I'm pretty sure they

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

2012-02-15 Thread AndyD
x27;3j&Kv@') accept 'Enter username ' to xuser && admin' && xpass = 'abc' SELECT * FROM users WHERE user = ?xuser AND password = ?xpass ?_TALLY && 0 **/** BUT **/** lvar = "Select * From Users where user = '" + xuser + "&#

Re: RE: SQL Server 2008 connectivity problem

2012-02-16 Thread AndyD
deas for a generalised report designer. AndyD 8-)₹ On 19:59, José Olavo Cerávolo wrote: > Ok, All basic configurations were taken care of. > Allow remote connections, protocols, firewall. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

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

2012-02-17 Thread AndyD
Well yes, I remember your early posts appearing , but I just noticed that on the TIOBE Index [V]FP has dropped out of the top 50 - above NATURAL and MUMPS but below Q and Smalltalk, so I guess we're all on the slow train to nowhere, or already on another track. AndyD 8-)₹ On 17/02/2012

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

2012-02-17 Thread AndyD
Surely what some of this discussion showed was that parameters (even Foxpro ?parms) do not need delimiters, and if a UI is used (a screen or even the ancient ACCEPT 'prompt' TO parm) then you don't even need to use delimiters to create the parameters? AndyD 8-)₹ On 17/02/2012 15

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

2012-02-17 Thread AndyD
not much more than a scripting toy) achieving much more acceptance than the more rigourous postgreSQL. AndyD 8-)₹ On 17/02/2012 16:39, Ed Leafe wrote: > On Feb 17, 2012, at 10:26 AM, Stephen Russell wrote: > >> The power of dynamic SQL ? >> >> That is running with scissors. >

Re: Re: [NF] A new Honda

2012-02-20 Thread AndyD
I finally managed to watch this (not good on 1 - 2 Mbps broadband). Amazing! A Rubik's wheel! AndyD 8-)₹ On 2/19/2012 12:21 AM, Dan Covill wrote: >>> On 02/18/12 13:30, Jean Laeremans wrote: >>>> http://www.youtube.com/watch_popup?v=cuIJRsAuCHQ >>>> &g

Re: Re: Importing files > 2GB

2012-02-21 Thread AndyD
ows." Write-only storage then? AndyD 8-)₹ On 22/02/2012 05:43, Michael Madigan wrote: > > > Yes, but is there another way or is that the ONLY option? How messy > would going the LLFF route be I wonder? > > ___ Post Messages

Re: Re: Importing files > 2GB

2012-02-23 Thread AndyD
You could add an auto-increment field? AndyD 8-)₹ On 22/02/2012 17:30, MB Software Solutions, LLC wrote: > On 2/22/2012 2:24 AM, AndyD wrote: >> llfs in Fox is *fast* - and very flexible - that's the way I'd go. Read >> in a chunk, take a substring up to the last who

Re: Re: Dot Matrix Printing

2012-02-23 Thread AndyD
.232558" per line is 4.30 lines/inch - I wonder if these are metric forms - 0.6cm/line is 4.2 lpi AndyD 8-)₹ On 22/02/2012 19:49, Jeff Johnson wrote: > Yep. Multi-part forms. There is a line spacing setting, but it doesn't > seem to go the right way. > > The

Re: Re: Importing files > 2GB

2012-02-23 Thread AndyD
I guess it's not the Fox but Windows; 2Gb being the limit of signed 32-bit addressing - if I counted properly. Don't think they're going to give us a 64-bit Foxpro. It does raise the question as to what tools *can* handle an address space over 32-bits wide on 32-bit architecture!

Re: Re: EDI

2012-02-23 Thread AndyD
So the standards docs are now available from ANSI? AndyD 8-)₹ On 23/02/2012 15:37, Brant E. Layton wrote: > > Standards Documents are expensive - to the tune of about $750 US for > a single document. > > >Effective 1/1/2012, all electronic medical claims have > been

Re: Re: [NF] nicer looking UI for VS2012

2012-02-25 Thread AndyD
product/B003CGOTJW/ref=as_li_qf_sp_asin_il_tl?ie=UTF8&tag=findanewgame-20&linkCode=as2&camp=1789&creative=9325&creativeASIN=B003CGOTJW> with The Cloud and everything, and for what he wants to do, including a fashionable retro editor, it all works nearly as well as a boring

Re: [NF]: Referencial Integrity

2012-02-29 Thread AndyD
, you should write rock solid SP's for all user functions which /are/ exposed. You are then protected from clever or malicious users who find a way around the UI - they can still do that but you have the checking in the SP. Others may disagree AndyD 8-)? On 28/02/2012 20:22, Eurico Chagas F

Re: Re: [NF] why learn how a new M$ product could be better

2012-03-02 Thread AndyD
d the Cloud can achieve everything, and that will be another nail in the coffin of Corporate data and core systems integrity. AndyD 8-)₹ On 02/03/2012 15:52, Stephen Russell wrote: > I know a few people who only use a tablet today. . These > people are the power of the company they repre

Re: Re: [NF] why learn how a new M$ product could be better

2012-03-03 Thread AndyD
IM in the first place: they are rock solid secure - for example the Indian Govt are considering banning RIM because their security people *can't* crack the encryption, they have expressed no such problems with Apple. AndyD 8-)₹ On 02/03/2012 16:44, Ed Leafe wrote: > On Mar 2, 2012

Re: Re: [NF] why learn how a new M$ product could be better

2012-03-03 Thread AndyD
pls see inline AndyD 8-)₹ Most people who use computers only use them for email, web browsing, digital photos, games, and music. None of these require a traditional computer; it is just as easy or in some cases easier on the iPad. >>> Agreed, but the argument was abo

Re: Re: [NF] why learn how a new M$ product could be better

2012-03-03 Thread AndyD
Not as expensive as my previous (and final) employers, they chose to replace everything with a "One solution fits all" solution: SAP AndyD 8-)₹ On 02/03/2012 21:40, Jean Laeremans wrote: > Well Ed i'm in the rather fortunate position not to give 'a damn > any-more &

Re: Re: [NF] why learn how a new M$ product could be better

2012-03-05 Thread AndyD
tens of millions. I haven't heard what's happened in the last 5 years or so but a quick Google shows they are currently shedding nearly 20% of jobs including IT and 'embracing the savings offered by cloud computing'. AndyD 8-)₹ On 05/03/2012 05:29, MB Software Solutions, LLC w

Re: Re: DBC File Size

2012-03-08 Thread AndyD
My employers always said it was too expensive; I never had any problems with DBCs but my apps created them on the fly and populated them with remote views during object init. AndyD 8-)₹ On 07/03/2012 15:59, MB Software Solutions, LLC wrote: > > SDT is a great insurance policy for tho

Re: RE: Need: VFP6 SP5

2012-03-16 Thread AndyD
Ah yes, I'd almost forgotten - the Judas kiss: Foxpro was going to have it's own wonderful ongoing existence - but outside Visual Studio..... AndyD 8-)₹ On 15/03/2012 13:07, Alan Bourke wrote: > I found the same thing as a download after it dawned on me to search for > Visua

Re: RE: Reindexing every night

2012-03-23 Thread AndyD
AndyD 8-)₹ On 22/03/2012 15:49, Richard Kaye wrote: > Especially here in Lake FoxBeGone... ;) > > -- > rk > > ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free ve

Re: [NF] I wonder if I'll ever see the name "Gartner" and not feel disgust

2012-04-03 Thread AndyD
Back in the mists of time I read that self-same article by Gartner Group rejoicing in how PC's were freeing end-users from the mainframe dinosaurs in the IT department - what goes around comes around! AndyD 8-)₹ On 03/04/2012 12:49, MB Software Solutions, LLC wrote: > http://gigaom.c

Re: RE: Memo Fields in SQL SELECTS...

2012-04-05 Thread AndyD
I stand in complete awe of Tracy Pearson, but I'm afraid she lost me with the ' NOT putting csrMemo in FROM Clause ' Glad it worked anyway. AndyD 8-)₹ On 05/04/2012 16:26, Kurt Wendt wrote: > Strangely enough - it still didn't work right. The Ship_Track field > ende

Re: Re: 2012 FoxPro Lifetime Achievement Award Committee

2012-04-11 Thread AndyD
*I agree -* ... I seem to remember he was nominated before but 'some' people were upset by something he did - - related to trying to run Fox on 'another' OS perhaps? AndyD 8-)? On 10/04/2012 13:31, Jeff Johnson wrote: > > FoxPro lives on in ProFox and I - fo

Re: Data Environment

2012-04-11 Thread AndyD
Interesting question - does the DE actually exist in [source] code? I suppose it may do. I always thought the DE was a very unappreciated resource - not strictly OOP enough perhaps? AndyD 8-)₹ On 10/04/2012 15:38, Dave Crozier wrote: > Does anyone know of an easy way to extract the d

Re: RE: Expanded dir listing info from XP command line using default Windows/cmd shell capabilities vs. 3rd party utilities

2012-04-12 Thread AndyD
Doesn't XP have WSH? If so you can use a vb or js script and use fileSystemObject (unless fully locked down with no js) AndyD 8-)₹ On 12/04/2012 08:33, Dave Crozier wrote: > Malcolm, > If you have M$ Office then you can write a VBA script in word or excel to get > what you want us

Re: Re: lockng issues

2012-04-24 Thread AndyD
I have found the SQL commands better at handling contention issues, why not: lDate = date() UPDATE YourTableName SET post_date = lDate WHERE post_date <> lDate AndyD 8-)₹ On 23/04/2012 22:57, MB Software Solutions, LLC wrote: > > > Not sure. My only advice is to change it to th

Re: Anyone looked at this?

2012-05-04 Thread AndyD
tion of Visual FoxPRO Read more about Lianja Features <http://www.lianja.com/features> by www.lianja.com <http://www.lianja.com> " -- EULA fine print. AndyD 8-)? On 03/05/2012 13:16, Dave Crozier wrote: > Just came across this: > > http://www.lianja.com/features

Re: DBF Synchronization

2012-05-07 Thread AndyD
offline views? AndyD 8-)₹ On 07/05/2012 14:28, Jeff Johnson wrote: > I want to synchronize several VFP9 dbf files. A user > uses her laptop and then when she returns to the office want's to > synchronize the dbf's with the server. A full two way synchron

Re: Re: DBF Synchronization

2012-05-08 Thread AndyD
I looked at in some depth a few years ago and as far as I can remember the main problem was lack of decent documentation, I didn't use it in anger because in the end I convinced the user to move the backend to SQL Server and wrote a small fairly limited web app for the remote users. An

Re: Re: Started learning C# today

2012-05-08 Thread AndyD
if it's still available and functioning? AndyD 8-)₹ On 07/05/2012 22:58, Stephen Russell wrote: > On Mon, May 7, 2012 at 4:37 PM, MB Software Solutions, LLC > wrote: > The hardest thing I faced was thinking that VFP was like every other > language. C# is pretty wide in scop

Re: RE: HELP! I'm getting a record out of range in my new form.

2012-05-08 Thread AndyD
mmitted to them -' lightswitch' looks like one big wizard - you can't even place things yourself. AndyD 8-)₹ On 08/05/2012 14:32, Kurt Wendt wrote: > I don't think the wizards were SO BAD - if you only used them as a > starting point. I haven't really touched them m

Re: RE: Memo Fields in SQL [was...RE: SQL Server Import & VFP Data Source]

2012-05-15 Thread AndyD
es to bite you in the ass! If you are importing into an existing database turn off integrity checks, triggers, SP's etc. wherever possible. cheers AndyD 8-)₹ On 15/05/2012 18:49, Kurt Wendt wrote: > Although, in the end - I still had the warnings about the > DefaultCodePage stuff - I

Re: Re: Signature Capture, part two

2012-05-28 Thread AndyD
wag: Samsung Galaxy Note??? AndyD 8-)₹ On 26/05/2012 21:13, Mike Copeland wrote: > Thanks for that Eurico! That looks exactly like what I'll have to do. > > If anyone sees any kind of Windows-based hardware that has a pressure > sensitive pad built-in, incorporated into the comp

Re: Re: [NF] UI Design ideas

2012-06-22 Thread AndyD
isual Studio 11 beta to build an HTML5 application JavaScript is the language that accesses the WinRT runtime/ AndyD 8-)? On 21/06/2012 22:44, Leland Jackson wrote: > On 06/21/2012 09:59 AM, Stephen Russell wrote: >> <http://www.developer.com/design/the-8-principles-of-great-user-inte

Re: RE: Sending E-mails from VFP

2012-06-29 Thread AndyD
You can use your own domain name with Gmail AndyD 8-)₹ On 29/06/2012 17:21, Kurt Wendt wrote: > This customer, in their original request - already mentioned something > about having the e-mails sent from their own .com domain server. So - I > figured that Gmail is definitely NOT an optio

Re: Re: [NF] Network Question

2012-07-21 Thread AndyD
No-one else has said it so I will : for two PC's forget wireless and vpn's - two $5 ethernet cards and a crossover cable! AndyD 8-)₹ ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/prof

Re: RE: [NF] loopy visual studio

2012-09-08 Thread AndyD
As will TextPad - still my favourite editor esp. for multi-file search / replace. AndyD 8-)₹ Allen, Both NotePad++ and PSPad will connect to an FTP site to modify files. Tracy Pearson PowerChurch Software ___ Post Messages to: ProFox@leafe.com

MSDN Product Keys

2009-07-14 Thread AndyD
product key for XP-MCE thanks AndyD 8-)# ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archiv

RE: MSDN Product Keys

2009-07-16 Thread AndyD
Dave Crozier said: "Andy, Nice to hear from you againhope you are both well in the sun!" Hi Dave - we're back in the UK for a bit, and we seem to have brought the sun with us. Nice to see a lot of the old names still on the list. cheers - AndyD 8-)# profoxtech-re

[Fwd: Fw: adieu]

2007-09-17 Thread AndyD
of profox, although I may someday soon come back as a lurker or silver surfing ghost one and all - it's been great to know you - many thanks for your cyber (and in some cases real) company. AndyD 8-)# Andrew Da