Re: AW: [NF] ML & Python anyone?

2021-10-05 Thread Peter Cushing
Hi Jürgen, That's great.  I will give it a go. Thanks, Peter Cushing IT Department WHISPERING SMITH On 04/10/2021 14:27, Jürgen Wondzinski wrote: > Hi Peter, > > for that you'll use the free (!) Community Edition. > https://www.lianja.com/resources/blog/38-development-n

Re: [NF] ML & Python anyone?

2021-10-04 Thread Peter Cushing
Lianja looks interesting but a little pricey for my purposes.  I won't  be building any apps but just some data mining/ML. Thanks, Peter Cushing IT Department WHISPERING SMITH On 01/10/2021 14:43, Jürgen Wondzinski wrote: > If you're able to speak Python, you could as well t

Re: [NF] ML & Python anyone?

2021-10-01 Thread Peter Cushing
Interesting.  Just recently downloaded python and was looking at doing some ML.  Also downloaded pytorch to hopefully do this.  Got to learn some python first, then try to apply it.   Lots to learn and will have a look at the videos on here.  Thanks, Peter Cushing IT Department WHISPERING SMITH

Re: Outlook Office 365

2021-08-24 Thread Peter Cushing
Hi Dave, Just tried an output report here and seems to be working fine using Office 365 32 bit.  Excel version 16.0.14228.20216 Peter Cushing IT Department WHISPERING SMITH On 24/08/2021 11:52, Dave Crozier wrote: > Has anyone had any issues when trying to load up Outlook 365 us

Re: File Server Sharing SMB1: W10 Update KB5001330 shuts off SMB1

2021-04-15 Thread Peter Cushing
Hi Christof, Is there a word missing from the key below (before Parameters)? Peter On 14/04/2021 16:54, Christof Wollenhaupt wrote: > > HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\\Parameters > OplocksDisabled DWORD 1 > This communication is intended for the person or organisation to

Re: This SQL didn't update just one record but ALL records....OOPS!!!!!

2020-10-26 Thread Peter Cushing
yntax inner join where the join goes in the where clause. Peter Cushing IT Department WHISPERING SMITH On 26/10/2020 16:05, MB Software Solutions, LLC wrote: > VFP9SP2 using DBC tables. > > The curWorkingGroup cursor had just ONE record in it.  The > Carriers_To_Process table (PK = IID f

Re: AW: May the Open Source Be With You: INTL and SDT!

2020-01-16 Thread Peter Cushing
On 16/01/2020 13:54, Jürgen Wondzinski wrote: > In that same area we should also mention: > > The "Hacker’s Guide to Visual FoxPro" is also now online and OpenSource > https://hackfox.github.io/ > I knew if I waited long enough, I would get it for free ;-) Peter This communication is intended f

Re: [NF] X# Bandol 2.2 released to the public

2019-12-18 Thread Peter Cushing
On 17/12/2019 21:54, Ricardo Araoz wrote: > > (should I declare the irony or you people are smart enough to notice it?) > > SET IRONY ON ;-) This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauth

Re: AW: So, about this VFPA thing...

2019-11-26 Thread Peter Cushing
On 25/11/2019 17:36, Jürgen Wondzinski wrote: > Sometimes it would help to get off that Trump-level paranoia :) > > wOOdy > "Just because you are paranoid doesn't mean Trump isn't out to get you"  ;-) Peter This communication is intended for the person or organisation to whom it is addressed. T

Re: Test Message

2019-10-28 Thread Peter Cushing
On 28/10/2019 12:23, Dave Crozier wrote: > Re-subscribed to the list now I have removed Mailsphere… This is a test > message > > Happy to be back after 9 months of not being able to post! > > Sounds like a case of mailsphere not wanting to play ball ;-) Peter This communication is intended for

Re: Will Visual FoxPro run on Windows 10's successor?

2019-10-23 Thread Peter Cushing
On 21/10/2019 14:43, Paul H. Tarver wrote: > I think I saw on the internet where Abraham Lincoln said that too. > > Paul H. Tarver > Lincoln was also complaining about devices on machines being "Master" and "Slave".  I think he want equality for devices ;-) Peter This communication is intended f

Re: APPEND BLANK with immediate field values set right after

2019-10-03 Thread Peter Cushing
On 03/10/2019 14:15, Ted Roche wrote: > > Well a minor difference, I think: APPEND BLANK / REPLACE changes the > RECNO() to the record being added to, where INSERT INTO may not. If other > code tries a REPLACE without locating the proper record, you could end up > changing the wrong one following a

