Recent content by pennyman

Many thanks for all of your kind contributions. I really appreciate the time taken and quality of advice. Great to see you're not completely out to pasture yet Mike Lewis[bigsmile]. My Painswick VFP course has been pretty handy over the last 25 years, and I'm still at it!! Whatever we end...

Thanks Griff, Your point on codebase is noted. Yes, I'm not expecting a fun time. I'm hoping that some of the still advertised conversion specialists have tools that may help take the grunt work away. Does anyone have any experience in using third parties for this sort of work? Cheers, Mike.

Hi all, Would anyone like to share their experiences in using 3rd parties to convert a VFP project to C# / SQL? Any recommendations or horror stories appreciated!! Mike Penny.

Hi, I've been using Zebra TLP 3844-Z printers for printing barcode labels for stock items and shipping labels for many years now. I use the native ZPL printer language (very simple and easy to understand), and the zpl windows driver networked from a print server. This driver supports the use...

Hi Edgar, Yes I've come across this. I this was a method of providing smb 1 storage for shared VFP data without affecting an entire server by switching off SMB1, or altering client network configuration. I suspect this is now defunct given current Windows 10 clients no longer support smb 1...

I note thread184-1809732 refers to this.

thread184-1800416 As an update to the above thread, please note the article referenced by Griff in his post of 20 Jan 20 8:59 is now dead. The article can now be found at: https://kb.datafile.co.uk/article.php?id=2132. Does anyone have any further experience or comment on using Server 2019...

Many thanks to all who have replied. Mike Yearwood - Spot on! sys(1104) does the trick - having issued SYS(1104) immediately prior to my select, the updated data is returned. I would expect a performance hit of course, but far better that, than to have out of date data returned quickly! I'd...

Mike, I you mention VFP default SELECT behaviour was buffered. You are right, I thought I had tested unbuffered, as I was assuming that running a select from code within a form whose BufferMode = 0 (none) would result in an unbuffered query. Is it the case that I need to set buffering...

Mike, thanks for the prompt reply. I'll try FlushFileBuffers IN Win32API once I've figured out how to apply it to an open dbf file. However, unless I'm missing something major, would you agree that this wouldn't explain how changes only in the selecttest form would give such drastically...

First, please forgive me if this is a well known issue, I feel sure it should be given the significance of its effects, but I have been unable to find any prior reference to the issue under Tec Tips or otherwise. I am rather hoping that I have I've done something stupid, or that the issue is...

Apologies Dave, I didn't make myself clear. I was after something programatic that I can include into code. Cheers anyway!

Does anyone know of a way to identify the user or workstation that is either locking a table or record, or simply has a record in use? I support an application with a considerable amount of legacy code, and where a transaction or simple update fails due to a record being in use I would like to...

Can anyone put me straight on whether it is 'safe' to use high (> char(127)) ascii characters in an email? A bit of background... We email clients in approx 100 countries worldwide. As policy, I advise users to initially use plain text until we know the recipient has a html client. Our email...

You need to change your default directory to the images directory before you call getfile ie: * we need to remember the current directory first... lcOldDir = sys(5)+sys(2003) CD c:\images lcImage = GETFILE("JPG") * now restore the default dir (in case it's used elsewhere) cd...