Re: [NF] Microsoft Commercials

2008-09-25 Thread Peter Cushing
Whil Hentzen wrote: > When something increases at the same rate, velocity is constant, > acceleration is 0. When velocity increases, acceleration is > 0. When > velocity decreases, acceleration is < 0. > AKA deceleration. Peter --

Re: Splitting of Distributable VFP System

2008-11-10 Thread Peter Cushing
Kurt Wendt wrote: > Hello there folks, > > > So - I am turning to this mailing list in hopes of getting ideas > for a possible solution! > > Hi Kurt, Welcome to the list. Hope it proves useful to you. There have been quite a few posts in the past from people who use a "loader" exe

Re: Error 39

2011-08-11 Thread Peter Cushing
Sytze de Boer wrote: > I wonder if some of you care to comment. > > There's a zillion places in my app where something is updated and an > example could be > > lnOv=10 > lnNv=20 > newvalue=lnOv/lcNv > replace currentcost with newvalue > > No problem sofar > > If lnOV=0 >we end up with numeric o

Re: Foxpro 2.6 to Win 7

2011-09-15 Thread Peter Cushing
> I've been perusing the leafe archives but am a little confused. > > 1. Will foxpro for windows 2.6 run on Win 7 32-bit as is? > > It certainly will. I'm running it (version 2.6a) on windows 7 32 bit, with no problems. Peter -

Re: [NF] Measuring code quality

2011-09-28 Thread Peter Cushing
MB Software Solutions, LLC wrote: > On 9/28/2011 9:45 AM, Richard Kaye wrote: > >> Code review? WTF is a code review? >> > I too am surprised at how many folks do NOT do code review. It's > amazing to me. Even people I'd expect would be on-board with that. WTF > don't they do it? lol

Re: Combo box in grid

2011-11-22 Thread Peter Cushing
Stephen Weeks wrote: > should it not be :- > thisform.grdsf.column2.combo1.ControlSource = 'dutyh.dh_fabrc' > > This gives an error when you try to run it. "Parent object will not allow this property setting for thisform.grdsf.column2.combo1.ControlSource" I've got a test form half working b

Re: Combo box in grid

2011-11-22 Thread Peter Cushing
- > From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of > Peter Cushing > Sent: 21 November 2011 17:27 > To: ProFox List > Subject: Combo box in grid > > Hi all, > > Having a few problems trying to get a combo box in a grid working the way I > wan

Re: Combo box in grid

2011-11-22 Thread Peter Cushing
Cheers Dave I'll check it out now. Thanks, * Peter Cushing * IT development and support Signature Dave Crozier wrote: > Oh, it should be non version specific in code, which is why I chose it > > Dave > > > -Original Message- > From: profox-boun...@lea

Re: Combo box in grid [SOLVED]

2011-11-23 Thread Peter Cushing
With Dave's help I found what was stopping the form working. In my other screens with grids I used to create the cursor in the init, then assign the recordsource and controlsource for the grid immediately afterwards. Been doing that for years in other forms and not had a problem. If I create

Re: Combo box in grid [SOLVED]

2011-11-23 Thread Peter Cushing
Tracy Pearson wrote: > > Peter, > > So you create the cursor in the FORM.LOAD event, then code up the grid in > the FORM.INIT? The grid doesn't exist yet in the FORM.LOAD. > > > I create the cursor in the form.load event but the grid has already been coded at design time. When I create the cur

Re: Report design problem

2011-12-02 Thread Peter Cushing
very simple. HTH * Peter Cushing * IT development and support Signature Paul Newton wrote: > Yes, exactly ... > > -Original Message- > From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On > Behalf Of Dave Crozier > Sent: 02 December 2011 1

Re: Problem with set filter

2011-12-07 Thread Peter Cushing
Michael Savage wrote: > > When the user would like to see both sets together, > I use > set filter to. > > After each filter change I issue a > Go top > to move the record pointer. > > But what happens is this: > When I chose, both, the filter is cleared, according to the > set("filter") command

Re: Problem with set filter

2011-12-07 Thread Peter Cushing
Michael Savage wrote: > sorry about the confusion... i know firstrecord is an active one... yet > the list still appears to be set to inactive. > mike > > Have you tried just browsing the table, then setting filters, then go top and check which record it goes it? If that works fine you cou

Re: VFP and multithreading

