RE: VFP9 Windows Server 2012

2013-08-16 Thread Dave Crozier
Tracy, Our 3 sans are all HP and to be honest we haven't needed to mess around with the San configuration at all. Having said that the HP SAN device software is all linux based running below Windows 2012 by a company called Left Hand who were bought out by HP to acquire their technology and

Re: Delimited TXT file

2013-08-16 Thread Alan Bourke
No need to complicate things with fopen() and low-level IO for most writing strings to a file tasks. set textmerge on noshow set textmerge to myfile.txt \ Here's my first line that the client wants. select mytable scan \field1,field2,field3,field4,field5,field6,field7 endscan set textmerge

Re: [OT] Modern Steam Train

2013-08-16 Thread Michael Madigan
Wow, the steam engines from the 1800's were better than those.  - Original Message - From: GaryT g...@taig.net To: profox@leafe.com Cc: Sent: Friday, August 16, 2013 1:56 AM Subject: Re: [OT] Modern Steam Train On 16/08/13 06:47, Eurico Chagas Filho wrote: Not sure Pete, I thought it

RE: Delimited TXT file

2013-08-16 Thread Darren
True enough however the output is different so a little more work to handle that - depends on how critical output format is. e.g. CREATE CURSOR w_test (fld1 N(10,2), fld2 c(30), fld3 c(40), fld4 T, fld5 I, fld6 L, fld7 d) Delimited: 1.00,1 ,1 ,16/08/2013 7:49:11

Re: FP: Trapping division by zero (Error 1307)

2013-08-16 Thread Man-wai Chang
I noticed that the original question involved the use of EVALUATE(). Maybe the stuff inside EVALUATE() was wrong. On Fri, Aug 16, 2013 at 2:17 AM, Gene Wirchenko ge...@telus.net wrote: I tried select 1/0 from ccli (ccli being a table in my app) and no error was thrown. I

Re: FRX2ANY Freezing - Problem Solved

2013-08-16 Thread Jeff Johnson
On 08/15/2013 01:04 PM, Jeff Johnson wrote: I am running FRX2ANY and this application is not working yet. It starts to convert and then locks. I am getting the error: Syntax Error pdffile Error 10 Method InsertObject Line 0 Any ideas what I am doing wrong. The app, dll,

RE: FRX2ANY Freezing - Problem Solved

2013-08-16 Thread Richard Kaye
The ; is old xBase shorthand for a linefeed, iirc. Happy B-day! -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff Johnson Sent: Friday, August 16, 2013 10:19 AM Subject: Re: FRX2ANY Freezing - Problem Solved The first was a syntax error

Re: Delimited TXT file

