Re: Word automation

2008-09-22 Thread Chris Davis
and if excel is loaded more than once ? is it possible to get access to either ? 2008/9/22 Dave Crozier <[EMAIL PROTECTED]> > Rafael, > Allen is correct - GetObj() will grant access to a currently loaded Excel. > An error indicates that Excel is NOT loaded. > > Dave Crozier > > -Original Mess

Re: Word automation

2008-09-22 Thread Chris Davis
gure out > how/why I got one or the other. > > Tracy > > -Original Message- > From: Chris Davis > Sent: Monday, September 22, 2008 12:10 PM > > and if excel is loaded more than once ? is it possible to get access to > either ? > > 2008/9/22 Dave Crozier

Help with VB.NET and VFP COM DLL

2011-09-21 Thread Chris Davis
Hi All, I am currently working with a VB.NET project (not my own) and wish to use my VFP COM DLL in it. I have created a very simple DLL for testing. The DLL works fine from VFP but when I try and implement it in the VB.NET project I get the following error. Could not load file or assembly '

Re: Help with VB.NET and VFP COM DLL

2011-09-21 Thread Chris Davis
Yes it is in references and the intellisense picks it up - Original Message - From: profoxtech-boun...@leafe.com To: profoxt...@leafe.com Sent: Wed Sep 21 15:16:51 2011 Subject: Re: Help with VB.NET and VFP COM DLL On Wed, Sep 21, 2011 at 8:54 AM, Chris Davis wrote: > Hi All, >

Re: Help with VB.NET and VFP COM DLL

2011-09-21 Thread Chris Davis
2008 and 9 - Original Message - From: profoxtech-boun...@leafe.com To: profoxt...@leafe.com Sent: Wed Sep 21 15:24:40 2011 Subject: Re: Help with VB.NET and VFP COM DLL On Wed, Sep 21, 2011 at 9:20 AM, Chris Davis wrote: > Yes it is in references and the intellisense picks it

Re: Help with VB.NET and VFP COM DLL

2011-09-21 Thread Chris Davis
9:20 AM, Chris Davis wrote: > Yes it is in references and the intellisense picks it up WAG here but the dependencies for VFP are not found. Was VFP installed on this system? If not maybe you need to put the VFP runtimes into the bin folder as well. -- Stephen Russell Unif

RE: Help with VB.NET and VFP COM DLL

2011-09-21 Thread Chris Davis
Moving the com dll into the bin folder does not make any difference -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Chris Davis Sent: 21 September 2011 15:43 To: profoxt...@leafe.com Subject: Re: Help with VB.NET and VFP COM DLL

RE: Help with VB.NET and VFP COM DLL

2011-09-21 Thread Chris Davis
Hi scrap this one, I didn't realise vb.net creates a interop.mydllname.dll file which I also have to move -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Chris Davis Sent: 21 September 2011 15:21 To: profoxt...@leafe.com Su

Re: Help with VB.NET and VFP COM DLL

2011-09-21 Thread Chris Davis
Just find oledb and vfp data in vb a chore - Original Message - From: profoxtech-boun...@leafe.com To: profoxt...@leafe.com Sent: Wed Sep 21 16:49:15 2011 Subject: Re: Help with VB.NET and VFP COM DLL On Wed, Sep 21, 2011 at 10:15 AM, Chris Davis wrote: > Moving the com dll into

Re: Help with VB.NET and VFP COM DLL

2011-09-21 Thread Chris Davis
, Sep 21, 2011 at 11:08 AM, Chris Davis wrote: > Just find oledb and vfp data in vb a chore --- Yep it is a chore. That might be where things are messed up. In that within VFP and the VFP engine it is fine, but anything else it fails. Can this com be called from excel in a

Foxpro for Windows and 64Bit

2011-10-26 Thread Chris Davis
Hi All, Some old foxpro for windows applications we run work fine on Windows 7 32bit, will they work on Windows 7 64bit. Thanks Chris. __ This email has been scanned by the MessageLabs Email Security System. For more informati

RE: Foxpro for Windows and 64Bit

2011-10-26 Thread Chris Davis
ual PC is your friend -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Chris Davis Sent: Wednesday, October 26, 2011 8:58 AM To: profox@leafe.com Subject: Foxpro for Windows and 64Bit Hi All, Some old foxpro for windows applications we