Re: SQL server connection

2019-08-21 Thread Peter Cushing
Wow.  Lots of stuff to check out there.  Will definitely be checking out the SQL server stuff even though I'm not writing the new software.  I could well be writing some reports though. Thanks, Peter Cushing IT Department WHISPERING SMITH On 21/08/2019 14:40, Stephen Russell wrote: >

Re: SQL server connection

2019-08-21 Thread Peter Cushing
,'SELECT @@identity') If nResult is 0 then assume a problem and disconnect, throw away the old handle, and then reconnect. How necessary is that check?  Should I use it before every call? Thanks, Peter Cushing IT Department WHISPERING SMITH On 21/08/2019 11:34, Frank Cazabon wrote: > I u

Re: SQL server connection

2019-08-20 Thread Peter Cushing
ly but if I try ?sqlconnect('x2live')   && returns -1 I have tried putting in the username/password and didn't make any difference. What actual commands do you use to connect? TIA Peter Cushing IT Department WHISPERING SMITH On 20/08/2019 15:11, Paul H. Tarver wrote: > P

SQL server connection

2019-08-20 Thread Peter Cushing
reporting purposes but may need to write to it at some point.  Looking through the archives some people mentioned SPT and others cursor adapters.  Just wondering what people recommend to connect, so I can avoid the usual gotchas. Thanks, -- Peter Cushing IT Department WHISPERING SMITH This

Re: SET DEFAULT or ?

2019-08-14 Thread Peter Cushing
in my app will use this var. HTH Peter Cushing IT Department WHISPERING SMITH On 14/08/2019 04:57, Gene Wirchenko wrote: > Hello: > > I have an app that has for years been executed out of the > default directory with the data there, too. > > Now, I have to give at

Re: Get file path and name from file handle

2019-08-02 Thread Peter Cushing
Hi Chris, I just did: nHandle = FCREATE('pc.txt') and it created a pc.txt in the current folder.  I could not open it so I know it is the right file.  Don't you have access to the original FCREATE command? Peter On 02/08/2019 13:22, Paul Newton wrote: > Hi all > > How can I get a file path and

Re: Converting an SCX to a PRG in batch mode

2019-05-30 Thread Peter Cushing
ile > 0 IF tModified < CTOT(DTOC(aTxtFile[1,3]) + ' ' + aTxtFile[1,4])     lOlder = .f. ENDIF   ENDIF    ENDIF    IF lOlder   ? 'Generating text file for ' + cForm   DO (HOME() + 'scctextx') WITH cHome + cForm + "."+cE

Re: Filtering Oddity

2019-05-21 Thread Peter Cushing
Message----- > From: ProfoxTech On Behalf Of Peter Cushing > Sent: Tuesday, May 21, 2019 6:35 AM > To: profoxt...@leafe.com > Subject: Re: Filtering Oddity > > On 20/05/2019 19:39, Fletcher Johnson wrote: >> Not sure where the "Had to be bad coding" comes in. &g

Re: Filtering Oddity

2019-05-21 Thread Peter Cushing
On 20/05/2019 19:39, Fletcher Johnson wrote: > Not sure where the "Had to be bad coding" comes in. > > For example, if you did "select * from employee where last name = 'Smith'" > you would get a cursor of only those employees. The employee table would > still be open, but VFP opened it again, in

Re: Filtering Oddity

2019-05-15 Thread Peter Cushing
On 15/05/2019 10:00, Koen Piller wrote: > Hi, > The use of 'Set Filter' in VFP is outdated. Nowadays we use > Selectfrom...Where...into > Regards, > Koen > Hey, leave my set filter alone... :-) I have found a few uses for it that work brilliantly and I couldn't think of an alternative.   Things

Re: [ADMIN] Email list footer changes

2019-04-29 Thread Peter Cushing
On 29/04/2019 15:46, Ted Roche wrote: > Pointing out bugs seems to be my gift. And my curse. > > Well "It depends" which one you view it as ;-) Peter This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law

Re: File Access Issues

2019-03-21 Thread Peter Cushing
Hi Chris, Workstations just use standard RDP and on the server we use thinstuff: https://www.thinstuff.com/products/xpvs-server/ Thanks, Peter On 21/03/2019 10:30, Chris Davis wrote: > Thanks Peter > > The RDP client ? > >> On 21 Mar 2019, at 10:28, Peter Cushing wrote: &g

Re: File Access Issues