2013-08-16 Thread Kurt @ VR-FX
Darren - FYI - if you hit Reply-To-All, you are actually sending out Duplicates of your Reply - as its going to the ProFox list AND the ProFoxTech List (that's the version of the list that does NOT include OT postings)! Just an FYI... -K- On 8/16/2013 6:07 AM, Darren wrote: True enough

Re: FP: Trapping division by zero (Error 1307)

2013-08-16 Thread Laurie Alvey
The original contained something like this: lcExpr = 1/0 ? EVALUATE(lcExpr) From: Man-wai Chang chan...@gmail.com To: ProFox Email List profox@leafe.com Sent: Friday, 16 August 2013, 11:17 Subject: Re: FP: Trapping division by zero (Error 1307) I noticed

VFP9: Document Management

2013-08-16 Thread Desmond Lloyd
Good morning, Has anyone attempted to manage PDF's from a VFP application?Let's say a manufacturing system where everything is tracked by some sort of order number (Manufacturing and/or purchasing). I imagine a kind of behind the scenes kind of thing where a selection to print to the

RE: VFP9: Document Management

2013-08-16 Thread Dave Crozier
I've written a document manager where you can either load an document(PDF, Word, Image, Scan) into SQL server as a binary object and then load it up/display it accordingly. Initiall this was using VFP as a back end but this proved to be unworkable the size of the Blobs... our Document Database

Re: VFP9: Document Management

2013-08-16 Thread Jean MAURICE
Hi Desmond, to create PDF, I use Cesar Chalom's Foxypreviewer To view PDF in a form, I use the olecontrol webbrowser dans gallery\_webview with ._web.navigate(your PDf file) If I succeeded to do it, it must be easy ;-) The Foxil ___ Post

RE: VFP9: Document Management

2013-08-16 Thread Dave Crozier
..and finally as Maurice says, FoxyPreviewer or XFRX (Equeus.com) to produce PDF's from VFP. Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 16 August 2013 17:02 To: ProFox Email List Subject: RE: VFP9: Document Management Desmond,

RE: VFP9: Document Management

2013-08-16 Thread Kent Belan
We send all our reports thru XFRX to generate PDF files, then preview them with the adobe reader plugin thru the WebBrowser control. We also have allow the user to attach the PDF to the case they are working on to view/print later. -Original Message- From: ProFox

RE: VFP9: Document Management

2013-08-16 Thread Dave Crozier
Desmond, As well as that we use XFRX to produce our PDF's and the system detailed in the last message to store them on disk in SQL. Displaying PDF's is no problem at all using VFP and I forgot to add We can also drag attachments from emails directly onto the VFP app which then stores the

RE: VFP9: Document Management

2013-08-16 Thread Dave Crozier
Sorry Jean, I Missed out your first name. the keyboard buffer gobbled it up! Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 16 August 2013 17:02 To: ProFox Email List Subject: RE: VFP9: Document Management Desmond, As well as

RE: VFP9: Document Management

2013-08-16 Thread jerry foote
I viewed the Foxypreviewer web site and on first glance it appeared to be a stand alone application, is that what it is? Jerry -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Jean MAURICE Sent: Friday, August 16, 2013 11:03 AM To: profox@leafe.com Subject:

Re: VFP9: Document Management

2013-08-16 Thread Jean MAURICE
Le 16/08/2013 18:04, Dave Crozier a écrit : Sorry Jean, I Missed out your first name. the keyboard buffer gobbled it up! Dave It doesn't matter my name is also a first name and I am used to be called by both ! The Foxil ___ Post Messages to:

Re: VFP9 Document Management

2013-08-16 Thread Desmond Lloyd
Thanks everyone for your responses... It would seem that generating and viewing the PDF's should be relatively easy. The scope of my project is not so large, so the SQL Server suggestion is probably a little overkill (although very impressive, 4TB!) Was thinking of placing a collection of

Re: VFP9: Document Management

2013-08-16 Thread Kevin Cully
Hello Desmond, I used to work for a company called Conarc that has a product called iChannel. http://conarc.com/ It's part VFP and part .NET. It can create PDFs and then create texted indexed databases, scan and ocr existing PDFS. Bottom line is that it has document management, with

Re: VFP9 Document Management

2013-08-16 Thread Jean MAURICE
Le 16/08/2013 19:05, Desmond Lloyd a écrit : Was thinking of placing a collection of documents in a folder identified by a particular order number, or location identified by the user. You can use easily long file name, so you can add informations such as client's name to the name of each pdf

Re: VFP9: Document Management

2013-08-16 Thread Jeff Johnson
Desmond: I use this on several applications. One major corp I work for has me outputting payslips with hours, miles, weight and payroll amounts printed to pdf with frx2any. I put the pdf's in a specific folder and their application picks them up and files them in an employee HR folder.

Combo Box problems

2013-08-16 Thread Sytze de Boer
I have a Stocks.dbf with about 90,000 items There's about 80 stock types in there which can be referenced in STYPES.dbf (code N(5), Desc C(25) I have a grid with all the stocks, and to limit the display, I have a combobox, and a set key command in the valid of the combobox I have 2 problems In

RE: Delimited TXT file

2013-08-16 Thread Darren
Thanks Kurt will watch that in future. Cheers -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt @ VR-FX Sent: Saturday, 17 August 2013 12:56 AM To: profoxt...@leafe.com Subject: Re: Delimited TXT file Darren - FYI - if you hit Reply-To-All, you

Re: Delimited TXT file

2013-08-16 Thread Sytze de Boer
And thank you all for comments. I think I've come up with a workable solution On Sat, Aug 17, 2013 at 10:27 AM, Darren fox...@ozemail.com.au wrote: Thanks Kurt will watch that in future. Cheers -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf

Re: Delimited TXT file

2013-08-16 Thread Kurt @ VR-FX
To what - Sytze - your Delimited TXT File problem??? :-) Just bustin'... I know - you responded to the wrong thread! -K- On 8/16/2013 6:28 PM, Sytze de Boer wrote: And thank you all for comments. I think I've come up with a workable solution On Sat, Aug 17, 2013 at 10:27 AM, Darren

Re: Delimited TXT file

2013-08-16 Thread Kurt @ VR-FX
NP Darren - as MANY of us over the years has made this mistake - as I have Also done on occasion... I suspect you are New here - so, welcome to the Fold! -K- On 8/16/2013 6:27 PM, Darren wrote: Thanks Kurt will watch that in future. Cheers -Original Message- From: ProfoxTech