RE: Foxpro for Windows and 64Bit

2011-10-26 Thread Chris Davis
t: Re: Foxpro for Windows and 64Bit Hi Chris, Check if 'hardware virtualization' is enabled. You may need to enable this in the BIOS. Of if you're unlucky your CPU might not support it. VirtualPC will run much faster with this. Paul On Wed, Oct 26, 2011 at 3:45 PM, Chris Davis wro

Reboot Windows

2011-11-09 Thread Chris Davis
I have some code which uses ExitWindowsEX to reboot the pc from fox, this does not seem to work on a Windows 7 PC any ideas? Thanks Chris. __ This email has been scanned by the MessageLabs Email Security System. For more inform

RE: Reboot Windows

2011-11-09 Thread Chris Davis
Sure does! -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke Sent: 09 November 2011 14:11 To: profoxt...@leafe.com Subject: Re: Reboot Windows Does shutdown -s -t 01 from the prompt work? -- Alan Bourke alanpbourke

RE: Reboot Windows

2011-11-09 Thread Chris Davis
Could it be anything to do with it being 64bit Windows 7 and the API call I'm making is 32bit ? -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke Sent: 09 November 2011 14:30 To: profoxt...@leafe.com Subject: RE: Reboot W

RE: Reboot Windows

2011-11-09 Thread Chris Davis
Seems I am getting a 1314 priviledge not held on Windows 7 -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Chris Davis Sent: 09 November 2011 14:37 To: profoxt...@leafe.com Subject: RE: Reboot Windows Could it be anything to do

RE: Reboot Windows

2011-11-09 Thread Chris Davis
Solved! All down to priviledges. -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Chris Davis Sent: 09 November 2011 14:57 To: profoxt...@leafe.com Subject: RE: Reboot Windows Seems I am getting a 1314 priviledge not held on

Re: Corruption

2008-06-06 Thread Chris Davis
so instead of fixing the table with a third party util i could lower the tablevalidate setting so that i can get the data out into a newly created replacement table ? 2008/6/4 Rick Schummer <[EMAIL PROTECTED]>: >>> how come the corruption does not affect the remote view ?<< > > The remote view is

RE: Google API for Geocoding ... Again

2019-02-04 Thread Chris Davis
Not sure if this will help as only glancing at these emails but in vfp I do visit the following URL http://maps.googleapis.com/maps/api/geocode/json?address=##ADDRESS## using either vfpconnection or the Microsoft html thing ( I can be more specific if required) the ##ADDRESS## is replaced with

VFP application issues on new server

2019-02-05 Thread Chris Davis
Hi All We have an app, which has lived on windows PC's and a windows server (on premisis) for years which has worked without issue. Nothing fancy going on! It has now been moved onto two virtual machines, both on the same host in the cloud. One machine is acting as the file server and one as

RE: VFP application issues on new server

2019-02-05 Thread Chris Davis
It's all server 2016 -Original Message- From: ProfoxTech On Behalf Of Alan Bourke Sent: Tuesday, 05 February 2019 10:29 To: profoxt...@leafe.com Subject: Re: VFP application issues on new server What are the operating systems in question ? There was an issue recently with an update to W

RE: VFP application issues on new server

2019-02-05 Thread Chris Davis
As far as I'm aware the backups will be being taken as an image of the virtual machine but I will check. I don't think it's indexing related as if we move the data to the RDS box (i.e. the data is on the same box as the client) it works fine, so whatever the issue is seems to be network related

RE: VFP application issues on new server

2019-02-05 Thread Chris Davis
he property in the goods passes to the buyer the seller shall be entitled at any time -Original Message- From: ProFox On Behalf Of Chris Davis Sent: 05 February 2019 09:26 To: profox@leafe.com Subject: VFP application issues on new server Hi All We have an app, which has lived on wi

RE: VFP application issues on new server

2019-02-06 Thread Chris Davis
I will double check, but I believe it is a dedicated physical box in a data centre, which then has the two virtual machines running on it. It's definitely not a file share across the internet as when it works its fine -Original Message- From: ProfoxTech On Behalf Of Alan Bourke Sent: We

Pipe Delimited

2019-02-07 Thread Chris Davis
Is it possible to export a cursor/table to Pipe Delimited with Headers without rolling my own? Thanks Chris. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages t