2019-03-21 Thread Peter Cushing
On 21/03/2019 09:41, Chris Davis wrote: > We are seeing increasing problems with VFP applications (some of our own and > other commercial ones) as our customers have their servers upgraded. > > A lot of these servers are now virtual machines hosted on a physical machine. > In some instances thes

Re: Creating a copy of a database -- best practice?

2019-03-01 Thread Peter Cushing
Hi Mike, Your COPY TO won't give you all the meta data, which is what you wanted in the first place.  When you already have a copy of the system the meta data is already there, you are just updating the data. HTH Peter Cushing IT Department WHISPERING SMITH On 28/02/2019

Re: Creating a copy of a database -- best practice?

2019-02-28 Thread Peter Cushing
On 27/02/2019 17:22, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: > I can easily do something like this: > > CREATE DATABASE C:\Backup\MyDBC.dbc > OPEN DATABASE C:\Production\MyDBC.dbc > liNumTables = adbobjects(laTables,'TABLE') > for ii = 1 to liNumTables >lcFile = forceext("C:\BACKUP\"

Re: false news....

2019-02-26 Thread Peter Cushing
On 25/02/2019 17:10, John Weller wrote: > I should have said given 😊 Gt Ducie St - that brings back memories of > commuting between Salford and Manchester Grammar many, many years ago! > It's more or less the same now, but with worse traffic :-( Oh and Boddington's brewery has gone. Peter This

Re: false news....

2019-02-25 Thread Peter Cushing
On 25/02/2019 16:53, John Weller wrote: > Thanks Ted, that explains it well. We have a similar number, the National > Insurance Number, which is unique and is not considered 'secret' at least as > far as I am aware, but that is random and includes a check digit. I don't > think I would use it

Re: Converting .scx to .prg

2019-01-29 Thread Peter Cushing
On 29/01/2019 05:14, Gene Wirchenko wrote: Hello: How do I convert a .scx to a .prg? I have found most of the pieces of code, but I do not see how the contained objects are created.  (I was expecting to find a form .Init().) As others have stated in the past, there are programs tha

Re: Hey, can you test this...

2019-01-16 Thread Peter Cushing
On 16/01/2019 11:37, Alan Bourke wrote: And\or do your browsing in a private Incognito tab (they're not just for looking at nude people, folks!) The only decent excuse I have heard for using a private tab was a mate who was looking for a present for his wife and wanted it to be a surprise.  Now

Re: AW: Custom Scrollbar

2019-01-08 Thread Peter Cushing
On 08/01/2019 03:27, Gene Wirchenko wrote: I can not get proper row-level validation working consistently.  I have tried and tried and tried.  I keep finding cases where it breaks.  I deal with a case, and something else breaks.  It is very frustrating. Maybe you can describe a scena

Re: ProFox List Statistics for 2018

2019-01-03 Thread Peter Cushing
On 03/01/2019 06:32, Gene Wirchenko wrote: Total [OT] Posts: 1 (Down 97.67% from 2017) First entry of the year for "Hilarity in Statistics"? What's so hilarious? If it was 43 last year and now it is 1 then it is down 97.67% Peter This communication is intended for the person or orga

Re: AW: REINSTALL FOX PRO 9

2018-12-13 Thread Peter Cushing
On 11/12/2018 08:12, juer...@wondzinski.de wrote: Ok I bit the bullet and translated that stuff to english (with some enormous help of DEEPL). Take a look here: http://woody-prolib.blogspot.com/2018/12/how-to.html Thanks for the translation.  I will be sure to use it next time I re-install. 

Re: AW: Visual FoxPro Toolkit for .NET

2018-11-22 Thread Peter Cushing
On 22/11/2018 15:34, juer...@wondzinski.de wrote: The main usecase for the toolkit is replicating / packaging classic VFP functions into object calls. If you're an "oldfashioned" FoxPro guy... What's wrong with having a mullet? ;-) Peter This communication is intended for the person or organ

Re: disappearing methods in forms

2018-11-19 Thread Peter Cushing
On 19/11/2018 17:42, Fernando D. Bozzo wrote: You should use a SCM tool (git, etc) and convert your binaries to text +1 on that.  Makes it easy to diff the changes and you have a copy of the methods in a text file. Peter This communication is intended for the person or organisation to whom

Re: Big Changes & Fox Work in SF Bay Area?

2018-11-19 Thread Peter Cushing
On 19/11/2018 16:15, Kurt at VR-FX wrote: Hello there Peter - from the other side of the big pond. AS for Karl - that will be tough - as he's been dead since 2009. You expect me to die soon - so that I can give him your greeting?? :-) No, not expecting you to die, just joking :-) I did grow u

Re: Big Changes & Fox Work in SF Bay Area?

2018-11-19 Thread Peter Cushing
On 18/11/2018 02:12, Kurt at VR-FX wrote: Very funny Mike!!! Well - am in Cali since my sister lives here in SF. Say hello to Karl Malden for me ;-) Peter This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected

Re: GetFile() issue

2018-11-08 Thread Peter Cushing
On 08/11/2018 14:35, Dave Crozier wrote: Peter, Mainly to place them into a folder where you preferably want them to put/get the file from rather than them being able to navigate around the PC & Network. Hi Dave, You are far too nice to your users!  We make them navigate the network for stu

Re: GetFile() issue

2018-11-08 Thread Peter Cushing
Hi Dave, I never change my default folder when the app is running and for things like output folders or getting data I usually just get the user to select the folder with : cImport = GETDIR('','Select upload folder') You can then ask for every report or save this for their session and keep

Re: Replacement for standard OLE image control

2018-10-24 Thread Peter Cushing
On 24/10/2018 15:43, Richard Kaye wrote: Thanks for the reply, Tracy. Very high res images but some display fine while others pixelate. I am storing directly in the file system with no transforms. They look fine if you preview in OS but the ancient OLE image control doesn't like something. The

Re: AW: FRX and window envelopes

2018-10-11 Thread Peter Cushing
On 11/10/2018 14:30, Jürgen Wondzinski wrote: Hi Richard, That's why there's a Report header, which only prints once. You would use that for your first page. Then, you print a report for each record separately SELECT YourAdressTable SCAN FOR YourCondition REPORT NEXT 1 FORM MyList.frx TO

Re: Print salary receipts to a pdf image

2018-09-14 Thread Peter Cushing
On 14/09/2018 15:53, Rafael Copquin wrote: Perhaps I was not very clear. I have scanned the empty receipt as a pdf image. I want to fill it with the applicable data and then print it on a laser printer I can't use the vfp report writer because it will not take a pdf file as an image. And if I u

Re: Lianja anyone?

2018-08-22 Thread Peter Cushing
On 22/08/2018 17:26, Alan Bourke wrote: It involves purchasing RDP licences is maybe one reason, you would normally need to implement Citrix XenApp or something to manage it properly. There are alternatives to RDP like ThinStuff that can work very well. +1 on the thinstuff, which we use her

Re: Every day a school day.

2018-07-31 Thread Peter Cushing
On 31/07/2018 10:49, Alan Bourke wrote: I only use it for collections, due to the fact that I avoid arrays if possible. When we were learning arrays at college using pascal, one of the students used to call his arrays 'hiphip' which looked good on the printouts. :-) Peter This communicatio

Re: Coverage profiler

2018-07-05 Thread Peter Cushing
On 05/07/2018 15:24, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: VFP9SP2 on Win7Pro PC I want to see how long it's taking some code to run.  Beyond self-created start/stop variables, I thought "why not use the coverage profiler?"  MANY years ago, I recall there was some sort of altern

Re: [NF] Tool to help you monitor mySQL/Marina

2018-06-26 Thread Peter Cushing
On 26/06/2018 15:51, Paul H. Tarver wrote: What can I say? I'm tight. :) I thought that was "Fiscally challenged" ;-) Peter This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copy

Re: Query Involving Sums and Two Most Recent Dates

2018-06-21 Thread Peter Cushing
Hi Ken, You can get them both with 1 query. Pressed send too soon on the last reply. select status.pk,count(*) as nCust,sum(apphours) as nApphours ; from status,hours ;    where status.pk = hours.pk and status.type = 'Approved' group by 1 ;   into cursor curres HTH Peter Pet

Re: Query Involving Sums and Two Most Recent Dates

2018-06-21 Thread Peter Cushing
Hi Ken, You can get them both with 1 query. select count(*) as nCust,sum(apphours) as nApphours from status,hours ;    where status.pk = hours.pk and status.type = 'Approved' group by 1 ;   into cursor curres HTH Peter Peter Cushing IT Department WHISPERING SMITH On 21/06/2018

Re: [NF] Let the meetings BEGIN.

2018-05-25 Thread Peter Cushing
On 25/05/2018 17:43, Paul H. Tarver wrote: Ajit's comment just made me realize, I am officially the old guy who sits on the porch yelling, "Get Off My Cloud!" Sorry, think that was Mick Jagger ;-) Peter This communication is intended for the person or organisation to whom it is addressed. The

