Re: XFRX and Windows Vista
What happens if they turn UAC off and then run it? On 25/02/2010 18:23, MB Software Solutions, LLC wrote: We've got a client who uses our VFP9SP1 app and when our app's code to use XFRX to create a PDF fires, Windows Vista cries foul and terminates our app. We may be one version back from current on XFRX. Going to check that this afternoon. Anyone else encounter this? -- Cheers Brian Abbott ___ 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/4b86c8f3.2010...@abbott.plus.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: VFP9SP2 app copied onto Windows 7 64-bit machine
Mike Does the prog try to write any files when it starts up? WIn7/Vista won't normally allow writing to any subfolder of Program Files. We explicitly tell customers not to install under Program Files. On 04/02/2010 13:05, MB Software Solutions, LLC wrote: Client has copied my app from his old WinXP box onto his Win7 64-bit box and can't get it to run. I put the runtimes in the app folder, so he's been able in the past to just copy the folder onto other (WinXP) machines are run it. On this machine, it's now running from c:\program files (x86)\mb software solutions folder. Should he not used that folder? I thought that x86 folder was the place for 32-bit apps. Please advise...tia! -- Cheers Brian Abbott ___ 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/4b6acee7.6020...@abbott.plus.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: Sequence Control # Problem!
Kurt
Your code:
DO WHILE .NOT. RLOCK()
XL = INKEY(1)
ENDDO
GOTO RECNO()
Not sure why that last line GOTO RECNO() is there? Would it not break
the record lock you've established?
On 03/02/2010 14:54, Kurt Wendt wrote:
Hey folks,
One of the users of our system has recently started having a problem (and
they recently switched from our older DOS based system to the newer VFP based
system - even though the VFP system is still DOS looking with the same color
scheme and fonts). The problem is that they got a duplicate Purchase Order #
and previously a duplicated Invoice #. This has happened like 3 or 4 times
over the past several months. They are getting so desperate and frustrated
with our system (due to other problems as well - but, this problem is a
SERIOUS one - and it makes the system look Very Unreliable) - that they are
ready to demand their money back for the upgrade from the DOS to the
Windows system - and go back to using the DOS system.
I personally looked at the Procedure that generates the Seq Control #'s - and
I didn't really see anything wrong with it - and its small and should run
fast - and doesn't seem like it Should be having this problem. But, its
happening anyway. Of course, we are even considering that it MAY be due to
hardware problems on the client end.
So - here's the deal. We have a Sequence Control file (SeqCtl.dbf) - with a
single record that contains 51 different fields. I just took a closer look at
that file - and some fields are not sequence #'s - but, other info - with
about ½ or more of the field being Sequence #'s.
In the past - another client experienced the problem. And, back then -
someone here implemented a solution of taking out 1 or a couple of the fields
and putting them into a Separate DBF file(but, it was done as a Customization
for that one client). And, this request has now been made for me to do the
same thing - for this current client - but also to our Base system. They want
me to pull out the Purchase Order, Sales Order and Invoice numbers - each to
a separate DBF file. And, that is what I am working on this morning.
But, in the meantime - I was wondering if someone could take a look at the
code below to see if there is any KNOWN VFP issue in the code that would
cause such a problem. Any help would be GREAT appreciated.
TIA,
Kurt
*-*-*-*-*-*-*-*
* [SEQCTL]
PROCEDURE SEQCTL
PARAMETER PARM
PRIVATE XVAL, XCLOSE, XALIAS
XALIAS = ALIAS()
XCLOSE = .F.
IF .NOT. USED('SEQCTL')
SELECT 0
USE (QDD+'SEQCTL')
XCLOSE = .T.
ENDIF
SELECT SEQCTL
CLEAR TYPEAHEAD
DO WHILE .NOT. RLOCK()
XL = INKEY(1)
ENDDO
GOTO RECNO()
STORE '' TO XZVAL, XVAL
DO CASE
CASE INVOICE $ PARM
XVAL = IIF(PARM100,PARM+1, 10)
XZVAL = ZSTR(XVAL,6)
IF INVOICE = NFINVOICE
REPLACE INVOICE WITH XVAL, NFINVOICE WITH XVAL
ELSE
REPLACEPARM WITH XVAL
ENDIF
CASE PONO = PARM
XVAL = IIF(PARM10,PARM+1, 1)
XZVAL = ZSTR(XVAL,5)
REPLACEPARM WITH XVAL
OTHERWISE
XVAL = IIF(PARM100,PARM+1, 10)
XZVAL = ZSTR(XVAL,6)
REPLACEPARM WITH XVAL
ENDCASE
UNLOCK
FLUSH
IF XCLOSE
USE
ENDIF
IF !EMPTY(XALIAS)
SELECTXALIAS
ENDIF
RETURN(XZVAL)
*-- END SEQCTL --
--- 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/4b69a75f.3020...@abbott.plus.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] Firefox 3.6 Memory Use
I used to suffer from this in v2.x, but have not seen the problem with v3, 3.5 and now 3.6 (mind, with v 3.5/3.6 I'm using 64-bit WIn7 with 8Gb) On 03/02/2010 06:46, Dave Crozier wrote: Gene, My experience is somewhat similar. I have still had the memory usage up and the consequent we are sorry...there was a problem message but not half as much as with 3.7. The real thing that seems to screw it up is Flash after a while it just goes mental and I wonder whether this is a flash problem as opposed to a Firefox problem, but there you go. On a slightly different tack, the new Google Chrome is much, much slicker than the older version and it certainly seems to be coming up on the rails as a browser contender now that there are addons available. Dave Crozier -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Gene Wirchenko Sent: 03 February 2010 04:38 To: ProFox Email List Subject: [NF] Firefox 3.6 Memory Use Dear Vixens and Reynards: Firefox 3.5.6 (and earlier versions) had memory issues. Over time, it would nibble memory. Task Manager showed it once as having just over 591,000K and during the subsequent termination, it got to just over 600,000K. This was on my 1GB system. Firefox 3.6 appears to be acting better, but had about 1/2 GB recently. It seems to have gone down by itself to about 1/3 GB. Does anyone know why? I am wondering if VFP is involved as it is the other program running on my system that will take all it can get. What are your experiences with Firefox 3.6? Sincerely, Gene Wirchenko [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/4b6923bd.7010...@abbott.plus.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: dbi-Tech SednaX components are NOT supported on Win7 per website
I use various dbi controls, including a Sedna one, with no problems on 64-bit Win7. My take: they were supported on Vista and so far as VFP is concerned Vista and 7 are indistinguishable. I suspect there's nothing to worry about, this is just dbi cutting costs by withdrawing official support from what, after all, was a free give-away to start with. On 31/01/2010 09:44, Allen wrote: Dam and I was going win7 sedna. Are we completely stuffed? Al -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions,LLC Sent: 31 January 2010 10:40 To: profoxt...@leafe.com Subject: dbi-Tech SednaX components are NOT supported on Win7 per website Heads up! http://www.dbi-tech.com/VisualFoxProSednaComponents.aspx * please note: the Sedna Components are not supported on Windows 7. For Windows 7 supported controls please download Studio Controls for COM Wonder why not? Also wonder what else Sedna isn't supported on Win7? [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/4b6564aa.8090...@abbott.plus.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] Sofware or templates for creating printed user manuals and PDF files with links
Doc2chm is what we use. http://dawningsoft.com/ Works well for us. On 22/01/2010 03:45, Malcolm Greene wrote: I need to produce a traditional style user manual formatted for printed output with an equivalent PDF version with table of contents and cross references converted as active links. Any recommendations on help authoring tool, Word template, and/or PDF conversion utility that will help me accomplish the above goals? Thanks, Malcolm --- 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/4b5972ea.3080...@abbott.plus.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] FireFox synchronizing bookmarks
Xmarks Ken Kixmoeller f/h wrote: Hey -- - --- I remember folks here discussing a FireFox add-on that synchronizes bookmarks among multiple computers. I can't find it in the archives (I did one technically-successful search, but other searches crash the server), and the FireFox add-ons site has about 2000 bookmark-related tools. Would you please remind me? Thanks 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/4b2a511d.7060...@abbott.plus.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: Ed's SETMEMORY code running on a VISTA laptop
MIke It's not Vista per se but the amount of RAM being over 4 GB. I've changed to using GlobalMemoryStatusEx rather than GlobalMemoryStatus: DECLARE GlobalMemoryStatusEx IN Win32API STRING @lcBuffer lcBuffer = long2str(64) + REPLICATE(CHR(0), 60) =GlobalMemoryStatusEx(@lcBuffer) lnAvailableMem = str2dlong(Substr(lcBuffer, 17,8)) ... and also putting the whole thing in a TRY CATCH. MB Software Solutions, LLC wrote: I've got a customer who's running my app that's worked fine in other non-Vista installations but for his Vista laptop it's erroring on the SYS(3050,x) lines. I'm not surprised I guess since Vista is sooo strict on any system changes. My plan now is to check the windows version using OS() and skip the SETMEMORY routine if it's Vista. Any alternative ideas to that? We went in a gave the app Full Control privileges (or so we thought). tia! --Mike -- Cheers Brian Abbott ___ 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/4b2351e1.3050...@abbott.plus.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: PictureVal and Windows 7
Grey X with SP1 Tracy Pearson wrote: Is anybody with a Windows 7 and VFP 9 able to see a picture loaded through the PictureVal property? _Screen.AddObject(oImage, Image) _Screen.oImage.PictureVal = FileToStr(GetPict(JPG)) _Screen.oImage.Visible = .T. If you get the picture, and not a grey X, what release are you running? (RTM, SP1, SP2) Thanks, Tracy [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/4b1d3f8d.6070...@abbott.plus.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: Windows 7 compatibility
Graham If it works in Vista, it'll almost certainly be OK in 7. They're 95% the same under the hood. Graham Brown wrote: Hi Has anyone seen any articles about fox 8 and fox 9 compatibility with Windows 7? I managed to avoid the issues with Vista but sounds like 7 is going to be a pain. What do you think. Regards Graham --- StripMime Report -- processed MIME parts --- multipart/mixed text/plain (text body -- kept) application/ms-tnef --- [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/4b1d5e8d.4090...@abbott.plus.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: Has anyone used this tool to integrate Quickbooks with your apps?
MB Software Solutions, LLC wrote: http://www.synergration.com/CoreObjX/default.aspx Heard about this component over the weekend to integrate your apps with QuickBooks. Has anyone heard of it or used it before? tia, I've used this: www.qodbc.com It's reliable and very straightforward, the biggest issue is installing the ODBC driver on each PC. Here's some typical code: cCommand = [Select ListId, Name from Account where Name like 'Accounts Receivable%'] nResult = SQLEXEC(nHandle, cCommand) IF nResult 1 AERROR(aErrr) ASSERT .F. MESSAGE aerrr[2] ELSE COPY TO qb_Account USE ENDIF -- Cheers Brian Abbott ___ 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/4aa78605.9030...@abbott.plus.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: Why is the Application Data folder not visible in the My Documents folder?
Gene Wirchenko wrote: I bought my programming editor (WordStar 2000) in 1988, and I Dr Who, I presume gdr -- Cheers Brian Abbott ___ 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/4a96e301.8000...@abbott.plus.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: Printing a PDF file.
Alan Bourke wrote: Not generating PDF file, mind, just printing an existing one programmatically. Is automating Acrobat Reader an option here? It appears to have been a flaky solution in the past. Or are there any freeware/open source approaches ? TIA ShellExecute works OK for me. -- Cheers Brian Abbott ___ 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/4a895dbf.8090...@abbott.plus.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] Problem with vfp and vista read only cursor
Where is the data located? And what access rights has the user? Vista is very picky about these things. Try relocating the data to a folder just off the root (ie not a subfolder of program files) and/or log on as admin and see if either makes a difference. Jerry Foote wrote: I am attempting to install a routine on a vista machine and some how vista has determined that the dbf is a read only cursor. The program is compiled in vfp 9.0 sp2.. the install is generated by setup Factory 6.0 A piece on sample code is included below. In the browse window I cannot modify the data in any way If anyone has any info I would appreciate the feedback Thanks Jerry [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/4a57614c.9050...@abbott.plus.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] Problem with vfp and vista read only cursor
Here's a start: http://my.advisor.com/articles.nsf/aid/18897 Jerry Foote wrote: The file in question now is in the start up folder. Where can I read about where I have to put files and give permissions for some one other than a admin to run program? Thanks Jerry -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Brian Abbott Sent: Friday, July 10, 2009 10:42 AM To: profox@leafe.com Subject: Re: [NF] Problem with vfp and vista read only cursor Where is the data located? And what access rights has the user? Vista is very picky about these things. Try relocating the data to a folder just off the root (ie not a subfolder of program files) and/or log on as admin and see if either makes a difference. Jerry Foote wrote: I am attempting to install a routine on a vista machine and some how vista has determined that the dbf is a read only cursor. The program is compiled in vfp 9.0 sp2.. the install is generated by setup Factory 6.0 A piece on sample code is included below. In the browse window I cannot modify the data in any way If anyone has any info I would appreciate the feedback Thanks Jerry [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/4a576d69.9060...@abbott.plus.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: Tables Disappearing on Vista
Jeff What folder are the files in? Make sure you're not falling foul of Vista's virtual folders 'feature' or the fact that stuff in c:\program files might be somewhere else (c:\program data). Doug Hennig's site has some good stuff on this. Jeff Johnson wrote: I have an application that reads and writes to tables mapped to a network share. This application has been working with VFP7 for many years with this arrangement. There are several sites for this customer. They are upgrading to Vista and in two locations it is working fine. In one location tables are disappearing. Yesterday the dbc disappeared and I restored it. Today a table disappeared. Any clue what may be happening? Could Vista do this? TIA -- Cheers Brian Abbott ___ 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/4a3a752c.2050...@abbott.plus.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 ADO automation and dates.
Have you tried SET DATE AMERICAN before doing the export?
Having said that, this works OK for me:
oWorkBook = oExcel.WorkBooks.Add()
oExcel.DisplayAlerts = .F. avoid dialog boxes
oSheet = oWorkBook.Worksheets.Add()
oConn = NewObject('ADODB.Connection')
oRs = NewObject('adodb.recordset')
cPath = EVL(tcPath, SYS(5)+SYS(2003))
cConnection_String = Provider=vfpoledb.1;Data Source=+cPath
cConnection_String =cConnection_String +;Collating Sequence=general;
oConn.ConnectionString=cConnection_String
cSQL=SELECT * FROM + cSource
cConnection_String = Provider=vfpoledb.1;Data Source=+cPath+';'
oQryTable = oSheet.QueryTables.Add('OLEDB;' +
cConnection_String,oSheet.Range('A1'),cSQL)
*** This next can barf if too many records or similar, so cater for that.
lError = .F.
TRY
oQryTable.REFRESH(.F.)
CATCH TO oErr
lError = .T.
ENDTRY
Alan Bourke wrote:
I'm automating Excel with VFP9, using ADO to populate rows in a
spreadsheet,as detailed here:
http://fox.wikis.com/wc.dll?Wiki~ExcelAutomation~VFP
Which all fine apart from the usual - bloody dates, or more specifically
datetimes. I'm running a SELECT on a VFP table similar to this:
VFP2Excel(_samples+'data\testdata.dbc','select * from
employee',.ActiveSheet.Range('A10'))
One of the VFP fields is DateTime, but it was going into Excel in US
format, i.e. month first. Nothing I could do with cell formats, custom
or otherwise, would change it. I can't see anything in the ADO
documentation about regionalisation.
So I gave up and decided to put the date part in one column and the time
in another. But this *still* puts the date in with the wrong format.
Has anyone who doesn't work with US-format dates ever done this ?
--
Cheers
Brian Abbott
___
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/4a1fda08.50...@abbott.plus.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 ADO automation and dates.
Alan Bourke wrote: On Fri, 29 May 2009 13:50 +0100, Brian Abbott br...@abbott.plus.com wrote: Have you tried SET DATE AMERICAN before doing the export? They *are* going in as American Brian, however I don't want them to since I'm not in America! Ah, I thought you were getting the dates altered as part of the process, if it's just the locale setting in Excel can't that be specified by automation? -- Cheers Brian Abbott ___ 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/4a1feb0e.1080...@abbott.plus.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] Visual studio 2010
Just out of interest Allen, why are you going the VS route rather than, say, Python/Dabo ? Allen wrote: Thanks Steve and Geoff for your answers. The reason I was asking was that I planned to get Visual Studio. At the moment I have express and its enough to play and learn with. I was looking at getting the pro upgrade which It says you can use if you have a registered express. But I didn't want to pay out for the upgrade if 2010 was likely to appear in the next 5-6 months. Being that express seems to do all I need it to it would be a waste of money. Allen -- Cheers Brian Abbott ___ 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/4952a8f4.1050...@abbott.plus.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] Editor for MP3 Properties
http://www.mp3tag.de/en/ Charles Hart Enzer, M.D., FAACAP wrote: I have some MP3 files that I want to burn. I want to edit the properties -- title, artist, and such like. What tool(s) do you suggest? Thank you. -- Charles -- Mailto:charles.en...@uc.edu Website: http://homepages.uc.edu/~enzerchhttp://homepages.uc.edu/http://homepages.uc.edu/~enzerch~enzerch [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/494409ee.3080...@abbott.plus.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 index corruption
Hi Jean Just to reinforce what Dave Crozier has said, we have quite a few customers with 30+ users and tables 1Gb+. Our experience over the last several years has been that the key to stability is the network infratructure. If the hardware/network is good, monthly reindexing is sufficient and data/index corruption NEVER happens. OTOH a faulty network card, old/tired server, environmental interference (eg electrical transients), etc can lead to the sort of intermittent problems you have experienced. Of course, in that situation the only way to resolve it is change the suspect stuff bit by bit and each time leave it a few days/weeks to see if that has cured the problem - which is not ideal ... Jean Haidar wrote: We have problems with one of VFP TABLE , it give an intermittent error message like this Index file \\lrd1fil2\vfpprod\mw\mwdata\profile.cdx is corrupted. Please rebuild it. we are rebuilding the PROIFLE.DBF often ; sometimes every 2 days by using these commands: for example: USE R:\MWDATA\PROFILE in 0 select profile copy to c:\data\PROFILE.dbf USE C:\DATA\PROFILE IN 0 EXCL here we rebuild the indexes like this: INDEX ON CASE_ID TAG CASE_ID INDEX ON CUST_ID TAG CUST_ID etc.. PROIFLE has about 29 index tags and profile.dbf is about 1.1 gig in size we are able to add and update records most of the time but sometime we are getting the error message above from different processes: 1) A batch process trying to update the DBF with an update statement like this: UPDATE case_id = lcCurRecord..case_id Error get generated like 7 times between mid November to first December 2) A Error generated like 4 times between mid November to first December (lcUpdateTable) ;SET lcUpdate WHERE ;form Querying the table ( Select statement include Profile and other table) Any ideas? Thanks, Jean [EMAIL PROTECTED] -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: Convert DBF to MDB
In the downloads there is some stuff that will do what you want. Jack Skelley wrote: Alan: Thanks for the reply... Actually, I don't want to use Access at all. I have a list of contacts out of Outlook that I want to import into VFP from a CSV to create a DBF (or if I can read the Outlook file directly that would be even better). I want to add some records to it while in a VFP app and export the DBF to a MDB so our Avaya phone system's phonebook can use it. The Avaya system uses a MDB file for its contact manager. I guess I was very vague in the original question. Thanks! Regards, Jack Skelley From: [EMAIL PROTECTED] [EMAIL PROTECTED] On Behalf Of Alan Bourke [EMAIL PROTECTED] Sent: Tuesday, December 09, 2008 12:06 PM To: [EMAIL PROTECTED] Subject: Re: VFP: Convert DBF to MDB Jack Do you mean an individual DBF or a whole database in VFP? If it's just a DBF then Access has import wizards that can bring it in. -- Alan Bourke [EMAIL PROTECTED] [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/[EMAIL PROTECTED] ** 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: VFP9 versions
You can run sp1 and sp2 concurrently on the same PC provided you put the correct support files in the relevant home directory. It is still the case that SP1 support files and SP2 runtimes (or vice versa) can cause C5 and similar errors. Andrew Stirling wrote: Al Yes you can Rick has written a whitepaper on it. http://rickschummer.com/blog/2008/03/vfp-9-rtmsp1sp2-one-machine.html Andrew Stirling 01250 874580 http://www.calcpay.co.uk HMRC Accredited UK payroll program Al wrote: Hi foxgang. I think I know the answer but just in case I'm wrong. I was planning on putting SP2 on for a new project but don't really want to issue new runtimes if I can help it for old projects. If I put SP2 on my main work machine but still update programs where users run SP1 will I have problems. Al [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/[EMAIL PROTECTED] ** 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: VFP9 versions
Yes, in a word. SP1 support files and SP2 runtimes (or vice versa) can cause C5 and similar errors. Al wrote: Hi foxgang. I think I know the answer but just in case I'm wrong. I was planning on putting SP2 on for a new project but don't really want to issue new runtimes if I can help it for old projects. If I put SP2 on my main work machine but still update programs where users run SP1 will I have problems. Al [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/[EMAIL PROTECTED] ** 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] Thunderbird 2.0 no longer has Body as option in filtering
MB Software Solutions General Account wrote: Brian Abbott wrote: It's there on TB3 ... ??? There is no TB3?!?!?? It's only on version 2?!?!?!?!? http://www.mozilla.com/en-US/thunderbird/ Sorry, blond moment ;-) Yes, it's there on my TB2 -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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 9 is starting off screen
Garry Bettle wrote: Howdy, Hope this email finds you all well. When I start VFP - 9.0 SP1 - it starts minimized. If I right-click and select, Restore nothing happens. I have to select, Maximize to get VFP to show. Move or Size don't work either. Is there a command to recover the screen? Vape your foxuser file -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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] Thunderbird 2.0 no longer has Body as option in filtering
It's there on TB3 ... MB Software Solutions General Account wrote: I *know* a past version of TB used to have filtering possible with the Body tag. I used to search for select crap within the body and if found, I'd delete the email. I still get tons of crap email so I went to add a filter last night and noticed that Body was no longer an option. ?!!?!?!? Is there anyone who uses TB 2.0 that can confirm this for me? Thanks. -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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] Netbooks - growing market sector
Ted Roche wrote: Wired blog: Tiny Notes Net Big Gains: The Netbook Revolution You may not know it yet, but the next computer you buy is going to be a netbook. The numbers say so. http://blog.wired.com/gadgets/2008/09/netbooks-evolvi.html Anyone planning on deploying their VFP apps on it? How about their web apps? I've seen a couple of these at LUG meetings and folks are raving about them. I've been playing around with putting apps that are currently on PDAs on to these things, in two different contexts: - we have a PDA app (written in c#) that is used by service engineers travelling to different customer sites and talks to a (vfp) web service. Whilst normal laptops could be used they're (relatively) delicate, cumbersome and have poor battery life. Now things like the eee make moving up from a PDA a whole lot more sensible - at home I've been experimenting with PDAs to remote control this (via its web interface): http://www.slimdevices.com/pi_squeezebox.html ... but haven't been too happy with it. Now an eee with Linux on should make a good cheap controller - when it arrives ;-) -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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 Debugger - Breakpoint problem
Allen wrote: On the debug subject. I find it often that even though I set a breakpoint it does not break. I have to set step on in the program to make the debug work. And ther debug is open and opens when I set the breakpoint. VFP9 btw. Anyone else had this very annoying feature ? Al I've had this and am in the habit now of setting the breakpoint to the first empty line previous to the one I want. That seems to cure it for me. -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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] Reclaim 1 gig of Vista space
Useful, thanks. Stephen Russell wrote: http://techie-buzz.com/tips-and-tricks/free-disk-space-by-making-windows-vista-service-pack-1-permanent.html or http://tinyurl.com/6zo9r6 I put about 3 hours into Vista yesterday and was pretty pleased with the performance of the machine. Today I will get all of my M$ dev software loaded. Yesterday I just did the FireFox, TBird, AV installs and removing the crap of a base install software. -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: Creating a ZIP file from within VFP
John J. Mihaljevic wrote: Hi all, Is there a way to create a ZIP file from within a VFP app? If so, how can it be done? Preferably without having to pay for any utilities. Thanks much! John http://www.sweetpotatosoftware.com Look for vfpcompression And it's free -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: VFP9 - Error 1104
Kent Belan wrote: Hello, I am getting an error 1104 - Error reading file at one client site. It appears the workstation has lost the connection to the server. If they exit the program and restart everything is back to normal. The error happens on a SEEK command. How can I trap for this error ? You can't - not reliably anyway. The only permanent cure is a reliable network (not what you want to hear I'm sure!) -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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] Windows Mojave
Alan Bourke wrote: http://arstechnica.com/journals/microsoft.ars/2008/07/24/microsoft-lies-to-xp-users-and-they-start-to-love-vista?bub I'm totally in agreement that a fair percentage of Vista-haters only hate it because they read on a load of forums and blogs that they should hate it. I don't _hate_ it (I use it), but a) it needs a well specified PC to perform well and b) whilst there are a few advantages (mainly networking related) they're not massive and are somewhat offset by the disadvantages (eg slow file copying) and c) if you're using it for work - as opposed to home - the eye candy is just distracting So overall a resounding 6 out of 10 from me ... -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: Is there an official repository for documented glitches in VFP
Joe Yoder wrote: example to be clear. I guess I got Advice for a greenhorn but I'd still like to know - Is there an official place for bug demo code? You can post on http://fox.wikis.com if you're _sure_it's a bug (just do a search there on buglist). It's a waste of time posting anything with MS - there won't be any more bugfixes. -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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] Yearly maintenance fees/support versus maintenance billing by the hour
MB Software Solutions General Account wrote: A client has been using FabMate Lite for 5 years without any further expense than the initial software. It's been courtesy hours in the past 5 years, and probably not even 10 hours per year. He calls me on Saturday and says they can't get into the program now. I'm virtually certain it's not my problem, as nothing has changed in years. However, I told him that I can't offer him free support any more. I'm now giving away the FabMate Lite software for FREE and only charging for an annual maintenance/support contract should they choose to be supported. (If it works for them as is, then by all means that's fine too and free for them.) So I basically told this client (who really hasn't paid anything to MBSS since Fall 2003 other than a few hundred for something the db guy did to screw up some files) that he'd need to buy a support contract. He doesn't want to, and just wants to pay the hourly support rate. How would you respond to this guy? I'd really like to get those yearly support contracts (for approx. $1200/year), but this guy doesn't want to spend anything, and while I understand his point (...that he'd rather pay $150/hr for 7 hours per year than $1200/year as he's still ahead then in numbers), I want to make a smart business decision here to help drive revenue for FabMate Lite support (which is the only revenue stream for that product now). Your advice appreciated! tia, --Michael I find it useful to make the point that on a support contract they're guaranteed a response, as per the SLA, to any support request. Anyone not on support has to take third place to a) supported customers b) what else you want to do with your life on a Saturday. -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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] Yearly maintenance fees/support versus maintenance billingby the hour
Dave Crozier wrote: Brian, I'm afraid Michael is of the same ilk as most good developers (I include you as well!) in that they will drop most things to help out a client in distress regardless of the personal disruption it causes to them personally. It's part of the baggage of being a good developer I'm afraid. So, in summary, your solution about Saturday is easy to say in practice, but difficult to implement if the call for help ever arises. So, you're saying that 'good developer' = 'crap at business' ? gdr More seriously, the end customer probably assumes you behave like they do (ie commercially tough-minded). So, in a negotiation like this it's a useful point to make. -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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] Need recommendation for web site code to allow clients to upload data
KAM wrote: We sometimes need to get a copy of client data to research something. For some reason it seems that more people are not able to attach a file to an email. What we would like is a button on one of our web site pages so they could press the button, then browse to the file to upload and we would get the file. We use Apache2 on Windows for our web site. (specifically, the apache2triad setup) Anyone have a recommendation? senduit.com -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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] List working?
Jim Harvey wrote: Something must be wrong, no one is replying to either of our inquiries. I'm getting both your and Casey's messages - but these are all I've seen today. Probably everyone's just busy at themoment ... -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: VFP9 and _genxtab
Sytze de Boer wrote: I have discovered _genxtab I have included a new module in my app that includes the line of code do (_genxtab) with 'CROSSTAB' All is well, but when I compile my app and run it from the EXE file, I get file does not exist immediatelt after it runs this line of code. Any assistance would be greatly appreciated (_genxtab) normally refers to the program vfpxtab.prg - is this in your project? As a side note there is at least one crosstab implementation that is a good deal faster than the original - see here: http://fox.wikis.com/wc.dll?Wiki~FastXTab -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: Extract information from Autocad drawing
I did somthing with this a few years ago. At the time you could use VBA to get at stuff. Maybe diferent now. The Autocad website should have details of their API. Graham Brown wrote: Hi all This has to be weirdest request I've had recently (programming related anyway..!) A customer has asked if I know of anyway to extract the part lists from autocad technical drawings and put them into excel spreadsheets So DRG1.DWG would create DRG1.XLS with the list of items. I guess what I'm asking if anyone knows whether there is an API or COM interface for Autocad which allows me to read the attributes (which I think is where it stores the parts). The aim is I will scan a given folder and do this for all DWG and DXF files I can find They can do it one at a time but there is 1000's Cheers Graham Brown -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: DBC Logging
Alan Bourke wrote: I need something to apply insert, delete and update triggers to a number of tables automatically, with a view to logging changes to the data. An ex-colleague was telling me about a solution for this a while back, which I believe was in the public domain, maybe off UT or similar. Does this ring any bells ? To create triggers programmatically see CREATE TRIGGER command. Once they're in place you can make them call any program you want, doesn't have to be a stored procedure. Of course it'll barf if the called program isn't there but then that's no bad thing ... -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: DBC Logging
Alan Bourke wrote: Thanks - it was more a ready-rolled utility to do this and apply it to like 150 tables in one go! Something like this? OPEN DATABASE MyDBC =ADBOBJECTS(aTables, TABLE) FOR nI = 1 to ALEN(aTables) cTable = aTables[nI] CREATE TRIGGER ON cTable FOR UPDATE AS MyProg() ENDFOR -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: need scrollable form inside form
Tom Cloud wrote: My task is to create a form where the user can examine up to six options per line be able to set or reset any one of them (a checkbox). But the number of rows exceeds what can be displayed on a monitor. I am working with an existing table where the options are stored in a character field as a series of T or F example: TTTFTF. The database is a set of definitions and the switches tell where those definitions will be used. There are 78 definitions by default and more can be added by the user. I've seen as many as 130. I put this in a grid, but the switches in the single character field make it a PITA -- I'd like to have a checkbox for each option in the character field and I don't know how to do that with the grid. At this time, only six switches are used, so I'm looking for a scrollable form that will have a header and between 78 to maybe 150 lines with a label (the definition) and six checkboxes per line. I will appreciate any suggestion you can offer. thanks, Tom Assuming you can't change the table structure, I'd use a grid and have the datasource a readwrite cursor with logical fields and checkbox controls. In the form init soemthing like this: SELECT IIF(left(mycharfield, 1)='T', .T., .F.) AS option1, ; IIF(substr(mycharfield, 2,1)='T', .T., .F.) AS option2, ; IIF(substr(mycharfield, 3,1)='T', .T., .F.) AS option3, ; ... and so on. When finished editing, save the cursor data back to the table in the reverse way. -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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] disappointed with AVG 8, looking for an alternative
David Smith wrote: I finally upgraded to the new AVG free version 8 and wow! It sucks! It would seem they have chosen to go the Norton / McAfee self-promotion and bloat route. The half dozen unasked for “features” that I can’t turn off without nag windows was bad enough, but an IE toolbar? I saw hints of this coming in version 7 but had no idea they’d abandon the efficient simplicity of their earlier products so completely. What a shame. So, it’s adios AVG free. Any suggestions for free antivirus solutions that stick to the basics without the nagging and baloney “features” would be most appreciated. Try AVAST. www.avast.com -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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] Contract not renewed.
Allen wrote: You guys need to remember there are worldwide (at least at the moment) members on this list. USA politics is not very interesting at the best of times and at the moment certainly not. It should be OT anyway ... -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: Update to Microsoft's VFP page: Fixed SP2 help file now available
Bill Anderson wrote: On Sat, Apr 26, 2008 at 4:18 AM, Malcolm Greene [EMAIL PROTECTED] wrote: I have a web service monitor MS's VFP page for updates. Here's the latest from yesterday (Apr 25 2008): http://msdn2.microsoft.com/en-us/vfoxpro/bb264582.aspx And there's a bug posted against it already... https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=340533 See also: http://rickschummer.com/blog/2008/04/vfp-9-sp2-help-fix-glitches.html Whilst the state of the help file as such doesn't bother me (for anything except the SP2 reporting extras, the SP1 help file should be OK I'd have thought), as an indicator of what else might be to come this isn't encouraging. I'm sticking to SP1 for the forseeable future... -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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} Acronyms - was Re: SP2 Fixes - Light at the end of the tunnel
Hmmm, I assumed (wrongly, obviously) that AIUI was a WKA (well known acronym). Just for interest, who does / doesn't know these: AIUI - as I understand it AKA - also known as IMO - in my opinion IOW - in other words IMHO - in my humble opinion AFAIK - as far as I know AFAIR - as far as I recall ATM - at the moment BTW - by the way FWIW - for what it's worth YMMV - your mileage may vary IIRC - if I recall correctly HTH - hope this helps LOL - laugh out loud ROFLMAO - roll on the floor laughing my ass off gdr - grin duck and run All these are ones I tend to use out of the scores out there - and I'd assumed that they were common currency. Maybe their use is dying out? Allen wrote: And for those native English speakers as well. Saves wrongful guessing. Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ricardo Araoz WIBEFAOU(STOUWANNES)TLTUOATAM ? (a.k.a. Wouldn't it be easier for all of us (specially those of us who are not native English speakers) to limit the use of acronyms to a minimum?) -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: SP2 Fixes - Light at the end of the tunnel
Eurico Chagas Filho wrote: Hi There is a fix for the report problem, I am using it. So, tell us about it g -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: SP2 Fixes - Light at the end of the tunnel
Dave Crozier wrote: Rick has blogged about a couple of fixes made for VFP SP2 Alan Griver spilled the beans today that Microsoft has some fixes for VFP 9 SP2. Alan announced the missing index items in the VFP 9 SP2 Help file are fixed and being reviewed http://rickschummer.com/blog/2008/04/mvp-summit-good-news-about-vfp.html Maybe all the major fixes to SP2 will be made...eventually! Hmmm, forgive me for being sceptical but, AIUI, YAG won't commit to what might be fixed (past the help file and the report toolbar) or to any timescales. Based on past performance I'm not holding my breath ... -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: SP2 Fixes - Light at the end of the tunnel
Paul McNett wrote: MB Software Solutions General Account wrote: Brian Abbott wrote: Hmmm, forgive me for being sceptical but, AIUI, YAG won't commit to what might be fixed (past the help file and the report toolbar) or to any timescales. Based on past performance I'm not holding my breath ... What's AIUI mean? As I Understand It? Yup -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: Chm files
Al wrote: Hi foxgang I am having problems with clients being unable to view help files (chm). I think this is an XP problem of Microsoap not even supportiung its own technology but I think there was mention of a way round it. Anyone know why and how to solve please ? Allen Has foxhhelp9.exe been installed *and* registered? (if not vfp9 substitute as appropriate in the file name) -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: Form off side of the screen VF6
Talk him through using the keyboard to move it. Alt + Space then down arrow then left-right arrow - something like that works anyway, AIR Adam Buckland wrote: Client has managed to drag a form ¾ of the way off the screen and can't get it back. Normally I'd increase the screen resolution so that it would be visible in its entirety, however this person has the screen at max resolution so I can't. Any suggestions (Polite please) on what I can do here for this munchkin? --- 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/[EMAIL PROTECTED] ** 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 6, MDAC and Vista
Rafael Copquin wrote: This colleague just purchased a new computer that comes with Vista preinstalled. He uses VFP 6 SP5. He tells me that when he is trying to install SP5, he is required to previously install MDAC 2.5 or higher. He runs MDAC_TYP.EXE, the files are decompressed and nothing else happens. When he tries to run the rest of the SP5 installation, he gets the message that he still needs to install MDAC 2.5 or higher. He tried to install more up-to-date versions of MDAC (2.7or 2.8), even running them as administrator, but with the same result. Does anybody know how to install the required MDAC version (whichever it is) so he can run his VFP 6 with the SP 5 ? Thank you in advance on my colleague's behalf Rafael Copquin Vista comes with WDAC pre-installed which is, apparently, the 'latest and greatest' version of MDAC and MS don't recommend installing MDAC over it. Maybe vfp6/sp5 doesn't recognise that it's installed? Sorry not to be of more help. -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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.
Any idea why this would fail (vfp8/sp1) ?
I have this in a form class: COPY TO OB10b.txt TYPE DELIMITED WITH WITH TAB vfp throws a syntax error with this and variations on it. However if I a) put it in a plain vanilla .prg or b) wrap it like this: cCommand = 'COPY TO OB10b.txt TYPE DELIMITED WITH WITH TAB' cCommand ... all is well. It also works fine in vfp9/sp1. I've recompiled the classlib to no avail. -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: Any idea why this would fail (vfp8/sp1) ?
Alan Bourke wrote: Brian Abbott wrote: COPY TO OB10b.txt TYPE DELIMITED WITH WITH TAB Well, that first one works for me in the command window. VFP9. Yeah, it works for me in the command window in vfp8 and 9. And all the time in 9. And in a plain .prg in 8. Just not in this classlib in 9. -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: Any idea why this would fail (vfp8/sp1) ?
Brian Abbott wrote: Alan Bourke wrote: Brian Abbott wrote: COPY TO OB10b.txt TYPE DELIMITED WITH WITH TAB Well, that first one works for me in the command window. VFP9. Yeah, it works for me in the command window in vfp8 and 9. And all the time in 9. And in a plain .prg in 8. Just not in this classlib in 9. Sorry, that last bit should be Just not in this classlib in 8. -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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 and PostgreSQL used to process FTC DoNotCall updates
Gil Hale wrote: Well, it finally happened. The source data DoNotCall files I download from the FTC monthly for clients finally pushed over the 2Gb file size limit for the Area Codes used by my clients! Luckily I saw this freight train coming about 2 or 3 years ago, and began to evaluate various SQL database solutions Hi Gil I'm interested in why you ended up with Postgres rather than MySql or Firebird. Was it an easy decision or a close call? -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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] RE: VFP and PostgreSQL used to process FTC DoNotCall updates
Gil Hale wrote: I'm interested in why you ended up with Postgres rather than MySql or Firebird. Was it an easy decision or a close call? Well, let's see. I know you did not ask why not M$ SQL Server or Oracle, so I assume you are also trying to avoid some of the things I wanted to avoid - $$$ and/or dependence on running on a M$ platform and dealing with M$ planned obsolescence (or their free SQL Server versions that have scaling limitations of their own). So you have robbed me of an opportunity to bash on M$ a bit for my purposes g. That is okay, let's get on with it... MySQL kicks ass, but it also has a dual license, and I was concerned about any potential fees either I or my clients would incur were I to deploy a MySQL database on their Server(s) for commercial use, with me not being willing to release my Source Code into the public domain. I am not sure how much the license fee is for commercial use of MySQL when the Source Code is kept private, but I think it is $400/Server annually. Most of my clients are Auto Dealers, and even something for free is too much to pay (they really do run on very tight margins). An additional $400/year would be painful to explain, especially when they have had VFP for free for so many years from me. They would not be wanting to hear all the Geek Speak re: why I had to migrate for any one of several reasons (scalability, built in security, performance over a thin net connection, hot backups, Cross-Platform capable...). Firebird looked promising, as it is totally Open Source, and has some pretty solid legacy roots. But I found the documentation was a bit light as compared to MySql and PostgreSQL (2 years ago, may 3). I do know of one company that uses Firebird, and their app has terrible performance with any kind of fairly large table sizes. Of course, that is totally due to their design, where they take all the Firebird tables from the server and pull them to the local PC to cache all records (for faster performance). This is done both at startup and any time a locally cached cursor is hit, to make certain all local records are up to date from the server! It is not Firebird that causes the large delay in lighting up and running the application. I know it is just a silly assed and poor design by the developers. But, it still left a bad taste in my mouth, however unfair that may have been. I was intrigued by the punchy performance offered by PostgreSQL, and the large amount of information available at the local bookstores. The reference material available is pretty much on par with the Big Boys. It has been around in its current and predecessor forms for a long time, and is rock solid. It is totally open source, free to use without any license fees, and Cross-Platform capable. So, I picked up a few books on PostgreSQL (I also have The First Official Firebird Book, some MySQL books, plenty of MS SQL and Oracle books from prior projects). I never looked back. I also considered the fact that Dabo is able to connect to PostgreSQL (as well as MySQL and others), so once I begin to migrate to that development environment my investment in learning PostgreSQL will not be wasted. In short, if I had to prepare to move from a VFP back end to a real RDBMS in order to get huge scalability, great performance over thin-net connections, built in security, Cross-Platform capability, Hot Backups and no license fees, I wanted to make a single move. I asked a lot of my compadres (to include ProFox members) their opinions and experiences. As good as MySQL was, it was the totally free part with PostgreSQL that won the day. Firebird just did not have enough documentation for my comfort, and I hardly know anyone who has used it. PostgreSQL just flat out feels more comfortable to me, and has no inherent deficiencies that would impact me. And, thus far it is behaving great with a VFP front end. I hope that is helpful. Good luck in your apparent impending cut-over. Gil Thanks Gil Yes, that was useful. AIUI MySQL licencing costs can be 'got round' by the customer installing it themselves, and the vfp app just happens to use it. But the licencing thing is an issue even so. OTOH MySQL seems to be much better accepted by ISPs etc ... -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: Re He who must not be named...
Kevin S. Goff wrote: Just to set the record straight on the Wiki (on http://fox.wikis.com/wc.dll?Wiki~FoxRockXArchives) I know for a fact that John Petersen (JVP) told Whil and Rainer that he didn't have a problem if they made his old content available for free. In fact, John stated directly to Whil/Rainer that he's fine if developers can benefit from what he wrote back in the 1990's. JVP simply doesn't want his content being used for a money-making enterprise. John has also stated that it's not just about him, as he feels that other authors during the period should be given the same opportunity to choose how their previous content should be handled. At the very least, what was written on the Fox Wiki is very misleading. At the most, well, with all the facts, you can draw your own conclusions. Whoever was responsible for this should be accountable and should make a public apology to JVP. Kevin Kevin Since you're clearly in close touch with JVP, you'll probably know the answer to this question? As JVP doesn't want his old content made available for for-profit purposes, but is happy for it to be made available for free, will he then be publishing them online as several other authors have done, or will he agree to a third party (eg leafe.com) making them freely available in pdf form for download? BTW have you seen this? http://spacefold.com/lisa/post/The-Foxx,-the-Voxx,-and-the-Phoenixx.aspx -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: [ADMIN] Report OT Abuse
Allen wrote: Question Several have mentioned including myself about allowing semi personal things on here. Being some like to get ideas how other's life is shaping. Its not techical but seems to be part of the foxpro community. Is this now not allowed. I understand if this is now to be OT but then I wont see it and I would like to. But I don’t want the OT normal offerings. Allen I think the whole point of what Ed is doing is that where the boundary lies will depend on the concensus among people in the list. I can't imagine that the sort of stuff you're describing would cause anyone to 'flag' you - OTOH someone who persistently introduces, say, political invective, is highly likely to get flagged. -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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] Really weird diffence between Internet Explorer and Firefox
Allen wrote: I thought a shank was a ball of wool. What's a shank, I would take a guess as a tart which was my thoughts. Allen http://www.urbandictionary.com/define.php?term=skank -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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 SPT Canvassing Opinion
Dave Crozier wrote: A general question regarding how those of you out there using SPT and Auto update cursors onto a Client Server back ends deal with record inserts into a table. As some of you may well know, I'm in the process of writing a set of data access classes for VFP to Client server back ends. OK, you may say, it has been done before but I wanted a specific architecture for a project I'm involved in so thought it would be a good idea to develop a set of classes from the floor up. My question is, when you use SPT to generate a VFP cursor which you then make updatable, how do you handle the insertion of records? I know how I do it and have always done it, but that is not the point and I simply wanted to get some feedback from others. Specifically: 1 Do you allow free access to the VFP cursor and native VFP commands like append blank and insert into... as well as the Auto insert when using grids to display the attached cursor which in effect controls the data from the front end GUI down and auto updates the back end? OR 2. Handle all the table insertions via an SPT Insert into... and then requery the back end from VFP to fill the GUI controls with the newly added blank record data. Hi Dave 2. for several years now. And 90% of the time I use grids read-only with a seperate editing area on the form which is repopulated when the gridrow changes. -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: He who must not be named...
Bill Anderson wrote: He lives! http://fox.wikis.com/wc.dll?Wiki~FoxRockXArchives Note at bottom... That's made my day! ROFLMAO -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: from VFP to Access
Rafael Copquin wrote: I need to add the following perks to one of my VFP 9 systems: the client needs some VFP tables to be added to an Access database, because he has a website that can only read Access data In the downloads you will find examples of vfp talking to Access data. -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: Final output code - where should it go?
Garry Bettle wrote: Howdy all, I have a bit of code that outputs some summary information to a XLS file. The normal way that this happens, is when a response from an API call indicates that a market is closed. What I'd like to do is shift this logic somewhat, so that if the user closes the form - click the top right X - it writes the XLS file, in addition to if the market is closed. Should I just populate the Destroy method on the form, and code the market is closed method to just call Destroy? The data going to Excel is a combination of cursor and table, so would Destory be the right method to use? Or, should I put it in the UnLoad method? Garry Put a call to the method that writes the XLS in the .QueryUnload() method - this always gets called when the top right X is clicked. -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: Final output code - where should it go?
Dave Crozier wrote: Garry, Definitely QueryUnload as this is ALLWAYS called however you unload the form. Dave Crozier Except if you issue the RELEASE command on the form in code or invoke the form's Release method. -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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] Microsoft release Office binary file formats.
Alan Bourke wrote: http://www.microsoft.com/interop/docs/OfficeBinaryFormats.mspx Could this be the tipping point for Linux on the desktop? http://www.joelonsoftware.com/items/2008/02/19.html -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: industry conference
Hi Bill Your experiences are very similar to what we have found in the UK, except that Quickbooks is hardly in the picture - Sage in its various incarnations is the must-have accounts interface ... Bill Arnold wrote: QuickBooks interface is a must -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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] Save energy in your dryer, largest energy waster in your home
Paul Hill wrote: On Fri, Feb 15, 2008 at 3:04 PM, Stephen Russell [EMAIL PROTECTED] wrote: http://www.dryermiser.com/ I think that I may take a look at this. Or you could invest in a washing line :-) ... and that way you'd save on medical bills too 'cos you'd get fitter. Oh, and the towels would be more fluffy after they'd dried. ;-) -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: industry conference
Bill Arnold wrote: Hi Brian, Your experiences are very similar to what we have found in the UK, except that Quickbooks is hardly in the picture - Sage in its various incarnations is the must-have accounts interface ... That's interesting. Well, I don't have a problem supporting more then 1 accounting system interface. What I wouldn't do is try to compete with accounting systems. Much better to interface. Does Sage have an API/SDK, like QuickBooks? Yeah, but you have to pay (like £1500 pa on up) to be a member of their dev program if you want to use it. They're a rapacious bunch, worse than MS just not anywhere near as big. -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: industry conference
Paul Hill wrote: Reminds me, I have to install Sage on our accountants PC sometime before April as we're moving over to it. Last time I used Sage it was DOS based and everything was a horrible green [1]. Did they ditch the green colour scheme? Yep. Windows now, still with green tinges but a lot different inteface (not particularly 'MS windows standard' though). -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: Table names
Al wrote: Hi foxgang. thought I would pass on an interesting thing I just got bit by. I have a table ocsusers.dbf It is open and I am adding several file in different directories with the name ocsusersap.dbf If I work on these by adding the tables for somereason they are open with the table area as a name so use in select(ocsusersap) fails becuase in this instance its open as D weird. I have checked the write ahead cache but it still does it. be warned. I think this is a VFP9 thing. I also have problems since VFP9 with making objects. I think there is a timing issue. Allen Isn't this just expected behaviour? If you open a table as the same name as one already open it allocates a single-letter alias B, C .. etc -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: Table names
Allen wrote: The objects problem is a bugger though. Allen What's the problem? -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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] Nice Virus Story
Bill Arnold wrote: Ahem ... Does this resemble the interesting forum it once was, or does it look more like the Madigan/Theisen/Russell mindless-chatter board? I rest my case. Top 20 Contributors by Number of OT Posts | Posts Contributor| 1. 159 Michael Madigan 2. 114 Pete Theisen 3. 66 Stephen Russell 4. 65 =?ISO-8859-1?Q?Ricardo_Ar=E1oz?= Bill Without wishing to be contentious I distinctly recall that, at the time Ed created ProfoxTech a few years back, you spoke out against the idea. And more or less the same participants were making the same sort of posts then ... Move to ProfoxTech - the air is so much clearer ;-) -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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] ACT! Export
Kevin Cully wrote: I have a client that is looking to (potentially) move away from ACT! Has anyone purchased a tool, or built a tool themselves, that allows for the export of ACT! data? I know that ACT! data used to be stored in Codebase data. It was DBF like structures, but not exactly equivalent to what VFP understands as a DBF. Kevin There is an SDK. It used to be free but now you have to pay for it (be a member of Sage's dev program). Depending how old your ACT! is you may find the old/free version will do the job. Overall though, $500 is probably less than the cost of your time getting to grips with the SDK ... -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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] Nice Virus Story
Allen wrote: ok I'll bite What has thunderbird got that outlook hasnt. Email wise that is Im not likely to change unless thunderbird got all the calendar goodies and worked with activesync. And didnt lock up when it checked emails like outlook does (2003). Allen I moved from Outlook to TB 2 or 3 years ago. And despite liking the look and feel of OL2007 I'm still sticking with TB. What I like: - doesn't lock up or leave several copies running hidden like OL does. - it's free - I've not yet been unable to read a data file in TB - which happened to me a couple of times with OL That's it really. I don't use/need all the calendar and activesync stuff ... -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: Sedna Released (with this the last Microsoft release ofVisualFoxPro)
Rick Rick Schummer wrote: No, this would be presenting Microsoft with a threat model. Que? YAG (hitherto a guy who has in the past kept reasonably in touch with the community) isn't talking to us any more. Assuming he isn't a total who has been b***ting lots of us over the years, it probably means he has pressure from above. He's at (I am lead to believe) middle management level. So, it's a reasonable bet that the pressure on him is from a beancounter or marketing droid. Do they, (all but the best, anyways) grok concepts such as 'long term' and 'goodwill' ? I doubt it. What they understand - viscerally - is 'fear and greed'. The only way to put pressure on them is to appeal to that. Why do you think MS is getting more open to Open Source these days? Fear. I don't disagree at all with your tactics (show the limited list of bugs, the reasons why VFP developers can't use the product ... etc) I just think they'll not be enough on their own. -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: Sedna Released (with this the last Microsoft release ofVisualFoxPro)
Rick Rick Schummer wrote: YAG is not a fear and greed kinda guy, so I can only assume when you say 'they' you mean Microsoft in general and not YAG, or any of the Fox Team for that matter. Alan definitely understands 'long Yes, I meant MS in general and specifically the people above YAG in the pecking order - sorry if that wasn't clear. Whilst I don't know any of them (the Fox team as was) personally I've no reason to doubt their motivation and that they've done their best for the Fox - but it's seems clear that they have limited or zero scope for doing anything Fox related on their own initiative now. -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: Sedna Released (with this the last Microsoft release ofVisualFoxPro)
Rick Schummer wrote: Michael, Michael, Michael, I guess I figured that although it may be huge, it's a dead language since it's death nell has been sounded by M$ saying no more beyond vfp9 and that salt-in-the-wound DBI comment for last version. :-( I guess every message these days has to have a negative spin to it. Moaning and groaning seems to be the in thing for many in the Fox Community (I just hit the UT to read what the Sedna and SP2 detractors and complainers had to whine). I am not sure what huge numbers of VFP developers in Hi Rick and PMFJI I suspect Michael is, like many others - me very much included - not looking at the glass as empty at all, but are just royally p***ed off with the way M$ has approached the whole SP2 thing. I have a major product currently on vfp8 that I'm all ready to roll out (and have promised my customers will be rolled out in Q1) with vfp9 - but which vfp9? At the moment sp2 has a couple of showstoppers (for me at least) and therefore the choice is sp1 or wait with fingers crossed to see if M$ actually do an sp2a or sp3. At the moment there are 'hints' that an sp2a _might_ be forthcoming (principally, I have to say, founded in the opinions/optimism that you and a couple of others closer than most to M$ have expressed). But why on earth can't they (M$) just tell it straight - will there be another sp and if so when? As a matter of interest, have you or anyone you know actually asked Milind Lele or YAG if/when there'll be another sp? -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: Need your advice on Web services
Vassilis Aggelakos wrote: Hi Folks, I need your advice. I have a VFP app which - if client wants - uses MS SQL Server 2005 or MS SQL Server 2005 Express or MYSQL ( recommended if it is already installed but not deployed by me aka license issues ). Now wanting to extend the program features I am considering to make my app consume some web services that are written in C#. Do you believe that it is better to make my VFP app consume (and deploy) SOAP Web services or it is better to make an external EXE in C# to consume the web services? - (and then send the returned data back to my VFP main program?) I have read many many posts with different deploying problems of SOAP. Is it true? Do you believe that it is safe to assume that my 500+ clients will install SOAP files without problems? ( mainly WinXP , several Win 2000) Keep in mind that when my client selects MS SQL Server as a database, the .NET framework is installed anyway so the external EXE doesn't add any more headaches to be deployed - You have already overcome the troubles, if you manage to install MS SQL Server! -;) Any help would be greatly appreciated. Vassilis Aggelakos Hi SOAP per se, though more complicated than MS would have you believe, works fine with vfp. The problem comes with the c# webservices. Since you mention services (plural) I assume some at least of these will be public ones over which you have no control. One of the things that .Net webservices can/do do is pass objects/complex structures back and forth. If a .Net webservice isn't doing this then you are OK with vfp. If it is, then you're stuck (at least, I don't know of anyone who has achieved it) unless you have .net at both ends. So, in your scernario, an external exe in c# looks like the best/only option. -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: Sedna Released (with this the last Microsoft release ofVisualFoxPro)
Jim Harvey wrote: Hello Brian, Would you mind advising what the main problems are with the SP2, as far as your project is concerned. The 2 main ones for me are report related: - the preview toolbar inoperative in some conditions - report data grouping bug There are others, which I (at least) could work around. See: http://fox.wikis.com/wc.dll?Wiki~VFP9SP2BugList~Wiki -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: Sedna Released (with this the last Microsoft release ofVisualFoxPro)
Hi Rick Rick Schummer wrote: As a matter of interest, have you or anyone you know actually asked Milind Lele or YAG if/when there'll be another sp? I learned a long time ago that complaining by itself does no good. The proper approach is to present the problem and potential solutions. Yes, I am unhappy with the results of SP2 too, but instead of moaning a groaning I am looking to do something about it. I think the key is to build the business case for SP3 Unless I'm missing something, the only business case I can think of (looking at it from MS' perspective) is that if they don't put out a new SP it will a) siginficantly damage their reputation in the community generally, that they've fought so hard to recover after the nadir of 10 years ago and b) following on from that, increasing numbers will go down the Open Source route rather than .Net. In line with that, complaining loudly and repeatedly to them would seem to be the best approach, no? and figure out a way Microsoft can put out a service pack that will be adopted by the Fox Community. I think the way the community feels at the moment, an SP that fixes the small handful of major bugs without introducing any more would be welcomed with open arms. Even if we (or the MVPs) had to do their testing for them, it would still be better than at present. -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: Need your advice on Web services
David Crooks wrote: On Wednesday, January 30, 2008 9:34 AM Brian Abbott wrote: I have been trying to copy a web service that is working from XP to 2003 and it fails. Any ideas? TIA! Permissions is the most likely issue I'd suspect. -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: Need your advice on Web services
David Crooks wrote: On Wednesday, January 30, 2008 10:00 AM Brian Abbott wrote: Permissions is the most likely issue I'd suspect. They usually are the issue. We did set the permissions on server. Any place else I should look? Thanks! David L. Crooks As Allen just mentioned, you need to explicitly insdtall MS SOAP 3. -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: Need your advice on Web services
Nothing else I can think of ATM. Are you using Westwind or something else? David Crooks wrote: On Wednesday, January 30, 2008 10:08 AM Brian Abbott wrote: As Allen just mentioned, you need to explicitly insdtall MS SOAP 3. Yes, the Microsoft SOAP Toolkit 3.0 is installed. David L. Crooks [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/[EMAIL PROTECTED] ** 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: What's new in 9
AAmazon.co.uk is generally cheapest Paul Newton wrote: Hi I've been able to locate two used copies at Amazon UK. Does anybody (in the UK) know if it makes sense to buy from hentzenwerke.com - bearing in mind shipping ? Or can recommend a UK source for a new hard-copy ? -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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] Dell UK Servers
We got 3x last month. Excellent machines. Disks were fine for our purposes, just needed a bit more memory. Only thing to beware of is they only have a 30 day warranty - any more you have to pay for ... Adam Buckland wrote: Looking at the US and the UK web sites they both offer the T105 viz: UK Offer (Time limited) http://configure.euro.dell.com/dellstore/config.aspx?c=ukcs=ukbsdt1kc=305l=enoc=PE1T1052s=bsdsbc=pedge_t105 £99 equates to approx $178 US Offer http://www.dell.com/content/products/productdetails.aspx/pedge_t105?c=uscs=04l=ens=bsd $384 Checking another system the SC1430 server is $685 against £379 giving a rate of $1.80 which is fair. Therefore the UK offer for the T105 is a blooming good deal if they have any left! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Madigan Sent: 28 January 2008 09:50 To: ProFox Email List Subject: Re: [NF] Dell UK Servers Being that the dollar is so weak, I wonder if you could buy a $4000.00 server here and ship it for less than £99. [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/[EMAIL PROTECTED] ** 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: Too big to fit on page ... error 1298
Does thius relate to a report? If so, check what printer they are using and page size. Chris Davis wrote: I am randomly getting this error on one machine, it does not happen on any others. Any ideas ? It's not the layout or the printer setup, well I don't think it is. As if the user re loads my application and tries again its fine. -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: Vista compatibility with VFP7 and earlier versions of VFP
Hi Ted We've been going through much the same process recently - we have a program which is a stub that copies the app file from the server so having ability to read/write to the local folder is important. We've ended up going the route that many, many people seem to have done and a) not installing under Program Files In Vista (if UAC is enabled everything down that tree is read-only after install) and b) forcing the installation folder to be read/write. Additional stuff that may be useful if you don't know it already: - to check permissions in the current folder, we use this code from Christof Lange that was posted to MSDN forums: http://tinyurl.com/246qfu - use API call IsUserAnAdmin() to check if user has admin rights - using Inno rather than IE (a no-brainer in any case IMHO!) Ted Roche wrote: On Jan 22, 2008 3:01 PM, Rick Schummer [EMAIL PROTECTED] wrote: A setup.exe will automatically raise permissions via UAC or the user will have to enter the admin password when it is executed. The bigger problem you face is the rights for the folder being set so the users can write to the tables. Hi, Rick, and thanks for the answer. It's apparent I haven't explained the problem very well. Sorry. This is a vertical niche application installed at a number of customers across the country. Clients run it on their network. This is the client's line-of-business application, running 100% of the time -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: Vista compatibility with VFP7 and earlier versions of VFP
AFAIK yes you can - and that's the strategy we're adopting for vfp9 - there's too much danger of running a SP1 app against SP2 support files (or vice versa) otherwise. Jeff Johnson wrote: I have heard two different answers on this and I am still confused. Can you place the VFP runtimes in the same folder as the application (or path) and run VFP apps without installing the runtimes? VFP 7 and VFP 9? TIA Jeff Jeff Johnson [EMAIL PROTECTED] SanDC, Inc. 623-582-0323 Fax 623-869-0675 Brian Abbott wrote: Hi Ted We've been going through much the same process recently - we have a program which is a stub that copies the app file from the server so having ability to read/write to the local folder is important. We've ended up going the route that many, many people seem to have done and a) not installing under Program Files In Vista (if UAC is enabled everything down that tree is read-only after install) and b) forcing the installation folder to be read/write. Additional stuff that may be useful if you don't know it already: - to check permissions in the current folder, we use this code from Christof Lange that was posted to MSDN forums: http://tinyurl.com/246qfu - use API call IsUserAnAdmin() to check if user has admin rights - using Inno rather than IE (a no-brainer in any case IMHO!) [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/[EMAIL PROTECTED] ** 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: Admin rights
Thanks Scott That was what I was looking for - it was on News2news as well but I somehow missed it when looking earlier ... Scott King wrote: Anyone know an API call (or other method) to tell if the current user has Windows administrator rights? Take a look at the NetUserGetLocalGroups API. This might also help: #define ADS_GROUP_TYPE_GLOBAL_GROUP 0x0002 #define ADS_GROUP_TYPE_DOMAIN_LOCAL_GROUP 0x0004 #define ADS_GROUP_TYPE_LOCAL_GROUP0x0004 #define ADS_GROUP_TYPE_UNIVERSAL_GROUP0x0008 #define ADS_GROUP_TYPE_SECURITY_ENABLED 0x8000 * ___ Function IsInRole *Determine whether user is in specified role *=== PARAMETERS cRole,cServer LOCAL oWinNTSystemInfo, cDomain, cUserName LOCAL oUser, oGroup, lResult oWinNTSystemInfo = createobject(WinNTSystemInfo) cDomain = oWinNTSystemInfo.DomainName cUserName = oWinNTSystemInfo.UserName lResult = .F. Try oUser = getobject(WinNT:// + cDomain + / + cUserName + ,user) oGroup = getobject(WinNT:// + cServer + / + cRole + ,group) If oGroup.IsMember(oUser.ADSPath) lResult = .T. Else For Each oGroup in oGroup.Members If lResult Exit Endif If UPPER(oGroup.Class) = GROUP and ; oGroup.GroupType = ADS_GROUP_TYPE_GLOBAL_GROUP lResult = IsInRole(oGroup.Name,cDomain) Endif Endfor Endif Catch to oException Messagebox(oException.Message,0+16+0,Error) Endtry Return lResult Regards, Scott [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/[EMAIL PROTECTED] ** 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.
Admin rights
Hi Anyone know an API call (or other method) to tell if the current user has Windows administrator rights? -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: Admin rights
Thanks. I've found plenty of WMI stuff, but from what I've seen the only way is to test for if the user has access rights to, say, HKLM. Or have I missed something? John Harvey wrote: Do a google search on foxpro wmi stuart dunkeld and craig boyd JH -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Abbott Sent: Friday, January 18, 2008 10:23 AM To: profox@leafe.com Subject: Admin rights Hi Anyone know an API call (or other method) to tell if the current user has Windows administrator rights? -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: OT] Dirty Atheist caught red-handed spewing his bile in
Why did you feel the need to send such peurile ssubstitute whatever you want here in the first place? Michael Madigan wrote: Why did the first bracket get removed? I checked my sent folder and it looked fine. -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: CVS and visual classes
Even without using CVS or whatever, keeping all your classes in 1 vcx is bad practice IMHO. Paul Newton wrote: Grigore Thanks for your reply but Grigore Dolghin wrote: There are two models: Lock-Modify-Unlock and Copy-Modify-Merge. Both have their strengths and weaknesses. I would suggest for you to use Lock-Modify-Unlock model, but this means only one developer makes changes at a time. To keep productivity, your classlibs should be small and containing fewer classes, to minimize the chances you both need to open the same classlib. The problem is that the classlib is large and contains all the classes we need - I agree Lock-Modify-Unlock would be best but this is exactly the reason that I started this thread ... CVS (or Subversion ?) will lock the whole VCX if I want to work on one class he won't be able to work on any other class in the same VCX. Because of the way he has set up everything in one humongous VCX, I really I see this as a can or worms ... That would only leave us with Copy-Modify-Merge as an option ... and I'm not sure if there wouldn't be problems with that approach as well Paul Newton [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/[EMAIL PROTECTED] ** 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] Estimating value of very old PC equipment
Another argument to use is that his accountanct will certainly have fully written them down by now, therefore they have a zero value on the books. Malcolm Greene wrote: I have a very large customer with a suite of servers that are 6-7 years old. I would like an objective (3rd party) way to prove the value of this equipment is zero. (Or less than zero if you factor in ecological disposal). Is there an internet site that would help me prove my point? Plain old common sense is not an option for this particular customer. -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: vfpcom RsToCursor
Most likely you have a network problem. Check it out by connecting one client direct to the server with a crossover cable and see how the speed is then. tanvir ahmad wrote: i mack a software in VFP-9 it's work very fast in surver but in clint it's very run very slow, if any budy have any hint plz help me. -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: Webservice 2nd attempt
Hi Allen We have a vfp8 webservice (built using west-wind) that works fine with PDAs running .Net2. However, it doesn't try to do anything complicated like passing objects - AIUI that's just not possible; but passing straightforward XML text is no problem. Allen wrote: Im beginning to wonder if web services are possible in VFP let alone what you want. Trouble is from what I gather is dotnet has moved the game from soap, so anything written in dotnet will not access a VFP created web service. This seems to be to do with complex types. See www.west-wind.com for a whitepaper on VFP and web services. I have had to give up on a VFP only and thanks (I think) to Microsofts changes in web services, or inability to get VFP to work with them, make a dotnet wrapper for my VFP com. Ive yet to get that to work because its taken a day and a bit just to get VS2005 and its updates on my server. Allen -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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: Webservice 2nd attempt
v 4.5 And yes, complex types are AIUI another no-no; but like you I don't (have never tried to) understand them so that's allright then ;-) Allen wrote: thats interesting to know. I dont think there are any objects passed but I have seen mention of complex types, and I cannot pretend to understand them at all. What did you use, west wind wise, to build the web services ? Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Abbott Sent: 07 December 2007 10:55 To: [EMAIL PROTECTED] Subject: Re: Webservice 2nd attempt Hi Allen We have a vfp8 webservice (built using west-wind) that works fine with PDAs running .Net2. However, it doesn't try to do anything complicated like passing objects - AIUI that's just not possible; but passing straightforward XML text is no problem. No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.16.17/1176 - Release Date: 06/12/2007 23:15 [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/[EMAIL PROTECTED] ** 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: Group header on group footer page
Vote for it and verify it on MS Connect - might do some good, maybe, just possibly ... Garrett Fitzgerald wrote: Looks like this bug: http://cathypountney.blogspot.com/2007/11/gotcha-serious-report-bug-with-data.html Argh, and I read that when she posted it, too. Thanks, Bill. Any thoughts on workarounds? Short of downgrading to SP1, which would break some of my other reports -- Cheers Brian Abbott ___ 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/[EMAIL PROTECTED] ** 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.