RE: Pipe Delimited

2019-02-07 Thread Chris Davis
kind of add the headers by hand. If I'm not mistaken... And - by hand - I mean doing low-level file handling - or some such. -K- On 2/7/2019 6:13 PM, Chris Davis wrote: > Is it possible to export a cursor/table to Pipe Delimited with Headers > without rolling my own? > > Than

SFTP

2019-02-08 Thread Chris Davis
Me again, sorry! I have been using vfpconnection for sometime now, very useful! However I have now got a ftp server that I wont connect to. The url I have been given starts SFTP, vfpconnection only seems to support FTPS. When I use FTPS I just send up with a SSL error when tracing it through.

RE: SFTP

2019-02-11 Thread Chris Davis
Thanks both I have given the trial version of west wind a whirl and as expected it just works! -Original Message- From: ProfoxTech On Behalf Of Tracy Pearson Sent: Friday, 08 February 2019 12:24 To: profoxt...@leafe.com Subject: Re: SFTP I use Chilkat and can recommend it. On Februar

RE: SFTP

2019-02-19 Thread Chris Davis
Yes please! -Original Message- From: ProfoxTech On Behalf Of mbsoftwaresoluti...@mbsoftwaresolutions.com Sent: Monday, 18 February 2019 20:48 To: profoxt...@leafe.com Subject: Re: SFTP On 2019-02-08 06:09, Chris Davis wrote: > Me again, sorry! > > I have been using vfpconne

RE: SFTP

2019-02-20 Thread Chris Davis
uyer the seller shall be entitled at any time -Original Message- From: ProFox On Behalf Of mbsoftwaresoluti...@mbsoftwaresolutions.com Sent: 19 February 2019 18:20 To: ProFox Email List Subject: Re: SFTP On 2019-02-19 13:18, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: > On

File Access Issues

2019-03-21 Thread Chris Davis
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 these are remote desktop servers which access the VFP

Re: File Access Issues

2019-03-21 Thread Chris Davis
Thanks Peter The RDP client ? > On 21 Mar 2019, at 10:28, Peter Cushing wrote: > >> 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 u

RE: File Access Issues

2019-03-21 Thread Chris Davis
de sure that Windows Defender has also been set to ignore .DBF/.CDX/.FPT files on both the servers and the workstations? Fred On Thu, Mar 21, 2019 at 2:42 AM Chris Davis wrote: > We are seeing increasing problems with VFP applications (some of our > own and other commercial ones) a

Mobile Forms

2019-04-08 Thread Chris Davis
Hi All We are looking at extending our application so we can gather some information from mobiles. The easiest example is a signature for proof of delivery. We certainly don't want to start from scratch and are hoping to find a solution which will allow us to feed some basic data across for th

RE: Mobile Forms

2019-04-08 Thread Chris Davis
wn to. We did it in android and followed their MVC application standards. All the tools are free all it takes is time and advil as you learn what you goofed upon. On Mon, Apr 8, 2019 at 9:32 AM Chris Davis wrote: > Hi All > > We are looking at extending our application so

RE: Mobile Forms

2019-04-09 Thread Chris Davis
   $0    $119$219 Johan Nel George, South Africa FOX member: Friends of XSharp Website    : https://xsharp.info <https://xsharp.info/> VFP forum  : https://www.xsharp.info/forum/public-vfp X# Runtime : https://github.com/X-Sharp/XSharpPublic On 2019/04/08 16:32, Chris Davis wrote: > Hi

RE: Landscape PDFs using XFRX

2019-04-24 Thread Chris Davis
>From XFRX FAQ 5.1. The paper size is wrong, landscape reports are generated as portrait. Make sure you don't delete all information from the EXPR field of the first record of the page. XFRX doesn't use printer settings stored in the FRX file and uses PAPERSIZE and ORIENTATION values from the EX

RE: Error on Win10 machine invoking IE in code from VFP9SP2 app

2019-04-26 Thread Chris Davis
Is it possible the 32bit version of internet explorer is either missing or disabled in some way? -Original Message- From: ProfoxTech On Behalf Of MB Software Solutions, LLC Sent: Friday, 26 April 2019 16:16 To: profoxt...@leafe.com Subject: Error on Win10 machine invoking IE in code fro

RE: File Access Issues

