RE: Print when condition with remove line
Thanks. To paraphrase, "The definition of insanity is when you ask the same question over and over again expecting a different answer." James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Michael Madigan Sent: Friday, January 20, 2012 3:33 PM To: ProFox Email List Subject: Re: Print when condition with remove line You have to put that same condition in all the fields on that band. ____ From: James E Harvey To: 'ProFox Email List' Sent: Friday, January 20, 2012 11:17 AM Subject: Print when condition with remove line I have a number of fields in the summary band of a report that each holds a variable which is a grand total of a value of the field in the cursor created by a select statement. If I'm choosing to group the report, and sub totaling the groups, the summary band makes sense, as it gives a grand total. If I select only one group for the report I don't need the summary band as the totals for the group are the same as the summary. I enter a "Print When" condition in one of the field's "Print only when expression is true" box in the summary band that compares the sub total value with the grand total value and if not equal it prints the grand total in the summary band. If the values agree then this field does not print. This part works fine. Now, I check the "Remove line if blank" condition in this field, and the field does not print, but all the other fields in the summary band continue to print. I'm not sure why I thought the "Remove line if blank" would work by not printing the summary band, but it was worth a try. Is there a method to cause the summary band not to print when the sub total of a group equals the grand total, or do I have to enter the same "Print when" condition in each field in the summary band? Please excuse me if this has been asked before, I've tried to research this, but can't seem to find an answer. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/038801ccd9d0$bf86cfd0$3e946f70$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Print when condition with remove line
Darn. I was looking at the "On Entry" expression builder under the "Edit Bands" option thinking maybe the Summary Band had some kind of "visible" property that could be set to false under certain conditions. This is similar to another limitation in the report writer where it seems near impossible to program whether or not you want to print a group on a new page, or new line, etc., etc... The solution to that was create a separate report with the "New Page" property set up under the data grouping tab, and have the user select the report through the UI, what a pain. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Paul Newton Sent: Friday, January 20, 2012 11:32 AM To: profox@leafe.com Subject: RE: Print when condition with remove line James The answer is: , or do I have to enter the same "Print when" condition in each field in the summary band? Yes Paul Newton -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of James E Harvey Sent: 20 January 2012 16:18 To: profoxt...@leafe.com Subject: Print when condition with remove line I have a number of fields in the summary band of a report that each holds a variable which is a grand total of a value of the field in the cursor created by a select statement. If I'm choosing to group the report, and sub totaling the groups, the summary band makes sense, as it gives a grand total. If I select only one group for the report I don't need the summary band as the totals for the group are the same as the summary. I enter a "Print When" condition in one of the field's "Print only when expression is true" box in the summary band that compares the sub total value with the grand total value and if not equal it prints the grand total in the summary band. If the values agree then this field does not print. This part works fine. Now, I check the "Remove line if blank" condition in this field, and the field does not print, but all the other fields in the summary band continue to print. I'm not sure why I thought the "Remove line if blank" would work by not printing the summary band, but it was worth a try. Is there a method to cause the summary band not to print when the sub total of a group equals the grand total, or do I have to enter the same "Print when" condition in each field in the summary band? Please excuse me if this has been asked before, I've tried to research this, but can't seem to find an answer. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/01c201ccd794$8975eb80$9c61c280$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Print when condition with remove line
I have a number of fields in the summary band of a report that each holds a variable which is a grand total of a value of the field in the cursor created by a select statement. If I'm choosing to group the report, and sub totaling the groups, the summary band makes sense, as it gives a grand total. If I select only one group for the report I don't need the summary band as the totals for the group are the same as the summary. I enter a "Print When" condition in one of the field's "Print only when expression is true" box in the summary band that compares the sub total value with the grand total value and if not equal it prints the grand total in the summary band. If the values agree then this field does not print. This part works fine. Now, I check the "Remove line if blank" condition in this field, and the field does not print, but all the other fields in the summary band continue to print. I'm not sure why I thought the "Remove line if blank" would work by not printing the summary band, but it was worth a try. Is there a method to cause the summary band not to print when the sub total of a group equals the grand total, or do I have to enter the same "Print when" condition in each field in the summary band? Please excuse me if this has been asked before, I've tried to research this, but can't seem to find an answer. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/01b701ccd78f$0e097de0$2a1c79a0$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] On-line password management
I'll take a look at LastPass, thanks for the advice. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Dan Covill Sent: Monday, October 10, 2011 12:33 PM To: ProFox Email List Subject: Re: [NF] On-line password management On 10/10/11 07:06, James E Harvey wrote: > Is anyone using an on-line service to manage their password, do you > feel safe using this service? Yet another vote for LastPass. I had tried Robo-whatever, but found it rather cumbersome. LastPass has the user interface right, and I like the facts that a) LastPass themselves can't see my passwords (they don't have the encryption key) and b) I CAN see them - helps me remember which ones I used where. Dan Covill [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/0ae101cc87b6$1f52f5f0$5df8e1d0$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] On-line password management
do you use an excel file, or something like that, or do you have password management software? James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Rafael Copquin Sent: Monday, October 10, 2011 10:15 AM To: profox@leafe.com Subject: Re: [NF] On-line password management I would definitely shy away from something like that. I prefer to keep my own records on passwords for the different url's I access Rafael Copquin El 10/10/2011 11:06, James E Harvey escribió: > Is anyone using an on-line service to manage their password, do you > feel safe using this service? > > It would be a great convenience to be able to browse to a central > repository for this critical information, but obviously the biggest > concern is security. > > > James E Harvey > Corresponding Officer/M.I.S. > Hanover Shoe Farms, Inc. > www.hanoverpa.com > office: 717-637-8931 > cell: 717-887-2565 > fax: 717-637-6766 > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/097c01cc8758$2a36ad80$7ea40880$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] On-line password management
Is anyone using an on-line service to manage their password, do you feel safe using this service? It would be a great convenience to be able to browse to a central repository for this critical information, but obviously the biggest concern is security. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/095b01cc8755$c4d9cdc0$4e8d6940$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: XFRX default "output" file name
Thanks Richard, let's hope Martin gets the time to take a look at these two requests. I do appreciate XFRX, it has made the offering of alternative output options to our users a key benefit. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Thursday, September 22, 2011 5:13 PM To: profox@leafe.com Subject: RE: XFRX default "output" file name Hi James, I haven't spent much time looking at the default file location yet but there are several ways you can approach setting the name itself. Probably the simplest way to do it is add your own code to the export options form class. You'll see this line in the init: this.text2.Value = this.ooptions.cOutputFile Of course, if you go this route you'll want to make sure you document what you do in case a new version of the library comes out. I've tried to be a little more OO in what I've started but it's still a WIP as the containership hierarchy is pretty complicated (at least it is to me). Matter of fact, what I've done so far for my own code defies simple explanation so I'm not going to put it here. It's just too damn ugly. BTW all the export magic seems to be handled by the export method of the xfCont class. Interestingly, this method accepts a single parameter for the name of the output. In the places where I can see it called, it typically look like this: This.Parent.oCnt.Export() (although sometimes it has multiple Parents (see prior comment about complicated containership hierarchy :)) So no parameter is being passed. Perhaps Martin's intention is to expose a way to pass that parameter. I hope this helps you get started. -- rk -Original Message- Subject: RE: XFRX default "output" file name Yes, I'm definitely interested. Please excuse me for asking too much, but what about changing the default path to a folder other than the working folder... James E Harvey [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/033901cc79e0$6a6e9910$3f4bcb30$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: XFRX support
Not sure when it appeared, maybe around ver 10, it is now at 14.1. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Wednesday, September 21, 2011 5:45 PM To: ProFox Email List Subject: Re: XFRX support On 9/16/2011 9:26 AM, James E Harvey wrote: > XFRX support resolution. > > Martin got back to me on my two issues. > > 1.I added the icon bitmaps into my project rebuilt the exe and now the > icons appear as expected. > > 2.Currently there is no way to substitute a randomly generated > filename for the output when a user chooses to export the report, or > to have a different default folder other than the working folder. He > said he would take a look to see how that could be accomplished. > > Thanks again for all your help and suggestions. > > Here is the code I use to take advantage of the XFRX report previewer. > > > Local loSession, lnRetval, lcPageCaption > > mreport = "hsrpissue" > > toViewer = Createobject("frmMPPreviewer") > > loSession=Evaluate([xfrx("XFRX#LISTENER")]) > > lnRetval = loSession.SetParams(,,"XFF") > > > If lnRetval = 0 > Report Form&mreport Object loSession Endif > > toViewer.iTool = 2 > toViewer.showstatus = .T. > > Local loXFFDocument > > loXFFDocument = loSession.oxfdocument > > toViewer.previewXFF(loXFFDocument, lcPageCaption) > > If toViewer.Visible = .F. > toViewer.Show(1) > ENDIF I've got an older version of XFRX. I wonder when this previewer was added? Will make a note to try your code in my app. Thanks! -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/024701cc7915$d2783870$7768a950$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: XFRX default "output" file name
Yes, I'm definitely interested. Please excuse me for asking too much, but what about changing the default path to a folder other than the working folder... James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Wednesday, September 21, 2011 2:19 PM To: profox@leafe.com Subject: RE: XFRX default "output" file name Hi James, I've found a way to assign a custom file name that the previewer class will use instead of output. If you're interested, let me know. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of James E Harvey Sent: Friday, September 09, 2011 8:04 AM To: profoxt...@leafe.com Subject: RE: XFRX default "output" file name Thanks Alan. I think I'm starting to understand that I'm trying to edit the properties of the Export method which is called when the user clicks the export button on the XFRX previewer. The doc's mention a method called "Export" with one parameter called "toXFF" as the handler for the XFF file being previewed. That seems to be where you could modify the defaults for the file's location and file name, but I'm not seeing how to do that? Jim James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Alan Bain Sent: Thursday, September 08, 2011 9:05 PM To: profox@leafe.com Subject: Re: XFRX default "output" file name James, Creating the pdf was tricky for me. Here is my code. Hope it helps. loObj = XFRX("XFRX#LISTENER") rptname = Alltrim(Str(dispatch.callnumber))+'_call' tmpdir = 'c:\dispatch' lcreportname = 'c:\dispatch\rpts\sht_am_L' lnRetVal = loObj.SetParams(Alltrim(rptname),tmpdir,.T."PDF") oapp.exlog('~GET~ lnRetVal from create loObj of xfrx' + Str(lnRetVal)) If lnRetVal = 0 loObj.setPasswords("ow",Alltrim(Defa.agencyph)) loObj.setPermissions(.T., .F., .F., .F.) *do we want to include the radio log? If printtlog Select dispatch Report Form &lcreportname For Recno() = thisrecord Object loObj Nopageeject Select runlog Report Form c:\dispatch\RPTS\runlog.FRX Object loObj Else Select dispatch Report Form &lcreportname For Recno() = thisrecord Object loObj Endif loObj.finalize() lsendgood = .T. else *something went wrong here, notify user Endif oapp.exlog('~GET~ created pdf file ') Thanks, Alan Bain On Thu, Sep 8, 2011 at 2:50 PM, James E Harvey wrote: [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/01f301cc7891$c6abf150$5403d3f0$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: XFRX support
XFRX support resolution. Martin got back to me on my two issues. 1. I added the icon bitmaps into my project rebuilt the exe and now the icons appear as expected. 2. Currently there is no way to substitute a randomly generated filename for the output when a user chooses to export the report, or to have a different default folder other than the working folder. He said he would take a look to see how that could be accomplished. Thanks again for all your help and suggestions. Here is the code I use to take advantage of the XFRX report previewer. Local loSession, lnRetval, lcPageCaption mreport = "hsrpissue" toViewer = Createobject("frmMPPreviewer") loSession=Evaluate([xfrx("XFRX#LISTENER")]) lnRetval = loSession.SetParams(,,"XFF") If lnRetval = 0 Report Form &mreport Object loSession Endif toViewer.iTool = 2 toViewer.showstatus = .T. Local loXFFDocument loXFFDocument = loSession.oxfdocument toViewer.previewXFF(loXFFDocument, lcPageCaption) If toViewer.Visible = .F. toViewer.Show(1) ENDIF James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Wednesday, September 14, 2011 12:09 PM To: profox@leafe.com Subject: RE: XFRX support Hi James, I'll toss out one more thing based on my running the demo form supplied by Eqeus. In that demo form, there's a container object called xfCont that has a property called defaultoutputfilename that is used to populate the report options object (opt.cOutputFIle). If you have the source, you could add your own method for populating that defaultoutputfilename property, recompile and get what you need. Unfortunately, I did not purchase the source code so I can only offer this general advice. FWIW I've forwarded your concerns about XFRX support to Martin. As mentioned earlier, my experience has been that he's been generally responsive to support emails. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of James E Harvey Sent: Wednesday, September 14, 2011 9:40 AM To: profoxt...@leafe.com Subject: RE: XFRX support Yes, I did purchase the source code. I've come to the conclusion that my skillsets are not up to the level of what is required to make this product work the way I'd like it to. Also, the lack of response from XFRX has turned me off this product for now. I do appreciate your help, but I'm going to have to move on to other projects. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Wednesday, September 14, 2011 9:22 AM To: profox@leafe.com Subject: RE: XFRX support Are you using the Export Options form object that's included? Again, I don't use the Export Options dialog but I have the help file to be very useful and there are a lot of good examples in there. I built my own wrapper around the XFRX object pretty much based on working through the help file. Did you purchase the source code with your license? -- rk -Original Message----- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of James E Harvey Sent: Wednesday, September 14, 2011 8:46 AM To: profoxt...@leafe.com Subject: RE: XFRX support The setparams doesn't seem to connect to the Export Options dialog that the user can use to export the report to different files types. Quite frankly I'm a bit disappointed in the apparent lack of response to my request for help from Eqeus. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Tuesday, September 13, 2011 11:16 AM To: profox@leafe.com Subject: RE: XFRX support I might be able to help with the first question. The first parameter of the XRFX object SetParams method is the name of the output file: Local m.lcFilename AS Character m.lcFolder=[C:\My special folder] m.lcFilename=ADDBS(m.lcFolder)+SYS(2015)+[.xff] lnRetval = loSession.SetParams(m.lcFilename,,"XFF") I haven't gotten around to using the XFRX previewer but have you included the bitmaps for the preview toolbar in your EXE? -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of James E Harvey Sent: Tuesday, September 13, 2011 10:51 AM To: profoxt...@leafe.com Subject: RE: XFRX support I have two issues
RE: XFRX support
Thanks Richard. He sent me an email stating he'd be looking at my questions soon. The previewer looks great, I really like the functionality of the user being able to "easily" export the report to many different formats. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Wednesday, September 14, 2011 3:49 PM To: profox@leafe.com Subject: RE: XFRX support Hi James, I just got an email from Martin saying that he's been a bit busy but that he has replied to you. BTW my looking at the demo has made me want to try implementing the XFRX previewer into my EXE so I should be better able to chime in on issues related to that once I figure it all out myself. -- rk -Original Message- Subject: RE: XFRX support FWIW I've forwarded your concerns about XFRX support to Martin. As mentioned earlier, my experience has been that he's been generally responsive to support emails. -- rk -Original Message- Subject: RE: XFRX support Also, the lack of response from XFRX has turned me off this product for now. I do appreciate your help, but I'm going to have to move on to other projects. [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/004201cc7396$84772070$8d656150$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: XFRX support
Yes, I did purchase the source code. I've come to the conclusion that my skillsets are not up to the level of what is required to make this product work the way I'd like it to. Also, the lack of response from XFRX has turned me off this product for now. I do appreciate your help, but I'm going to have to move on to other projects. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Wednesday, September 14, 2011 9:22 AM To: profox@leafe.com Subject: RE: XFRX support Are you using the Export Options form object that's included? Again, I don't use the Export Options dialog but I have the help file to be very useful and there are a lot of good examples in there. I built my own wrapper around the XFRX object pretty much based on working through the help file. Did you purchase the source code with your license? -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of James E Harvey Sent: Wednesday, September 14, 2011 8:46 AM To: profoxt...@leafe.com Subject: RE: XFRX support The setparams doesn't seem to connect to the Export Options dialog that the user can use to export the report to different files types. Quite frankly I'm a bit disappointed in the apparent lack of response to my request for help from Eqeus. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Tuesday, September 13, 2011 11:16 AM To: profox@leafe.com Subject: RE: XFRX support I might be able to help with the first question. The first parameter of the XRFX object SetParams method is the name of the output file: Local m.lcFilename AS Character m.lcFolder=[C:\My special folder] m.lcFilename=ADDBS(m.lcFolder)+SYS(2015)+[.xff] lnRetval = loSession.SetParams(m.lcFilename,,"XFF") I haven't gotten around to using the XFRX previewer but have you included the bitmaps for the preview toolbar in your EXE? -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of James E Harvey Sent: Tuesday, September 13, 2011 10:51 AM To: profoxt...@leafe.com Subject: RE: XFRX support I have two issues now. First. I'd like to edit the properties of the Export method which is called when the user clicks the export button on the XFRX previewer. The default file name is output.xps, and the default location is the path the application is in. I'd like to use sys(2015) to create a random file name with the xps extension (or whatever extension the user chooses to export to) and change the path to a folder created to hold these files other than the working folder. [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/02b501cc72e3$dcd85710$96890530$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: XFRX support
The setparams doesn't seem to connect to the Export Options dialog that the user can use to export the report to different files types. Quite frankly I'm a bit disappointed in the apparent lack of response to my request for help from Eqeus. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Tuesday, September 13, 2011 11:16 AM To: profox@leafe.com Subject: RE: XFRX support I might be able to help with the first question. The first parameter of the XRFX object SetParams method is the name of the output file: Local m.lcFilename AS Character m.lcFolder=[C:\My special folder] m.lcFilename=ADDBS(m.lcFolder)+SYS(2015)+[.xff] lnRetval = loSession.SetParams(m.lcFilename,,"XFF") I haven't gotten around to using the XFRX previewer but have you included the bitmaps for the preview toolbar in your EXE? -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of James E Harvey Sent: Tuesday, September 13, 2011 10:51 AM To: profoxt...@leafe.com Subject: RE: XFRX support I have two issues now. First. I'd like to edit the properties of the Export method which is called when the user clicks the export button on the XFRX previewer. The default file name is output.xps, and the default location is the path the application is in. I'd like to use sys(2015) to create a random file name with the xps extension (or whatever extension the user chooses to export to) and change the path to a folder created to hold these files other than the working folder. [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/029a01cc72dc$3f360c20$bda22460$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: XFRX support
I have two issues now. First. I'd like to edit the properties of the Export method which is called when the user clicks the export button on the XFRX previewer. The default file name is output.xps, and the default location is the path the application is in. I'd like to use sys(2015) to create a random file name with the xps extension (or whatever extension the user chooses to export to) and change the path to a folder created to hold these files other than the working folder. The doc's mention a method called "Export" with one parameter called "toXFF" as the handler for the XFF file being previewed. That seems to be where you could modify the defaults for the file's location and file name, but I'm not seeing how to do that? Here is the code I'm using to create the report using XFRX: Local loSession, lnRetval, lcPageCaption mreport = "hsrpissue" toViewer = Createobject("frmMPPreviewer") loSession=Evaluate([xfrx("XFRX#LISTENER")]) lnRetval = loSession.SetParams(,,"XFF") If lnRetval = 0 Report Form &mreport Object loSession Endif toViewer.iTool = 2 toViewer.showstatus = .T. Local loXFFDocument loXFFDocument = loSession.oxfdocument toViewer.previewXFF(loXFFDocument, lcPageCaption) If toViewer.Visible = .F. toViewer.Show(1) ENDIF Second. For some crazy reason the icons on the preview toolbar at the top do not appear in the buttons if I use my "loader" program to start the application. If I double click the main exe on the server to run the application they do appear, weird? I could send you screen shots direct if that would help explain things better. I know I can't send them through ProFox which only allows plain text (wish I could use html). James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Tuesday, September 13, 2011 8:48 AM To: profox@leafe.com Subject: RE: XFRX support No, I don't. Remind me what you were trying to figure out and maybe I can shed some light. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of James E Harvey Sent: Tuesday, September 13, 2011 8:45 AM To: profoxt...@leafe.com Subject: RE: XFRX support Thanks, I'll try that address to see if I can get through. Do you know if he offers a fee based telephone support option? James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Tuesday, September 13, 2011 8:36 AM To: profox@leafe.com Subject: RE: XFRX support I had a brief conversation with Martin in the last couple of weeks. I just emailed my question directly to eq...@eqeus.com. In general, I've found him to be responsive. Perhaps something is stuck in a spam bucket somewhere? -- rk -----Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of James E Harvey Sent: Tuesday, September 13, 2011 7:45 AM To: profoxt...@leafe.com Subject: XFRX support Has anyone tried using the support system for XFRX recently? They have an email which I used to post a couple questions last week, and have not heard back. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/00aa01cc7224$9c6c3cb0$d544b610$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: XFRX support
Thanks, I'll try that address to see if I can get through. Do you know if he offers a fee based telephone support option? James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Tuesday, September 13, 2011 8:36 AM To: profox@leafe.com Subject: RE: XFRX support I had a brief conversation with Martin in the last couple of weeks. I just emailed my question directly to eq...@eqeus.com. In general, I've found him to be responsive. Perhaps something is stuck in a spam bucket somewhere? -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of James E Harvey Sent: Tuesday, September 13, 2011 7:45 AM To: profoxt...@leafe.com Subject: XFRX support Has anyone tried using the support system for XFRX recently? They have an email which I used to post a couple questions last week, and have not heard back. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/007401cc7212$ee4a0d30$cade2790$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
XFRX support
Has anyone tried using the support system for XFRX recently? They have an email which I used to post a couple questions last week, and have not heard back. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/005c01cc720a$96e6f6a0$c4b4e3e0$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: XFRX default "output" file name
Thanks Alan. I think I'm starting to understand that I'm trying to edit the properties of the Export method which is called when the user clicks the export button on the XFRX previewer. The doc's mention a method called "Export" with one parameter called "toXFF" as the handler for the XFF file being previewed. That seems to be where you could modify the defaults for the file's location and file name, but I'm not seeing how to do that? Jim James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Alan Bain Sent: Thursday, September 08, 2011 9:05 PM To: profox@leafe.com Subject: Re: XFRX default "output" file name James, Creating the pdf was tricky for me. Here is my code. Hope it helps. loObj = XFRX("XFRX#LISTENER") rptname = Alltrim(Str(dispatch.callnumber))+'_call' tmpdir = 'c:\dispatch' lcreportname = 'c:\dispatch\rpts\sht_am_L' lnRetVal = loObj.SetParams(Alltrim(rptname),tmpdir,.T."PDF") oapp.exlog('~GET~ lnRetVal from create loObj of xfrx' + Str(lnRetVal)) If lnRetVal = 0 loObj.setPasswords("ow",Alltrim(Defa.agencyph)) loObj.setPermissions(.T., .F., .F., .F.) *do we want to include the radio log? If printtlog Select dispatch Report Form &lcreportname For Recno() = thisrecord Object loObj Nopageeject Select runlog Report Form c:\dispatch\RPTS\runlog.FRX Object loObj Else Select dispatch Report Form &lcreportname For Recno() = thisrecord Object loObj Endif loObj.finalize() lsendgood = .T. else *something went wrong here, notify user Endif oapp.exlog('~GET~ created pdf file ') Thanks, Alan Bain On Thu, Sep 8, 2011 at 2:50 PM, James E Harvey wrote: [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/06d601cc6ee8$9ebbd640$dc3382c0$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: XFRX default "output" file name
The .setparams method does work using the lcfile parameter in this way to create the files: lcfile = sys(5) + "\foxdat\xfrx\" + sys(2015) LOXFRX = XFRX("XFRX#LISTENER") lnretval = LOXFRX.SETPARAMS(lcfile,"",.f.,"",.t.,.f.,"FDOC") if lnretval = 0 report form (mreport) object LOXFRX messagebox("The report has been created and is located in " + lcfile,64,"Notice") else ? lnretval Endif The value of the File Name textbox is a different animal, so I need to do some more work to figure it out. Another option is to train the users to use the ellipsis button to navigate to a folder other than the working folder and rename the file from "Output" to something more sensible. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Mike Copeland Sent: Thursday, September 08, 2011 1:32 PM To: profox@leafe.com Subject: Re: XFRX default "output" file name James, FWIW, you're doing it exactly the way I do, except I'm creating PDFs, not XFF files. With XFRX, the output location and file name are defined using the first parameter of the .SetParams() method as you have done below. All I can suggest is to make sure that the path and folder exist prior to running the report output. In fact, you might try simply specifying the file name...something like a fixed string "Test123", without a path specified, run the routine, then look for the file to see if the file name is a match. My understanding is that XFRX will output to the default VFP folder. Next try creating the report in C:\ (unless you're on Win7) or some other simple location and build from there. Mike Original Message Subject: XFRX default "output" file name From: James E Harvey To: profoxt...@leafe.com Date: 9/8/2011 10:42 AM I'm trying to figure out how to change the default "output" file name to a programmatically generated name in a specific folder, but can't seem to connect the dots. Below is the code that creates the XFRX previewer, which works, but the default name remains "output" and is located in the working folder. Lcfile doesn't seem to matter. So when a user runs the report, and then selects the export file button, the "Export Options" dialog box pops up and the "File Name" text box is automatically filled with "output" along with the appropriate extension depending on what kind of file they are exporting to. The doc's mention a "loObj.targetfilename" property, but I'm at a loss as to how to implement it in the code below. Maybe someone else has already done this (Sytze?)... Local loSession, lnRetval, lcPageCaption lcfile = sys(5) + "\foxdat\xfrx\" + sys(2015) mreport = "hsrpmarebooknotify" toViewer = Createobject("frmMPPreviewer") loSession=Evaluate([xfrx("XFRX#LISTENER")]) lnRetval = loSession.SetParams(lcfile,,"XFF") If lnRetval = 0 Report Form&mreport Object loSession Endif toViewer.iTool = 2 Local loXFFDocument loXFFDocument = loSession.oxfdocument toViewer.previewXFF(loXFFDocument, lcPageCaption) If toViewer.Visible = .F. toViewer.Show(1) ENDIF James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/065b01cc6e60$85cafbd0$9160f370$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
XFRX default "output" file name
I'm trying to figure out how to change the default "output" file name to a programmatically generated name in a specific folder, but can't seem to connect the dots. Below is the code that creates the XFRX previewer, which works, but the default name remains "output" and is located in the working folder. Lcfile doesn't seem to matter. So when a user runs the report, and then selects the export file button, the "Export Options" dialog box pops up and the "File Name" text box is automatically filled with "output" along with the appropriate extension depending on what kind of file they are exporting to. The doc's mention a "loObj.targetfilename" property, but I'm at a loss as to how to implement it in the code below. Maybe someone else has already done this (Sytze?)... Local loSession, lnRetval, lcPageCaption lcfile = sys(5) + "\foxdat\xfrx\" + sys(2015) mreport = "hsrpmarebooknotify" toViewer = Createobject("frmMPPreviewer") loSession=Evaluate([xfrx("XFRX#LISTENER")]) lnRetval = loSession.SetParams(lcfile,,"XFF") If lnRetval = 0 Report Form &mreport Object loSession Endif toViewer.iTool = 2 Local loXFFDocument loXFFDocument = loSession.oxfdocument toViewer.previewXFF(loXFFDocument, lcPageCaption) If toViewer.Visible = .F. toViewer.Show(1) ENDIF James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/063801cc6e3d$f15965d0$d40c3170$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Cannot resolve backlink
Thanks much for everyone's help and advice. It looks like things are back to normal. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of James E Harvey Sent: Tuesday, August 30, 2011 3:48 PM To: 'ProFox Email List' Subject: RE: Cannot resolve backlink yep, it is and i found an old dll so that seems better too. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Alan Bourke Sent: Tuesday, August 30, 2011 3:47 PM To: profox@leafe.com Subject: Re: Cannot resolve backlink On Tue, 30 Aug 2011 09:07 -0400, "James E Harvey" wrote: > We installed a new server running Win 2008R2 in VMware last week, and > everything has been running fine until yesterday. Make sure SP1 is on it. -- Alan Bourke alanpbourke (at) fastmail (dot) fm [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/009101cc677a$5f9b0e10$1ed12a30$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Cannot resolve backlink
yep, it is and i found an old dll so that seems better too. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Alan Bourke Sent: Tuesday, August 30, 2011 3:47 PM To: profox@leafe.com Subject: Re: Cannot resolve backlink On Tue, 30 Aug 2011 09:07 -0400, "James E Harvey" wrote: > We installed a new server running Win 2008R2 in VMware last week, and > everything has been running fine until yesterday. Make sure SP1 is on it. -- Alan Bourke alanpbourke (at) fastmail (dot) fm [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/001601cc674d$c26f2b70$474d8250$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Cannot resolve backlink
Okay, that's been fixed. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Tracy Pearson Sent: Tuesday, August 30, 2011 1:54 PM To: profox@leafe.com Subject: RE: Cannot resolve backlink James E Harvey wrote on 2011-08-30: > Is the write caching a setting in VMware or in Win 2008? > > James E Harvey James, Windows 2008. Right click on the drive that is storing the data Properties Hardware Select the drive, click Properties Click Change settings Under the Policies tab, be sure "Enable write caching on the device" is NOT checked. Tracy Pearson PowerChurch Software [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/000801cc673e$1f317530$5d945f90$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Cannot resolve backlink
Is the write caching a setting in VMware or in Win 2008? James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Tracy Pearson Sent: Tuesday, August 30, 2011 1:28 PM To: profox@leafe.com Subject: RE: Cannot resolve backlink James E Harvey wrote on 2011-08-30: > The VMware file server is only on the Dell server. The exe runs on > the local pc, but they are not running VM locally, just the normal > Win OS (XP, > Vista, Win 7) > > James E Harvey James, The Policy of the drive in the VM might be set "Enable write caching on the device". Also; Anti-Virus, on demand backup, desktop indexing utilities have caused troubles with CDX and FPT files for our clients. Tracy Pearson PowerChurch Software [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/000601cc673c$fa1376a0$ee3a63e0$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Cannot resolve backlink
I checked And the server in VMware is running Win Server 2008R2 Standard with Service pack 1 James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Grigore Dolghin Sent: Tuesday, August 30, 2011 11:28 AM To: profox@leafe.com Subject: Re: Cannot resolve backlink I highly doubt. VMWare is a stable product; Win 2008R2 is stable too (assuming the service pack is applied). I am using this combination and had no problems with it at all. On Tue, Aug 30, 2011 at 6:25 PM, James E Harvey wrote: > I'm starting to see all kinds of crazy behavior with the database. > I'm wondering if it has anything to do with using VMware and Win 2008R2? > > I open the database, validate, get error messages, remove the table, > add it back in, validate, and it looks okay. Try to run the program > and get the backlink error again... > > James E Harvey > Corresponding Officer/M.I.S. > Hanover Shoe Farms, Inc. > www.hanoverpa.com > office: 717-637-8931 > cell: 717-887-2565 > fax: 717-637-6766 > > -Original Message- > From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On > Behalf Of John Harvey > Sent: Tuesday, August 30, 2011 9:34 AM > To: 'ProFox Email List' > Subject: RE: Cannot resolve backlink > > OPEN THE DATABASE EXCLUSIVE AND "VALIDATE DATABASE" > > John Harvey > > -Original Message- > From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On > Behalf Of James E Harvey > Sent: Tuesday, August 30, 2011 8:08 AM > To: 'ProFox Email List' > Subject: Cannot resolve backlink > > We installed a new server running Win 2008R2 in VMware last week, and > everything has been running fine until yesterday. > > For some unknown reason we had a couple of corrupted files yesterday > (I have not seen a corrupted file for years?), and I used some old > code to fix them both. Everything seemed fine after that, we could > load the form, see the data, etc., etc. > > Now this morning one of the forms is throwing an error when the user > tries to load it. "Error loading file - record number 4. > Hsfrm_cash_receipts < or one of its members>. Loading form or the data > environment: Cannot resolve backlink." > > I don't use the data environment, but use tables in the load. If I go > to the command window and try to use the table "hfcashr.dbf" I get a > "Cannot resolve backlink". > > Now I can't remember how I fixed this in the past? > > > > James E Harvey > Corresponding Officer/M.I.S. > Hanover Shoe Farms, Inc. > www.hanoverpa.com > office: 717-637-8931 > cell: 717-887-2565 > fax: 717-637-6766 > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/001301cc6738$7baf0940$730d1bc0$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Cannot resolve backlink
The VMware file server is only on the Dell server. The exe runs on the local pc, but they are not running VM locally, just the normal Win OS (XP, Vista, Win 7) James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Tracy Pearson Sent: Tuesday, August 30, 2011 12:01 PM To: profox@leafe.com Subject: RE: Cannot resolve backlink James E Harvey wrote on 2011-08-30: > I'm starting to see all kinds of crazy behavior with the database. > I'm wondering if it has anything to do with using VMware and Win 2008R2? > > I open the database, validate, get error messages, remove the table, > add it > back in, validate, and it looks okay. Try to run the program and get > the backlink error again... > > James E Harvey James, If your VMware workstations are using NAT instead of Bridged for networking, I saw many problems on my Windows 7 Professional host and network traffic. My scenario: I have a VFP application on the host that connects to data on a network share (physical Win 2003 server in another room). Each time I worked in this VFP application, and had a VM workstation running Windows 7, which was set to use NAT, the VFP application would fail not being able to find CDX or FPT files associated to the DBF. Upon closing the Windows 7 guest, everything worked fine in the VFP application. Changed the VM to use bridged and now I can work in the VFP application without troubles. I recall Outlook had many problems finding the associated files it uses on the network as well. Tracy Pearson PowerChurch Software [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/001101cc6738$0a8ffda0$1faff8e0$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Cannot resolve backlink
I did the display tables and they all looked good. This is getting even crazier, now when I rebuild the exe on my computer and try to run it locally I get a "Resource file version mismatch. Visual foxpro cannot start could not load resources." James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Jeff Johnson Sent: Tuesday, August 30, 2011 11:54 AM To: profox@leafe.com Subject: Re: Cannot resolve backlink This may or may not have something to do with it, but do a DISPLAY TABLES and check the paths. I have inadvertently added a table from another location to a database that caused all sorts of problems. I also depend on Stonefield Database Toolkit for database management. HTH Jeff --- Jeff Johnson j...@san-dc.com (623) 582-0323 www.san-dc.com On 08/30/2011 08:25 AM, James E Harvey wrote: > I'm starting to see all kinds of crazy behavior with the database. > I'm wondering if it has anything to do with using VMware and Win 2008R2? > > I open the database, validate, get error messages, remove the table, > add it back in, validate, and it looks okay. Try to run the program > and get the backlink error again... > > James E Harvey > Corresponding Officer/M.I.S. > Hanover Shoe Farms, Inc. > www.hanoverpa.com > office: 717-637-8931 > cell: 717-887-2565 > fax: 717-637-6766 > > -Original Message- > From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On > Behalf Of John Harvey > Sent: Tuesday, August 30, 2011 9:34 AM > To: 'ProFox Email List' > Subject: RE: Cannot resolve backlink > > OPEN THE DATABASE EXCLUSIVE AND "VALIDATE DATABASE" > > John Harvey > > -----Original Message- > From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On > Behalf Of James E Harvey > Sent: Tuesday, August 30, 2011 8:08 AM > To: 'ProFox Email List' > Subject: Cannot resolve backlink > > We installed a new server running Win 2008R2 in VMware last week, and > everything has been running fine until yesterday. > > For some unknown reason we had a couple of corrupted files yesterday > (I have not seen a corrupted file for years?), and I used some old > code to fix them both. Everything seemed fine after that, we could > load the form, see the data, etc., etc. > > Now this morning one of the forms is throwing an error when the user > tries to load it. "Error loading file - record number 4. > Hsfrm_cash_receipts< or one of its members>. Loading form or the data > environment: Cannot resolve backlink." > > I don't use the data environment, but use tables in the load. If I go > to the command window and try to use the table "hfcashr.dbf" I get a > "Cannot resolve backlink". > > Now I can't remember how I fixed this in the past? > > > > James E Harvey > Corresponding Officer/M.I.S. > Hanover Shoe Farms, Inc. > www.hanoverpa.com > office: 717-637-8931 > cell: 717-887-2565 > fax: 717-637-6766 > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/000601cc6737$479808b0$d6c81a10$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Cannot resolve backlink
I'm starting to see all kinds of crazy behavior with the database. I'm wondering if it has anything to do with using VMware and Win 2008R2? I open the database, validate, get error messages, remove the table, add it back in, validate, and it looks okay. Try to run the program and get the backlink error again... James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of John Harvey Sent: Tuesday, August 30, 2011 9:34 AM To: 'ProFox Email List' Subject: RE: Cannot resolve backlink OPEN THE DATABASE EXCLUSIVE AND "VALIDATE DATABASE" John Harvey -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of James E Harvey Sent: Tuesday, August 30, 2011 8:08 AM To: 'ProFox Email List' Subject: Cannot resolve backlink We installed a new server running Win 2008R2 in VMware last week, and everything has been running fine until yesterday. For some unknown reason we had a couple of corrupted files yesterday (I have not seen a corrupted file for years?), and I used some old code to fix them both. Everything seemed fine after that, we could load the form, see the data, etc., etc. Now this morning one of the forms is throwing an error when the user tries to load it. "Error loading file - record number 4. Hsfrm_cash_receipts < or one of its members>. Loading form or the data environment: Cannot resolve backlink." I don't use the data environment, but use tables in the load. If I go to the command window and try to use the table "hfcashr.dbf" I get a "Cannot resolve backlink". Now I can't remember how I fixed this in the past? James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/000601cc6728$ff77dd20$fe679760$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Cannot resolve backlink
We installed a new server running Win 2008R2 in VMware last week, and everything has been running fine until yesterday. For some unknown reason we had a couple of corrupted files yesterday (I have not seen a corrupted file for years?), and I used some old code to fix them both. Everything seemed fine after that, we could load the form, see the data, etc., etc. Now this morning one of the forms is throwing an error when the user tries to load it. "Error loading file - record number 4. Hsfrm_cash_receipts < or one of its members>. Loading form or the data environment: Cannot resolve backlink." I don't use the data environment, but use tables in the load. If I go to the command window and try to use the table "hfcashr.dbf" I get a "Cannot resolve backlink". Now I can't remember how I fixed this in the past? James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/011401cc6715$cbe023e0$63a06ba0$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Copyright for vfp code
Sorry, that won't work for me as I do not subclass my forms. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Friday, August 05, 2011 3:10 PM To: ProFox Email List Subject: Re: Copyright for vfp code On 8/5/2011 3:56 PM, James E Harvey wrote: > I'm looking for an automated way to add a copyright statement to all > the forms in a project. Basic information such as my name as author > is all I'm looking at adding, and I thought it could go in the .init > or .load of each form. > > The documenting wizard doesn't seem to have been designed for this, > and I kind of remember using something years ago to document another > project, but my memory is failing me now. If you've subclassed your forms, then just add it to the base class that you subclassed. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/074a01cc53ac$0058c640$010a52c0$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Copyright for vfp code
I'm looking for an automated way to add a copyright statement to all the forms in a project. Basic information such as my name as author is all I'm looking at adding, and I thought it could go in the .init or .load of each form. The documenting wizard doesn't seem to have been designed for this, and I kind of remember using something years ago to document another project, but my memory is failing me now. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/072e01cc53a9$d49cb540$7dd61fc0$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] Issue with paths to videos on YouTube and Goadaddy web site
We do embed some of the videos but that won't work for these as there are literally hundreds of them. The path to the video is stored in a table which is read in the c# code in the aspx.cs page. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of lelandj Sent: Wednesday, July 27, 2011 8:57 AM To: ProFox Email List Subject: Re: [NF] Issue with paths to videos on YouTube and Goadaddy web site You might try right clicking on the video to bring up a menu. One of the options in the menu is "Copy Embed html". This option allows you to copy and paste the html needed to embed the youtube video directly into your web page. Hope this helps. Regards, LelandJ On 07/27/2011 08:17 AM, James E Harvey wrote: > I'm trying to get the pathing right so users can click the video > button on our web page that will take them to either a YouTube video, > or a video located on the Godaddy web site. > > these paths to the YouTube video return an error on the page: > > http://www.youtube.com/watch?v=_8Mw9F7OTUQ > > www.youtube.com/watch?v=_8Mw9F7OTUQ > > The same type, of error appears near the top of the web page: > '~http://www.youtube.com/watch?v=_8Mw9F7OTUQ' is not a virtual path. > > The path is created in an excel file which is uploaded to the godaddy > site and posted into a 2005 sqlexpress table. There are many other > paths for other videos, but they are all relative paths, such as: > "/images/video/2010/7T8H94.rm", and they all work. > > Maybe there is a problem with Godaddy having an issue determining the > difference between virtual paths and relative paths? > > > James E Harvey > Corresponding Officer/M.I.S. > Hanover Shoe Farms, Inc. > www.hanoverpa.com > jhar...@hanoverpa.com > 717-637-8931 > fax: 717-637-6766 > cell: 717-887-2565 > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/043e01cc4c6d$70aa7fb0$51ff7f10$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] Issue with paths to videos on YouTube and Goadaddy web site
I'm trying to get the pathing right so users can click the video button on our web page that will take them to either a YouTube video, or a video located on the Godaddy web site. These paths to the YouTube video return an error on the page: http://www.youtube.com/watch?v=_8Mw9F7OTUQ www.youtube.com/watch?v=_8Mw9F7OTUQ The same type, of error appears near the top of the web page: '~http://www.youtube.com/watch?v=_8Mw9F7OTUQ' is not a virtual path. The path is created in an excel file which is uploaded to the godaddy site and posted into a 2005 sqlexpress table. There are many other paths for other videos, but they are all relative paths, such as: "/images/video/2010/7T8H94.rm", and they all work. Maybe there is a problem with Godaddy having an issue determining the difference between virtual paths and relative paths? James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/03c401cc4c5f$8c16f2a0$a444d7e0$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] "Best" file format for video playback on web site
I haven't checked yet, but our web site is hosted by Godaddy, would they have an issue using something like this? James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of lelandj Sent: Tuesday, July 26, 2011 9:29 AM To: ProFox Email List Subject: Re: [NF] "Best" file format for video playback on web site On 07/26/2011 08:19 AM, James E Harvey wrote: > We do have a YouTube account for some of our farm videos, but the > yearling videos number in the 100's + and counting, and it seems a > better user experience to use the web site to promote the product. There are a number of free and commercial web based video player that can be integrated into your web pages. http://go.brightcove.com/content/en-online-video-hosting-made-easy-video-upl oad?c=7013000jfhB http://www.instantshift.com/2010/05/14/21-free-video-players-for-your-websit e-and-blogs/ http://www.web-video-player.com/userguide.php http://www.easyflv.com/ There are probably many more. You could do a Google to see. Regards, LelandJ > > > James E Harvey > Corresponding Officer/M.I.S. > Hanover Shoe Farms, Inc. > www.hanoverpa.com > jhar...@hanoverpa.com > 717-637-8931 > fax: 717-637-6766 > cell: 717-887-2565 > > > -Original Message- > From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On > Behalf Of Stephen Russell > Sent: Monday, July 25, 2011 4:14 PM > To: ProFox Email List > Subject: Re: [NF] "Best" file format for video playback on web site > > On Mon, Jul 25, 2011 at 3:33 PM, James E Harvey > wrote: >> With the advent of the Ipad I think we need to provide a format that >> can play on this and the Android devices, and Flash still won't play >> on the Ipad, right? > --- > > Correct. Flash is not going to play on the i??? device(s) > > Would YouTube be a good location for them? Easier to have people > share and if one goes viral your hardware will never have to support that demand. > > > > Stephen Russell > > Unified Health Services > 60 Germantown Court > Suite 220 > Cordova, TN 38018 > > Telephone: 888.510.2667 > > 901.246-0159 cell > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/024101cc4ba2$88ace880$9a06b980$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] "Best" file format for video playback on web site
Ok, but I guess we really don't want to be dependent on YouTube in the long run for this part of our operation, just in case something happens there, like they might decide to start charging for the service? James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Tuesday, July 26, 2011 9:02 AM To: ProFox Email List Subject: Re: [NF] "Best" file format for video playback on web site On Tue, Jul 26, 2011 at 8:19 AM, James E Harvey wrote: > We do have a YouTube account for some of our farm videos, but the > yearling videos number in the 100's + and counting, and it seems a > better user experience to use the web site to promote the product. -- I am saying that you embed the youtube video into your page design, not send people to youtube to view it. -- Stephen Russell Unified Health Services 60 Germantown Court Suite 220 Cordova, TN 38018 Telephone: 888.510.2667 901.246-0159 cell [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/023f01cc4ba2$1907f9c0$4b17ed40$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] "Best" file format for video playback on web site
We do have a YouTube account for some of our farm videos, but the yearling videos number in the 100's + and counting, and it seems a better user experience to use the web site to promote the product. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Monday, July 25, 2011 4:14 PM To: ProFox Email List Subject: Re: [NF] "Best" file format for video playback on web site On Mon, Jul 25, 2011 at 3:33 PM, James E Harvey wrote: > With the advent of the Ipad I think we need to provide a format that > can play on this and the Android devices, and Flash still won't play > on the Ipad, right? --- Correct. Flash is not going to play on the i??? device(s) Would YouTube be a good location for them? Easier to have people share and if one goes viral your hardware will never have to support that demand. Stephen Russell Unified Health Services 60 Germantown Court Suite 220 Cordova, TN 38018 Telephone: 888.510.2667 901.246-0159 cell [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/021301cc4b96$98d33d60$ca79b820$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] "Best" file format for video playback on web site
With the advent of the Ipad I think we need to provide a format that can play on this and the Android devices, and Flash still won't play on the Ipad, right? James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of lelandj Sent: Monday, July 25, 2011 12:52 PM To: ProFox Email List Subject: Re: [NF] "Best" file format for video playback on web site You might take a look at CoffeeCup's Web Video Player. It convert all the popular formats to flash. Also, if you had a youtube account, I believe all uploaded videos are convert to run in flash, and can be played in a number of ways depending on the selected option like full screen or 360, 480, 720 or 1080 resolutions, etc. http://www.coffeecup.com/video-player/ Regards, LelandJ On 07/25/2011 11:44 AM, James E Harvey wrote: > I'm looking for advice, input, etc., on which format(s) would be > consider "best" to playback videos on our web site. > > We're using flv files in an html wrapper with swf to play the video > for this year's crop. We've tried .rm, in the past too. > > Below is the code generated by our videographer to create the html > wrapper we're using now. It all seems so complicated, and I was > hoping for something simpler. > > 01 > > > > classid="clsid:D27CDB6E-AE6D-11cf-96B8-44455354" > codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swfl > ash.ca b#version=9,0,115,0" width="600" height="338"> > > > > > pluginspage="http://www.macromedia.com/go/getflashplayer"; > type="application/x-shockwave-flash" width="600" height="338" > allowScriptAccess="sameDomain" allowFullScreen="True"> > > > > > ** > > We tried mp4 files, but they wanted to download before playing, and > we'd rather they stream from the web page. Is there a way to cause > the mp4 files to stream and play in a new tab? > > You can see the video by going to the web page below, then click on > the "RED" button on the top left. The page will refresh with the "Adios" > yearlings being sold Friday, and you should see a button on the right > for the videos. > > > http://www.hanoverpa.com/Foal/Default.aspx > > > > > James E Harvey > Corresponding Officer/M.I.S. > Hanover Shoe Farms, Inc. > www.hanoverpa.com > jhar...@hanoverpa.com > 717-637-8931 > fax: 717-637-6766 > cell: 717-887-2565 > > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/01be01cc4b0a$235ac850$6a1058f0$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] "Best" file format for video playback on web site
I'm looking for advice, input, etc., on which format(s) would be consider "best" to playback videos on our web site. We're using flv files in an html wrapper with swf to play the video for this year's crop. We've tried .rm, in the past too. Below is the code generated by our videographer to create the html wrapper we're using now. It all seems so complicated, and I was hoping for something simpler. 01 http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.ca b#version=9,0,115,0" width="600" height="338"> http://www.macromedia.com/go/getflashplayer"; type="application/x-shockwave-flash" width="600" height="338" allowScriptAccess="sameDomain" allowFullScreen="True"> ** We tried mp4 files, but they wanted to download before playing, and we'd rather they stream from the web page. Is there a way to cause the mp4 files to stream and play in a new tab? You can see the video by going to the web page below, then click on the "RED" button on the top left. The page will refresh with the "Adios" yearlings being sold Friday, and you should see a button on the right for the videos. http://www.hanoverpa.com/Foal/Default.aspx James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/004401cc4aea$1563da90$402b8fb0$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] Google+
I'm definitely interested, hoping it's an "easier" interface to learn than Facebook. I like the idea of the circles (sub groups) James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Jarvis, Matthew Sent: Friday, July 15, 2011 12:19 PM To: profox@leafe.com Subject: [NF] Google+ I'm starting to get more and more emails and invites for the new Google+ Frankly I'm trying to tone down my online presence (bye bye FB, bye bye Tweets), but if G+ is supposed to be the shiznizzle do folks here think it's worth a look? Thanks, Matthew Jarvis || Business Systems Analyst IT Department McKenzie-Willamette Medical Center 1460 G Street, Springfield, OR 97477 || Ph: 541-744-6092 || Fax: 541-744-6145 -- Disclaimer: This electronic message may contain information that is Proprietary, Confidential, or legally privileged or protected. It is intended only for the use of the individual(s) and entity named in the message. If you are not an intended recipient of this message, please notify the sender immediately and delete the material from your computer. Do not deliver, distribute or copy this message and do not disclose its contents or take any action in reliance on the information it contains. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/00b501cc431e$77e83bd0$67b8b370$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: new server advice
More expandable is good, especially since we generally seem to underestimate our needs in the future... James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Patrick Bibro Sent: Wednesday, July 13, 2011 2:21 PM To: profox@leafe.com Subject: RE: new server advice Purchasing through Dell outlet you choose pre-configured systems and I think these 2 offered the best performance and value at that time. I think one had SBS2008 with it and the other no OS, which is what I was looking for. The T710 has some extras that offer little value to me like a triple redundant power supply. I am fine with the redundant power supply offered by the T610. I would not say a T710 is more powerful, perhaps more expandable in terms of # of drives and memory slots. -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of James E Harvey Sent: Wednesday, July 13, 2011 10:58 AM To: profoxt...@leafe.com Subject: RE: new server advice May I ask why you elected to purchase two different models? My impression is the T710 is a bit more powerful than the T610? James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Patrick Bibro Sent: Wednesday, July 13, 2011 10:40 AM To: profox@leafe.com Subject: RE: new server advice We recently purchased a T610 and a T710 from Dell outlet (if you are not set on a exact configuration you can save a bunch). Were running MS Small business server which provides licenses for both servers. We have been happy with both. One think to note, the T710 is larger (deeper) than it looks online. -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of James E Harvey Sent: Tuesday, July 12, 2011 8:19 AM To: profoxt...@leafe.com Subject: new server advice We've gotten a couple quotes for a new server to replace the two older boxes we now have. I thought we could combine the two old HP servers into one using VMware to virtualize the software. One VM would be for Terminal Services and Docuware (our document imaging software), the other would be for file/print share to handle all our business applications, written in VFP of course. One vendor mentioned a concern that using virtualization does cause performance issues, and I'm worried that using VM would put us back a step in that area? Here are the specs for the two Dells. I'm considering looking into HP, which is what we have now. Both servers will be running Win Server 2008R2 Dell T610 specs: 16GB Mem Single Intel Xeon E5620 2.4 Ghz Processor (5) 146GB 15K RPM SCSI Hotplug hard drives, Raid 5 Dell T710 specs: 12 GB Mem (2) Intel Xeon Proc (6) 300 GB 10K RPM Some of my thoughts on this project: We're scanning most our documents now, so we'd like to plan for enough HD for the next three years. Don't want to implement something that is going to be of lessor performance that what we have now. We have about 25 users and performance is good now. Main Server duties: Active Directory File/Print share (for all our business applications written in VFP) Terminal Services (only a few users use this) Docuware (document imaging software) Does using VM make sense for our purpose, or is it overkill. Any general thoughts, ideas, and or advice appreciated. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/00de01cc4192$c4d955b0$4e8c0110$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: new server advice
May I ask why you elected to purchase two different models? My impression is the T710 is a bit more powerful than the T610? James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Patrick Bibro Sent: Wednesday, July 13, 2011 10:40 AM To: profox@leafe.com Subject: RE: new server advice We recently purchased a T610 and a T710 from Dell outlet (if you are not set on a exact configuration you can save a bunch). Were running MS Small business server which provides licenses for both servers. We have been happy with both. One think to note, the T710 is larger (deeper) than it looks online. -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of James E Harvey Sent: Tuesday, July 12, 2011 8:19 AM To: profoxt...@leafe.com Subject: new server advice We've gotten a couple quotes for a new server to replace the two older boxes we now have. I thought we could combine the two old HP servers into one using VMware to virtualize the software. One VM would be for Terminal Services and Docuware (our document imaging software), the other would be for file/print share to handle all our business applications, written in VFP of course. One vendor mentioned a concern that using virtualization does cause performance issues, and I'm worried that using VM would put us back a step in that area? Here are the specs for the two Dells. I'm considering looking into HP, which is what we have now. Both servers will be running Win Server 2008R2 Dell T610 specs: 16GB Mem Single Intel Xeon E5620 2.4 Ghz Processor (5) 146GB 15K RPM SCSI Hotplug hard drives, Raid 5 Dell T710 specs: 12 GB Mem (2) Intel Xeon Proc (6) 300 GB 10K RPM Some of my thoughts on this project: We're scanning most our documents now, so we'd like to plan for enough HD for the next three years. Don't want to implement something that is going to be of lessor performance that what we have now. We have about 25 users and performance is good now. Main Server duties: Active Directory File/Print share (for all our business applications written in VFP) Terminal Services (only a few users use this) Docuware (document imaging software) Does using VM make sense for our purpose, or is it overkill. Any general thoughts, ideas, and or advice appreciated. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/002a01cc4175$a7581b10$f6085130$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: new server advice
We've had HP servers over the years, but I'm okay with changing based on the consultant's relationship with his supplier. I am a little nervous about VMware, mainly because I've had no experience with this technology. I believe I understand a benefit is the ability to have only physical box, but several servers running separately on that box. Upside there is you could "re-boot" one of the VMware servers, and not affect the others. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of John Harvey Sent: Tuesday, July 12, 2011 9:28 AM To: 'ProFox Email List' Subject: RE: new server advice We use Dell, but I'm sure HP will do just as good a job. John -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of James E Harvey Sent: Tuesday, July 12, 2011 8:52 AM To: 'ProFox Email List' Subject: RE: new server advice Do you have a feeling for either Dell versus HP servers generally speaking? James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Alan Bourke Sent: Tuesday, July 12, 2011 8:48 AM To: profox@leafe.com Subject: Re: new server advice We have a lot of people using VMs, *done properly* I see no difference at all in speed terms. -- Alan Bourke alanpbourke (at) fastmail (dot) fm [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/0c4101cc40a3$5b896680$129c3380$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: new server advice
No plans to covert our apps for the next 3 years at least (I'm retiring in 2014). The Docuware app uses Mysql, and they said the VM was okay. They have a major upgrade available now, so we are discussing how to handle that while doing the new server. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Tuesday, July 12, 2011 9:06 AM To: ProFox Email List Subject: Re: new server advice On Tue, Jul 12, 2011 at 8:18 AM, James E Harvey wrote: > We've gotten a couple quotes for a new server to replace the two older > boxes we now have. I thought we could combine the two old HP servers > into one using VMware to virtualize the software. > > One VM would be for Terminal Services and Docuware (our document > imaging software), the other would be for file/print share to handle > all our business applications, written in VFP of course. > > One vendor mentioned a concern that using virtualization does cause > performance issues, and I'm worried that using VM would put us back a > step in that area? > > Here are the specs for the two Dells. I'm considering looking into > HP, which is what we have now. > > Both servers will be running Win Server 2008R2 > > > Dell T610 specs: > 16GB Mem > Single Intel Xeon E5620 2.4 Ghz Processor > (5) 146GB 15K RPM SCSI Hotplug hard drives, Raid 5 > > Dell T710 specs: > 12 GB Mem > (2) Intel Xeon Proc > (6) 300 GB 10K RPM > > > Some of my thoughts on this project: > > We're scanning most our documents now, so we'd like to plan for enough > HD for the next three years. > Don't want to implement something that is going to be of lessor > performance that what we have now. > We have about 25 users and performance is good now. > > Main Server duties: > Active Directory > File/Print share (for all our business applications written in VFP) > Terminal Services (only a few users use this) Docuware (document > imaging software) > > > Does using VM make sense for our purpose, or is it overkill. > > Any general thoughts, ideas, and or advice appreciated. --- Consider a NAS like the Drobo FS NAS server - Serial ATA-300 as cheaper storage. Are you going to convert over to a RDBMS in the next few years replacing .dbf? If so consider one virtual being just your database and that db needs two spindles on your raid for killer performance. What is the db for your DocMgmt system? Do they give you a clearance to run it in a virtual, and if so what do they expect in resources? -- Stephen Russell Unified Health Services 60 Germantown Court Suite 220 Cordova, TN 38018 Telephone: 888.510.2667 901.246-0159 cell [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/0c3c01cc409d$e59d0da0$b0d728e0$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: new server advice
Do you have a feeling for either Dell versus HP servers generally speaking? James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Alan Bourke Sent: Tuesday, July 12, 2011 8:48 AM To: profox@leafe.com Subject: Re: new server advice We have a lot of people using VMs, *done properly* I see no difference at all in speed terms. -- Alan Bourke alanpbourke (at) fastmail (dot) fm [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/0c1201cc409a$eab9d410$c02d7c30$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
new server advice
We've gotten a couple quotes for a new server to replace the two older boxes we now have. I thought we could combine the two old HP servers into one using VMware to virtualize the software. One VM would be for Terminal Services and Docuware (our document imaging software), the other would be for file/print share to handle all our business applications, written in VFP of course. One vendor mentioned a concern that using virtualization does cause performance issues, and I'm worried that using VM would put us back a step in that area? Here are the specs for the two Dells. I'm considering looking into HP, which is what we have now. Both servers will be running Win Server 2008R2 Dell T610 specs: 16GB Mem Single Intel Xeon E5620 2.4 Ghz Processor (5) 146GB 15K RPM SCSI Hotplug hard drives, Raid 5 Dell T710 specs: 12 GB Mem (2) Intel Xeon Proc (6) 300 GB 10K RPM Some of my thoughts on this project: We're scanning most our documents now, so we'd like to plan for enough HD for the next three years. Don't want to implement something that is going to be of lessor performance that what we have now. We have about 25 users and performance is good now. Main Server duties: Active Directory File/Print share (for all our business applications written in VFP) Terminal Services (only a few users use this) Docuware (document imaging software) Does using VM make sense for our purpose, or is it overkill. Any general thoughts, ideas, and or advice appreciated. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/0c0a01cc4096$34c74b50$9e55e1f0$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: 'Not equal to' choices
Thought so, been using <>, but liking # as it is only one keystroke. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Fred Taylor Sent: Monday, June 13, 2011 2:13 PM To: ProFox Email List Subject: Re: 'Not equal to' choices Whatever you're most comfortable using. Depends more on your programming heritage, I'd say. They all boil down to the same thing. Fred On Mon, Jun 13, 2011 at 11:47 AM, James E Harvey wrote: > Just curious if there is some reason to choose one of the not equal to > operator over another. > > <>, #, != > > James E Harvey > Corresponding Officer/M.I.S. > Hanover Shoe Farms, Inc. > www.hanoverpa.com > jhar...@hanoverpa.com > 717-637-8931 > fax: 717-637-6766 > cell: 717-887-2565 > > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/098e01cc29fe$593f62a0$0bbe27e0$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
'Not equal to' choices
Just curious if there is some reason to choose one of the not equal to operator over another. <>, #, != James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/098901cc29fa$5450b540$fcf21fc0$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Start group on new page
I'm doing that now, but it seemed more efficient to have one report so when I need to make changes there's only one report to edit... I've looked at the book by Cathy Pountney (that's how I learned about the evaluate option), but could not seem to find anything about the new page vs new line option. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Tuesday, June 07, 2011 2:11 PM To: profox@leafe.com Subject: RE: Start group on new page While I'm sure there's a way to hack it in, why not just have 2 versions of the FRX and then run the appropriate one? -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of James E Harvey Sent: Tuesday, June 07, 2011 2:53 PM To: profoxt...@leafe.com Subject: Start group on new page I have a report that will group by categories picked by the user by using the evaluate(pcgroupexpr) in the report form's data grouping properties dialog, but can you programmatically set the "Group starts on" the "New line" or "New Page" so it can be a selection the user can choose prior to running the report. [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/015f01cc2548$e48890d0$ad99b270$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Start group on new page
I have a report that will group by categories picked by the user by using the evaluate(pcgroupexpr) in the report form's data grouping properties dialog, but can you programmatically set the "Group starts on" the "New line" or "New Page" so it can be a selection the user can choose prior to running the report. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/014e01cc2544$14d59fd0$3e80df70$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] web hosting location
Thanks much. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Paul Hill Sent: Monday, May 09, 2011 10:56 AM To: ProFox Email List Subject: Re: [NF] web hosting location Hi James, I think this is just where the domain is registered? Try a trace route, this is what I get: tracert www.theblackbook.com Tracing route to www.theblackbook.com [69.175.39.218] over a maximum of 30 hops: 1<1 ms * <1 ms hoist-dc5.hoistlondon.com [192.168.0.254] 2 *** Request timed out. [snip] 14 107 ms 106 ms 107 ms 64.124.146.114.allocated.above.net [64.124.146.114] 15 106 ms 105 ms 106 ms asw-fu139.ord03.singlehop.net [69.175.1.146] 16 109 ms 105 ms 105 ms web.theblackbook.com [69.175.39.218] singlehop.net seems to be a hosting provider. Regards, Paul On Mon, May 9, 2011 at 3:18 PM, James E Harvey wrote: > How does one find out who is hosting a website, and where is it > located > > www.theblackbook.com > > > "whois" tells me the domain is registered with Network Solutions, and > the Domain server is NS1.EASYCGI.COM, so I guess that means they must > be hosting the site, right? > > > > James E Harvey > Corresponding Officer/M.I.S. > Hanover Shoe Farms, Inc. > www.hanoverpa.com > jhar...@hanoverpa.com > 717-637-8931 > fax: 717-637-6766 > cell: 717-887-2565 > > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/00e201cc0e67$698361a0$3c8a24e0$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] web hosting location
How does one find out who is hosting a website, and where is it located www.theblackbook.com "whois" tells me the domain is registered with Network Solutions, and the Domain server is NS1.EASYCGI.COM, so I guess that means they must be hosting the site, right? James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/004501cc0e53$fd6aa180$f83fe480$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] Server age concerns
We have an extra drive for each server, but we'd need to get help to install either one, and they are in a Raid. Being down for any length of time (one day, or several) wouldn't be great, but it's happened before and we've survived, I just wouldn't want to do it again. Backups are tested on a weekly basis by actually retrieving files, and we do both online (Carbonite) and on-site (external hard drive) backups, but it would take a while to restore the whole kit'n'kaboodle..., I'm debating whether it is worth spending money to upsize our current servers, given their age... James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Jarvis, Matthew Sent: Friday, May 06, 2011 2:06 PM To: profox@leafe.com Subject: RE: [NF] Server age concerns > -Original Message- > From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] > On Behalf Of James E Harvey > Sent: Friday, May 06, 2011 11:31 AM > To: profoxt...@leafe.com > Subject: RE: [NF] Server age concerns > > I went online to see if there was any information on a MTBF for these > servers, but could not find a definitive answer to this question. > Regardless of an alleged MTBF, like Dan said/implied - How vulnerable are you if one or both of these servers goes down? How long can you be down? If one goes down, can you hot swap the functionality of one server over onto the other if need be? Do you have an action plan to: Do a disk drive replace? Are you running RAID? What level? Do you know how to replace drives in a RAID config? Bare metal installation? Do you trust your backup? Really? Have you tested it? And I mean *really* tested it? How long does it take to get info from backup device/service onto your machine? Like SR pointed out - offsite might not be an option if your backups/restores are large. Thanks, Matthew Jarvis || Business Systems Analyst IT Department McKenzie-Willamette Medical Center 1460 G Street, Springfield, OR 97477 || Ph: 541-744-6092 || Fax: 541-744-6145 -- Disclaimer: This electronic message may contain information that is Proprietary, Confidential, or legally privileged or protected. It is intended only for the use of the individual(s) and entity named in the message. If you are not an intended recipient of this message, please notify the sender immediately and delete the material from your computer. Do not deliver, distribute or copy this message and do not disclose its contents or take any action in reliance on the information it contains. [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/031701cc0c27$4fb658f0$ef230ad0$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] Server age concerns
I went online to see if there was any information on a MTBF for these servers, but could not find a definitive answer to this question. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Friday, May 06, 2011 1:02 PM To: ProFox Email List Subject: Re: [NF] Server age concerns On 5/6/2011 12:42 PM, Dan Covill wrote: > I would say this is exactly the right time to start on replacing one > of them. While you can think about it a bit, instead of waiting for a > catastrophe! I guessjust seems to me that I'd hope they would last at least 5+ years, but then again, it's always on and working if it's a server I guess, so it'll wear out sooner theoretically than a similarly configured desktop/workstation. [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/026801cc0c1b$be56c670$3b045350$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] Server age concerns
Our two servers are 3 1/2 years old, out of warranty, and the main server 75% full. I was wondering if I should start to get concerned about the life span of these servers. They both have developed some quirks, but are not showing any specific behavior to make me thing they might fail in the immediate future. Server 1: The first server is used for most of our day to day business applications. We do not run Exchange as we use Rackspace to host our email. HP Proliant ML350 G5, Win 2003 SP2, 4 x Intel Pentium III Xeon, 3 GB RAM, 2.67 GHz It's showing 32.4 GB free out of 136GB, and has 5 drives, (2) - HP36GB SAS Hard drives and (3) - HP72GB Hot Plug. Server 2: This server is now used to run the document imaging software "Docuware", and terminal services for the few users that remote in occasionally (5 users at the most). HP Proliant ML310 G5, Win 2003 R2 SP2, 2 x Intel Xeon, 3.4 GB Ram, 2.67 GHz It has 147 GB free out of 180 GB, and has (4) - HP72GB drives with no space bays. I have analyzed the data on the first server, and it looks like a certain amount is static and not critical to day to day operations. This type of data (pictures, videos, user's folders) could possibly be moved to some kind of storage device attached to the network, or the moved to the second server. Or, is it possible to buy more Hot Plug drives. There are three empty bays in the case. Or, since these two servers are getting some age, should we look into one new server. I guess what I am mainly concerned about, other than the first server getting full, is the age factor. I can't seem to find a straight answer to the MTBF for these servers... James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/021e01cc0c0d$2477f050$6d67d0f0$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: I'm back...Just
Hello Dave, Glad to hear you're on the mend, and happy new year to you too :) James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier Sent: Monday, April 04, 2011 4:59 AM To: Profox@leafe.com Subject: I'm back...Just Hi you guys, You may (or probably didn't ) have noticed that I haven't been around for about 3 months. Unfortunately I had a bad accident which I am now slowly recovering from and trying to get back into "work mode". I wanted to apologise to a few group members who I did promise things to before the accident as they didn't materialise, especially Rafael. I'll try and retrieve back what I promised if it is still relevant. Meanwhile, a happy new year to you all! Albeit a belated one! Dave C [http://flexipol.co.uk/graphics/Flexipol_Logo.jpg] [http://flexipol.co.uk/graphics/Flexipol_Shields.jpg] --- This communication and the information it contains is intended for the person or organisation to whom it is addressed. Its contents are confidential and may be protected in law. If you have received this e-mail in error you must not copy, distribute or take any action in reliance on it. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the risk of virus transmission through email and therefore any files sent via e-mail will have been checked for known viruses. However, you are advised to run your own virus check before opening any attachments received as Flexipol Packaging Ltd will not in any event accept any liability whatsoever once an e-mail and/or any attachment is received. It is the responsibility of the recipient to ensure that they have adequate virus protection. Flexipol Packaging Ltd. Unit 14 Bentwood Road Carrs Industrial Estate Haslingden Rossendale Lancashire BB4 5HH Tel:01706-222792 Fax: 01706-224683 www.Flexipol.co.uk<http://www.flexipol.co.uk/> --- Terms & Conditions: Notwithstanding delivery and the passing of risk in the goods, the property in the goods shall not pass to the buyer until the seller Flexipol Packaging Ltd. ("The Company") has received in cash or cleared funds payment in full of the price of the goods and all other goods agreed to be sold by the seller to the buyer for which payment is then due. Until such time as the property in the goods passes to the buyer, the buyer shall hold the goods as the seller's fiduciary agent and bailee and keep the goods separate from those of the buyer and third parties and properly stored protected and insured and identified as the seller's property but shall be entitled to resell or use the goods in the ordinary course of its business. Until such time as the property in the goods passes to the buyer the seller shall be entitled at any time --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/003801cbf2ca$8b8780a0$a29681e0$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: validate database error
Thanks Michael, I did as you suggested, and it worked, no more error message. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Thursday, February 17, 2011 11:37 AM To: ProFox Email List Subject: Re: validate database error On 2/17/2011 11:02 AM, James E Harvey wrote: > While validating a database this message occurs: > > Validate Database HANOVER > Rebuilding structural index Index rebuilt Object #959 (Index > 'req'): Bad property types or lengths: 1 > > I "use" the database, browse for Objectid = 959, and see the > Objecttype is "Index" with an Objectname = req. The "Property" record > shows a table "hftrns.dbf". > > Then hftrns.dbf does not have a "req" index tag. > > Can I remove the data in the property field and expect the Validate to be > successful? Backup the files first. Then add the RECOVER option to that command to see if that fixes it. Sorry, Jim, in a hurry with other stuff but wanted to fire that off to you to try in the meanwhile. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/022601cbcec1$38839ab0$a98ad010$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
validate database error
While validating a database this message occurs: Validate Database HANOVER Rebuilding structural index Index rebuilt Object #959 (Index 'req'): Bad property types or lengths: 1 I "use" the database, browse for Objectid = 959, and see the Objecttype is "Index" with an Objectname = req. The "Property" record shows a table "hftrns.dbf". Then hftrns.dbf does not have a "req" index tag. Can I remove the data in the property field and expect the Validate to be successful? James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/021a01cbcebc$0970c4f0$1c524ed0$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Sedna extensions for VS 2008
Has anyone heard if there are any plans for the DDEXProvider with VS 2008? James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/005201cbcd26$877f2860$967d7920$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: insert into ms sql 2005 table
We changed the password, and the site has been updated and is back up. I'm truly sorry for sending my initial email without spending the time to think it through. I've always respected this list and the members who take their time to answer intelligent questions, but in this instance I was not courteous to the group. Please accept my apology. James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Grigore Dolghin Sent: Monday, January 24, 2011 2:47 PM To: profox@leafe.com Subject: RE: insert into ms sql 2005 table It seems you need to do some changes in your website's web.config file as well - it is down now, complaining about "Login failed for user 'hanovershoefarms" :) us. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/095601cbbc04$96538c60$c2faa520$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: insert into ms sql 2005 table
OMG, I'd fire myself if I could, how can I be so GD stupid!!! James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche Sent: Monday, January 24, 2011 12:58 PM To: profox@leafe.com Subject: Re: insert into ms sql 2005 table On Mon, Jan 24, 2011 at 11:40 AM, James E Harvey wrote: > I'm trying to insert records into a table on the ms sql godaddy > database, but this isn't working. Does anyone have any advice as to > what I'm doing wrong? You're giving us (and the entire internet) your passwords. Your machine should be owned by now. You say it isn't working, but you don't say if you've: - tested to confirm the connection is working - verified that the SQL statement is correct - tried to get back an error message to determine what's wrong - done any troubleshooting what-so-ever. My advice? Read: http://www.catb.org/~esr/faqs/smart-questions.html But first, please read on... > m.lcxn=("Driver={SQL Server}; > Server=hanovershoefarms.db.6386843.hostedresource.com; > Database=hanovershoefarms; Uid=hanovershoefarms; Pwd=r5V0n18") > > m.lih=Sqlstringconnect(m.lcxn) I've tested this much. From Linux, using unixODBC, FreeTDS and isql. It does, in fact work. Now that you've posted this to the internet, any malicious user can come along and issue DROP ALL, or change your password. Someone's going to... Please change your UID and password. NOW. In the future, please don't share user ids and passwords. > > lc_selectcommand = "SELECT * into hsf_broodmares FROM > c:\foxdat\hsf_broodmare" This is unusual syntax. Are you sure this is right? Does the GoDaddy MS SQL server have a local c:\foxdat\hsf_broodmare file? -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/092101cbbbf5$ba5deb50$2f19c1f0$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
insert into ms sql 2005 table
I'm trying to insert records into a table on the ms sql godaddy database, but this isn't working. Does anyone have any advice as to what I'm doing wrong? m.lcxn=("Driver={SQL Server}; Server=hanovershoefarms.db.6386843.hostedresource.com; Database=hanovershoefarms; Uid=hanovershoefarms; Pwd=r5V0n18") m.lih=Sqlstringconnect(m.lcxn) lc_selectcommand = "SELECT * into hsf_broodmares FROM c:\foxdat\hsf_broodmare" SQLExec(m.lih,lc_selectcommand) James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/091301cbbbe5$67b178a0$371469e0$@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: vfp with office 2010
I think I got it figured out. I apparently misread the documentation and checked, instead of unchecking files types to trust, duh James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of James E Harvey Sent: Monday, January 10, 2011 10:15 AM To: 'ProFox Email List' Subject: vfp with office 2010 I installed Office 2010 (32 bit version) on my pc last week (Win 7 Prof 64 bit) Today I ran a select in vfp 9 to a type xls file. Opened the file in Office 2010 and tried to save as a xlsx type, but get a message that states I need to adjust settings in the Trust Center Settings area of Excel. I followed the instructions but this did not work, and now the documentation mentions a registry hack. Has anyone else run into this situation, I'm wary about hacking the registry... James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/001501cbb0dc$69065ef0$3b131c...@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
vfp with office 2010
I installed Office 2010 (32 bit version) on my pc last week (Win 7 Prof 64 bit) Today I ran a select in vfp 9 to a type xls file. Opened the file in Office 2010 and tried to save as a xlsx type, but get a message that states I need to adjust settings in the Trust Center Settings area of Excel. I followed the instructions but this did not work, and now the documentation mentions a registry hack. Has anyone else run into this situation, I'm wary about hacking the registry... James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/000301cbb0d9$2eae7c90$8c0b75...@hanoverpa.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: select on ms sql 2005 data on web server
Do you have a favorite source you use to research the syntax? James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Tuesday, December 28, 2010 10:02 PM To: ProFox Email List Subject: Re: select on ms sql 2005 data on web server On Tue, Dec 28, 2010 at 8:34 PM, James E Harvey wrote: > Thanks everyone. > > It will be nice when Godaddy finally starts to support ms sql 2008, as I > believe that version supports the date datatype? How the heck have they coped for all these years? Come on dude. Just learn the syntax and roll with it. -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/013f01cba756$b4b79fb0$1e26df...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: select on ms sql 2005 data on web server
You mean like this: mfdate = ThisForm.hscntsqlcon.hstxtfdate.Value mldate = mfdate + 1 mcfdate = DTOC(mfdate) mcldate = DTOC(mldate) m.lcxn=("Driver={SQL Server}; Server=; Database=; Uid=; Pwd=") m.lih=SQLSTRINGCONNECT(m.lcxn) SQLEXEC(m.lih,"SELECT * FROM hsf_webct where DTE_OWN between ?mcfdate and ?mcldate " ) browse James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Alan Bourke Sent: Wednesday, December 29, 2010 5:50 AM To: profox@leafe.com Subject: Re: select on ms sql 2005 data on web server And you're using parameters in the query instead of building a string directly from user input, right? Right. :) -- Alan Bourke alanpbourke (at) fastmail (dot) fm [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/013c01cba751$344f4170$9cedc4...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: select on ms sql 2005 data on web server
Thanks everyone. It will be nice when Godaddy finally starts to support ms sql 2008, as I believe that version supports the date datatype? James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Tuesday, December 28, 2010 4:21 PM To: ProFox Email List Subject: Re: select on ms sql 2005 data on web server On Tue, Dec 28, 2010 at 2:28 PM, James E Harvey wrote: > I can connect and pull all the records using: > > SQLEXEC(m.lih,"SELECT * FROM hsf_webct") > > > But when I try the where clause it fails: > > SQLEXEC(m.lih,"SELECT * FROM hsf_webct where TTOD(DTE_OWN) = > {^2010/12/28}") > > > > dte_own is a datetime MS SQL2005 datatype --- In 2005 you have to go between time frames of the DATE you want. This should find all. SQLEXEC(m.lih,"SELECT * FROM hsf_webct where DTE_OWN between '2010/12/28' and '2010/12-29' ) -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/011601cba700$dff19060$9fd4b1...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
select on ms sql 2005 data on web server
I can connect and pull all the records using: SQLEXEC(m.lih,"SELECT * FROM hsf_webct") But when I try the where clause it fails: SQLEXEC(m.lih,"SELECT * FROM hsf_webct where TTOD(DTE_OWN) = {^2010/12/28}") dte_own is a datetime MS SQL2005 datatype James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. jhar...@hanoverpa.com 717-637-8931 fax: 717-637-6766 cell: 717-887-2565 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/008301cba6cd$c4a56030$4df020...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
grid.text show property
What's the property to show the value in a grid.column.text cell that isn't long enough to show its value entirely. You move the mouse over the cell and the value kind of "pops up" like a tip? James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/025a01cb77a9$08c074c0$1a415e...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: VFP to MS SQL on Godaddy
Thanks, I'll take a look at the upsize wizard. James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Alan Bourke Sent: Thursday, October 14, 2010 8:25 AM To: profox@leafe.com Subject: Re: VFP to MS SQL on Godaddy James The Upsizing Wizard that comes bundled with VFP9 can help you here: http://msdn.microsoft.com/en-us/library/ecsk43h4(VS.80).aspx -- Alan Bourke alanpbourke (at) fastmail (dot) fm [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/016901cb6bae$fa6b5210$ef41f6...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: The Mysterious VANISHING Print Preview ToolBar.
I think if you right-click on the resulting report, the drop-down menu will have a "Toolbar" option. If you click that the "Toolbar" should re-appear. James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Kurt Wendt Sent: Thursday, October 14, 2010 8:37 AM To: profox@leafe.com Subject: The Mysterious VANISHING Print Preview ToolBar. Hello there folks, I had a strange little problem happen to me yesterday - and the problem I found was proliferated to other users around me here today. In this small system of mine - I run a Print Preview to allow users (and myself) to review the data before printing. However, its also via the Preview that I give them the ability to actually print. However, that Toolbar that normally pops-up, which allows you to move between pages - and then hit Print - it VANISHED! Yesterday, when I was running the system myself - I had just tried moving the little toolbar out of the way - so I could see something. But, when I did it - I moved it out of the main screen window - and then it disappeared. So - now I need it to come back - not only for ME - but for everyone else. Has anyone seen this problem before - and do you know what simple thing I can do - to get back my Preview Toolbar??? TIA, -K- Developer Waitex Information System, Inc. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/016601cb6bae$9bb9fcd0$d32df6...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
VFP to MS SQL on Godaddy
Looking for advice and direction on how to proceed with this project. Our web site is hosted on Godaddy.com, and part of it uses a MS SQL database. We'd like to export data from a VFP 9 table to a MS SQL table, and host that data in the MS SQL table on the Godaddy hosted web site. What options are available to export the data from VFP to MS SQL? What is the normal procedure for getting the data onto our web site at Godaddy (FTP?) Research shows there is a software package (Data Loader Ver. 4.0) that can export vfp to ms sql. Is this a tool I should be looking at? Any advice and or guidance on where to go for material to help with this project would be much appreciated. James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/010101cb6b98$7491e2f0$5db5a8...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] Best IM software
Okay, thanks James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Alan Bourke Sent: Friday, September 24, 2010 9:22 AM To: profox@leafe.com Subject: RE: [NF] Best IM software The JRE is the Java Runtime Edition - if you are confident the machines already have that then you don't need it. On Fri, 24 Sep 2010 10:08 -0500, "James E Harvey" wrote: > The Sparks downloads page offers one with the Java JRE and one without, > don't know what that means? > -- Alan Bourke alanpbourke (at) fastmail (dot) fm [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/016f01cb5bfc$b6fa3c10$24eeb4...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] Best IM software
The Sparks downloads page offers one with the Java JRE and one without, don't know what that means? James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Friday, September 24, 2010 8:05 AM To: ProFox Email List Subject: Re: [NF] Best IM software On Fri, Sep 24, 2010 at 8:32 AM, James E Harvey wrote: > I'm looking for advice on a program that I can to use to IM a message to a > user on my network. Email is great for most communications, but sometimes > an Instant Message can speed things up a bit (and the recipient can't say "I > didn't see that message". > > We used something "free" a few years ago, but can't remember the name, and I > imagine things are much better nowadays. > > Our network is a typical LAN, server is running Win 2003, with about 25 > users running anything from Win XP to Win 7. > > Is there a business oriented package that doesn't make it easy to do the > social networking aspect? --- We use Spark ver 2.5.8 here at the county and it is pretty good. Not only can you post messages but you can drop files in as well. There is the one via Windows but not sure if it is free off the server. -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/016901cb5bfa$506ca480$f145ed...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] Best IM software
I'm looking for advice on a program that I can to use to IM a message to a user on my network. Email is great for most communications, but sometimes an Instant Message can speed things up a bit (and the recipient can't say "I didn't see that message". We used something "free" a few years ago, but can't remember the name, and I imagine things are much better nowadays. Our network is a typical LAN, server is running Win 2003, with about 25 users running anything from Win XP to Win 7. Is there a business oriented package that doesn't make it easy to do the social networking aspect? James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/011801cb5bec$f79e0950$e6da1b...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: excel automation
This seems to work now, thanks. Int(Val(Hip_No)) as Hip_No, ; oexcel.activesheet.range("J2:J" + ltrim(str(ntotalrow))).NumberFormat = "0" James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier Sent: Wednesday, September 01, 2010 10:43 AM To: 'ProFox Email List' Subject: RE: excel automation James, Unless I am being stupid then on the assumption that the HIP_No field is character VFP data with leading zero's and trailing decimals in the form "9.4023" then make the select statement for the HIP_No field like the following: Select all Int(Val(Hip_No)) as Hip_No >From ... The field will then be transferred as a numeric field into Excel. If you need to round it then just add the round() function into the select statement as this will simply take the integer part of the character field. Just be careful of any null field values you have. Somehow I think that it isn't exactly what you want to do but holla if it is different. Dave C [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/09fb01cb4a11$24a2f570$6de8e0...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: excel automation
Yep, www.hanoverpa.com James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Michael Madigan Sent: Wednesday, September 01, 2010 12:02 PM To: ProFox Email List Subject: Re: excel automation I didn't know you were in the horse business. --- On Wed, 9/1/10, James E Harvey wrote: > From: James E Harvey > Subject: excel automation > To: "'ProFox Email List'" > Date: Wednesday, September 1, 2010, 12:04 PM > I'm trying to convert the "hip_no" > field from a character to numeric value > with no decimals in the resulting excel file. > > I ran an excel macro after the file was created and came up > with this, but I > can't figure how to do this in vfp programmatically? > > Selection.NumberFormat = "0" > > Here is the code to create the cursor and run to excel. > > > > select ; > "/images/photo/" + ALLTRIM(filepath) + > ".jpg" as photo, ; > "/images/pedigree/" + > ALLTRIM(filepath) + ".pdf" as pedigree, ; > "/images/video/" + > ALLTRIM(filepath) + ".rm" as videofile, ; > "/images/video/" + > ALLTRIM(filepath) + > ICASE(yrfoal="2007",".rm",yrfoal="2008",".flv",yrfoal="2009",".html"," > ") > as video, ; > COMP_NO as tattoo, ; > name, ; > color, ; > SEX, ; > GAIT, ; > iif(DATE_FOAL <> {}, > dtoc(DATE_FOAL),dtoc({})) as DATE_FOAL, ; > SIRE1 as sire, ; > DAM1 as dam, ; > HIP_NO, ; > LOC_SOLD as sale, ; > iif(DATE_SOLD<> {}, > dtoc(DATE_SOLD),dtoc({})) as DATE_SOLD, ; > price_sold as sale_price, ; > alltrim(buy_name) as buyer ; > from lcfile3 ; > order by ; > DATE_FOAL desc, DAM1 ; > into cursor lcfile4 > > > oexcel = createobject("excel.application") > obook = oexcel.workbooks.add() > orange = oexcel.activesheet.range("a1:p1") > > > with oexcel.activesheet > .range("a1") = "Photo" > .range("b1") = "Tattoo" > .range("c1") = "Name" > .range("d1") = "Color" > .range("e1") = "Sex" > .range("f1") = "Gait" > .range("g1") = "Date Foal" > .range("h1") = "Sire" > .range("i1") = "Dam" > .range("j1") = "Hip No." > .range("k1") = "Pedigree" > .range("l1") = "Video" > .range("m1") = "Sale" > .range("n1") = "Date Sold" > .range("o1") = "Sale Price" > .range("p1") = "Buyer" > > > orange = orange.offset(1,0) > > > scan > > nlastrow = > orange.row-1 > ntotalrow = > nlastrow+1 > > with orange > > .columns[1].value = photo > > .columns[2].value = [="] + alltrim(tattoo) +["] > > .columns[3].value = name > > .columns[4].value = color > > .columns[5].value = SEX > > .columns[6].value = GAIT > > .columns[7].value = DATE_FOAL > > .columns[8].value = sire > > .columns[9].value = dam > > .columns[10].value = HIP_NO > > .columns[11].value = pedigree > > .columns[12].value = video > > .columns[13].value = sale > > .columns[14].value = DATE_SOLD > > .columns[15].value = sale_price > > .columns[16].value = buyer > endwith > > orange = > orange.offset(1,0) > > endscan > > James E Harvey > Hanover Shoe Farms, Inc. > M.I.S./Corresponding Officer > Off: 717-637-8931 > fax: 717-637-6766 > email: jhar...@hanoverpa.com > > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/09df01cb4a10$81085450$8318fc...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
excel automation
I'm trying to convert the "hip_no" field from a character to numeric value with no decimals in the resulting excel file. I ran an excel macro after the file was created and came up with this, but I can't figure how to do this in vfp programmatically? Selection.NumberFormat = "0" Here is the code to create the cursor and run to excel. select ; "/images/photo/" + ALLTRIM(filepath) + ".jpg" as photo, ; "/images/pedigree/" + ALLTRIM(filepath) + ".pdf" as pedigree, ; "/images/video/" + ALLTRIM(filepath) + ".rm" as videofile, ; "/images/video/" + ALLTRIM(filepath) + ICASE(yrfoal="2007",".rm",yrfoal="2008",".flv",yrfoal="2009",".html","") as video, ; COMP_NO as tattoo, ; name, ; color, ; SEX, ; GAIT, ; iif(DATE_FOAL <> {}, dtoc(DATE_FOAL),dtoc({})) as DATE_FOAL, ; SIRE1 as sire, ; DAM1 as dam, ; HIP_NO, ; LOC_SOLD as sale, ; iif(DATE_SOLD<> {}, dtoc(DATE_SOLD),dtoc({})) as DATE_SOLD, ; price_sold as sale_price, ; alltrim(buy_name) as buyer ; from lcfile3 ; order by ; DATE_FOAL desc, DAM1 ; into cursor lcfile4 oexcel = createobject("excel.application") obook = oexcel.workbooks.add() orange = oexcel.activesheet.range("a1:p1") with oexcel.activesheet .range("a1") = "Photo" .range("b1") = "Tattoo" .range("c1") = "Name" .range("d1") = "Color" .range("e1") = "Sex" .range("f1") = "Gait" .range("g1") = "Date Foal" .range("h1") = "Sire" .range("i1") = "Dam" .range("j1") = "Hip No." .range("k1") = "Pedigree" .range("l1") = "Video" .range("m1") = "Sale" .range("n1") = "Date Sold" .range("o1") = "Sale Price" .range("p1") = "Buyer" orange = orange.offset(1,0) scan nlastrow = orange.row-1 ntotalrow = nlastrow+1 with orange .columns[1].value = photo .columns[2].value = [="] + alltrim(tattoo) +["] .columns[3].value = name .columns[4].value = color .columns[5].value = SEX .columns[6].value = GAIT .columns[7].value = DATE_FOAL .columns[8].value = sire .columns[9].value = dam .columns[10].value = HIP_NO .columns[11].value = pedigree .columns[12].value = video .columns[13].value = sale .columns[14].value = DATE_SOLD .columns[15].value = sale_price .columns[16].value = buyer endwith orange = orange.offset(1,0) endscan James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/089501cb49ef$6a77d240$3f6776...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] SqlExpress 2008 error on creating new table
I thought I'd take a look at MS SQLexpress 2008, but have run into a road block. I was able to connect to the server and add a new database, but when I select "Tables" and then right click to select "New Tables" an error message occurs, "Unspecified error", with no other information? Thought about reinstalling, but wasn't sure where to start. James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com --- StripMime Report -- processed MIME parts --- multipart/related multipart/alternative text/plain (text body -- kept) text/html image/png --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/00fe01cb1460$726bbb70$574332...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: justpath with out dirve or file name
I did that, but was wondering if there was a function by itself, apparently not. James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Dan Olsson Sent: Monday, June 21, 2010 8:58 AM To: profox@leafe.com Subject: Re: justpath with out dirve or file name At 2010-06-21 16:39, you wrote: >Can't seem to find a function that returns just the path (no drive >letter,and no filename) >getdir("\images\pedigree\","Choose Folder","Folder",64), returns the >complete path including the drive letter. So remove the drive... SUBSTR(GetDir(blablabla),3) ** * Dan Olsson * <mailto:d...@dolittle.se> * <http://www.dolittle.se> [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/00c501cb1154$be959430$3bc0bc...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
justpath with out dirve or file name
Can't seem to find a function that returns just the path (no drive letter, and no filename) getdir("\images\pedigree\","Choose Folder","Folder",64), returns the complete path including the drive letter. We want to gather the path with the subfolder selected to insert into an excel cell representing the folder on the web where files are stored "\images\pedigree\2009 foals\" James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/00bc01cb114f$a014d700$e03e85...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
richtext control issue with alignment
This is for a VFP 9 application on the desktop, not the web. I finally found the correct syntax and setting, and applied it, but to no avail. Syntax object.SelAlignment [= value] 0 = LEFT 1 = RIGHT 2 = CENTER The control source for the control is a form property which refers back to a record in a table. The field in the table is numeric 4, so that is my problem. Looks like I'm going to have to rethink the data structure, and how the hip number is generated. James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Paul McNett Sent: Thursday, June 17, 2010 12:49 PM To: profox@leafe.com Subject: Re: [NF] C# vs VB On 6/17/10 7:21 AM, Ricardo Aráoz wrote: > On 17/06/2010 12:26 a.m., Paul McNett wrote: >> On 6/16/10 7:07 PM, Jeff Johnson wrote: >> >>> Paul: One of my favorite movies (Top Secret being a great predecessor). >>> Your analogy is "spot on" as they would say. Nice! >>> >> But in retrospect, the captain had fish. It was the Dr. (Leslie Nielsen) >> that had the >> lasagna. Time to dust that movie off and watch it again. It's on VHS, >> recorded in the >> 80's off of HBO, in ELP. The titles on the tape are: >> >> Airplane! >> Swimming To Cambodia >> 1/2 of Valley Girl >> >> > > Did you ask for permission to make the copies? Or are you in violation > of the EULA? ;-p Nah, that was in the days when there was the concept of "free use". Paul [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/018c01cb0e51$03ce6970$0b6b3c...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Richtext control alignment
I'm trying to align the text in the richtext control to the right, but can't find the correct property setting. ***Form.init with .HIP_NO .font = "arial" .font.bold=.t. .font.size = 150 .backcolor = rgb(0,0,0) .sellength = len(.textRTF) .SelColor = rgb(255,255,0) .selAlignment = 2 endwith James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/00a401cb0e20$aaa8c280$fffa47...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] C# vs VB
I wonder of you can mix and match the languages, use VB for some pages, and C# for others, or is that a stupid idea... James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of kamcgin...@gmail.com Sent: Wednesday, June 16, 2010 3:00 PM To: ProFox Email List Subject: Re: [NF] C# vs VB I like classis ASP which is something like asp.net and both are something like VB. I think it is easy to read and pick up. If someone ask me to create some web pages in C#, perl or any of those cryptic things I would pass. I do have a couple of pages that use perl, but I would use it as an excuse to pickup python if I had to do any major work on it. - Original Message - From: "James E Harvey" To: "'ProFox Email List'" Sent: Wednesday, June 16, 2010 1:16 PM Subject: RE: [NF] C# vs VB Are you aware of any speed issues, does one perform better than the other on the web? James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Jarvis, Matthew Sent: Wednesday, June 16, 2010 2:04 PM To: profox@leafe.com Subject: RE: [NF] C# vs VB > -Original Message- > From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] > On Behalf Of James E Harvey > Sent: Wednesday, June 16, 2010 12:45 PM > To: profoxt...@leafe.com > Subject: [NF] C# vs VB > > This sounds like an important decision, does anyone have any opinions on > which is "better", VB or C#? > Trying to read C-related code always gives me a headache the syntax requirements IIRC are rather extreme VB has at least looked a lot more like VFP code and is a bit more intuative to grasp Thanks, Matthew Jarvis || Business Systems Analyst IT Department McKenzie-Willamette Medical Center 1460 G Street, Springfield, OR 97477 || Ph: 541-744-6092 || Fax: 541-744-6145 -- Disclaimer: This electronic message may contain information that is Proprietary, Confidential, or legally privileged or protected. It is intended only for the use of the individual(s) and entity named in the message. If you are not an intended recipient of this message, please notify the sender immediately and delete the material from your computer. Do not deliver, distribute or copy this message and do not disclose its contents or take any action in reliance on the information it contains. [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/009601cb0d96$acde81f0$069b85...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] C# vs VB
Are you aware of any speed issues, does one perform better than the other on the web? James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Jarvis, Matthew Sent: Wednesday, June 16, 2010 2:04 PM To: profox@leafe.com Subject: RE: [NF] C# vs VB > -Original Message- > From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] > On Behalf Of James E Harvey > Sent: Wednesday, June 16, 2010 12:45 PM > To: profoxt...@leafe.com > Subject: [NF] C# vs VB > > This sounds like an important decision, does anyone have any opinions on > which is "better", VB or C#? > Trying to read C-related code always gives me a headache the syntax requirements IIRC are rather extreme VB has at least looked a lot more like VFP code and is a bit more intuative to grasp Thanks, Matthew Jarvis || Business Systems Analyst IT Department McKenzie-Willamette Medical Center 1460 G Street, Springfield, OR 97477 || Ph: 541-744-6092 || Fax: 541-744-6145 -- Disclaimer: This electronic message may contain information that is Proprietary, Confidential, or legally privileged or protected. It is intended only for the use of the individual(s) and entity named in the message. If you are not an intended recipient of this message, please notify the sender immediately and delete the material from your computer. Do not deliver, distribute or copy this message and do not disclose its contents or take any action in reliance on the information it contains. [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/005501cb0d90$cea7b460$6bf71d...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] C# vs VB
I've been asked by our web site consultants which language we'd like them to use to program our new web site, VB or C#. They will be using VS 2008 to create the site, and MS SQLExpress for the data part. I have no experience with this, but may want to become involved in the future developing new pages. This sounds like an important decision, does anyone have any opinions on which is "better", VB or C#? James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/003c01cb0d8c$78ce9c60$6a6bd5...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] Creating a newsletter
We use Constant Contact. James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Thursday, May 13, 2010 3:01 PM To: ProFox Email List Subject: [NF] Creating a newsletter MB Software Solutions, LLC wrote: > Some of you may get the TechSmith newsletter. How do they create it? > I'd like to create a newsletter for my users. > Sorry...should be [NF]. [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/007d01caf360$1b959bc0$52c0d3...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] Document Management Software
We're looking into installing "Docuware", a document management software package. Has anyone had any experience with this software, or any other document management type applications? James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/00d501caf106$ed5d1a40$c8174e...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] web site's browser compatibility
Interesting web site, thanks. James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Virgil Bierschwale Sent: Tuesday, April 06, 2010 8:03 PM To: ProFox Email List Subject: Re: [NF] web site's browser compatibility seems like w3schools.com has info on that.. On 4/6/2010 7:52 PM, James E Harvey wrote: > Well, it's not that we want to run them off, or don't appreciate their > business, on the contrary, we just don't know how to go about creating a web > site that will work for all browsers. > > James E Harvey > Hanover Shoe Farms, Inc. > M.I.S./Corresponding Officer > Off: 717-637-8931 > fax: 717-637-6766 > email: jhar...@hanoverpa.com > > > -Original Message- > From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf > Of Ken Kixmoeller f/h > Sent: Tuesday, April 06, 2010 4:38 PM > To: ProFox Email List > Subject: Re: [NF] web site's browser compatibility > > James E Harvey wrote: > >> We don't support Safari, and the only "feedback" I've ever received was >> > from > >> a web master in Canada. >> >> It seems obvious that our business doesn't attract people using that >> browser, so why should we worry, or are we losing customers? >> > "Yeah, screw those folks that don't use *my* browser! Who needs 'em > anyway? Apple types are all fanatical idiots anyway, so we don't want > *their* money." > > Boy, that's my kind of company! > > Ken > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/018f01cad64e$0b0bb430$21231c...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] web site's browser compatibility
Well, it's not that we want to run them off, or don't appreciate their business, on the contrary, we just don't know how to go about creating a web site that will work for all browsers. James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Ken Kixmoeller f/h Sent: Tuesday, April 06, 2010 4:38 PM To: ProFox Email List Subject: Re: [NF] web site's browser compatibility James E Harvey wrote: > We don't support Safari, and the only "feedback" I've ever received was from > a web master in Canada. > > It seems obvious that our business doesn't attract people using that > browser, so why should we worry, or are we losing customers? "Yeah, screw those folks that don't use *my* browser! Who needs 'em anyway? Apple types are all fanatical idiots anyway, so we don't want *their* money." Boy, that's my kind of company! Ken [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/011f01cad5ec$ebc0$cccdc3...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] web site's browser compatibility
I'm afraid to state that we're still using FrontPage 2003 as our editor. I know it's truly embarrassing. We are looking at Dreamweaver, but I think we need to move our web site first, from Comcast to maybe Godaddy. Comcast is our ISP and hosts our web site, but the site is now actually on Hostway's servers although they won't give us support. It's all a big mess! James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche Sent: Tuesday, April 06, 2010 12:03 PM To: profox@leafe.com Subject: Re: [NF] web site's browser compatibility On Tue, Apr 6, 2010 at 1:07 PM, James E Harvey wrote: > We don't support Safari, and the only "feedback" I've ever received was from > a web master in Canada. That sentence ought to sound as weird as "our parking lot only supports Fords. We don't support customers using Chevy in our lots." What kind of "Support" do you expect you need? If you write legitimate HTML, it should be viewable in all browsers. And you can test browser support even if you don't have those browsers. > It seems obvious that our business doesn't attract people using that > browser, so why should we worry, or are we losing customers? How is it obvious? Do you collect stats on your site? How do you know what percent of your users are using which browser? I had a client who insisted that his site didn't need to be tested in Safari because none of his customers had Macs. I showed him how his site was _unusuable_ in Safari, and explained that's why he didn't have any Mac-using clients. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/00ac01cad5b7$c65cc360$53164a...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] web site's browser compatibility
We don't support Safari, and the only "feedback" I've ever received was from a web master in Canada. It seems obvious that our business doesn't attract people using that browser, so why should we worry, or are we losing customers? James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Alan Bourke Sent: Tuesday, April 06, 2010 9:44 AM To: profox@leafe.com Subject: RE: [NF] web site's browser compatibility On Mon, 05 Apr 2010 13:08 -0500, "Jarvis, Matthew" wrote: > No matter how many versions of browsers you try and account for, there's > *some* bozo out there still running Netscape 1.1 or something... Yep - and I say screw them, you have to draw the line somewhere and for me it would now be IE7 (in the IE world) -- Alan Bourke alanpbourke (at) fastmail (dot) fm [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/009d01cad5ab$9613bbc0$c23b33...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] web site's browser compatibility
Has anyone seen a standard recommendation on how many browsers and how far back a web site should allow for? Is something like this normal? IE 8 IE 7 (?) IE 6 (?) FireFox Chrome Safari Opera Do you feel that you're not professional if your web site doesn't support Safari or Opera? James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/032b01cad4f0$e4442070$accc61...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: listbox behavior
I removed the most interior container, same bad behavior, removed the next container put both listboxes directly on the form, and all works fine now. Can't figure it out but at least in this circumstance the listbox does not operate as expected if it is contained, and laying them directly on the form cured the issue... James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Jack Skelley Sent: Wednesday, March 24, 2010 12:19 PM To: profox@leafe.com Subject: RE: listbox behavior James: I can't recall the exact instance but I do remember having an issue with an object inside of a container. I can't remember if it was a listbox or a grid. But when I removed the container all behaved as expected. And it did have something to do with a click event. Try removing one of the containers... Regards, Jack From: profoxtech-boun...@leafe.com [profoxtech-boun...@leafe.com] On Behalf Of James E Harvey [jhar...@hanoverpa.com] Sent: Wednesday, March 24, 2010 12:39 PM To: profoxt...@leafe.com Subject: RE: listbox behavior No, it does not return. James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Jack Skelley Sent: Wednesday, March 24, 2010 10:25 AM To: profox@leafe.com Subject: RE: listbox behavior James: If you right click in the listbox does the left mouse return? Regards, Jack Skelley From: profoxtech-boun...@leafe.com [profoxtech-boun...@leafe.com] On Behalf Of James E Harvey [jhar...@hanoverpa.com] Sent: Wednesday, March 24, 2010 12:19 PM To: profoxt...@leafe.com Subject: listbox behavior I have two listboxes in a container, in another container, on a form. There is a bindevent that fires when the user clicks the value in the first listbox that moves the value to a second listbox. The values in the second listbox are used in a where statement in a cursor that feeds a report. All works fine the first run through. After the report runs the method brings the users back to the first listbox, BUT the mouse click no longer works. The user can use the up-down arrows to move through the listbox, and that will cause the value to move, but no amount of clicking with the mouse will work. The values in the first list box are created with an SQL statement when the form is loaded "select day from stnhorse group by day into cursor sys(2015) noconsole" Any ideas what I'm missing... James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/01ab01cacb8f$ebbacc10$c33064...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: listbox behavior
No, it does not return. James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Jack Skelley Sent: Wednesday, March 24, 2010 10:25 AM To: profox@leafe.com Subject: RE: listbox behavior James: If you right click in the listbox does the left mouse return? Regards, Jack Skelley From: profoxtech-boun...@leafe.com [profoxtech-boun...@leafe.com] On Behalf Of James E Harvey [jhar...@hanoverpa.com] Sent: Wednesday, March 24, 2010 12:19 PM To: profoxt...@leafe.com Subject: listbox behavior I have two listboxes in a container, in another container, on a form. There is a bindevent that fires when the user clicks the value in the first listbox that moves the value to a second listbox. The values in the second listbox are used in a where statement in a cursor that feeds a report. All works fine the first run through. After the report runs the method brings the users back to the first listbox, BUT the mouse click no longer works. The user can use the up-down arrows to move through the listbox, and that will cause the value to move, but no amount of clicking with the mouse will work. The values in the first list box are created with an SQL statement when the form is loaded "select day from stnhorse group by day into cursor sys(2015) noconsole" Any ideas what I'm missing... James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/017501cacb70$9400b350$bc0219...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
listbox behavior
I have two listboxes in a container, in another container, on a form. There is a bindevent that fires when the user clicks the value in the first listbox that moves the value to a second listbox. The values in the second listbox are used in a where statement in a cursor that feeds a report. All works fine the first run through. After the report runs the method brings the users back to the first listbox, BUT the mouse click no longer works. The user can use the up-down arrows to move through the listbox, and that will cause the value to move, but no amount of clicking with the mouse will work. The values in the first list box are created with an SQL statement when the form is loaded "select day from stnhorse group by day into cursor sys(2015) noconsole" Any ideas what I'm missing... James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/014801cacb6d$bb809380$3281ba...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Cannot find the menu-generation program (Error 1693)
We grow "horses" James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Pete Theisen Sent: Monday, March 22, 2010 2:54 PM To: ProFox Email List Subject: Re: Cannot find the menu-generation program (Error 1693) James E Harvey wrote: > James E Harvey > Hanover Shoe Farms, Inc. Hi James, Hanover Shoe Farms, Inc. I find myself wondering what sort of plant grows shoes, Tree, Bush, Vine? -- Regards, Pete http://pete-theisen.com/ http://elect-pete-theisen.com/ [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/002d01caca01$fe9e84a0$fbdb8d...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Cannot find the menu-generation program (Error 1693)
Thanks Tracy, I forgot to reset the path in the Options, File Locations for the menu builder. I guess I did not already rebuild the exe as I thought... Now I'm wondering what else I'm missing, it's been so long since I had to set up a new computer half the stuff has evaporated from my brain. James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Tracy Pearson Sent: Monday, March 22, 2010 2:09 PM To: profox@leafe.com Subject: RE: Cannot find the menu-generation program (Error 1693) Is that where the _GENMENU variable points to? -Original Message----- From: James E Harvey Sent: Monday, March 22, 2010 4:05 PM Tried to rebuild my exe and got this message. "Cannot find the menu-generation program (Error 1693)" Running Win 7 64 OS, and have used rebuild several times previous with no problems. The genmenu.prg is in the c:\program files (x86)\Microsoft Visual FoxPro 9\ folder? [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/002a01cac9ff$686fa0b0$394ee2...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Cannot find the menu-generation program (Error 1693)
Tried to rebuild my exe and got this message. "Cannot find the menu-generation program (Error 1693)" Running Win 7 64 OS, and have used rebuild several times previous with no problems. The genmenu.prg is in the c:\program files (x86)\Microsoft Visual FoxPro 9\ folder? James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/01cac9fa$fd1550c0$f73ff2...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] network traffic problem
I called Comcast, again... Now they say our problem is due to an old "rate" code held over from when we were a Blazenet customer. The Tech person updated our code, and low and behold increased our speed from 5 MB down and 1 MB up, to 22 MB down and 5 MB up, plus they lowered our monthly charge from $169.00 to $99.95, and he said if the SMC cable modem freezes again to call and they would send out a newer, bigger, and more capable modem (Docsis 3.0)! Thanks to all for your suggestions and advice. James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/00b601cabbd9$76bbb1b0$643315...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] network traffic software (free preferable)
They (Comcast tech support) suggested I purchase a "router" to install between their SMC and our switch as they believed that all of a sudden the SMC could no longer handle the routing requirements, and it was their opinion we need a separate device to handle that job. Based on their assumption I purchased a Linksys Cable/DSL/Router Model No. BEFSR41. Do you think this device will suffice? In the meantime we think we have narrowed the problem down to one user's computer. With it connected the SMC runs out of memory in about 20 - 30 minutes, without it connected the SMC has been good for about an hour so far, and that is the results of two tests... James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of kamcgin...@gmail.com Sent: Wednesday, March 03, 2010 11:22 AM To: ProFox Email List Subject: Re: [NF] network traffic software (free preferable) I can't pass up this opportunity to throw a jab at comcast. Once I thought that PacBell was the worst communication company but Comcast proved they were the winner of that title. I was on the SF peninsula at that time. Back to your note, I am not sure if this will be of any value, but because of so much trouble like you describe, we now have the ISP set their device to 'bridge' mode. That way it won't cause any trouble. Then we connect something like a SMC 7004 broadband router which is very easy to program and allows you to turn the ping response on and off, block ports, DHCP, etc. You have control. At any time you can check the status of the SMC 7004 and see if you have an internet connection and see a log of who connected when, illegal connection tries, etc. ----- Original Message - From: "James E Harvey" To: "'ProFox Email List'" Sent: Tuesday, March 02, 2010 2:29 PM Subject: [NF] network traffic software (free preferable) Our network recently started to experience problems with speed over the internet. The COMCAST SMC device would also be inaccessible due to an error message stating "Access error: data follows, can't get memory". We re-boot the SMC and access speeds are back to normal and the SMC is accessible. After a period of time (30 min to 1 1/2 hr) we're back to the bad behavior. Comcast stated that the SMC was "not locking properly". They then used ping somehow to determine the speed was poor, had us pull the network cable and announced that the ping was now fine, so according to them the problem is on our end. My question is, is there any free software that will "find" which device is going bad and sending out bad packets, if that is the problem? James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/00c701cabaef$679c0a30$36d41e...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] network traffic software (free preferable)
Our network recently started to experience problems with speed over the internet. The COMCAST SMC device would also be inaccessible due to an error message stating "Access error: data follows, can't get memory". We re-boot the SMC and access speeds are back to normal and the SMC is accessible. After a period of time (30 min to 1 1/2 hr) we're back to the bad behavior. Comcast stated that the SMC was "not locking properly". They then used ping somehow to determine the speed was poor, had us pull the network cable and announced that the ping was now fine, so according to them the problem is on our end. My question is, is there any free software that will "find" which device is going bad and sending out bad packets, if that is the problem? James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: jhar...@hanoverpa.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/000401caba57$c81f0e40$585d2a...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.