Re: Class Definition Not Found

2018-05-02 Thread Peter Cushing
We also have Opera 3 and for support we initially go to our reseller, which is how I have always understood it to work.  Usually if they cannot solve the problem they go to Pegasus, but I didn't think you could go directly to Pegasus. HTH Peter On 02/05/2018 08:51, Paul Newton wrote: Chris

Re: Fun (not) with the report writer

2018-04-20 Thread Peter Cushing
On 19/04/2018 17:09, Richard Kaye wrote: OK. Here's my conundrum of the day. I've got an invoice report. There are multiple group bands and multiple potential multi-line objects, and periodically I get just the right combination of text that I appear to get a 2 page report that should fit on

Re: INSERT INTO...SELECT Issue

2018-04-19 Thread Peter Cushing
On 19/04/2018 14:38, Paul H. Tarver wrote: My question is this: Has anyone here run into this issue and if so, Is there any another way or procedure around this situation that would allow me to manually fix the fieldnames which start with a number assuming I have no way to change the source

Re: VFP9 - Save as XLSX

2018-04-16 Thread Peter Cushing
On 16/04/2018 17:17, Desmond Lloyd wrote: Good Morning, Need to be able to copy the contents of a cursor to an Excel file, but it needs to be in the xlsx. Am a newbie to Excel Automation and have read that you can saveas, and it will save in the latest format. Well mine doesn't. oworkbook.v

Re: VFP9 Screwed - HELP!

2018-03-29 Thread Peter Cushing
On 29/03/2018 11:35, Dave Crozier wrote: Fellow Gurus. Any input welcome as to why my VFP9 all serviced packed to date and working no problem on Win 10, 64 bit has suddenly died and won't come back to life. Not worried about why it went wrong, I just want a working VFP system. For some reason

Re: VFP Programmers

2018-03-23 Thread Peter Cushing
On 22/03/2018 15:41, Bryant wrote: I’m getting ready to retire and I’m looking for a VFP programmer in my area (Medford, NJ) who might be interested in taking over my business. I have about 150 copies of my database software for the Cemetery industry in use. If anyone is interested they can lo

Re: Error 108 on an INSERT INTO MyVFPTable

2018-03-16 Thread Peter Cushing
On 16/03/2018 06:34, Fernando D. Bozzo wrote: I didn't test it and didn't use it in many years, but could be possible that the table had a file lock (not record lock) by this another user? Don't know if the message is the same or something more like "table header is locked by another user" I ha

Re: Date / Date Time Picker Class

2018-03-09 Thread Peter Cushing
On 05/03/2018 22:04, Ted Roche wrote: Or, you can just write your own that works the way you want it to. It's fun, it's easy, it's something you know the rules for, and it will work exactly the way you want it to. Eventually. I love that word on the end ... eventually.  It says everything abo

Re: MariaDB

2018-01-26 Thread Peter Cushing
On 26/01/2018 06:13, AndyHC wrote: p.s. when checking this I came across the CREATE VIEW command (.vue files) - I do not remember ever using this, or even knowing it existed - anyone use it? This is nothing to do with remote views into other databases.  It just works in the visual foxpro env

Re: [NF] Anyone working within the cloud?

2017-12-05 Thread Peter Cushing
On 05/12/2017 16:39, Ed Leafe wrote: I prefer the much more relatable visualization of the different levels: https://pbs.twimg.com/media/Bw-NkNDCcAAatyf.png I think on that diagram you need to take out Soda and substitute it for Beer. Also note that cheese is a given on a pizza, which IMHO is

Re: Fun thought

2017-11-30 Thread Peter Cushing
On 30/11/2017 00:26, Ted Roche wrote: The second rule of World Domination is you do NOT talk about World Domination. ;) Have you been watching fight club again :-) Peter This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and

Re: [NF] Open systems Drive you crazy

2017-11-13 Thread Peter Cushing
On 13/11/2017 11:04, John Weller wrote: Milan, rush hour - it'll need a complete processor just to handle the horn! Not seen Milan rush hour but can't be any worse than Rome.  That was scary just trying to cross the road - on a crossing! Peter This communication is intended for the person

Re: NF - Splashtop Remote software use

2017-11-07 Thread Peter Cushing
On 06/11/2017 08:38, Alan Bourke wrote: Take a look at Thinstuff maybe. http://www.thinstuff.com/products Uses RDP but far cheaper than implementing a Microsoft RDP server setup. Works fine for VFP applications. We use this and it works great.  We also use RDP guard to stop brute force attack