2011-12-15 Thread Peter Cushing
Sytze de Boer wrote: > I've been wondering about multi-threading > I don't know if I completely understand this process and I wonder if > someone here can throw some light on this > > In my app, there is 1 module where people have to wait from 5 to 15 secs > for the system to complete a process > (

Re: Merry Christmas

2011-12-22 Thread Peter Cushing
Dave Crozier wrote: > On the basis that I will be finishing work in about 2 hours time until the > new year, I would like to wish every one of you on the list a Merry Christmas > and a Happy new year. > > We may be a dwindling bunch of out of date developers (lol!!) but you guys > are some of

Re: Select statement... aaargh!

2012-01-04 Thread Peter Cushing
P SQL will allow you do get away without doing that. I think there is a command SET ENGINEBEHAVIOR to 6 or something similar to set it back to an earlier version. HTH * Peter Cushing * IT development and support Signature Adam Buckland wrote: > I run a routine once a year and have just up

Re: Select statement... aaargh!

2012-01-04 Thread Peter Cushing
Just thought about that a bit more and you don't actually need the distinct at all. If you did: select key1, cust, pcode, sum(sale) as sold from tempsac group by 1,2,3 into table usage That should give you all the distinct key1's as you are grouping by it. *Peter Cushing * IT d

Re: Format expression in report designer

2012-01-06 Thread Peter Cushing
Hi Paul, You could leave the format blank and change the field in your report cursor to the format you want. It would then just report it as it finds it. Other than hacking the .FRX/T files I can't think of another way of doing it. HTH * Peter Cushing * IT development and support Sign

Re: Two DBC's with the same file name

2012-01-24 Thread Peter Cushing
You could use DBF('filealias') and check the path and presumably that will show the difference. HTH * Peter Cushing * IT development and support Signature Jeff Johnson wrote: > I have two DBC's with the same file name in them. Everything works okay > except for checki

Re: Debugger - Source Not Available

2012-02-03 Thread Peter Cushing
Kurt Wendt wrote: > As for the Env. - I'm building the App in our office, and when its done > - it will be sent to the client. It's a new App for the client, but > based upon an older one used for other clients (its for UCC Label > printing). > > I did just now set the project to include DEBUG info

Buy VFP 9 plus alternative reporters.

2012-02-08 Thread Peter Cushing
, -- * Peter Cushing * IT development and support Signature Rajan Imports has changed - we are now Whispering Smith Ltd. For more information see our website at www.whisperingsmith.com Please update your address book with my new email

Re: Report Writer Situation

2008-06-09 Thread Peter Cushing
Francis (net) wrote: > I've got a report with three tables ... related. > > I'm using two detail bands and one Group similar to > 'employeesMD.frx' > in "The VFP Report Writer: Pushing it to the Limit and Beyond" > ... chapter 5 VFP 9 update. > > In actuality it's behaving exactly as I would expect

Re: Foxpro For Windows 2.6 GetFile oddity.

2008-08-12 Thread Peter Cushing
Alan Bourke wrote: > FPW 2.6 application running as an APP called from an EXE. There is a > call to GetFile() to return a filename. > > Run locally, it works. Run off a Novell server, the GetFile() call > brings up the file location dialog, but locks the FPW EXE up on > clicking the 'Open' button i

Re: VFP Print to fit reports

2008-08-18 Thread Peter Cushing
Cathy Pountney wrote: > No .. there are no videos of the sessions. > Hi Cathy, Don't tell me... you've got to buy the book ;-) Actually, is this available in any of your books? Peter This communication

Re: VFP Print to fit reports

2008-08-18 Thread Peter Cushing
Cathy Pountney wrote: > No .. it's not in any book. The book I wrote was back when VFP 7 was current > so there isn't anything about VFP 9 in there. I would really like to update > the book .. and some days I really, really get the urge. I'm currently > involved in co-authoring a book about Sedna a

Re: VFP9 SP1 bug?

2008-08-19 Thread Peter Cushing
Dave Crozier wrote: > Kam, > Just to elaborate, if you think about it then the default alias of the table > becomes sample-p, which can be misinterpreted by a parser as being an actual > expression - hence the error. > Hi Dave, Using VFP7 when I open a table of this name the default alias beco

Re: [NF] Whither Firefox 3??

2008-09-05 Thread Peter Cushing
Kenneth Kixmoeller/fh wrote: > >> FireFox is now at 3.0.1 and I downloaded it recently. So far so > good. > > Thanks, Rick = == > > With the deafening silence to my question, it seemed like people were > collectively "Well, duh" about upgrading. > Sorry, was going to reply earlier but been

Re: VFP9 - Speed

2010-03-19 Thread Peter Cushing
Tracy Pearson wrote: > That needs the Group By 1 (or group by client) on it too. > > > select client, MAX(date) from winhst > where client=myclient into cursor temp > if _Tally >0 > your stuff here > endif > > select MAX(date) from winhst ; where client=myclient into cursor temp if

Re: [NF] Rackspace CEO interview on CNBC

2010-05-20 Thread Peter Cushing
Ed Leafe wrote: > Lanham Napier, president and CEO of Rackspace, on CNBC yesterday > talking about cloud computing and what it means for businesses. > > http://www.cnbc.com/id/15840232?video=1498260012&play=1 > ( -or- http://j.mp/cb00mH ) > > And is it just me, or does Lanham sound li

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

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

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

  1   2   3   4   5   6   7   8   9   >