2019-04-29 Thread Chris Davis
xTech On Behalf Of Chris Davis Sent: Thursday, 21 March 2019 16:26 To: profoxt...@leafe.com Subject: RE: File Access Issues I am sure the Anti Virus which had been ruled out as the cause (Sophos) has been reinstalled and disables Defender, but it's a good heads up and I will double check. T

VFP Data / Node / MariaDB

2019-07-11 Thread Chris Davis
I have been experimenting (more like messing around) with ways to create an API to VFP data. The reason for this is to be able to leave our existing or other third party VFP apps doing what they do but provide the information within them to other parties via an API. I quite easily created a si

RE: VFP Data / Node / MariaDB

2019-07-11 Thread Chris Davis
helps, Tracy P.S. Shameless plug http://swfox.net/SessionsSWFOX.aspx#Implementing_a_VFP_COM_Object_in_a_C_Project -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Chris Davis Sent: Thursday, July 11, 2019 11:15 AM To: profoxt...@leafe.com Subject: VFP

SFTP

2019-08-02 Thread Chris Davis
Before I make a purchase of either Chilkat or West Wind Internet & Client Tools which are both around the same price. At this moment its simply to get a SFTP function but both of these come with lots of other stuff. Does anyone else pay for either of these and have any recommendations of one o

RE: SFTP

2019-08-02 Thread Chris Davis
Thanks ed I will check it out, but I fear ease of deployment might be the compromise ? -Original Message- From: ProfoxTech On Behalf Of Ed Leafe Sent: Friday, 02 August 2019 13:53 To: profoxt...@leafe.com Subject: Re: SFTP On Aug 2, 2019, at 4:25 AM, Chris Davis wrote: > > Be

RE: SFTP

2019-08-02 Thread Chris Davis
://www.chiark.greenend.org.uk/~sgtatham/putty/ In the past, I have set up a couple of clients with overnight routines that process data and upload results using PuTTY. On Fri, Aug 2, 2019 at 8:53 AM Ed Leafe wrote: > On Aug 2, 2019, at 4:25 AM, Chris Davis wrote: > > > >

RE: [NF] Microsoft Teams

2019-08-20 Thread Chris Davis
If you have Office365 and had Skype for Business installed then Microsoft Teams is it's replacement. -Original Message- From: ProfoxTech On Behalf Of data...@adam.com.au Sent: Wednesday, 21 August 2019 04:35 To: profoxt...@leafe.com Subject: RE: [NF] Microsoft Teams Me either. But it al

RE: Someone was asking about SFTP client libraries recently.

2019-08-23 Thread Chris Davis
Thanks Alan -Original Message- From: ProfoxTech On Behalf Of Alan Bourke Sent: Friday, 23 August 2019 09:13 To: profoxt...@leafe.com Subject: Someone was asking about SFTP client libraries recently. It appears that the very popular free WinSCP client has a .NET Assembly that wraps its s

SMB

2019-08-27 Thread Chris Davis
Hi All With any networked VFP application sharing a DBC the SMB performance of the server hosting the DBC is very important? Assuming your answer to the above question is Yes or Of Course, then when you have one server that seems to perform well and one that doesn't it would be useful to easil

RE: SMB

2019-08-27 Thread Chris Davis
Value name: Smb2Value type: REG_DWORD0 = disabled1 = enabled 4. Set the value to 0 to disable SMB 2.0, or set it to 1 to re-enable SMB 2.0. 5. Reboot the server. This paper may also be of some assistance: https://www.dataaccess.com/KBasePublic/Files/2476.Tuning%20Microsoft%20Networks%20for%20th

RE: SMB

2019-08-27 Thread Chris Davis
Ted Roche Sent: Tuesday, 27 August 2019 13:32 To: profoxt...@leafe.com Subject: Re: SMB On Tue, Aug 27, 2019 at 6:58 AM Chris Davis wrote: > > With any networked VFP application sharing a DBC the SMB performance > of the server hosting the DBC is very important? > No. Yes, netwo

Re: SMB

2019-08-27 Thread Chris Davis
Brilliant Alan thanks I will give it a shot > On 27 Aug 2019, at 14:32, Alan Bourke wrote: > >> On Tue, 27 Aug 2019, at 11:57 AM, Chris Davis wrote: >> >> or at least allow you to compare two setups? > > Go to server 1 and run PowerShell as adm