Re: Reactivated old FOXil

2017-10-19 Thread Peter Cushing
On 19/10/2017 11:59, Jürgen Wondzinski wrote: Hi all Yes, that old wOOdy FOXil is still alive and kicking :) After several years of silence and self-maintenance, I thought it couldn't hurt to take a look at ProFox again. Now let's see how often I manage to chime in here :) wOOdy Got the

Re: Sad news...

2017-10-11 Thread Peter Cushing
Sad to hear.  I didn't know him but a good contributor to the forum. Peter On 11/10/2017 10:32, Dave Crozier wrote: Fellow Profoxers, I have just been told of some unfortunate news regarding our colleague Allen Pollard (known as Al by most people) who has unfortunately departed to the to the

Re: Textbox in grid column.... When is cursor updated?

2017-09-25 Thread Peter Cushing
On 25/09/2017 16:04, Matt Slay wrote: />> //What is the controlsource for the textbox set to? / controlsource of the column is: "csrPartTasks.Setup" textbox inherits same control source. I have a screen where the user can enter values in a grid and I call a function thisform.sumrows called f

Re: Textbox in grid column.... When is cursor updated?

2017-09-25 Thread Peter Cushing
On 25/09/2017 15:55, Matt Slay wrote: Textbox in grid column question When is the value entered in a textbox in a grid column applied to the underlying bound cursor relative to the firing of the grid.AfterRowColChange() when user hits tab to move to the next column? Here is the situation

Re: [NF] Excel Text formatted cells converting to scientific notation when saving as csv

2017-09-20 Thread Peter Cushing
On 20/09/2017 13:18, Michael Madigan wrote: I thought I'd pass this tip along.  If you have large text fields with numeric values, like insurance policy numbers or UPC Codes,  you have to format the cell with custom type ### or similar, otherwise the CSV file gets scientific notati

Re: XFRX to Excel just repeating the first record.

2017-09-14 Thread Peter Cushing
On 14/09/2017 10:58, Alan Bourke wrote: I can pause execution just before the report and there's 40 odd records which is correct. If I open the report layout in VFP and save it just before it runs then it's fine, however the next time I do it if I don't open\save the problem occurs. Select _fees

Re: XFRX to Excel just repeating the first record.

2017-09-14 Thread Peter Cushing
On 14/09/2017 10:28, Alan Bourke wrote: I'm creating Excel output using the XFRX driver. The basis for the report is a cursor which has in my test setup about 40 records. It's created using SQL Select with the nofilter clause. There are no relations in to it or out from it. It is the currently se

Re: [NF] Windows updates August problems?

2017-08-10 Thread Peter Cushing
On 10/08/2017 11:41, Ted Roche wrote: One of our clients calls after every second Tuesday complaining the app fails on startup with an "goDataManager is not an object error" message, despite the fact that we've told them for 10 years that means a network share is disconnected, and they should g

Re: GETFILE() Returns Empty String in Some Cases

2017-08-08 Thread Peter Cushing
On 31/07/2017 21:04, Ken Dibble wrote: Are you declaring your variable as PRIVATE right before you run the GETFILE() command? PRIVATE mypath mypath = GETFILE("csv","Spreadsheet","Open",0,"Open Spreadsheet") Just curious if that is affecting it. GAHHH!!! That's it!! Not a PRIVATE decl

Re: [NF] Export video to DVD

2017-06-26 Thread Peter Cushing
On 26/06/2017 11:40, John Weller wrote: I'm using the latest version of Win 10. The annoying thing is that Movie Maker used to do an excellent job and I also have a copy of Pinnacle Studio 15 which no longer works properly - damn M$! You could also try CD burner XP. One we have used at work w

Re: [NF] Export video to DVD

2017-06-26 Thread Peter Cushing
On 26/06/2017 11:26, John Weller wrote: Thanks Alan. Unfortunately one of the few things that handbrake doesn't do is create a DVD :-) What OS are you trying to create it with? I wanted to do something similar on my home machine and when I checked my windows 7 (32 bit) I found it came with a

Re: VFP & Server 2012

2017-06-22 Thread Peter Cushing
Hi Chris, What does Opera 3 run like on the server itself? (presuming you have installed the client). You can then rule out the network connection. Our 2012 server is actually a VM but is very quick when running from the server console. Peter Cushing IT Department WHISPERING SMITH On 22

Re: VFP & Server 2012

2017-06-22 Thread Peter Cushing
On 22/06/2017 10:45, Chris Davis wrote: Thanks for the replies, yes we used to disable SMB2 to remove the index corruption issue but this now seems to be a performance issue. This particular scenario is 2 brand new Server 2012 boxes, fully patched. One is the server and one is a remote deskto

Re: "Record is not available" error in FPW 2.6

2017-06-02 Thread Peter Cushing
On 02/06/2017 12:12, Michael Madigan wrote: I have an unlock in the show gets snippet, which happens right after this code, but you're suggesting the unlock occur before the flush? Yes. When I worked on FPW2.6 stuff we always had a save something like this. if if RLOCK() replace ... etc

Re: "Record is not available" error in FPW 2.6

2017-06-02 Thread Peter Cushing
On 02/06/2017 11:26, Michael Madigan wrote: 2. The line code that triggers this set century on replace gemdebto.dmmemo with gemdebto.dmmemo+chr(13)+chr(13)+chr(10)+"Notes:"+dtoc(date())+' '+time()+' '+"Computer:"+padr(memuser,15,' ')+' '+memnotes flush Why no rlock() before the replace?

Re: [NF] URGENT Request - MailMerge w/PDF

2017-05-25 Thread Peter Cushing
On 25/05/2017 11:55, Ted Roche wrote: Adobe are the people who invented PDF, and likely have some tools that would work for you. If this truly is a one-off job, and not a "we'll ask you to do this every 6 months, as an emergency," it might be cheaper to search for an Adobe professional who could

Re: Recommendations for temporary file storage

2017-05-24 Thread Peter Cushing
On 24/05/2017 15:00, Ted Roche wrote: Oh, later in the thread, I see you say "Thanks. I could host my own box but I don't want to maintain it." Okie-dokey. Would you pay someone else to maintain the host? How much? Anyone who does maintain a web site ought to be willing to do this for you, fo

Re: generate pdf files by batch and send them by email

2017-05-17 Thread Peter Cushing
On 16/05/2017 21:37, rafael.copq...@gmail.com wrote: I need to generate a batch of invoices in PDF format and then send them automatically by email I’ve been exploring the web for some meaningful code but most examples are in VB 1. I have a cursor with N invoices and all pertinent header data 2.

Re: [NF] Sending Large Files...

2017-05-10 Thread Peter Cushing
We are just looking at sendanywhere now. People here can email up to something like 15-20mb then for anything bigger we just create links (with a password) and send them out for people to download. We get links sent to us all the time from wesendit and various others. No need to chop anything

Re: is there a proper way in FPW 2.6 to add a line to the end of a memo?

2017-04-28 Thread Peter Cushing
On 28/04/2017 10:15, Michael Madigan wrote: is there a recommended way in FPW 2.6 to add a line to the end of a memo field? I have been using : replace memo_field with memo_field + new_line and every once in a while the FPT file blows up to a large size (2 or 3 times normal size). I'm guessi

Re: Text file import

2017-04-21 Thread Peter Cushing
On 21/04/2017 16:13, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: I'll take a quick second to remind folks too of VFP2C32.FLL for accessing files greater than 2GB too. Functions are FGetSex Hope that doesn't take you to a dodgy site ;-) Peter This communication is intended for the pe

Re: SQL sum

2017-04-20 Thread Peter Cushing
Hi Tom, Not sure if you are mixing up different tables here. In most of the stock systems I have seen you have: Stock header file. [stock id] [quantity] (in stock, allocated, on PO etc) This total could be say 100 in 4 locations, so 4 records in location file. then you have a stock locatio

Re: Fuzzy Name Searching

2017-04-12 Thread Peter Cushing
On 12/04/2017 15:55, Ken Dibble wrote: I'm looking for suggestions on how to produce results that include close matches on last names that doesn't require pre-processing. About 20 years ago I did some work on marketing databases and one of the big tasks is de-duping data. We did things like

Re: Retrospective properties - the magic of inheritance

2017-04-10 Thread Peter Cushing
On 08/04/2017 00:50, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: I've always tried to never go more than 3 deep. My corporate gig has me digging 11+ levels at times. Needless to say, it's an "Excedrin moment" when I have to debug that. The developers are of a genius level--really, so

Re: Excel class not registered

2017-03-29 Thread Peter Cushing
On 29/03/2017 09:39, Paul Newton wrote: Hi all Whilst testing AssocQueryString I temporarily renamed EXCEL.EXE. When finished I restored the original name. However, now: CreateObject('Excel.Application') returns an OLE error code 0x80040154: Class not registered. Any suggestions welcome. T