RE: SMB

2019-09-03 Thread Chris Davis
Has anyone got any thoughts on New-SMBMapping -UseWriteThrough $True -Original Message- From: ProfoxTech On Behalf Of MB Software Solutions, LLC Sent: Tuesday, 27 August 2019 14:44 To: profoxt...@leafe.com Subject: Re: SMB On 8/27/2019 8:29 AM, Frank Cazabon wrote: > Hi Chris, > > I m

RE: SMB

2019-09-03 Thread Chris Davis
>From what I have read it is also in the latest version of Windows 10, so you >can effectively type from the client end ... New-smbmapping -remotepath '\\myserver\myvfpappshare' UseWriteThrough $True And it doesn't matter what the server is. -Original Message- From: ProfoxTech On Beha

OLE iDispatch Exception

2019-10-24 Thread Chris Davis
The following code works most of the time but occasionally it throws the following OLE error when .send is called, any ideas? lcURL=www.bbc.co.uk && not the real url oHTTP = CreateObject("msxml2.xmlhttp") oHTTP.open("GET",lcurl,.f.) oHTTP.send() OLE IDispatch exception c

RE: OLE iDispatch Exception

2019-10-24 Thread Chris Davis
2019 11:34 To: profoxt...@leafe.com Subject: Re: OLE iDispatch Exception Your internet connection is [briefly] down? On 24-Oct-2019 2:50 PM, Chris Davis wrote: > The following code works most of the time but occasionally it throws the > following OLE error when .send is called, any ideas? > >

File Sync

2019-11-20 Thread Chris Davis
Can anyone recommend a free and simple file syncing program to mirror a folder on a server to a local folder (files and subfolders). I had been using freefilesync / robocopy but struggling with both of these on one particular computer and want to try another such utility to see if it gives me a

SQL Dump

2019-11-28 Thread Chris Davis
Hi All Is there any tricks I am missing which would speed up a dump of a VFP table into a SQL table. I have predifined by SQL statement something like this "insert into mytable (myfield) values (?m.myfield)" I am then scanning through the VFP table performing a scatter memvar and then executi

RE: SQL Dump

2019-11-30 Thread Chris Davis
lowing you to watch the process as it is cranking. Your single row inserts will waste a lot of energy updating the log for each row you inserted. This skips that altogether. On Thu, Nov 28, 2019 at 10:55 AM Chris Davis wrote: > Hi All > > Is there any tricks I am missing which would

RE: SQL Dump

2019-11-30 Thread Chris Davis
...@leafe.com Subject: Re: SQL Dump For the purposes of a daily backup as a failsafe or what? On 11/30/2019 2:51 PM, Chris Davis wrote: > Thanks everyone for all the ideas and advice, I will give them a try. > > Effectively what I am trying to create is a way to replicate a VFP DBC to a > SQL Da

RE: SQL Dump

2019-12-01 Thread Chris Davis
set up in SSIS There are plenty of youtube vids on this. We use SSIS to extract data from our ERP database nightly for inclusion in the data warehouse and then for our data marts. On Sat, Nov 30, 2019 at 1:52 PM Chris Davis wrote: > Thanks everyone for all the ideas and advice, I will g

RE: SQL Dump

2019-12-01 Thread Chris Davis
Sorry! Thanks Stephen even! -Original Message- From: ProfoxTech On Behalf Of Chris Davis Sent: Sunday, 01 December 2019 14:30 To: profoxt...@leafe.com Subject: RE: SQL Dump Thanks Russell I will get on google/youtube tonight and look into this , thanks for the heads up -Original

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

2020-01-18 Thread Chris Davis
http://eqeus.com/ Does more than just PDF, but includes lots of useful extras. -Original Message- From: ProfoxTech On Behalf Of António Tavares Lopes Sent: Friday, 17 January 2020 23:55 To: profoxt...@leafe.com Subject: Re: AW: May the Open Source Be With You: INTL and SDT! Foxypreview

RE: Is there a way to uto open the last project?

2020-02-03 Thread Chris Davis
We use a simple project class to put us into the root directory of the project we have just opened. DEFINE CLASS projhook AS projecthook Height = 22 Width = 23 Name = "projhook" PROCEDURE Init LOCAL lcDir lcDir=_VFP.ACTIVEPROJECT.H

Opinions on Servers