Re: Monday Survey Question

2017-03-22 Thread Peter Cushing
On 22/03/2017 14:58, Man-wai Chang wrote: -- .~. 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! Hey Man-wai, Isn't it about time you upgraded your Ubuntu 9.10 ;-) Pete

Re: [NF][FW] NASA Releases Tons Of Free, Open Source Software, Here’s How To Get Them

2017-03-06 Thread Peter Cushing
On 06/03/2017 15:31, Man-wai Chang wrote: Download Page: https://software.nasa.gov/ List of tools: https://software.nasa.gov/NASA_Software_Catalog_2017-18.pdf Full story: https://www.techworm.net/2017/03/nasa-released-massive-catalog-free-open-source-software-download.html Looks pretty confus

Re: Hard-Coded Scalar Value Substituted at Run Time

2017-03-02 Thread Peter Cushing
On 02/03/2017 16:58, Ken Dibble wrote: Of course, the way to handle this is to add code to test the size of the array before trying to iterate it, which I have now done. But I am still at a loss to understand how the error could occur. What I usually do in situations like this is to put in lin

Re: Copy Excel worksheet to another workbook

2017-02-17 Thread Peter Cushing
On 17/02/2017 12:35, Paul Newton wrote: Richard Unfortunately, you are copying the worksheet to a new worksheet in the same workbook. I want to copy the active worksheet to a new worksheet in a different workbook (which already exists), _without_ opening the target workbook ... still don't ha

Re: Copy Excel worksheet to another workbook

2017-02-16 Thread Peter Cushing
On 16/02/2017 16:48, Paul Newton wrote: Hi all I want to use automation to copy the active worksheet into another workbook (as an additional worksheet) I believe I need something like this ActiveSheet.Copy After:=Workbooks("YourWorkbookName.xls"). Sheets("Sheet3") But I can't find how to send t

Re: "Cannot locate the Microsoft Visual FoxPro Support Library"

2017-02-03 Thread Peter Cushing
Just checked one of my install scripts and it installs: msvcr70.dll in one script and msvcr71.dll in another. Not sure why at the moment. vfp7renu.dll vfp7r.dll plus some other rich text controls etc but think they are optional. HTH Peter Cushing IT Department WHISPERING SMITH On 03/02

Re: Diffing VCXs

2017-02-01 Thread Peter Cushing
I right clicked on the link button and "save link as" it then brought up my fireftp add-on and I could then transfer the file. Confirmed the zip contains the program. I can email it to you if you have no joy. Peter Cushing IT Department WHISPERING SMITH On 01/02/2017 14:07, P

Re: CleverFox Backup

2017-01-31 Thread Peter Cushing
On 30/01/2017 13:39, Ted Roche wrote: Peter: I would have a concern if the backup server can be connected-to over the same network containing the primary data, you have a risk that malware on connecting machines (ransomware is the current concern, but not the only one) could contaminate both the

Re: CleverFox Backup

2017-01-30 Thread Peter Cushing
On 27/01/2017 19:25, Ted Roche wrote: And how do you grab all the indexes, including that new one you added last week? And the free tables as well as the ones in the DBC. And don't forget the captions and stored procedures in the DBC. I mean, how hard can it be? Selling utilities to programm

Re: New Year Brain Teaser...

2017-01-06 Thread Peter Cushing
On 06/01/2017 14:19, Dave Crozier wrote: In the init of the form the oData property is assigned i.e. Select Scatter name Thisform.oData memo What I ultimately want to do is the following: Thisform.txtText1.ControlSource = "Thisform.oData.Field1" ... for each of the form controls etc. Hi Dave

Re: Unit quantities

2016-12-22 Thread Peter Cushing
On 20/12/2016 22:20, Sytze de Boer wrote: In my accounting/invoicing system, clients create product items. Let's say you sell Apples You can sell single apples apples in a carton (e.g. 25 apples per carton) cartons of apples on a pallet (e.g. 50 cartons per pallets) I would like to know how YOU

Re: VFP Help File Problem

2016-12-01 Thread Peter Cushing
Hi Dave, Perhaps the CHM has become corrupt. Do you have a backup copy to try or maybe install VFP9 on a VM and nick the CHM off it. Peter Cushing IT Department WHISPERING SMITH On 01/12/2016 14:21, Dave Crozier wrote: In the VFP Global options, the help file is pointing to the correct

  1   2   3   4   5   6   7   8   9   >