2020-11-23 Thread Chris Davis
Hi All Just a general question ... If you was choosing a server which would run a vfp application using standard dbfs as fast as possible for around 30 users (connected via remote desktop). What server would you choose to get the best performance? Is it CPU's , Hard Drive Configuration, Memor

RE: Opinions on Servers

2020-11-23 Thread Chris Davis
+ clients. The fastest drives you can get (SSD's are a good choice) and a good backup solution. HTH, Tracy -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Chris Davis Sent: Monday, November 23, 2020 9:04 AM To: profoxt...@leafe.com Subject: Opinion

RE: Opinions on Servers

2020-11-24 Thread Chris Davis
Hi Alan Yes sorry I didn't make it clear, this is an RDS server so the .exe and DBFs will be on the same machine. So it sounds like the main consideration to make the application work as quickly as possible is the disk. Typically in the past we would have had 4 15k rpm HDD's running in a Rai

RE: Opinions on Servers

2020-11-24 Thread Chris Davis
Thanks Christof, I think trying a Raid 10 array with 4 SSD's seems like a good way forward for us as its not a massive change to the norm. Thanks for your input. Regards Chris. -Original Message- From: ProfoxTech On Behalf Of Christof Wollenhaupt Sent: Tuesday, 24 November 2020 11:17

XLSX-Workbook-Class

2020-11-26 Thread Chris Davis
Can anyone help with this ??? I use the example readxlsxfile.prg and check the generated debugexcelread file and everything is correct. i.e. all the values and all the rows ... I then replicate this code in my application and then any string value that's return always returns the first value

RE: XLSX-Workbook-Class

2020-11-26 Thread Chris Davis
Sorry forget this question I have updated from the R31 version to the R32 beta and its now working as expected. -Original Message- From: ProfoxTech On Behalf Of Chris Davis Sent: 26 November 2020 15:53 To: profoxt...@leafe.com Subject: XLSX-Workbook-Class Can anyone help with this

RE: XLSX-Workbook-Class

2020-11-26 Thread Chris Davis
f you would specify, which xlsx class you're referring to. Link? -Ursprüngliche Nachricht- Von: ProFox Im Auftrag von Chris Davis Gesendet: Donnerstag, 26. November 2020 16:53 An: profox@leafe.com Betreff: XLSX-Workbook-Class Can anyone help with this ??? [excessive quoting removed

Printing PDF's

2021-06-02 Thread Chris Davis
Hi All We are currently printing some PDF content using the shell print function that just triggers the default application for opening PDF's to do its stuff. We have a lot of A5 content which needs to printed to fit A4 paper, is there another method I could use that would give us this control

RE: Printing PDF's

2021-06-02 Thread Chris Davis
printers, then I was able to get a list of defined paper sizes for my desired printer, the I was able to print a PDF tabloid (ledger, 11" X 17") from the command line. https://www.cmd2printer.com/overview/syntax <https://www.cmd2printer.com/overview/syntax> *- Matt Slay* On

RE: Printing PDF's

2021-06-03 Thread Chris Davis
I've found ... http://www.columbia.edu/~em36/pdftoprinter.html seems to achieve what I needed Thanks for the heads up on 2printer though Matt. Regards Chris. -Original Message- From: ProfoxTech On Behalf Of Chris Davis Sent: Wednesday, 02 June 2021 13:37 To: profoxt...@leaf

RE: Printing PDF's

2021-06-07 Thread Chris Davis
by default. PDFprinter has a couple of properties than can be set in Settings > Printers. Dne 03.06.2021 v 13:20 Chris Davis napsal(a): > I've found ... > > http://www.columbia.edu/~em36/pdftoprinter.html > > seems to achieve what I needed > > Thanks for the heads up

RE: Printing PDF's

2021-06-07 Thread Chris Davis
even print to a network printer. Hope it helps. http://www.brooksnet.com/lpd/how-print-pdf-files-command-line-windows-printer Mike C Chris Davis wrote: > Thanks for the replies, but I'm not printing to a PDF ... I am printing an > existing PDF to the printer. > > -Original Mes

RE: Printing PDF's

2021-06-09 Thread Chris Davis
PC as default service for PDFs will get that job. wOOdy -Ursprüngliche Nachricht- Von: ProFox Im Auftrag von Chris Davis Gesendet: Montag, 7. Juni 2021 10:10 An: profox@leafe.com; profoxt...@leafe.com Betreff: RE: Printing PDF's Thanks for the replies, but I'm not prin

ShellExecute

2021-06-09 Thread Chris Davis
Hi All I want to ShellExecute a program repeatedly but not until the previous instance has finished, what's the best approach? So I effectively want to wait in a loop until the previous instance exits and then run it again. Ideas? TIA Chris. --- StripMime Report -- processed MIME parts ---

RE: ShellExecute

2021-06-09 Thread Chris Davis
ReturnCode = loWshShell.Run(lcExe + " " + lcCommandLine, 1, .t.) && Wait for result. Endfunc -- Alan Bourke alanpbourke (at) fastmail (dot) fm On Wed, 9 Jun 2021, at 10:33 AM, Chris Davis wrote: > Hi All > > I want to ShellExecute a

RE: Pringing PDFs via ShellExecute from VFP

2021-07-02 Thread Chris Davis
Hi Philip I had the same problem recently and switched with success to http://www.columbia.edu/~em36/pdftoprinter.html as sometimes we found adobe would leave itself open so any checks to see if it was still running couldn't be relied on. Then using the following ShellExecute code ... you wil

Google Sheets

2021-08-04 Thread Chris Davis
Before I start I just wondered if anyone has any experience of interacting with a google sheet from VFP? I have a licensed copy of ChilKat and have successfully create an app and authenticated and managed basic read and write bulk data updates. But now need to my head around identifying and upd

Slow performance after moving to VM

2021-10-26 Thread Chris Davis
Hi All Has anyone got any suggestions as to where the problem maybe in the following scenario. We have a VFP application, using DBC/DBF's on a windows server, it has been running fine and quick for years. Various windows clients (all now Windows 10). The server was a physical server but has n

RE: Slow performance after moving to VM

2021-10-26 Thread Chris Davis
Thanks Christof, assuming at the moment this was the issue did you manage to speed it up? Was there a configuration on the client which determined how many packets could be exchanged? -Original Message- From: ProfoxTech On Behalf Of Christof Wollenhaupt Sent: 26 October 2021 11:23 To:

Anyone on here involved with Virtual Fox Fest?

2021-12-21 Thread Chris Davis
Any idea if this link will be made available again? https://virtualfoxfest.com/2020/ Thanks Chris. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@

RE: Anyone on here involved with Virtual Fox Fest?

2021-12-22 Thread Chris Davis
Thank you Ajit -Original Message- From: ProfoxTech On Behalf Of Ajit Abraham Sent: 22 December 2021 04:50 To: profoxt...@leafe.com Subject: Re: Anyone on here involved with Virtual Fox Fest? I tried the link yesterday - got a 404 error Its fine today. Ajit On 21/12/2021 16:53, Chris

VFP Advanced COM

2022-04-26 Thread Chris Davis
Just having a play around with this, I have created a simple COM exe and compiled it in the 64bit version of VFPA. It suggests its creating a 64bit exe but I can only create an instance of it from a 32bit application (VFP 32bit / Node 32bit) ... if I try from VFPA 64Bit or Node 64Bit then it ca

RE: VFP Advanced COM

2022-04-26 Thread Chris Davis
Actually got this working now, a typo! But interesting when I try and create an instance of the 64 bit com exe within the command window of VFPA itself it crashes, everywhere else it works fine. -Original Message- From: ProfoxTech On Behalf Of Chris Davis Sent: 26 April 2022 14:49 To

RE: Need Help - Foxpro & Chilkat & Rest API

2022-07-11 Thread Chris Davis
Hi Paul I use Chilkat a lot to grab data from API's, a lot using OAuth and the expiring token. Are you able to share the code that's getting you to the 400 response so I can see where your upto? Regards Chris -Original Message- From: ProfoxTech On Behalf Of Paul H. Tarver Sent: 09 J

RE: Need Help - Foxpro & Chilkat & Rest API

2022-07-12 Thread Chris Davis
Hi Paul Sorry only just got around to your email in my inbox! Do you have a link to the API documentation? or if not, as well as the token end point in your code (/rest/api/token/) do you also have an authorisation end point? Regards Chris. -Original Message- From: ProfoxTech On Be

Small Report/Label Designs

2023-01-12 Thread Chris Davis
Anyone got any tips for working easier on small label designs? TIA Chris. Chris Davis Acton Gate Systems Limited Please note our new address from 1st May 2022: 1 Nightingale Place Pendeford Business Park Wolverhampton WV9 5HF M: 07966 020 473 T: 01902 249299 *: chr...@actongate.co.uk Web

RE: Small Report/Label Designs

2023-01-15 Thread Chris Davis
Something similar to a Zebra. -Original Message- From: ProfoxTech On Behalf Of Alan Bourke Sent: 13 January 2023 12:28 To: profoxt...@leafe.com Subject: Re: Small Report/Label Designs What label printer are you printing them on ? -- Alan Bourke alanpbourke (at) fastmail (dot) fm [

RE: Small Report/Label Designs

2023-01-15 Thread Chris Davis
sions. It will be easier if printer-friendly labels are available. In the worst case, use PDF format? :) On Thu, Jan 12, 2023 at 9:19 PM Chris Davis wrote: > > Anyone got any tips for working easier on small label designs? > -- .~. Might, Courage, Vision. SINCERITY! / v \ 64-bit Fe

RE: Small Report/Label Designs

2023-01-16 Thread Chris Davis
Original Message- From: ProfoxTech On Behalf Of Ted Roche Sent: 15 January 2023 14:50 To: profoxt...@leafe.com Subject: Re: Small Report/Label Designs On Thu, Jan 12, 2023 at 8:19 AM Chris Davis wrote: > > Anyone got any tips for working easier on small label designs? > Sure. Wha

RE: Small Report/Label Designs

2023-01-16 Thread Chris Davis
t: Re: Small Report/Label Designs Well, with a Zebra I would forget the VFP report designer and just send it ZPL commands. And use this to to the design. http://labelary.com/viewer.html -- Alan Bourke alanpbourke (at) fastmail (dot) fm On Sun, 15 Jan 2023, at 10:56 AM, Chris Davis

ZPL

2023-11-13 Thread Chris Davis
is doing something relating to page size? But not sure. If possible I would like a native VFP method of connecting to either a USB or Network connected ZPL printer and be able to send whatever I like ... thoughts? TIA Chris Davis --- StripMime Report -- processed MIME parts --- multipart

RE: ZPL

2023-11-13 Thread Chris Davis
? command also translates embedded strings between curly braces: ??? "This is a printer control string: {27}Q{100} to set the right margin" If you need to print that left curly bracket in real, then you need to do a "{{}" wOOdy -Original Message- From: ProFox

RE: ZPL

2023-11-13 Thread Chris Davis
Done a bit more testing and capture the print job it looks like it only sends upto 16535 kB to the printer before it's then captured as a job? Make any sense? -Original Message- From: ProfoxTech On Behalf Of Chris Davis Sent: Monday, November 13, 2023 12:44 PM To: profoxt...@leaf

RE: ZPL

2023-11-13 Thread Chris Davis
rns, etc. It is a dBASE II command and ought to be avoided. See https://hackfox.github.io/section4/s4g173.html for details. On Mon, Nov 13, 2023 at 7:44 AM Chris Davis wrote: > > Thanks Woody > > That seems to behave the same as me using ... > > STRTOFILE(label1.mlabel,"c:

RE: ZPL

2023-11-14 Thread Chris Davis
, "{{}") wOOdy -Original Message- From: ProFox On Behalf Of Chris Davis Sent: Monday, November 13, 2023 3:13 PM To: profox@leafe.com Subject: RE: ZPL Done a bit more testing and capture the print job it looks like it only sends upto 16535 kB to the printer before it's then c

RE: ZPL

2023-11-15 Thread Chris Davis
After a lot of testing it turns out this was a bug at the other end, I have obtained a patch for it and now VFP sends the data fine. -Original Message- From: ProfoxTech On Behalf Of Chris Davis Sent: Tuesday, November 14, 2023 9:41 AM To: profoxt...@leafe.com Subject: RE: ZPL Thanks

Printer Dialogue

2023-12-21 Thread Chris Davis
I'm not certain when but in Windows 11 the printer dialogue for 32 bits apps changed ... If you leave the new dialogue active (you can change registry settings to force the old one) then anything you do with set printer before printing a report with printer prompt brings up the dialogue but it

  1   2   3   4   >