RE: Anyone heard of MV.Base?
Thanks Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave Crozier Sent: 28 April 2008 15:44 To: 'ProFox Email List' Subject: RE: Anyone heard of MV.Base? Graham, I know a colleague who says he used it up to a couple of years ago. He says that there is an ODBC client available called Liberty ODBC. Other than that he doesn't know of anny connectors apart from writing one yourself using the SDK. http://www.multivalue.com/LibODBC.html Evidently there is an evaluation version that comes with MV.Base itself. Dave Crozier -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Graham Brown (CompSYS) Sent: 28 April 2008 11:48 To: ProFox Email List Subject: Anyone heard of MV.Base? Hi I've been asked about linking into a piece of software called MOS which uses MV.Base (pick based?) as its underlying database. The MOS product has a query builder for extracting information to Excel which is a pig to use. I've checked control panel and there aren't any ODBC drivers or DSNs. Anybody come across this before please? Graham Brown CompSYS Software Solutions T:0845 202 8480 F:0845 202 8480 / 0845 009 4480 M:07973 988939 E:[EMAIL PROTECTED] BNI Member. The Business Referral Organisation For more information please go to http://www.bni-plains.co.uk --- 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.
Anyone heard of MV.Base?
Hi I've been asked about linking into a piece of software called MOS which uses MV.Base (pick based?) as its underlying database. The MOS product has a query builder for extracting information to Excel which is a pig to use. I've checked control panel and there aren't any ODBC drivers or DSNs. Anybody come across this before please? Graham Brown CompSYS Software Solutions T:0845 202 8480 F:0845 202 8480 / 0845 009 4480 M:07973 988939 E:[EMAIL PROTECTED] BNI Member. The Business Referral Organisation For more information please go to http://www.bni-plains.co.uk --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ 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] Exists query from mySQL table
Hi all I'm trying to figure out what I think should be an exists query What I have is two tables Lookup List has two fields ID (autonumber) and a description ID=1, description=Red ID=2, description=blue ID=3, description=Green ID=4, description=Purple The customer table has a name field and a memo. The memo contains which colour preferences the customer has, customer can choose as many preferences as they like so Name=Graham, Memo=1,2, (Graham prefers red and blue) Name=Fred, Memo=2,3, Name=Sue, Memo=2,4, Name=Chris, Memo=1, What I'm trying to do is end up with this : - Red is preferred by 2 customers Blue is preferred by 3 customers Green is preferred by 1 customer Purple is preferred by 1 customer This table will help the user figure out which items to stock. I know I can do this long hand by creating a temporary cursor but was looking for something easier. I've been messing with : - select distinct description, count(*) from lookup_list where exists (select memo from customers where instr(cast(lookup_list.id as char),memo)0) group by lookup_list.description order by lookup_list.description But that doesn't want to play. Any pointers would be gratefully received. Thanks! Graham Brown CompSYS Software Solutions BNI Member. The Business Referral Organisation For more information please go to http://www.bni-plains.co.uk --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ 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] Any Ajax gurus out there please!
Hi all I have this code on one site (test_site_a.co.uk...) what it does is call an asp file called higson.asp on a completely different website which then returns a html table of subscribers. The code in this JS then writes out that table directly with document.write. This works just fine in IE but fails miserably in Firefox. No error message just doesn't do anything. I've read that FF does not allow http ajax calls across different domains, anybody know if that is correct please? Cheers Graham script language=Javascript var xmlHttp; try { xmlHttp=GetXmlHttpObject() xmlHttp.onreadystatechange=function() { if(xmlHttp.readyState==4) { document.write(xmlHttp.responseText); } } xmlHttp.open(GET,http://www.bni-plains.co.uk/higson.asp,true); xmlHttp.send(null); } catch (e) { try { // Firefox, Opera 8.0+, Safari xmlHttp=new XMLHttpRequest(); xmlHttp.onreadystatechange=function() { if(xmlHttp.readyState==4) { document.write(xmlHttp.responseText); } } xmlHttp.open(GET,http://www.bni-plains.co.uk/higson.asp,true); xmlHttp.send(null); } catch (e) { // Internet Explorer try { xmlHttp=new ActiveXObject(Msxml2.XMLHTTP); xmlHttp.onreadystatechange=function() { if(xmlHttp.readyState==4) { document.write(xmlHttp.responseText) } } xmlHttp.open(GET,http://www.bni-plains.co.uk/higson.asp,true); xmlHttp.send(null); } catch (e) { try { xmlHttp=new ActiveXObject(Microsoft.XMLHTTP); xmlHttp.onreadystatechange=function() { if(xmlHttp.readyState==4) { document.write(xmlHttp.responseText) } } xmlHttp.open(GET,http://www.bni-plains.co.uk/higson.asp,true); xmlHttp.send(null); } catch (e) { alert(Your browser does not support AJAX!+chr(13)+chr(10)+e.description); } } } } /script Graham Brown CompSYS Software Solutions E:[EMAIL PROTECTED] BNI Member. The Business Referral Organisation For more information please go to http://www.bni-plains.co.uk ___ 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.
SQL Pass Thru question
Hi I've written a simple routine to upload into Quickbooks via the QODBC.com link. What I'm finding is periodically some records are not getting written into quickbooks. I can run the insert statements manually and they work so I suspect it has something to do with firing the inserts one after the other. Does SQLExec need a delay loop to wait until it has finished executing each insert command? This is the code for QB. It looks to see if the customer record is already on file, inserts if not then checks again to see if went through, finally it adds a child record for the job card. Regards Graham Select emails Go Top nH=SQLConnect(QuickBooks Data) If nH=0 Wait Window Unable to connect to Quickbooks Else N=1 Scan For emails.f_imported=No =SQLEXEC(nH,Select * from customer where name='+Strtran(Proper(Alltrim(emails.f_forename)+ +Alltrim(emails.f_surname)),','')+',MyCust) If Reccount(MyCust)=0 ** Need to add the customer record cSQL=Insert into customer (Name,BillAddressAddr1,BillAddressAddr2,BillAddressAddr3,BillAddressAddr4,Bi llAddressCity,email,isActive,CompanyName) values( cSQL=cSQL+'+Strtran(Proper(Alltrim(emails.f_forename)+ +Alltrim(emails.f_surname)),','')+', cSQL=cSQL+'+Rtrim(m.add1)+', cSQL=cSQL+'+Rtrim(m.add2)+', cSQL=cSQL+'+Rtrim(m.add3)+', cSQL=cSQL+'+Rtrim(m.add4)+', cSQL=cSQL+'+Rtrim(m.add5)+', cSQL=cSQL+'+Rtrim(emails.f_email)+', cSQL=cSQL+1, cSQL=cSQL+'+Strtran(Proper(Alltrim(emails.f_forename)+ +Alltrim(emails.f_surname)),','')+' cSQL=cSQL+) oSecurity.recordEvent(SQL,,cSQL) =SQLEXEC(nH,cSQL) =Sqlcommit(nH) Endif cSQL=Select * from customer where name like '+Proper(Alltrim(emails.f_forename)+ +Alltrim(emails.f_surname))+%' =SQLEXEC(nH,cSQL,MyCust) If Reccount(MyCust)0 **name,parentreflistid,parentreffullname,companyname,jobdesc m.faultinfo=Fault Desc here cSQL=Insert into customer (name,notes,jobstatus,parentreflistid,parentreffullname,jobdesc) values( cSQL=cSQL+'Job:+Alltrim(Str(emails.f_jobno))+ - +Strtran(Proper(Alltrim(emails.f_make)+ +Alltrim(emails.f_model)),','')+ (+Strtran(Time(),:,)+)', cSQL=cSQL+'+Rtrim(Strtran(m.faultinfo,',''))+', cSQL=cSQL+'Pending', cSQL=cSQL+'+Rtrim(MyCust.listid)+', cSQL=cSQL+'+Rtrim(MyCust.parentreffullname)+', cSQL=cSQL+'+Rtrim(MyCust.companyname)+', cSQL=cSQL+'+Rtrim(Proper(Strtran(Alltrim(emails.f_make)+ +Alltrim(emails.f_model),','')))+' cSQL=cSQL+) =SQLEXEC(nH,cSQL) =Sqlcommit(nH) Endif N=N+1 Select emails Replace f_imported With Yes =Tableupdate() Endscan =SQLDISCONNECT(nH) Endif ___ 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
Can you close the form with ctrl f4? then reopen? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Adam Buckland Sent: 01 April 2008 11:36 To: ProFox Email List Subject: RE: Form off side of the screen VF6 The top of the form is off the top of the program so all I have is the bottom right 1/4 of the form... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alan Bourke Sent: 01 April 2008 11:35 To: profox@leafe.com Subject: Re: Form off side of the screen VF6 Adam Buckland wrote: Client has managed to drag a form ¾ of the way off the screen and can't get it back. Does right-clicking on the top bar of the form present any options? [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.
Disable one cell in a grid
Hi all I'm having a numpty moment. I've got this code to build a grid on a form. The underlying table (QTE_D) has a field called QTY_LOCKED which means the user is not allowed to change the qty for that one line item. I would have thought that .columns(4).enabled=iif(QTY_LOCKED==Y,.f.,.t.) would have worked but it doesn't Is there an easier way than setting the dynamic forecolor to grey and changing the when event for the column? Thanks With Thisform.pageframe1.page1.grid1 .Top=thisform.pageframe1.page1.cssShape1.Top+3 .Height=300 .Width=thisform.pageframe1.width-50 .Visible=.F. .Left=5 .GridLines=0 .RecordMark=.F. .DeleteMark=0 .RecordSourceType=1 .RecordSource=qte_d .ColumnCount=7 .Columns(1).Name=column1 .Columns(1).ControlSource=qte_d.qd_desc1 .Columns(1).Width=250 .Columns(1).HEADER1.Caption=Description .Columns(2).Name=column2 .Columns(2).ControlSource=qte_d.qd_LENGTH .Columns(2).Width=70 .Columns(2).HEADER1.Caption=Length .columns(2).alignment=1 .columns(2).inputmask=999 .Columns(3).Name=column3 .Columns(3).ControlSource=qte_d.qd_width .Columns(3).Width=70 .Columns(3).HEADER1.Caption=Width .columns(3).alignment=1 .columns(3).inputmask=999 .Columns(4).Name=column4 .Columns(4).ControlSource=qte_d.qd_qty .Columns(4).Width=70 .Columns(4).HEADER1.Caption=Qty .columns(4).alignment=1 .Columns(5).Name=column5 .Columns(5).ControlSource=qte_d.qd_itemprice .Columns(5).Width=120 .Columns(5).HEADER1.Caption=Each .columns(5).alignment=1 .Columns(6).Name=column6 .Columns(6).ControlSource=qte_d.qd_disc .Columns(6).Width=70 .Columns(6).HEADER1.Caption=Discount .columns(6).alignment=1 .Columns(7).Name=column7 .Columns(7).ControlSource=qte_d.qd_totalprice .Columns(7).Width=120 .Columns(7).HEADER1.Caption=Total .columns(7).alignment=1 .highlightstyle=2 .Refresh() Endwith Graham Brown CompSYS Software Solutions T:0845 202 8480 F:0845 202 8480 / 0845 009 4480 M:07973 988939 E:[EMAIL PROTECTED] BNI Member. The Business Referral Organisation ___ 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: Which version of Vista for Fox
Thanks Thats kinda what I thought, the local computer store said that Home Premium will connect to a domain but it looks like Home only sees the gateway. I've ordered a Dell with Vista Business along with a brand new server to run SBS2003. Do VFP8 apps work on Vista? Regards Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Alan Bourke Sent: 31 March 2008 10:23 To: profox@leafe.com Subject: Re: Which version of Vista for Fox Graham Brown (CompSYS) wrote: Could anybody tell me which version of Vista I need so it connects my network the same as XP Pro? Also are there any specific editions which work better or worse with database apps in v8? 'Business' or 'Ultimate' I reckon. [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: [OT] Red Light Cameras work too well
You haven't got mobile speed (revenue) cameras yet? We have unmarked white vans at the side of the road in the UK. They park up with the backdoor or side door open with the cameras rolling. We also have average speed cameras on many of our motorways so even if you slow for the camera you still get the fine and points because it's averaged out over a longer distance. ... and where there aren't cameras they've put speed ramps just to make sure either you get a fine or a wrecked suspension. The best one though is where we have the roads with 1 lane in either direction and they put road narrowing ramps in so there is just enough room for 1 car to go in one direction so you have to go onto the wrong side of the road into the path of oncoming cars. What actually happens is you get drivers playing chicken with oncoming traffic. Not quite sure how that makes things safer but there you go. They've also just announced today that the fines for central London for parking on yellow lines has gone up to ?120 and about ?80 everywhere else. The traffic wardens don't even need to ticket you as they have digital cameras so the first you know is when the fine is posted out. Don't you just love it... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stephen Russell Sent: 31 March 2008 13:44 To: ProFox Email List Subject: Re: [OT] Red Light Cameras work too well On Sat, Mar 29, 2008 at 7:00 AM, Michael Madigan [EMAIL PROTECTED] wrote: Listen to this nonsense. Some cities have seen a drop in revenue from red light violations and are considering turning off the cameras. It seems too many people are obeying the traffic stops. I thought the idea of cameras was to improve safety and save lives? --- Wait till they take them mobile, where they pick a new corner every other week. -- Stephen Russell Sr. Production Systems Programmer Mimeo.com Memphis TN 901.246-0159 --- 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.
Which version of Vista for Fox
Hi all I've heard M$ are about to kill off XP (again) so I suppose I should go out and buy a pc with Vista on it to see how my VFP8 apps work with it. Could anybody tell me which version of Vista I need so it connects my network the same as XP Pro? Also are there any specific editions which work better or worse with database apps in v8? I'm going to trawl the posts later to see what else is broken in Vista but I've read on this list that VFP9 SP1 breaks more than it fixes? Graham Brown CompSYS Software Solutions BNI Member. The Business Referral Organisation ___ 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: Getting at Excel data from VFP
Does Set NullDisplay to handle that? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of NickC Sent: 28 March 2008 10:08 To: 'ProFox Email List' Subject: RE: Getting at Excel data from VFP Stephen, I do indeed now have the null problem but the only suggestion I can find is IMEX=1 which doesn't actually help with the problem I have. The problem is that any empty Excel fields get imported by the ADO CursorAdapter as .null., then when I process that cursor through GenHTML (which I am now using for creating the output) those fields are simply ignored. The best I can come up with at the moment is to loop through each record and each field in each cursor converting nulls to blank, can anyone think of a better way of doing this? Cheers, Nick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen Russell Sent: 25 March 2008 19:34 To: ProFox Email List Subject: Re: Getting at Excel data from VFP On Tue, Mar 25, 2008 at 1:57 PM, NickC [EMAIL PROTECTED] wrote: Finally done, as always thanks for your suggestions. Also a quick plug for Robert Abram's FTP_Service which looks to be doing the FTP upload admirably. A bit of code for the archives, reading Excel into VFP: - as a heads up google for excel null errors and connection string. Years back I found that there was another setting that would tell the jet engine to skip all the nulls that got in the way. lcRegBkPath= IncomingSpreadsheetPath loConn = NewObject('ADODB.Connection') loconn.Provider=Microsoft.Jet.OLEDB.4.0 loconn.ConnectionString=[Data Source=]+lcRegBkPath+ ; [;Extended Properties=Excel 8.0;HDR=Yes;;] loconn.Open() loRs = NewObject('ADODB.recordset') oCA = CREATEOBJECT(CursorAdapter) oCA.DataSourceType = ADO lcWorksheet=WorksheetName lcRange=A1:Z99 lcCursor=lcWorksheet loRS.Open([SELECT * FROM `]+lcWorksheet+[$]+lcRange+[`],loConn) oCA.Alias=lcCursor oCA.CursorSchema = Field1 C(50), Field2 C(50), Field3 C(50) IF NOT oCA.CursorFill(.T.,,,loRS) ? AERROR(laError) ? laError ENDIF oCA.CursorDetach() EXPORT TO (lcWorksheet) TYPE XL5 loRS.Close [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: Any Quickbooks experts out there?
Hi Nottingham (UK) is rather a long way to bring someone to demo! It is supposed to be possible but just got through to their support line in India and it is both possible and impossible to import to sales orders! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of MB Software Solutions General Account Sent: 26 March 2008 18:01 To: ProFox Email List Subject: Re: Any Quickbooks experts out there? Graham Brown (CompSYS) wrote: Hi all I've been asked by a client if I can import sales order information into Quickbooks. The website refers to being able to import data in CSV format but doesn't say which modules. Appears that there are also three versions of QB so if anybody could tell me which version I'd need to buy for them. Cheers Graham Brown CompSYS Software Solutions BNI Member. The Business Referral Organisation I think Rick Borup advertises this as one of his services. Also, Rick Schummer could give some name(s), as I met the gentleman in Michigan back in 2006. [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: Any Quickbooks experts out there?
Thanks QODBC looks promising. I can get the info from the MySQL database without too much hassle. I guess Fox8 should be able to do this with SQL/PT Just trying to find some sample code to demo importing sales orders. Cheers -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jeff Johnson Sent: 26 March 2008 19:52 To: profox@leafe.com Subject: Re: Any Quickbooks experts out there? Hello Michael! I have used the same format for 99 through 2007 without any changes. Jeff Jeff Johnson [EMAIL PROTECTED] SanDC, Inc. 623-582-0323 Fax 623-869-0675 MB Software Solutions General Account wrote: Jeff Johnson wrote: http://quickbooksgroup.com/webx/forums/importexport/2861 Discusses Sales Orders. I personally use .iif import files for bank transactions and credit card transactions. Hi Jeff, Do you mandate a certain version of QB be used? --Michael [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: [OT] Smart ForTwo by Mercedes
Nice cars, they did have a small problem with not being able to go round corners though, well not quite true they *could* go round corners just upside down thats all. Always put me off them after that. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of William Sanders / EFG Sent: 26 March 2008 22:17 To: profox@leafe.com Subject: RE: [OT] Smart ForTwo by Mercedes Mr. B - my apologies - I seem to have the A110 stuck in the brain. I Do, instead, mean the A160 here's some 'nice' info - http://cgi.benl.ebay.be/MERCEDES-BENZ-Classe-A-W168-A-160-Classic-1998-1_W0Q QitemZ320229282866QQihZ011 Mondo Regards [Bill] -- William Sanders / efGroup [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] PDF to DOC
Hi I downloaded this http://www.bluesquad.com/uk/prod.php?pid=1185tr1=BS_UK_TR_PDFTW hth Cheers -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Charles Hart Enzer, M.D. Sent: 25 March 2008 19:36 To: profox@leafe.com Subject: Re: [NF] PDF to DOC Dear Paul: Looks neat. Thank you. I need one for XP SP2. Original message Date: Tue, 25 Mar 2008 11:33:23 -0700 From: Paul M¢Nett [EMAIL PROTECTED] Subject: Re: [NF] PDF to DOC To: [EMAIL PROTECTED] Charles Hart Enzer, M.D. wrote: What tools do you suggest for: Text only Text and images This may or may not help. On Linux, there are some command-line tools such as: pdftotext pdftops pdftohtml pdfimages They do the job, with quality about what you'd expect from a tool that has to work backwards. pdftops (to postscript) tends to work the best, since postscript and pdf are related. pdftotext just gets the raw text with an attempt at formatting blocks of text that tends to miss the mark by a lot. But it gives good output for, e.g. indexing. I'm sure there are GUI tools built on top of these CLI tools, and I'm sure there are other solutions available on Windows, but I thought I'd mention these anyway. I've used them for years with good results. Paul [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[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] Unix webhosting - directory password protection
Hi all I have a few websites hosted on nix servers which have private folders so in the online control panel they are set to require password. When someone attempts to go to this folder in a browser they get a standard windows login dialog. Does anyone know how to retrieve the user name (and password) they used to login to the folder either with PHP/Perl? I want to basically have Welcome back... then the persons name. Graham Brown CompSYS Software Solutions M:07973 988939 E:[EMAIL PROTECTED] BNI Member. The Business Referral Organisation ___ 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] Unix webhosting - directory password protection
Thanks I'll give that a go tomorrow. Regards Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ted Roche Sent: 19 March 2008 19:40 To: profox@leafe.com Subject: Re: [NF] Unix webhosting - directory password protection On Wed, Mar 19, 2008 at 2:19 PM, Graham Brown (CompSYS) [EMAIL PROTECTED] wrote: Does anyone know how to retrieve the user name (and password) they used to login to the folder either with PHP/Perl? I want to basically have Welcome back... then the persons name. ?php if(isset($_SERVER['REMOTE_USER'])) { $cLoginName = $_SERVER['REMOTE_USER']; } else { $cLoginName = Intruder! Thief! Alarm! } ? -- Ted Roche Ted Roche Associates, LLC http://www.tedroche.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[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: Getting at Excel data from VFP
Hi Nick The other link had some code to write back I think. The problem looks like creating a new sheet with ADO which doesn't seem possible. However I have dim distant recollections of ADOX (ADO Extension/ADO Extensibility library) with Access Jet and a quick google search for ADOX turned this up. http://support.microsoft.com/kb/303814 Have a look and see if that's got it. Please let us know how you get on... Cheers -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of NickC Sent: 17 March 2008 09:37 To: 'ProFox Email List' Subject: RE: Getting at Excel data from VFP Graham, It certainly does work. I currently have a small test, albeit VB script, running on the server and reading from a spreadsheet. Excel is not installed on the server. Next problem is seeing if ADO can also write to the new spreadsheet! Thx for the ADO suggestion, Nick [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: Getting at Excel data from VFP
Yep the articles looked interesting. Will have a look when I get 5 as well as hadn't realised Excel can be queried with Jet. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of NickC Sent: 16 March 2008 15:54 To: 'ProFox Email List' Subject: RE: Getting at Excel data from VFP Thx Graham, looks like this will work. ADO is apparently installed with IIS so is present on the server. Nick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Graham Brown (CompSYS) Sent: 15 March 2008 15:17 To: ProFox Email List Subject: RE: Getting at Excel data from VFP Hi What about this on technet? http://www.microsoft.com/technet/scriptcenter/resources/officetips/jun05/t ip s0607.mspx and this http://www.visualbasic.happycodings.com/Database_SQL_Stuff/code14.html It doesn't refer to having Excel loaded just the standard JET Oledb drivers. Not tried the code but it looks promising. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of NickC Sent: 15 March 2008 13:50 To: 'ProFox Email List' Subject: RE: Getting at Excel data from VFP Thx Graham but that will only work on a machine that has Excel installed on it. [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: Getting at Excel data from VFP
This is some simple code I use to rip data from an Excel spreadsheet Any use? If messagebox(Import Suppliers,36,Please confirm)=6 cFilename=getExFile(d:\suppliers.xls) getexfile just does a locfile is the path is wrong If !isnull(cFilename) Sele 0 Use supplier Zap oXL=CREATEOBJECT(Excel.Application) oWB=oXL.Workbooks.open(cFilename) oWS=oWB.ActiveSheet nMax=0 For EACH oRow IN oWS.Rows If oRow.row=1 Loop Endif If empty(oRow.cells[1,1].value) Exit Endif Append blank Scatter memvar memo m.changed_by=System m.changed_date=date() m.created_by=System m.created_date=date() m.su_add1=oRow.cells[1,4].value m.su_add2=oRow.cells[1,5].value m.su_add3=oRow.cells[1,6].value m.su_add4=oRow.cells[1,7].value m.su_add5=oRow.cells[1,8].value m.su_add6= m.su_contact= m.su_email= m.su_fax=oRow.cells[1,13].value m.su_ref=oRow.cells[1,1].value m.su_telno=oRow.cells[1,12].value m.su_vatcode=S m.su_vatrate=17.5 m.su_pcode=oRow.cells[1,9].value m.su_name=oRow.cells[1,2].value Gather memvar memo Wait window m.su_name nowait noclear Next Use in supplier Release oWS Release oWB Release oXL Endif Endif -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of NickC Sent: 14 March 2008 14:54 To: 'ProFox Email List' Subject: RE: Getting at Excel data from VFP Hi Tracy, The only reason for not installing Excel is that it is a Server that this will run on; I am of the opinion that installing any MS Office product on a server comprimises its security. However, if there is an Excel 'Data part' install that would be fine, unfortunately I can't fine anything like that. Nick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tracy Pearson Sent: 14 March 2008 14:16 To: profox@leafe.com Subject: RE: Getting at Excel data from VFP Disclaimer: I'm not a lawyer. Check into the licensing of Excel. Isn't there a part in there you can install it on multiple machines (up to 3 I think) as long as you are the only one using it, and only one instance at a time. Wouldn't this fall into that technically? You did mention this runs on its own in the middle of the night when most people which work in the office will be asleep. Tracy -Original Message- From: NickC Sent: Friday, March 14, 2008 10:11 AM Excel is being used as a database. The initial problem with Append From is that on the first column (Id field) it adds a CHR(0) at the front of the field and chops off the last character. Nick [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] Search Engine Ranking Software
Hi all Advanced Web Ranking looks like it will do the reporting. http://www.advancedwebranking.com You tell it the site URL, click the Import meta keywords, select the search engines and let it go. This gives a readout of where a site is in the search engines. Took about an hour to run through a fairly big site. Very simple to use and also has a lot more functionality which I haven't looked at yet. Cheers G -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Graham Brown (CompSYS) Sent: 03 March 2008 17:09 To: ProFox Email List Subject: [NF] Search Engine Ranking Software Hi Could anyone recommend any software which shows a sites ranking on the major search engines. I've come across a product called SEO Suite 8 but it is s complicated to use I've given up with it. Thanks Graham Brown CompSYS Software Solutions BNI Member. The Business Referral Organisation [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.
[NF] Search Engine Ranking Software
Hi Could anyone recommend any software which shows a sites ranking on the major search engines. I've come across a product called SEO Suite 8 but it is s complicated to use I've given up with it. Thanks Graham Brown CompSYS Software Solutions BNI Member. The Business Referral Organisation ___ 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] Search Engine Ranking Software
Hi The submission software I'm using sends to Msn,AOL,Overture,Excite,Lycos,iWon,HotBot,DogPile,Ask Jeeves, WebCrawler,MetaCrawler,Overture,InfoSpace,Netscape Search,Alltheweb,About,Alexa Go,Looksmart,NBCi, Search King,Search.com,Espotting,EarthLink,ScrubTheWeb,Mamma,Teoma, Yahoo,altavista Plus about 50 other SEs. Some of these I'm not that fussed about because they probably share the same database as google or yahoo (or nobody uses them!) This is the info I get from an SEO company for one of my sites it arrives as a pdf with lots of graphics so probably won't come out very well but it shows me for certain keywords my sites position in certain search engines. For approx $3000-$4000 per year I don't get all my search keywords or very many search engines. Page 1 Advanced Web Ranking Report Project: Portable Floor Makers 25-Apr-2007 (Compare to 19-Apr-2007) Visibility for www.portablefloormakers.co.uk First Place: 13 In Top 10: 32 In Top 20: 38 In Top 30: 40 Moved Up: 6 Moved Down: 2 Gain/Loss: 4 Not Changed: 26 Added: 6 Dropped: 0 Ranked: 40 Not Ranked: 2 Visibility Score: 1022 Visibility Percent: 81.11% Keywords: 6 Search Engines: 7 www.portablefloormaker s.co.uk Altavista UK (UK) AOL UK (UK) Google UK Google UK (UK) Lycos UK MSN UK Yahoo UK (UK) banqueting chairs 13 5 6 2 5 1 16 3 14 banqueting tables 6 1 1 1 8 1 7 plastic chairs 25 5 5 1 5 2 1 22 plastic tables 11 2 3 2 2 2 1 12 1 portable bars 1 1 12 2 2 4 1 2 portable stages 1 1 4 1 4 1 2 Not Ranked Added Dropped Moved Up Moved Down Not Changed I can get Google Analytics stats for how well the site is doing but am looking for more info to give the customer. I don't know if that explains what I'm trying to achieve. Regards -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Paul McNett Sent: 03 March 2008 19:09 To: profox@leafe.com Subject: Re: [NF] Search Engine Ranking Software Graham Brown (CompSYS) wrote: Could anyone recommend any software which shows a sites ranking on the major search engines. I've come across a product called SEO Suite 8 but it is s complicated to use I've given up with it. What search engine, besides Google, do you consider major? Paul [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[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.
Tapi Intro
Hi I've possibly got a project lined up which will be required to link my existing fox 8 app to a Samsung PBX via tapi. The Samsung PBX has an API library which ships with but I haven't seen this yet so don't know how good it is or what it actually does. All I know is that it gives a tapi interface. If it happens the project is going to be to link a sales enquiry line, so when the phone rings the operator answers it, the application shows all the customers details. The current application without tapi asks for either the client name or quotation reference and then uses this to pop up the info. Could anyone point me in the direction of any general resources for fox and tapi please? Graham Brown CompSYS Software Solutions BNI Member. The Business Referral Organisation ___ 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] charges on my bank card.
If it don't cost to query then I'd query just in case you're paying for something you don't use. I once had someone charge a lot of womens slinky underwear to my card. Gave me some explaining to do, Mrs Brown thought she maybe had competition either that or I'd started batting for the other team !! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Michael Madigan Sent: 21 January 2008 19:47 To: profox@leafe.com Subject: [NF] charges on my bank card. I'm getting this showing up on my online banking. I think it must be for an Internet service or something, but I can't figure it out. The bank can't tell me who it is unless I dispute it and it will take a few days for me to find out who it is. This is how it shows up on my check card. Does this look familiar to anyone? YBNMEMBE YBNMEMBERSE LOS ANGELES CA Nothing comes up when I Google it. All the other charges are clearly understandable, and most companies put a telephone number with it. They've been taking $7.50 a month out of my account per month for a while. I knew what it was when it first started, but now I can't figure it out. Today they charged $165.40. I think Alzheimer's is kicking in. [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: interactivechange
Hi I'd add another property to hold the original value/listindex and set this in the gotfocus Then in interactive if failed this.value/listindex =this.original If that doesn't work please email back. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ailsom F. Heringer (OSKLEN) Sent: 17 January 2008 17:41 To: profox@leafe.com Subject: interactivechange Hi All, At a combobox, when InteractiveChange event is trigged, how can I cancel (or not) the change and return to the original value ? -- Aílsom F. Heringer [EMAIL PROTECTED] Skype: ailsom.osklen Analista de Sistemas -- Osklen Departamento de Informática Rio de Janeiro - RJ BRASIL http://www.osklen.com.br 55 21 22198971 --- 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.
Gantt Chart Source
Hi Has anyone come across any freebie source for doing Gantt charts (like Microsoft Project) in vfp8? Cheers Graham Brown CompSYS Software Solutions BNI Member. The Business Referral Organisation ___ 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: combo box: How to undo changes ???
Not tried. What about adding a new property called original_value In the gotfocus set this.original_value to this.value InteractiveChange then has if failed this.value=this.original_value I think you may need a nodefault in there as well. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ailsom F. Heringer (OSKLEN) Sent: 15 January 2008 13:57 To: profox@leafe.com Subject: combo box: How to undo changes ??? Foxers, At the INTERACTIVECHANGE method of a combo box, depending on the item the user must answer YES or NO to a message box. If the answer is NO, how can I undo the change and set the combo box to its original selected item ? -- Aílsom F. Heringer [EMAIL PROTECTED] Skype: ailsom.osklen Analista de Sistemas -- Osklen Departamento de Informática Rio de Janeiro - RJ BRASIL http://www.osklen.com.br 55 21 22198971 --- 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.
Cursor Adapters and autoinc field in vfp 8
Hi all Hope someone can help with this because it is driving me nuts!! I have this code snippet to insert a record into the customers table ** f_rn is auto Inc field in tblcustomers ** oCrCustomers is a cursor adapter to tblcustomers and returns alias of customers oCrCustomers.cSelectCMDFilter=f_rn=0 just create an empty cursor. oCrCustomers.Cursorfill() Select Customers Append blank repl cust_name with Hello =tableupdate() I'm trying to find an easy way to retrieve the value of f_rn for this record, the only way I can see is to do oCrCustomers.cSelectCMDFilter=cust_name='Hello' oCrCustomers.cursorfill() m.f_rn=customers.f_rn Thanks Graham Brown CompSYS Software Solutions T:0845 202 8480 BNI Member. The Business Referral Organisation ___ 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] computer job ads, then and now
The best one I had was from a chap I was interviewing for a promotion to the development team. He sat down and started running through his list of skills and then proceeded to show me a Delphi project he'd written. I was just thinking this guy is better than me when something just caught my eye. I scrolled back to the top of the source file and there in big letters Copyright Borland Corporation. This chap was only trying to pass off the Delphi samples as his own work !! Didn't even have the brains to remove the standard comments. He never did get the job... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Michael Madigan Sent: 02 January 2008 23:10 To: ProFox Email List Subject: Re: [OT] computer job ads, then and now Yes. Aditionally, the work ethic is lacking in many of these guys. We had one summer intern think nothing of sleeping at his desk. All he had to do was stay awake, graduate, and he would have received an entry level position. But there was no way anyone was going to sponsor him after catching him snoozing several times. --- Ricardo Aráoz [EMAIL PROTECTED] wrote: David Crooks wrote: I can not imagine what the year 2020 will look like. Can you? Dec 27, 1994 ... PC REPAIR TECHNICIAN Individual must have 2-3 years experience in the repair of PC hardware with a strong electronics background Must able to analyze run and take appropriate action. Must possess working knowledge of MS-DOS ... --- Dec 21, 2007 . Front end development with skills in JavaScript, CSS, Ajax, DOM, DHTML, XHTML, XML, XSL, XSLT and 2-3 years with a server side technology; PHP 5 and or Java. . Experience building and integrating with AJAX frameworks, specifically with DOJO widget driven architectures using dijit, and other JavaScript frameworks. . Ability to quickly take mockups / comps and build production ready CSS driven pages to defined specifications incorporating cross browser rendering, performance and display issues. . Ability to build scalable, efficient event driven UI features for heavily trafficked site with 1.6 million+ daily unique visitors. . Experiencing building and using Web services, JSON RPC, SOAP, WSDL, REST, XML-RPC. . Experience connecting widgets/Ajax enabled features with MySQL, Oracle and other enterprise data sources. . Test driven development experience and iterative process; SCRUM, Agile, Pair / XP. . Version control using Subversion. . Flash, Actionscript experience a plus. . Experience with servlet containers / app servers; Resin, Apache and mod_caucho a plus David L. Crooks I used to think I was under trained or something when reading those ads. Until in my previous job I met these young guys, average, some knowledge but what you would expect for their years. But if you took a look at their CV's you would've thought they were about to get a Nobel. All kinds of groups of upper case letters, but when you sat with them to solve a real problem they were average guys. Have you perceived the same thing over there? ___ 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. [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.
Sub Reports/Joining two reports together
Hi all I'm working on replacing a couple of Access products with Vis Fox. The reports in Access use sub reports to join several together which looks kinda nice. I can do the same in fox with automation or using postscript and ghostscript to send to a pdf. Both of these rely on external factors though (like having word) so possibly not a good solution. Could anyone think is there another way to accomplish the same in Fox v8? Thanks Graham Brown CompSYS Software Solutions BNI Member. The Business Referral Organisation ___ 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: Refox-concept for CHM?
I've got something called html help workshop, no idea where it came from but have just reversed a chm file with it. This has given me all the html code and a HHC file. I've then opened the hhc and can see the project. If you want to email me the file off list to spam1 at compsysdotcodot.uk I'll have a crack at it for you as long as I'm not going to breach anybody's license !! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of MB Software Solutions Sent: 18 December 2007 20:37 To: Profox Subject: Refox-concept for CHM? We've got a CHM file but no source. Is there a refox kind of application for CHM files? I found this via Google search: http://www.grainge.org/pages/authoring/reverse_engineering/reverse_engineeri ng.htm ...but wondered if others have successfully used a tool they could recommend? tia! --Michael -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com Work smarter, not harder, with MBSS custom software solutions! [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: Refox-concept for CHM?
Just seen the earlier posts saying its a hlp rather than a chm. Did the command line thing work? Failing that I'm fairly sure I have/had a piece of software on another pc (Win98!) which may reverse it. The exe name to that is helpman but I can't remember the name of the product. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Graham Brown (CompSYS) Sent: 20 December 2007 14:37 To: ProFox Email List Subject: RE: Refox-concept for CHM? I've got something called html help workshop, no idea where it came from but have just reversed a chm file with it. This has given me all the html code and a HHC file. I've then opened the hhc and can see the project. If you want to email me the file off list to spam1 at compsysdotcodot.uk I'll have a crack at it for you as long as I'm not going to breach anybody's license !! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of MB Software Solutions Sent: 18 December 2007 20:37 To: Profox Subject: Refox-concept for CHM? We've got a CHM file but no source. Is there a refox kind of application for CHM files? I found this via Google search: http://www.grainge.org/pages/authoring/reverse_engineering/reverse_engineeri ng.htm ...but wondered if others have successfully used a tool they could recommend? tia! --Michael -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com Work smarter, not harder, with MBSS custom software solutions! [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: outlook e-mail help
Any use? oOutlook=Createobject(outlook.application) If Type(oOutlook)=O And Not Isnull(oOutlook) oNameSpace=oOutlook.getNameSpace(MAPI) If Type(oNameSpace)=O And Not Isnull(oNameSpace) oNameSpace.logon oMSG=oOutlook.createItem(0) With oMSG .subject=Your Quotation from Portable FloorMaker Ltd cbody=Dear +Iif(Len(Trim(cCursor..qh_salutation))=0,cCursor..qh_salutation,Sir/Mada m)+Chr(13)+Chr(10)+Chr(13)+Chr(10) .body=cbody .recipients.Add(Rtrim(cEmail)) If File(cPDF) .attachments.Add(cPDF) Else =Messagebox(Unable to open +cPDF,16,PDF Email Error) Endif .Display() Endwith Release oNameSpace Endif Release oOutlook Endif -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Matthew Jarvis Sent: 19 December 2007 00:17 To: profox@leafe.com Subject: Re: outlook e-mail help Bryant Minard wrote: I use the following code inside of VFP. I need to add an attachment like: C:\CEMDATA.ZIP Anyone have any ideas on addinf an attachment? snip Somewhere on the VFUG website (www.vfug.org) should be my series on Office Automation, and one of the articles should have an example of doing the attachment. Can't seem to pull up the website right now, but if I remember when I get home tonight I'll try and dig up the code Matthew S. Jarvis IT Manager Bike Friday - Performance that Packs. www.bikefriday.com 541/687-0487 x140 [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.
Recommendations for UK based touch screens.
Hi all Has anyone got any recommendations for UK based touch screens suppliers? I'm working on a shop floor data capture screen and the customer asked about touch screens. (No doubt he has been playing one of those annoying higher or lower card games you get in pubs/bars) Thanks Graham Brown CompSYS Software Solutions BNI Member. The Business Referral Organisation ___ 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] ? about one
lol well toast does always land buttered side down and cats do always land on their feet... Would be cool to find out though, purely in the interests of science... Give me a while and I'll try when both my wife and Tibbles the cat aren't looking. Cheers G -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of kam Sent: 10 December 2007 17:11 To: ProFox Email List Subject: [OT] ? about one at the risk of starting a stupid thread, I don't understand this one? If you tied buttered toast to the back of a cat and dropped it from a height, what would happen? [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: [OT] ? about one
Would work equally well with Amy Winehouse but she is so out of it most of the time, she probably wouldn't notice. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Michael Madigan Sent: 10 December 2007 17:27 To: ProFox Email List Subject: RE: [OT] ? about one Let's drop Hillary Clinton out of a plane with buttered toast strapped to her back, and see what happens. --- Dave Crozier [EMAIL PROTECTED] wrote: Kam, The underlying theories are that: 1. If you drop a piece of toast, it will ALWAYS drop buttered side down. 2. When a cat falls it will always twist in mid air and hence land on its feet. Conundrum: So, which of the forces would prevail, the buttered toast always landing buttered side down, or the cat - always landing on its feet? One to discuss in the Philosophy course I think. Dave Crozier -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of kam Sent: 10 December 2007 17:11 To: ProFox Email List Subject: [OT] ? about one at the risk of starting a stupid thread, I don't understand this one? If you tied buttered toast to the back of a cat and dropped it from a height, what would happen? [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: [OT] ? about one
discuss philosophy? why would you want to do that when Mr Tibbles has already volunteered? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave Crozier Sent: 10 December 2007 17:25 To: 'ProFox Email List' Subject: RE: [OT] ? about one Kam, The underlying theories are that: 1. If you drop a piece of toast, it will ALWAYS drop buttered side down. 2. When a cat falls it will always twist in mid air and hence land on its feet. Conundrum: So, which of the forces would prevail, the buttered toast always landing buttered side down, or the cat - always landing on its feet? One to discuss in the Philosophy course I think. Dave Crozier -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of kam Sent: 10 December 2007 17:11 To: ProFox Email List Subject: [OT] ? about one at the risk of starting a stupid thread, I don't understand this one? If you tied buttered toast to the back of a cat and dropped it from a height, what would happen? [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.
[OT] Finding new business
Hi all I've been following the threads about coming out of contracting and getting a proper job! Thought I'd share some thoughts with you. All the business I get is from word of mouth referrals, I find this is a lot easier than getting out there tendering for jobs etc. I know at one stage a few years back I thought my business was going to dry up so I set about finding ways to generate referral business. This is the easiest way to find new work because someone else recommends me. This gives me immediate credibility and also allows me to jump up the queue of preferred suppliers. Here in the UK we have various networking groups like the Business Link and Federation of Small Business. What I did was join the local chapter of a worldwide networking organisation. Costs me about £700 per year which is far less than the cost of advertising in the phone book! In my local group I have 20 other companies all of whom introduce me to contacts they have. As an example one of my products is aimed at lift(elevator) servicing and I asked the group if someone could introduce me into the largest lift installer in my home town (nottingham). Turns out one of my fellow member's brothers is the national IT manager for that company and I now have a meeting with him. If you are struggling to find new work ask yourself if you have a word of mouth referral strategy, if not then you really need one! I've just started asking my existing customers to write me a bit of a testimonial at the end of each project and if they could recommend me to anyone else. The testimonial is as much about advertising my customer as me so they also get exposure. I also have various strategic partnerships with IT hardware companies, they are an excellent source of referrals. If you want to know more about how I find work for myself then take a look at the BNI. Either http://www.bni.com (US) or http://www.bni.eu (Europe) There are loads of Podcasts and advice about networking and referrals on the site with links to other sites. btw my customers don't care if I develop solutions in Vis Fox, they only care if the solutions work so I don't get hung up on moving to other products. We need MS to sort out this vista nonsense for us and we're set for another 10 years! I'd be interested to know what you think about this. Graham Brown CompSYS Software Solutions BNI Member. The Business Referral Organisation ps I'm not a salesman for the BNI/Business Link/Federation, I don't make any commission and I'm not an affiliate!! ___ 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] Audio Files on Web Page
Do you mean the file didn't get uploaded? Obvious things are to check to see if it is going to the correct folder where you think it is going? Can you use Secure FTP to upload all other types of files? Also check with your hosting company, some prohibit certain file types so possibly that could be a cause. I had one not allow Exes so had to zip everything. Just a thought. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Allen Sent: 04 December 2007 09:19 To: profox@leafe.com Subject: RE: [NF] Audio Files on Web Page I use frontpage :) Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charles Hart Enzer, M.D. I wrote a web page in html. I put in a link to a WMA file. Using Secure FTP, I could not find the WMA file in the local folder, let alone SFTP it to the Web Server. What do you suggest? I want to put up 9 files for a total of about 30 minutes. Thank you. No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.16.13/1169 - Release Date: 03/12/2007 22:56 [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.
[NF] .Net Crystal Reports
Hi all When deploying a .NET application which uses Crystal Reports does the customer need to buy crystal in order to run them? Cheers Graham CompSYS Software Solutions BNI Member. The Business Referral Organisation ___ 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] Deploying a .NET application with Installshield
Hi Stephen Isn't a setup normally an exe? Not used MSIs. I've VS2003 although I must have 2005 in my actionpack somewhere. I've been developing in fox for over 10 years but this one customer asked me to port an Access database to VB so he can distribute it so although I've done some ASP.NET it looks like I have to get my head VB.Net enough to give him what he wants. Cheers Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stephen Russell Sent: 23 November 2007 01:21 To: ProFox Email List Subject: Re: [NF] Deploying a .NET application with Installshield On Nov 22, 2007 5:25 PM, Graham Brown (CompSYS) [EMAIL PROTECTED] wrote: Hi all Is Installshield Express capable of building an installer for a VB.Net application? Can't make head nor tail of the installation project type in VS. What are you trying to create for your final product, a msi? What version of VS are you working with? In VS2005 just rt click on the project and select publish. HTH __Stephen [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: setting a form to autocenter based on a condition
Hi Jeff Could you check sys(16) to see if it returns the .exe name? You should be able to set autocenter true/false either in the form load or form init. Not tried but I can't see why that wouldn't work. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jeff Roberts Sent: 21 November 2007 22:13 To: profox@leafe.com Subject: setting a form to autocenter based on a condition Hi all, I've been doing a lot of development on my laptop lately, and screen space is tighter there. I've got an app that most all the form's autocenter property is set to true, and I'd like for that to be false when I'm running the app or form under the vfp ide. That way the form pops up in the middle of the customer's screen when they are running the exe but when I am working on the form it stays in the upper left, not underlapping with my command window, debugger, etc. Is there any way to set a form's autocenter property before it runs, or is there an alternative way to center the form? Thanks, Jeff [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: Getting a Dropdown List to loop
Hi I don't know if this post is still current but this works for me on the down arrow. Cheers DEFINE CLASS frmdatamanagerformcustom1 AS frmdatamanagerformcustom DoCreate = .T. Name = Frm1 ADD OBJECT combo1 AS combobox WITH ; ColumnCount = 0, ; ColumnWidths = , ; RowSourceType = 1, ; RowSource = A,B,C,D, ; FirstElement = 1, ; Height = 24, ; Left = 48, ; NumberOfElements = 0, ; Style = 2, ; Top = 48, ; Width = 100, ; Name = Combo1 PROCEDURE combo1.KeyPress Lparameters nKeyCode, nShiftAltCtrl If nKeyCode=24 down If This.ListIndex=This.ListCount This.ListIndex=1 NODEFAULT Else Endif ELSE Endif ENDPROC PROCEDURE combo1.Init =DODEFAULT() this.ListIndex=1 ENDPROC ENDDEFINE -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Paul Newton Sent: 09 November 2007 15:19 To: profox Subject: Getting a Dropdown List to loop Hi all I have a dropdown list with rowsource type 1 and three values and which is working fine except that I would like it to loop if the user presses the down-arrow key when its listindex is 3, or presses the up-arrow key when its listindex is 1. IOW if the user repeatedly presses either of these keys the control will simply loop through the three values. What would be the best way to achieve this - I've tried a couple of things in the interactivechange and keypress events code but can't seem to get to work the way I want Thanks 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.
[NF] Deploying a .NET application with Installshield
Hi all Is Installshield Express capable of building an installer for a VB.Net application? Can't make head nor tail of the installation project type in VS. Cheers Graham Brown CompSYS Software Solutions BNI Member. The Business Referral Organisation ___ 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.
[OT] Our fantastic government
Hi ...and today's story of total incompetence is... Our fantastic government have succeeded in misplacing two disks containing the personal banking info of 25 million people in the UK. Which is almost half the population! They were evidently sending the disks in their internal mail to the National Audit Office and they disappeared. The spin doctors are saying there is no risk but we've already seen reports popping up on MSN where people have lost substantial sums of money due to identity theft. Only in the UK don't you just love it. Wonder if they'd like a nice foxpro database writing...? Graham ___ 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] Joke
Probably really really funny after a few beers... did you try that? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Eurico Chagas Filho Sent: 17 November 2007 08:55 To: 'ProFox Email List' Subject: [OT] Joke Hi Can someone explain to me the joke below ? House, Michael (HNI Corp) [4:30 PM]: here's a joke for you House, Michael (HNI Corp) [4:30 PM]: Three guys walk into a bar. House, Michael (HNI Corp) [4:30 PM]: the fourth one ducks! Thanks, Eurico. No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.15.32/1131 - Release Date: 14-Nov-07 16:54 [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.
[NF] any PHP4 gurus out there?
Hi all I'm working on some code to upload to a website cms via PHP. The script works fine up to 500k but errors on anything over at about 90 seconds. The php.INI file has max_execution_time=1200 max_input_time=1200 memory_limit=100M post_max_size=100M upload_max_filesize=100M max_file_size=100M post_max_size=100M if((!empty($_FILES[uploaded_file])) $_FILES['uploaded_file']['error']==0 ) { The file $_FILES['uploaded_file']['error'] always equals 2 at this point for large files. but is fine for smaller files. $filename = basename($_FILES['uploaded_file']['name']); $ext = substr($filename, strrpos($filename, '.') + 1); //Determine the path to which we want to save this file $newname = dirname(__FILE__).'/upload/'.$filename; //Check if the file with the same name is already exists on the server if (!file_exists($newname)) { //Attempt to move the uploaded file to it's new place if ((move_uploaded_file($_FILES['uploaded_file']['tmp_name'],$newname))) { echo File . $filename . has been succcessfully transferred.br ; echo An email confirmation has also been sent to: . $_POST['fldemail']; } else { echo Error: A problem occurred during file upload!; } } else { echo Error: File .$_FILES[uploaded_file][name]. already exists; } } else { echo brbrError: No file uploaded; echo The error returned was ; echo $_FILES['uploaded_file']['error']; } Appreciate it if anyone can shed any light because this is driving me nuts. Regards Graham ___ 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] any PHP4 gurus out there?
Well done Ted It was the 100M in the form vars. Setting these to 1048... worked and I've uploaded an 85mb file without problem to the website. If anybody wants to see the full code please let me know. Cheers Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ted Roche Sent: 16 November 2007 19:43 To: profox@leafe.com Subject: Re: [NF] any PHP4 gurus out there? On Nov 16, 2007 2:29 PM, Graham Brown (CompSYS) [EMAIL PROTECTED] wrote: input type=hidden name=MAX_FILE_SIZE value=100M / What happens if you change this to: input type=hidden name=MAX_FILE_SIZE value=1 / or if you want to be finicky, 104857600? See the note at: http://www.php.net/manual/en/faq.using.php#faq.using.shorthandbytes -- Ted Roche Ted Roche Associates, LLC http://www.tedroche.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[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] any PHP4 gurus out there?
Hi This is the html form which gets submitted, just straight forward html. form enctype=multipart/form-data action=upload.php method=post table width=100% trtdimg src=./images/logo.gif/td/tr /table span class=titleClient Upload Area/span brbr span class=smalltitleFormat:/span ulliNo MAC files!/li liAll files must be sent with CMYK-colour settings./li liUse the following formats only: JPEG, PDF./li liWith vector graphic formats all text must be converted to paths!/li liSet up pixel images with 300 dpi to avoid loss of quality during printing./li liAll text, logos, and important artwork must stay away from all edges by a minimum of 5mm to avoid being cut off. /li /ul table border=0px trtd colspan=2Please enter your details in the spaces below/td td style=border: 1px solid gray rowspan=12Some nice adverts can go in here/td /tr tr tdEnter Project Name:/td tdinput type=text name=fldpname size=75/td /tr tr tdYour Name:/td tdinput type=text name=fldname size=75/td /tr tr tdYour Company Name:/td tdinput type=text name=fldcname size=75/td /tr tr td valign=topYour Address:/td tdinput type=text name=fldadd1 size=75br input type=text name=fldadd2 size=75br input type=text name=fldadd3 size=75br input type=text name=fldadd4 size=75br input type=text name=fldadd5 size=75br /td /tr tr td valign=topYour Telephone Number:/td tdinput type=text name=fldphone size=75/td /tr tr td valign=topYour Fax Number:/td tdinput type=text name=fldfax size=75/td /tr tr td valign=topYour Email Address:/td tdinput type=text name=fldemail size=75/td /tr tr td valign=topHow can we help?:/td tdtextarea rows=10 name=fldcomments cols=75/textarea/td /tr trtd input type=hidden name=MAX_FILE_SIZE value=100M / input type=hidden name=POST_MAX_SIZE value=100M / Choose a file to upload: /tdtdinput name=uploaded_file type=file / /td/tr trtd colspan=3input type=button value=Upload onclick=submitme() //td/tr /form -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ted Roche Sent: 16 November 2007 19:25 To: profox@leafe.com Subject: Re: [NF] any PHP4 gurus out there? On Nov 16, 2007 2:02 PM, Graham Brown (CompSYS) [EMAIL PROTECTED] wrote: I'm working on some code to upload to a website cms via PHP. The script works fine up to 500k but errors on anything over at about 90 seconds. You don't supply the script, so it's hard to guess what's going wrong. Are you using a PUT or POST? The manual http://www.php.net/features.file-upload has some suggestions. -- Ted Roche Ted Roche Associates, LLC http://www.tedroche.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[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] Sage question (mainly for UK guys)
Hi John Sage should come with an ODBC driver This is some simple vfp8 code to rip out the names and addresses. I used Excel and MSQuery to find out the tables and field names. nHandle=Sqlstringconnect(dsn=SageLine50v11;uid=manager) If nHandle=0 N=SQLEXEC(nHandle,select * from sales_ledger order by address_1,temp) If Select(temp)0 oDE=Createobject(decust+db_platform) oDE.custsupp.lNoDataOnLoad=.F. oDE.OpenTables() Select temp SCAN WAIT WINDOW temp.address_1 NOWAIT noclear SELECT custsupp LOCATE FOR cs_name=temp.address_1 IF EOF() APPEND BLANK REPLACE cs_name WITH temp.address_1 ENDIF REPLACE cs_add1 WITH temp.address_2,; cs_add2 WITH temp.address_3,; cs_add3 WITH temp.address_4,; cs_postcode WITH temp.address_5,; cs_telno WITH temp.telephone,; cs_fax WITH temp.fax,; cs_email WITH temp.email,; cs_web WITH temp.web_address,; cs_accno WITH temp.account_ref =mtableUpdate() SELECT temp Endscan oDE.CloseTables() USE IN temp Else Wait Window Unable to open Sage View ENDIF SQLDISCONNECT(nHandle) Else Wait Window Unable to access Sage Endif -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of John Weller Sent: 16 November 2007 20:02 To: profox@leafe.com Subject: [NF] Sage question (mainly for UK guys) I am working with a local charity who have a few shops. They need a simple stock control system and have asked me to write one. They are currently using Sage Line 50 to hold their stock and find it far too complex for their simple requirements and too inflexible for their situation. My question is - does any of the UK brethren know if data can be exported from Sage into a CSV or similar? If not I'll have the system produce a printout and direct it to a text file and manipulate that to get the data but it would be easier if I could get it directly. I know Sage used to have that facility but I hear that now you need an SDK which is not cheap. TIA John Weller 01380 723235 07976 393631 [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] any PHP4 gurus out there?
Hi all This simple application is for 3 companies I deal with. Signwriter, printer and architect. The brief was to give them a simple page which will allow their clients to upload artwork without messing around with ftp. As you can see there is nothing earth shattering about it, the big thing was the large file upload. I've tested with just under 90megs and that went through ok. I'm going to tart it up some more, probably rejecting scripts, exes, dlls before giving it the graphics people to make it look pretty. The pages are hosted on a linux server. The html form !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Strict//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd; html xmlns=http://www.w3.org/1999/xhtml; head meta http-equiv=content-type content=text/html; charset=utf-8 / link href=default.css rel=stylesheet type=text/css / script language=Javascript function submitme(){ cMess=; oform=document.forms[0]; if(oform.fldpname.value==){ cMess=Please enter your Project Name; } if(oform.fldname.value==){ cMess=Please enter your Name; } if(oform.fldphone.value==){ cMess=Please enter your Telephone Number; } if(oform.fldemail.value==){ cMess=Please enter your Email Address; } if(cMess!=){ alert(cMess); return false; } else{ oform.submit(); } } /script /head body form enctype=multipart/form-data action=upload.php method=post input type=hidden name=MAX_FILE_SIZE value=104857600 / input type=hidden name=POST_MAX_SIZE value=104857600 / table width=100% trtdimg src=./images/logo.gif/td/tr /table span class=titleClient Upload Area/span brbr span class=smalltitleFormat:/span ulliNo MAC files!/li liAll files must be sent with CMYK-colour settings./li liUse the following formats only: JPEG, PDF./li liWith vector graphic formats all text must be converted to paths!/li liSet up pixel images with 300 dpi to avoid loss of quality during printing./li liAll text, logos, and important artwork must stay away from all edges by a minimum of 5mm to avoid being cut off. /li /ul table border=0px trtd colspan=2Please enter your details in the spaces below/td td style=border: 1px solid gray rowspan=12Some nice adverts can go in here/td /tr tr tdEnter Project Name:/td tdinput type=text name=fldpname size=75/td /tr tr tdYour Name:/td tdinput type=text name=fldname size=75/td /tr tr tdYour Company Name:/td tdinput type=text name=fldcname size=75/td /tr tr td valign=topYour Address:/td tdinput type=text name=fldadd1 size=75br input type=text name=fldadd2 size=75br input type=text name=fldadd3 size=75br input type=text name=fldadd4 size=75br input type=text name=fldadd5 size=75br /td /tr tr td valign=topYour Telephone Number:/td tdinput type=text name=fldphone size=75/td /tr tr td valign=topYour Fax Number:/td tdinput type=text name=fldfax size=75/td /tr tr td valign=topYour Email Address:/td tdinput type=text name=fldemail size=75/td /tr tr td valign=topHow can we help?:/td tdtextarea rows=10 name=fldcomments cols=75/textarea/td /tr trtd Choose a file to upload: /tdtdinput name=uploaded_file type=file / /td/tr trtd colspan=3input type=button value=Upload onclick=submitme() //td/tr /form /body /html css body { font-family: Helvetica Neue, Helvetica, sans-serif; border: 1px solid #ff; padding: 0px; margin: 0px; } span.title { font-family: Helvetica Neue, Helvetica, sans-serif; font-size:40px; font-weight:bold; color:blue; padding: 0px; margin: 0px; } span.smalltitle { font-family: Helvetica Neue, Helvetica, sans-serif; font-size:20px; font-weight:bold; color:blue; padding: 0px; margin: 0px; } PHP.Ini needs to be in the root of the webspace. max_execution_time=1200 max_input_time=1200 memory_limit=100M post_max_size=100M upload_max_filesize=100M max_file_size=104857600 post_max_size=104857600 This is the upload file !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Strict//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd; html xmlns=http://www.w3.org/1999/xhtml; head meta http-equiv=content-type content=text/html; charset=utf-8 / link href=default.css rel=stylesheet type=text/css / body table width=100% trtdimg src=./images/logo.gif/td/tr /table span class=titleClient Upload Area/span brbr table border=0px trtd colspan=2Upload Status./td td style=border: 1px solid gray rowspan=2Some nice adverts can go in here/td /tr trtd ?php if((!empty($_FILES[uploaded_file])) ) { $filename = basename($_FILES['uploaded_file']['name']); $ext = substr($filename, strrpos($filename, '.') + 1); //Determine the path to which we want to save this file $newname = dirname(__FILE__).'/upload/'.$filename; //Check if the file with the same name is already exists on the server if (!file_exists($newname)) { //Attempt to move the uploaded file to it's new place if ((move_uploaded_file($_FILES['uploaded_file']['tmp_name'],$newname))) { echo File . $filename . has been
Explorer at 99% utilisation
Hi all Has anyone come across a problem on WinXP where the taskman reports explorer at 99%? My application is running on a small network of about 10-15 users. It is VFP8 using CA's to a native fox dbc. Normally the CA generates a cursor of 15000 records in a fraction of a second. When one user goes in and runs the query they get the 99% problem and everybody else slows to a crawl and takes literally minutes to run the same query. If I get everybody out and keep the problem machine logged off the system runs normally. The machine in question appears to have both AVG and Norton AV which probably isn't good so I've asked them to flatten the pc and reinstall. The last time I had this it was cabling but not this time. Has anyone seen the same problem please? Thanks Graham ___ 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: Explorer at 99% utilisation
Hi I don't know. The IT chap on site said it wasn't AV but I can't see any other logical explanation. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Robert Jennings Sent: 08 November 2007 17:55 To: profox@leafe.com Subject: RE: Explorer at 99% utilisation Graham, I assume that the AV has been sorted out already? Robert Foxpro is will die in 2015, what is the next best language to go to? Python? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Graham Brown (CompSYS) Posted At: 08 November 2007 17:49 Posted To: Profox Archive Conversation: Explorer at 99% utilisation Subject: Explorer at 99% utilisation Hi all Has anyone come across a problem on WinXP where the taskman reports explorer at 99%? My application is running on a small network of about 10-15 users. It is VFP8 using CA's to a native fox dbc. Normally the CA generates a cursor of 15000 records in a fraction of a second. When one user goes in and runs the query they get the 99% problem and everybody else slows to a crawl and takes literally minutes to run the same query. If I get everybody out and keep the problem machine logged off the system runs normally. The machine in question appears to have both AVG and Norton AV which probably isn't good so I've asked them to flatten the pc and reinstall. The last time I had this it was cabling but not this time. Has anyone seen the same problem please? Thanks Graham [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: Explorer at 99% utilisation
Thanks all I'm back on site on monday so will see if the pointers sort it. Regards Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Michael Madigan Sent: 08 November 2007 21:39 To: ProFox Email List Subject: Re: Explorer at 99% utilisation First thing to do is to remove either Norton or AVG from their system. Two anti-virus programs can wreak havoc. Second is to shut off network disk scanning on all the computers. Third is to disable Windows Defender as it is always causing problems. Fourth is to check the system event log to see if anything goofy is going on there. Sometimes you get a bad cluster in a paging file and it brings the system to its knees. I've noticed that if you have two opposing programs that scan files, you're asking for problems. Having Windows Defender and AVG anti-virus and Carbonite backup all running on the same machine can bring everything to a crawl. Since I've disabled Windows Defender and Carbonite, my computer flies. [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.
[NF] Outlook Calendar
Hi all I've recently had to rebuilt my PS file on Outlook2k. Since I've done this the calendar doesn't highlight the days properly. The calendar is day view mode so I have the appointments for today in the middle of the screen and the calendar display for this month and next month on the right. Before the right hand calendar view would highlight the days where I have a meeting in bold text so I can see at glance I'm supposed to be somewhere. No idea why this is not working now. Anybody seen this before please? Thanks Graham ___ 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: Ideas for trial versions
Yep neat! On a networked app I also limit to one user accessing the data. I also use the limit on the main tables, example only 20 customers, products, jobs etc As it is one base class that controls all data access really easy to implement. but don't do what Winzip used to do, You are now on day 726 or you 14 day evaluation!! Do you need to watch taking access to a system away completely though, I used to limit the days so after 60 it just said Thanks, now buy or go forth you cheapskate and log 'em out. One of the solicitors said I couldn't do this. I had to make the system read only after so many days. Never found out what the legal precedent was for this though. Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Michael J. Babcock, MCP Sent: 25 October 2007 15:16 To: profox@leafe.com Subject: Re: Ideas for trial versions On Thu, October 25, 2007 10:01 am, Alan Bourke wrote: Yes that's what I meant. How about increasing the transparency of your forms depending on days past the trial expiration? :) LOL! I love it! ;-) [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] Animated GIFs
I used gif construction a while back. http://www.mindworkshop.com/alchemy/gifcon.html regards -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Michael J. Babcock, MCP Sent: 23 October 2007 16:54 To: profox@leafe.com Subject: [NF] Animated GIFs What's the easiest way to make an animated GIF file (from your experience)? tia! --Michael [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.
[OT] Ordnance survey maps x/y coordinates
Hi all Completely off topic this one. I've inherited some really neat PHP code today which takes a UK postcode (zipcode!) and looks in a database to find the nearest database record with that postcode. The php code is basically for entering your postcode and finding where the nearest stockist is to your location. It does this by using the Ordnance Survey X/Y coordinates and looking up the first part of the postcode LE4 to find the X/Y. Mainland UK postcodes can be easily looked up with http://www.streetmap.co.uk/streetmap.dll?GridConvert?name=CV32%204ATtype=Po stcode The code works really well but before I port it to VFP I've tested it with Jersey (little place between the mainland uk and france!) and it fails. Although I have the JE2 postcode I can't find anywhere which publishes the OS x/y for the channel islands. Would anyone happen to know if Ordnance Survey is one of the quirky mainland uk things or where i can find OS cordinates for outside the mainland uk. ps if anybody wants the php code let me know! Cheers Graham ___ 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: Reporting differences on HP Laser
Hi Michael Both A4. Regards -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Michael Hawksworth Sent: 03 October 2007 11:53 To: profox@leafe.com Subject: RE: Reporting differences on HP Laser Form size default on printers different? Regards Michael Hawksworth -Original Message- From: [EMAIL PROTECTED] [mailto:profoxtech- [EMAIL PROTECTED] On Behalf Of Graham Brown (CompSYS) Sent: 03 October 2007 11:42 To: [EMAIL PROTECTED] Subject: Reporting differences on HP Laser Hi all I have a landscape report which is printed on a HP Laser (6L from memory) and it is fine. I then print to the same report having stripped out the tag and expr fields to a HP (1320 from memory) and the print is 2 inches over to the right which is not so good. I am thinking margin or something like but can't see anything special about the 1320 printer. I always thought windows print drivers removed the issues with printing to different printers and they have always looked the same whenever I've done this in the past. Any idea why a 1320 would look completely different to a 6L. Regards Graham [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.
FW: Highlighting item in a treeview
Hi all Just had to drop back onto this one again and the darned thing is still eluding me, am I going crazy or what?! If anybody could I shed any light on why this isn't playing I'd appreciate it. Regards Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Graham Brown (CompSYS) Sent: 21 September 2007 14:33 To: ProFox Email List Subject: Highlighting item in a treeview Hi all I'm sure this shouldn't be as difficult as I'm making it! I'm working on a project which calls for a treeview and grid to be in sync so move one and the other moves. I need to highlight the entry in a treeview and for some strange reason I can't get it to work. The ensurevisible method is firing fine and expands the nodes of the tree as expected. I thought it was oTree.nodes.item(J1).selected=.t. but that doesn't want to play. I need a sanity check please! Cheers Graham [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: DBFs disappearing when PACKing
Some more questions! (sorry, couldn't remember if the file created by pack was a tbk,bak or tmp but tmp makes sense) I don't know if a pack does a delete dbf, rename tmp to dbf, delete tmp so it may be an idea to check you can both rename and delete files in explorer just in case it is a rights issue. I had one it specialist remove delete rights for my application so it crapped out whenever it tried to remove temp files. As some temp files are in memory and don't touch the disk the error message looked sporadic until I worked out what he'd done. Diskspace? make sure there is definitely enough space for the real file and its copy. As fox can/does stick files in c:\windows\temp (set(_temp)?) make sure you have local diskspace also. Do any of the files show as readonly in explorer/file properties. Does the account you are running in have local rights to c:\. Ensure the logged on network user is a local admin to check. You can also identify if its a rights issue by running as admin on the domain. For XP and beyond it may be worth setting the network user up as a local admin also I would certainly suggest turning antivirus off for a moment or ensure it is not scanning dbf,fpt etc etc. Has Norton AV been on the machines previously, norton is notorious for not uninstalling properly particularly where script blocking is concerned. Cheers Graham# -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of John J. Mihaljevic Sent: 27 September 2007 17:40 To: profox@leafe.com Subject: RE: DBFs disappearing when PACKing Hi all, Just did some more testing on this, so here are some answers to the questions that were asked of me yesterday. First off, it's apparently not a VFP9 problem, as it's also happening with VFP6. That leads me to believe there's some kinda networking issue (Server 2003 on our server) or a Vista issue (on each of our workstations). Combining this with the fact that we're unable to save files on our server from Microsoft Office 2007, I'm starting to think it's some kinda rights issues. But even so, here are my responses to the emails I got from everyone yesterday (Thanks much to everyone!!!): From: [EMAIL PROTECTED] [mailto:profoxtech- [EMAIL PROTECTED] On Behalf Of Graham Brown (CompSYS) it's gone. The CDX is still there, but the DBF is gone. Sorry didn't make clear, is there a parts.tbk instead of the dbf when it vanishes? There is not, but there's a big TMP file there. When I USE that TMP file, it appears to be the original DBF with the deleted records successfully removed. Strange that it'd stay in a TMP file and not the correctly-named DBF. From: [EMAIL PROTECTED] [mailto:profoxtech- [EMAIL PROTECTED] On Behalf Of John Weller A WAG - is the index corrupt? The index file is fine. I've reindexed and tried this with several files. Which brings me to your next question... Does this happen with other DBFs or just Parts? It happens with every DBF I try to PACK on the network. I can successfully PACK DBFs on my local C-drive, but not on our network's F-drive. From: [EMAIL PROTECTED] [mailto:profoxtech- [EMAIL PROTECTED] On Behalf Of Peter Cushing How many records are in the table and how many should be there after the pack? In one example, there are 13,963 records in the original DBF. I tried deleting one, and the TMP I mentioned above has 13,962 records, which is correct. The only problem is the error message and the fact that it's leaving me with a TMP file instead of the correctly-named DBF file. Have you tried doing the same thing with a version on the C drive to see if it makes any difference? Yes. Everything is fine on C. Is the table free standing or part of a DBC This is a free-standing DBF. From: [EMAIL PROTECTED] [mailto:profoxtech- [EMAIL PROTECTED] On Behalf Of Graham Brown (CompSYS) When a table is packed doesn't it copy to a temp name either a tbk or bak or something like delete then copy back the other way. Apparently so, since I'm getting a TMP with the correct data. From: [EMAIL PROTECTED] [mailto:profoxtech- [EMAIL PROTECTED] On Behalf Of Tracy Pearson I recently had several clients running an anti-virus called BitDefender which caused this problem. I now pack the files manually with zap and append commands. XP, Vista, Local, or Network didn't matter. The common factor was BitDefender. I'm using McAfee on this machine. From: [EMAIL PROTECTED] [mailto:profoxtech- [EMAIL PROTECTED] On Behalf Of Vince Teachout I don't know the answer, but if you do this: Use Parts Order 1 Excl Set Deleted OFF Copy for .NOT. Deleted() to MyTest Question: Does Mytest now exist, and if so, is it the same size? If not I would guess data corruption. Yes. Everything is okay if I do it that way. That's what I've been doing in the meantime until I figure out how (if?) I can PACK normally again. Continuing: USE MyTest EXCLU PACK Question: Does Mytest still exist
RE: DBFs disappearing when PACKing
Is there a tbk with the same name? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of John J. Mihaljevic Sent: 25 September 2007 16:45 To: profox@leafe.com Subject: DBFs disappearing when PACKing Hi all, I'm using a DBF in VFP9 on a machine with Vista Business: USE parts ORDER 1 EXCL When I issue the PACK command, I get a window that reads: File f:\prices9\parts.dbf does not exist. And when I go to use the file again (or to simply browse for it in Windows), it's gone. The CDX is still there, but the DBF is gone. Any idea why the DBF could be disappearing? This has happened several times. Thanks! [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: DBFs disappearing when PACKing
it's gone. The CDX is still there, but the DBF is gone. Sorry didn't make clear, is there a parts.tbk instead of the dbf when it vanishes? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of John J. Mihaljevic Sent: 25 September 2007 16:52 To: profox@leafe.com Subject: RE: DBFs disappearing when PACKing There is not. Just a DBF, CDX and BAK (as well as an SCT and SCX for a form). -Original Message- From: [EMAIL PROTECTED] [mailto:profoxtech- [EMAIL PROTECTED] On Behalf Of Graham Brown (CompSYS) Sent: Tuesday, September 25, 2007 1:14 PM To: [EMAIL PROTECTED] Subject: RE: DBFs disappearing when PACKing Is there a tbk with the same name? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of John J. Mihaljevic Sent: 25 September 2007 16:45 To: profox@leafe.com Subject: DBFs disappearing when PACKing Hi all, I'm using a DBF in VFP9 on a machine with Vista Business: USE parts ORDER 1 EXCL When I issue the PACK command, I get a window that reads: File f:\prices9\parts.dbf does not exist. And when I go to use the file again (or to simply browse for it in Windows), it's gone. The CDX is still there, but the DBF is gone. Any idea why the DBF could be disappearing? This has happened several times. Thanks! [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: DBFs disappearing when PACKing
When a table is packed doesn't it copy to a temp name either a tbk or bak or something like delete then copy back the other way. I have a dim distant recollection that an IT guy I used to work with created this problem with a rights problem. Certainly running local should prove this. Also when I pack tables I lock the dbc exclusive as well just to be safe. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Vince Teachout Sent: 25 September 2007 17:21 To: ProFox Email List Subject: Re: DBFs disappearing when PACKing Date: Tue, 25 Sep 2007 11:44:42 -0400 From: John J. Mihaljevic [EMAIL PROTECTED] Subject: DBFs disappearing when PACKing I'm using a DBF in VFP9 on a machine with Vista Business: USE parts ORDER 1 EXCL When I issue the PACK command, I get a window that reads: File f:\prices9\parts.dbf does not exist. I don't know the answer, but if you do this: Use Parts Order 1 Excl Set Deleted OFF Copy for .NOT. Deleted() to MyTest Question: Does Mytest now exist, and if so, is it the same size? If not I would guess data corruption. Continuing: USE MyTest EXCLU PACK Question: Does Mytest still exist, or is it gone, also? [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] How to Open CAB File
Quick google search from annoyances.org! Using .CAB Files Intended For Windows 98 Windows 95 When using a complex operating system with hundreds of support files, like Windows, every once in a while you'll need to get one of the files off of the distribution diskettes. These files are often compressed into CAB (cabinet) files, which are similar to ZIP files. If you're using Windows Me, 2000, or XP, CAB file support is built-in. If you're using Windows 95 or 98, you'll need the CabView utility (one of Microsoft's PowerToys). Just double-click a CAB file to open it - files can be extracted by dragging them out of the CAB window. To create new Cabinet files, obtain the DOS-based CAB Maker utility. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Charles Hart Enzer, M.D. Sent: 25 September 2007 17:30 To: profox@leafe.com Subject: [NF] How to Open CAB File I want to install WinDiff from the Folder [c:\SWTOOLS] What are the steps/ Thank you. -- Charles Hart Enzer, M.D. -- Past President Child and Adolescent Psychiatry Council of Cincinnati and Dayton Mailto:[EMAIL PROTECTED] Website: http://capccd.org [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.
Highlighting item in a treeview
Hi all I'm sure this shouldn't be as difficult as I'm making it! I'm working on a project which calls for a treeview and grid to be in sync so move one and the other moves. I need to highlight the entry in a treeview and for some strange reason I can't get it to work. The ensurevisible method is firing fine and expands the nodes of the tree as expected. I thought it was oTree.nodes.item(J1).selected=.t. but that doesn't want to play. I need a sanity check please! Cheers Graham ___ 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: All Computers on Network Lock up
I have a dim distant recollection that having the always suspend checked also created this problem? Been a while since I last worked in 2. This was a setting on the shortcut on the program tab. may be worth having a look. Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Michael Madigan Sent: 23 August 2007 22:33 To: ProFox Email List Subject: Re: All Computers on Network Lock up Slow down or lock up? They may have anti-virus software scanning the network drive. Set their antivirus softare to not scan the network drive. If that fixes it, remind them that it wasn't you're fault. --- Kent Belan [EMAIL PROTECTED] wrote: Hello, I have a client running an old FPW 2.6 app. They just got 3 new Dell XP computers. The computers lockup occassionally and they are blaming my app because that is what they are using when it locks up. What is strange is that all 3 computers lock up at the same time. I find it hard to believe it is my app that causes other computers to lock up. Anyone heard of this or have any ideas ? Thanks, Kent ___ 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] chsi.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. [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.
[OT] From a grateful nation...
To all Americans On behalf of we Brits could I express our gratitude at your taking Victoria Beckham AKA Posh Spice AKA the pounty one off our hands !! Having seen the news last night she seems to be really settled and there is absolutely no need to send her back. We hope her talent (lack thereof) brings a ray of sunshine to you all. btw also saw on the news last night. President Bush appeared to have a go at running our prime minister over with a golf cart, he seemed to be going round and round in circles with Gordon clinging on for his life. Could clearly hear the people in the background laughing. Interesting that this clip hasn't appear on any further news bulletins since! 10 out of 10 for the idea but must try harder, next time tyre tracks over his middle please. Again many thanks Signed The Brits ___ 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-CRM
Hi I don't know if this helps What I have in my systems is an eventlog table basically contains a datetime, user,table name and memo The memo has entries like: - Contact name changed from Fred to Bill Phone changed from 0116 to 0117 I've hooked into the tableupdate so that it scans the table being updated and generates the event log record. There isn't much of an overhead as the eventlog table is not keep long and doesn't take too much effort to update. I only use this to find keying errors, but theoretically I could union join different event logs and roll back to any given date. Never had to but its there. Another alternative which I use on newer systems is also to have datetimes for when the record was created and when it was last updated. Cheers Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of MB Software Solutions Sent: 26 July 2007 01:35 To: profox@leafe.com Subject: Re: VFP9-CRM Sytze de Boer wrote: I have a client with an Access database which they refer to as their CRM system. (Developed by an in-house chap who is no longer there) They also use my accounting system for Receivables, Payables, GL, Payroll, etc They have asked me to convert the CRM system into VFP and to integrate it with the rest of the system. Biggest problem that I see is the synchronizing of this data. i.e. 1 Client copies the system to his laptop 2 Goes overseas and updates contact details, sales discussions, etc 3 Comes back and wants to synch it with Head Office data Does anyone have such a module already or does anyone have ideas about the best way to handle synchronization? My only suggestion for offline scenarios would be to use GUIDs as your keys instead of integers to ensure uniqueness. That should allow you to see what you have different from another computer's data. -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com Work smarter, not harder, with MBSS custom software solutions! [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] Moving files off a laptop for an ex-employee
I don't know if this helps but a quick google search turned this up Mozilla Firefox Bookmarks: For Mozilla Firefox favorites, open the Firefox browser. Click on Bookmarks - Manage Bookmarks. In the new window, click on File - Export. In the new window, use the drop down menu at the top to navigate to the folder where the bookmarks will be saved. Click Save to finish. Cheers Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of MB Software Solutions Sent: 24 July 2007 16:43 To: Profox Subject: [NF] Moving files off a laptop for an ex-employee I'm laying off a person and would like to take their stuff off of the company laptop and put it on a CD for them, including their bookmarks. I looked in the directory tree under Program Files\Mozilla Firefox but didn't see the obvious file for their bookmarks. Can someone tell me where to find it? (Other stuff is easily moved via the Send To option, of course. I just need to locate the bookmarks file.) tia, --Michael -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com Work smarter, not harder, with MBSS custom software solutions! [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: Slow load of runtimes
Hi I had a site a couple of months back which was doing the same. Exe was local, runtimes also local vfp data on network and still running slow. Switched off every machine and server and still 14 ports lit on the switches. Turned out to be cabling with the 5 network switches in that they had switch A connected to switch B which was connected back to switch A and so on (14 times!) No I didn't believe anyone could be so stupid either having spent hours checking the application over!! I'd recommend if it is a small network isolating it to the one machine. Cheers Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Michael Hawksworth Sent: 19 July 2007 08:24 To: profox@leafe.com Subject: RE: Slow load of runtimes AV, DNS lookup issues or Your app is causing memory paging when it is open with the 42K spreadsheets, word documents and sundry other programs that obviously don't effect performance! (early XP desktops only had 256MB memory) If this is using SQL server check that your ODBC does have a reference to the server otherwise it has to go find a suitable system (30s-2mins delay). Degrag the drive (run checkdsk first) It is usually one of the above. Regards Michael Hawksworth -Original Message- From: [EMAIL PROTECTED] [mailto:profoxtech- [EMAIL PROTECTED] On Behalf Of MB Software Solutions Sent: 18 July 2007 20:28 To: [EMAIL PROTECTED] Subject: Re: Slow load of runtimes Allen wrote: I have seen this on sites where the program is loaded from a server. Its painfull. Allen Yes, I've seen what you've seen too. However, I run my apps local...not from the server location. -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com Work smarter, not harder, with MBSS custom software solutions! [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: Slow load of runtimes
It was only the machines down one side of the building which was the weird thing. I had the network guru hovering over me asking why is *your* software not working? over and over. It obviously took him a while to agree to down the networks on a hunch but once he saw what was happening with his boss stood behind him his attitude completely changed. While not actually apologising to me it was good fun watching him squirm his way out. happy days. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of mrgmhale Sent: 19 July 2007 14:00 To: profox@leafe.com Subject: RE: Slow load of runtimes Wow, I thought only I had run across that kind of loopback on a LAN g... In the case where I saw it, the entire network went down immediately after some folks began to migrate cables to a new set of switches. I got the call after everything crashed. I asked what they had changed just before it all crashed. Nothing, we just started moving cables from the old hubs to the new switches, then it all stopped working. We think we have a bad switch out here. I had then double check to make certain they did not have two or more cables uplinking to any child switches. Sure enough, there was a duplicate uplink. They unplugged the offending cable the new, broken switch was suddenly fixed g... Gil -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Graham Brown (CompSYS) Sent: Thursday, July 19, 2007 5:40 AM To: [EMAIL PROTECTED] Subject: RE: Slow load of runtimes Hi I had a site a couple of months back which was doing the same. Exe was local, runtimes also local vfp data on network and still running slow. Switched off every machine and server and still 14 ports lit on the switches. Turned out to be cabling with the 5 network switches in that they had switch A connected to switch B which was connected back to switch A and so on (14 times!) No I didn't believe anyone could be so stupid either having spent hours checking the application over!! I'd recommend if it is a small network isolating it to the one machine. Cheers Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Michael Hawksworth Sent: 19 July 2007 08:24 To: profox@leafe.com Subject: RE: Slow load of runtimes AV, DNS lookup issues or Your app is causing memory paging when it is open with the 42K spreadsheets, word documents and sundry other programs that obviously don't effect performance! (early XP desktops only had 256MB memory) If this is using SQL server check that your ODBC does have a reference to the server otherwise it has to go find a suitable system (30s-2mins delay). Degrag the drive (run checkdsk first) It is usually one of the above. Regards Michael Hawksworth -Original Message- From: [EMAIL PROTECTED] [mailto:profoxtech- [EMAIL PROTECTED] On Behalf Of MB Software Solutions Sent: 18 July 2007 20:28 To: [EMAIL PROTECTED] Subject: Re: Slow load of runtimes Allen wrote: I have seen this on sites where the program is loaded from a server. Its painfull. Allen Yes, I've seen what you've seen too. However, I run my apps local...not from the server location. -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com Work smarter, not harder, with MBSS custom software solutions! [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 / SQL Performance and Configuration
Yep, I totally agree I've just had my chaps put in a second server (which is about the size of a small car!) on one site for just Exchange and a file/printer share type things, the sql app runs elsewhere We used to get some big joke type movies emailed or downloaded and before you knew it every user would forward it to every other user going round and round which would quite happily cripple the lan. Exchange needs a minimum of 1gb just for itself? I'm sure we spec'd the server with far more memory than that. Aside from what MS recommend because its gonna need more if you'd like to know what we recommend I'll ask the hardware guys. Regards -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of mrgmhale Sent: 19 July 2007 14:03 To: profox@leafe.com Subject: RE: VFP / SQL Performance and Configuration I have always been told to never, ever, ever run anything but Exchange off an Exchange Server. Apparently it consumes huge overhead, and can draw a Server nearly to its knees from time to time. I do have 2 clients running Exchange Servers. They both recently ugraded their Servers (all not just Exchange). In both cases they left Exchange on its own server, as opposed to trying to comingle Server processes from 2 older units to one newer, faster Server. I bet it was due to Exchange Server's demand for RAM and other resources. Gil -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Andrew MacNeill Sent: Thursday, July 19, 2007 8:35 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: VFP / SQL Performance and Configuration Hey all. I have a client who is running into some sporadic but severe and frustrating performance issues on a VFP 9 app connecting to a SQL Server box. The SQL Server box is their primary office server , also running Exchange. Lots of disk space but only 1 GB of RAM. As I mentioned, it IS sporadic - I can't really see anything from the Performance tuner - sometimes some queries get suspended but then run again.. The application itself has data stored on another server and was working fine before switching to the SQL version. I've increased the size of tempdb. The database is spread into two main files but has tons of space free (it's got a size of 1 GB with 600 MB free). Any suggestions on where to look for those items killing performance? Thanks Andrew [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: Trapping system date change.
Hi chaps I just use a net time /set command to sync the time in one of my bar code apps. htu Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave Crozier Sent: 03 July 2007 16:16 To: 'ProFox Email List' Subject: RE: Trapping system date change. Alan, I'll email you off line as it’s a bit long to send in a post. Dave Crozier -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alan Bourke Sent: 03 July 2007 16:11 To: profox@leafe.com Subject: Re: Trapping system date change. Dave Crozier wrote: Alan, I have an API call that allows you to sync the time with any other PC on the network. Is that what you mean or do you wish to access a remote Internet Time source? No another PC i.e. the server would be perfect. I don't even want to sync it, just see if someone is playing silly buggers with the system date. [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: Trapping system date change.
Thanks Hadn't seen it fail before. My application is a time fees system so as you can imagine having the correct time is quite important. I had the users messing with the system date time so they could start late and go home early before! I'm sure they still have at least one win98 machine so will check it for sync errors. Cheers -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave Crozier Sent: 03 July 2007 17:22 To: 'ProFox Email List' Subject: RE: Trapping system date change. Graham, The problem with Net time /Set is that sometimes the call will return an incorrect Date/Time - especially on Win98 systems (if you still have any). I got really caught by this one some time ago, hence the need to write an API call. Dave Crozier -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Graham Brown (CompSYS) Sent: 03 July 2007 18:08 To: ProFox Email List Subject: RE: Trapping system date change. Hi chaps I just use a net time /set command to sync the time in one of my bar code apps. htu Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave Crozier Sent: 03 July 2007 16:16 To: 'ProFox Email List' Subject: RE: Trapping system date change. Alan, I'll email you off line as it’s a bit long to send in a post. Dave Crozier -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alan Bourke Sent: 03 July 2007 16:11 To: profox@leafe.com Subject: Re: Trapping system date change. Dave Crozier wrote: Alan, I have an API call that allows you to sync the time with any other PC on the network. Is that what you mean or do you wish to access a remote Internet Time source? No another PC i.e. the server would be perfect. I don't even want to sync it, just see if someone is playing silly buggers with the system date. [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: Trapping system date change.
If you have the API code could I also have a look please. info at compsys dot co dot uk -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave Crozier Sent: 03 July 2007 17:19 To: 'ProFox Email List' Subject: RE: Trapping system date change. Alan, Glad to help! Dave Crozier -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alan Bourke Sent: 03 July 2007 16:48 To: profox@leafe.com Subject: Re: Trapping system date change. Well I've furtled it just to return the remote date so I can compare it with the local date, works great, thx! [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.
SQL Server Import Small Date Time
Hi all I'm importing a fox database into SQL2k. Is there any easy way to default all the dates to just datetime, the DTS wizard always puts these down as smalldatetime. I have to edit the sql statements each time to put them back to datetime which is a pain. Thanks Graham ___ 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: SQL Server Import Small Date Time
Thanks Andy Looks like you have to do this for every date field in every table. Just spent the last 3 hours doing this. Can't see any other way of saying treat all foxpro date fields as datetime and not smalldatetime At least its saved as a DTS now so I only have to do it once! Cheers Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Andy Davies Sent: 26 June 2007 15:04 To: profox@leafe.com Subject: Re: SQL Server Import Small Date Time there's an option in dts ( a tagged page - 'filter' or some such irc) where you can change the 'to' file spec. hth Andrew Davies MBCS CITP - AndyD 8-)# ** Manchester City Council supports Smokefree England - 1 July 2007 This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. Please contact [EMAIL PROTECTED] with any queries. ** [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] Need help with website design
Hi Take a look at w3schools.com. There are millions of these sites out there but this should give you a fairly good overview. Cheers Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mike Wohlrab Sent: 18 June 2007 03:50 To: profox@leafe.com Subject: RE: [NF] Need help with website design Thanks Ed, One question though. Where would I put that in my code? I attached my html code in case you wanted to look at it and tell me where to put it or put it in there if you know where it goes. If you would rather not and have me learn where it goes then that would be fine as well. Ted Roche, My goals for the site are really to do a combination of advertising my services and what I do and how to contact me and etc. It is also going to be used for an experience of building and maintaining a website as a learning experience and just to have a site and say I made this great website. Also, I am not trying to build a website that is going to compete with a very large company or organization or really compete at all. If I was going to have a website that would compete with for say Microsoft or google or adobe, best buy, etc, then I would hire a professional to do it for me or take high end website design courses, which I am taking dreamweaver in college, but that's TO. I am a single man company just trying to set up a website and I was just wondering how to make the page center according to the width of the web browser similar to what google does on their homepage or what Microsoft does. Or also what Graham Brown suggested in the two sites he asked about if they are similar in what they do to what I am looking in regards to adjusting the page in accordance to the width of the web browser. Mike Wohlrab Computer Technology Solutions 585-944-3823 [EMAIL PROTECTED] www.ComputerTechnologySolutions.org FTP://MikeWohlrab.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ed Leafe Sent: Saturday, June 16, 2007 10:31 PM To: [EMAIL PROTECTED] Subject: Re: [NF] Need help with website design On Jun 16, 2007, at 10:13 PM, Mike Wohlrab wrote: I need your help with a small problem I have while designing my website. The problem is that whenever the page is displayed it shows the page onto the left side of the web browser. Does anyone know how to change it so that anytime the website is displayed on the users' computer browser it is centered? I am using Microsoft Publisher from Office 2007. Thanks for any of your help. div style=text-align: center; How hard is that? Maybe you need to use something simpler, like a text editor? Or a simple CSS editor? -- Ed Leafe -- http://leafe.com -- http://dabodev.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[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] Any .NET SMTP gurus out there?
Hi From what I can gather the standard mail uses an SMTP server of localhost if it is not set within code. The example the hosting company sent me back is using mail.smtpserver=127.0.0.1 So need to work out if they can give me back localhost or whether I need to change the pages to hardwire the 127.. address. Regards Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Graham Dobson Sent: 12 June 2007 17:11 To: ProFox Email List Subject: RE: [NF] Any .NET SMTP gurus out there? Could it have to do with not having a mail box set up on the new web server? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Graham Brown (CompSYS) Sent: Monday, June 11, 2007 10:16 AM To: ProFox Email List Subject: [OT] Any .NET SMTP gurus out there? Hi all Totally OT I know and probably a bit of a swear word on this forum!! I've just inherited an ASP.NET (c#) app. The customer has just moved the hosting and now it won't send emails. There are no obvious error messages, it seems to go through but the emails never arrive. The code hasn't changed and I can't see anywhere the application is sending any sort of authentication. It just uses the standard built in SMTMail object. My guess is that the new hosts have their mailserver locked down to prevent spam but I don't know, and of course the new webhosts have washed their hands of it!! Could anyone point me in the general direction of any troubleshooting guides or give me any sort of pointers? Cheers Graham [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.
[OT] Any .NET SMTP gurus out there?
Hi all Totally OT I know and probably a bit of a swear word on this forum!! I've just inherited an ASP.NET (c#) app. The customer has just moved the hosting and now it won't send emails. There are no obvious error messages, it seems to go through but the emails never arrive. The code hasn't changed and I can't see anywhere the application is sending any sort of authentication. It just uses the standard built in SMTMail object. My guess is that the new hosts have their mailserver locked down to prevent spam but I don't know, and of course the new webhosts have washed their hands of it!! Could anyone point me in the general direction of any troubleshooting guides or give me any sort of pointers? Cheers Graham ___ 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.
###### installshield 1606 errors !!
Hi all I don't know if anyone else gets these but I now have three brand new Dell machines which are all currently standalone (not on domain yet) running xp pro. When I try to install my vfp 8 app on these these machines I get the dreaded 1606 location not found error. According to KB this means that I have a duff drive letter in the registry for Shell folders. I've checked these and some aren't set to anything but all the other ones are pointing to c: which is correct. In this instance I've manually copied MSVCR70 and the common files/vfp. When I then ran the app I got a missing language support file (RENU?) which was there but never mind. I then ran the install again and it worked. I don't understand where the problem is but obviously can't be visiting every site to install my applications as I'd never get any work done. Has anyone found a reason/fix for this? Regards Graham ___ 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.
[OT] Any C++ programmers out there?
Hi all I've been asked if I can assist another programmer with some C++ code (which I can't) Does anyone fancy doing some consultancy work for the chap? If so please email me off list and I'll put you in touch. Cheers Graham Brown CompSYS Software Solutions Telephone: 0870 753 8480 General fax: 0870 753 8490 Support fax: 0845 009 4480 Mobile: 07973 988939 email: [EMAIL PROTECTED] web: http://www.compsys.co.uk CompSYS is a member of the BNI (Business Network International). If you'd like to know how the BNI could grow your business or would like to visit one of the weekly meetings held throughout the area, please let me know. IMPORTANT: This email (including all attachments) is confidential and may be privileged. It may only be read, copied and used by the intended recipients. If you are not the intended recipient, you should not disseminate, distribute or copy this email. Please notify the sender immediately and delete this email from your system. The security and reliability of emails is not guaranteed. Verification should be sought from a mailed or faxed copy. Whilst we operate anti-virus programmes, emails can become infected after being transmitted. You should therefore take full responsibility for virus checking. --- StripMime Report -- processed MIME parts --- multipart/related multipart/alternative text/plain (text body -- kept) text/html image/jpeg --- ___ 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.
Self referencing joins
Hi all I have a bit of problem with a system which I can't get my head around and wonder if anyone can do me a sanity check. What I have is two tables arranged in header/detail fashion. The key field between the two is a job number Header table stru is for the sake of argument Jobno Product to be made Qty required Detail stru is Jobno Item number Product to be issued Qty to be issued Child job Child job refers to a sub assembly job. So to make a computer (assuming I'm going to make a monitor!) I have Job1, product is Computer, Qty 1 The details for this job are J1, Item 1, Monitor,1 required, Child J4 which shows how to make a monitor J1, Item 2, Keyboard, 1, No child job J1, Item 3, Mouse, 1, No child job J1, Item 4, Tower, 1, Child job J12 J4 Header has Monitor,1, J4 Details has J4, Item 1, Monitor Case, 1, no child J4, Item 2, Buttons, 4, no child J4, Item 3, TFT Panel, 1, no child J12 header would then have Tower, 1 J12 details J12, Item 1, Case, 1, no child J12,Item 2, MB, 1 Child job J14 J14 would then drill down onto the motherboard and so on With the application I can easily go 15 levels deep due to the way my customer sets up how they build things What I need to do is get this info into a cursor so I can populate a treeview with it, I currently create cursor_level1 for the children in J1 and then create another cursor for J4 then another cursor for J12 which is dog slow. I have complication that in my example above if the customer needs two computers then all qtys underneath must be multiplied by 2. However if it is one computer with 2 monitors then I'll need 2 monitor cases and 8 buttons. This quantity ripples all the way down 15 levels or however many. Could anyone assist with an SQL statement to show the hierachy in a cursor. Cheers Graham Graham Brown CompSYS Software Solutions Telephone: 0870 753 8480 General fax: 0870 753 8490 Support fax: 0845 009 4480 Mobile: 07973 988939 email: [EMAIL PROTECTED] web: http://www.compsys.co.uk CompSYS is a member of the BNI (Business Network International). If you'd like to know how the BNI could grow your business or would like to visit one of the weekly meetings held throughout the area, please let me know. IMPORTANT: This email (including all attachments) is confidential and may be privileged. It may only be read, copied and used by the intended recipients. If you are not the intended recipient, you should not disseminate, distribute or copy this email. Please notify the sender immediately and delete this email from your system. The security and reliability of emails is not guaranteed. Verification should be sought from a mailed or faxed copy. Whilst we operate anti-virus programmes, emails can become infected after being transmitted. You should therefore take full responsibility for virus checking. --- StripMime Report -- processed MIME parts --- multipart/related multipart/alternative text/plain (text body -- kept) text/html image/jpeg --- ___ 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: Self referencing joins
Hi Thanks! Yep. This is effectively what I'm doing with the cursors. Was trying to work out if I can do this another way due to the speed of the thing. Regards Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ed Leafe Sent: 19 April 2007 17:33 To: ProFox Email List Subject: Re: Self referencing joins On Apr 19, 2007, at 12:30 PM, Graham Brown ((CompSYS)) wrote: With the application I can easily go 15 levels deep due to the way my customer sets up how they build things What I need to do is get this info into a cursor so I can populate a treeview with it, I currently create cursor_level1 for the children in J1 and then create another cursor for J4 then another cursor for J12 which is dog slow. I have complication that in my example above if the customer needs two computers then all qtys underneath must be multiplied by 2. However if it is one computer with 2 monitors then I'll need 2 monitor cases and 8 buttons. This quantity ripples all the way down 15 levels or however many. Could anyone assist with an SQL statement to show the hierachy in a cursor. I don't believe you can accomplish this in a single SQL statement. Probably the best approach is to use CREATE CURSOR to create the structure you want, and then run a query, appending the results to the cursor. Then iterate through all the records of the results, using the keys in those records to get all the sub-assemblies, which are then added to the main cursor, and then these records are queried for their child records. Obviously something like this lends itself to recursive calls, as long as you know that your data is sound (i.e., that it doesn't contain an assembly that contains parts that contain the original assembly). -- Ed Leafe -- http://leafe.com -- http://dabodev.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[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: To flush or not to flush, that is the question
Hi John Haven't had chance to look at 9 yet. My libraries are tried and tested on v8 so need to get some spare time to check with 9. btw the scenario I have is exactly as you say, a parameters table holding the next available number. Will look at autoincs thanks. I've put the flush code out there today so will see if this fixes the problem, like you say it is highly intermittent (twice in a year!) Will also post back in a little while when I've got some feedback. Regards -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of John Weller Sent: 06 February 2007 18:13 To: profox@leafe.com Subject: RE: To flush or not to flush, that is the question How are you generating the invoice numbers - from a table holding the next number? I had a problem like this generating primary keys using a next number table on a couple of apps. It be-devilled us for years, I couldn't find what was causing it as it seemed to be intermittent - it only went away when I upgraded and started using auto incrementing fields. Why upgrade to VFP 8, why not VFP 9? John Weller 01380 723235 07976 393631 I've got a weird problem whereby I get duplicate invoice numbers in a vfp6 native app. Does a tableupdate issue a flush at the same time? It has just duplicated today for the second time in about a year. [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 ** 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: To flush or not to flush, that is the question
Hi The code is just use optimistic ie tableupdate(.t.) The params table is one record so will stick a rlock in for good measure as well. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave Crozier Sent: 07 February 2007 17:00 To: 'ProFox Email List' Subject: RE: To flush or not to flush, that is the question Ted, I omitted to add that fact. Well expanded and amplified. Dave Crozier -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ted Roche Sent: 07 February 2007 16:53 To: profox@leafe.com Subject: Re: To flush or not to flush, that is the question On 2/7/07, Dave Crozier [EMAIL PROTECTED] wrote: On the Index table how are you locking the parameter (Next record Id) table? 99% of the time VFP will do this automatically for you but I prefer the Rlock()/Flock() manual method, that way I can be SURE of getting no duplicates. This is the ONLY time I ever use manual locking however. I'd amplify your statement a little: You MUST lock a record to ensure that VFP is reading the most current value from a table. In PK generation, this is essential and mandatory. In other places in the application, that's what conflict detection is for. -- Ted Roche Ted Roche Associates, LLC http://www.tedroche.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** 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: To flush or not to flush, that is the question
lol Cheers for that, went down lovely with supper! G. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave Crozier Sent: 07 February 2007 16:30 To: 'ProFox Email List' Subject: RE: To flush or not to flush, that is the question Graham, In a lighter vein, my mother always used to say on the question to flush or not to flush: If its yellow...let it mellow but if it's brown...then FLUSH it down!! BG Dave Crozier -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Cushing Sent: 07 February 2007 16:25 To: profox@leafe.com Subject: Re: To flush or not to flush, that is the question Graham Brown (CompSYS) wrote: btw the scenario I have is exactly as you say, a parameters table holding the next available number. I had a bit of a problem a couple of years ago with the same scenario but we had two systems accessing the parameter table. The first was our old FPD 2.6 system and the other our newer VFP7 system. It appeared that VFP was cacheing the table and could not tell that the old system had updated it, even though we were using RLOCK() then unlock etc. What I had to do to make it work was get VFP to close the table after it had got the number. It gave me a right headache with duplicate barcode numbers. :-( Peter [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 ** 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.
To flush or not to flush, that is the question
Hi all I've got a weird problem whereby I get duplicate invoice numbers in a vfp6 native app. Does a tableupdate issue a flush at the same time? It has just duplicated today for the second time in about a year. I'm in the process of upgrading this one to VFP8/CAa SQLServer so hopefully not a problem soon (Will post some interesting stuff on this one when I've got my head round it myself!) Cheers Graham Brown CompSYS Software Solutions Telephone: 0870 753 8480 General fax: 0870 753 8490 Support fax: 0845 009 4480 Mobile: 07973 988939 email: [EMAIL PROTECTED] web: http://www.compsys.co.uk CompSYS is a member of the BNI (Business Network International). If you'd like to know how the BNI could grow your business or would like to visit one of the weekly meetings held throughout the area, please let me know. IMPORTANT: This email (including all attachments) is confidential and may be privileged. It may only be read, copied and used by the intended recipients. If you are not the intended recipient, you should not disseminate, distribute or copy this email. Please notify the sender immediately and delete this email from your system. The security and reliability of emails is not guaranteed. Verification should be sought from a mailed or faxed copy. Whilst we operate anti-virus programmes, emails can become infected after being transmitted. You should therefore take full responsibility for virus checking. --- StripMime Report -- processed MIME parts --- multipart/related multipart/alternative text/plain (text body -- kept) text/html image/jpeg --- ___ 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 ** 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.
SQLServer Cursor Adapters
Hi all I'm still working through the upsize to sqlserver. The first problem I've encountered is that SQL upsized my dates to datetimes. I've changed the cursoradapter so that everywhere it mentioned a time type it now shows a date. The control source on the both textboxes and grid columns are still showing a datetime. How do I force these to just show a date? Changing the format on both to D makes no difference. I've also looked at DBSetprop but that doesn't work for ca's. Thanks! Regards Graham Brown CompSYS Software Solutions Telephone: 0870 753 8480 General fax: 0870 753 8490 Support fax: 0845 009 4480 Mobile: 07973 988939 email: [EMAIL PROTECTED] web: http://www.compsys.co.uk CompSYS is a member of the BNI (Business Network International). If you'd like to know how the BNI could grow your business or would like to visit one of the weekly meetings held throughout the area, please let me know. IMPORTANT: This email (including all attachments) is confidential and may be privileged. It may only be read, copied and used by the intended recipients. If you are not the intended recipient, you should not disseminate, distribute or copy this email. Please notify the sender immediately and delete this email from your system. The security and reliability of emails is not guaranteed. Verification should be sought from a mailed or faxed copy. Whilst we operate anti-virus programmes, emails can become infected after being transmitted. You should therefore take full responsibility for virus checking. --- StripMime Report -- processed MIME parts --- multipart/related multipart/alternative text/plain (text body -- kept) text/html image/jpeg --- ___ 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 ** 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: SQLServer Cursor Adapters
Hi Thanks Stephen Just thinking about this, isn't the basic design of a foxpro app to assign the fields to the control source and then issue a tableupdate to commit. Changing the app to native datetimes means I can't use control source for any dates as I'd have to assign the date time to a variable, cast it to a date then place this in the text.value property. Does this mean the select statement in the ca is ignoring the cursorschema property when its fetching data? VFP not being able to handle dates when talking to SQL server sounds fairly major? Sounds nasty! I was looking to have one app with two sets of CAs so it's a quick swap but that doesn't sound feasible with this? Cheers -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stephen the Cook Sent: 28 January 2007 15:49 To: 'ProFox Email List' Subject: RE: SQLServer Cursor Adapters Graham Brown (CompSYS) wrote: Hi all I'm still working through the upsize to sqlserver. The first problem I've encountered is that SQL upsized my dates to datetimes. I've changed the cursoradapter so that everywhere it mentioned a time type it now shows a date. The control source on the both textboxes and grid columns are still showing a datetime. How do I force these to just show a date? Changing the format on both to D makes no difference. I've also looked at DBSetprop but that doesn't work for ca's. Getting just the date from SQL Server = select CONVERT(VARCHAR(12), your_Column|Or_Var here, 101) That 101 is an identifier for the look of the output and it's set for a USA date look and feel. As a heads up, Fox Dates is your problem. If you convert all your fox based systems to date time columns you will be much farther along in getting this problem worked out. Stephen Russell DBA / .Net Developer Memphis TN 38115 901.246-0159 A good way to judge people is by observing how they treat those who can do them absolutely no good. ---Unknown http://spaces.msn.com/members/srussell/ -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.17.12/654 - Release Date: 1/27/2007 5:02 PM [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 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: New Report Writer?
Hi Is Cognos still around? I also saw a demo of Synaptris a few years back. Cheers -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of MB Software Solutions Sent: 27 January 2007 17:15 To: profox@leafe.com Subject: Re: New Report Writer? Stephen the Cook wrote: MB Software Solutions wrote: (F*ck your mgmt if they're dissing the Fox for no good/valid reason. I hate politics---that's why I became an independent.) Could have been a breech of security and all the customer data, and credit card details were taken. There were no details so I present a valid option. But that would be a very valid reason. I said if they had *no* good/valid reason!! -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com Work smarter, not harder, with MBSS custom software solutions! [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 ** 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.
Upsize VFP 8 application to SQL
Hi all I need to upsize my first vfp 8 application to SQL Server, the application uses cursor adapters for the local database and I have a DTS already to convert the data. I've done a lot with ASP .NET to SQL so understand connection strings etc etc. Is this just a case of swapping the ca's over to SQL server versions or are there any major gotchas? Appreciate any pointers or info to kb articles etc. Regards Graham Brown CompSYS Software Solutions Telephone: 0870 753 8480 General fax: 0870 753 8490 Support fax: 0845 009 4480 Mobile: 07973 988939 email: [EMAIL PROTECTED] web: http://www.compsys.co.uk CompSYS is a member of the BNI (Business Network International). If you'd like to know how the BNI could grow your business or would like to visit one of the weekly meetings held throughout the area, please let me know. IMPORTANT: This email (including all attachments) is confidential and may be privileged. It may only be read, copied and used by the intended recipients. If you are not the intended recipient, you should not disseminate, distribute or copy this email. Please notify the sender immediately and delete this email from your system. The security and reliability of emails is not guaranteed. Verification should be sought from a mailed or faxed copy. Whilst we operate anti-virus programmes, emails can become infected after being transmitted. You should therefore take full responsibility for virus checking. --- StripMime Report -- processed MIME parts --- multipart/related multipart/alternative text/plain (text body -- kept) text/html image/jpeg --- ___ 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 ** 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: Error Handling
Hi John erm wait window? Do you know what SQL line is being processed? Had something very similar with a barcode app and ended up having a simple fcreate/fopen, fwrite(..cSQL) fclose to work what it was doing. doesn't fox also have a set talk to file, can't recall? If you know where its failing, is the code something you can post up so we can take a look with you? Cheers -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of John Weller Sent: 05 January 2007 13:05 To: profox@leafe.com Subject: Error Handling I have an app which runs at intervals unattended overnight. It is triggered by Windows Scheduler. The error handler enters details of any error into a log and then shuts the app down by issuing a CLEAR EVENTS command which I understand to immediately return to the line following the READ EVENTS line where I have my shutdown routine. I have had an error in an SQL statement which is inside a scan which is in turn inside a FOR ENDFOR loop in a form method called by another method on the same form and I am not getting the behaviour I expect. It tries to execute the SQL statement, executes the error handling code, makes an entry into the log then appears to return to the FOR ENDFOR loop and executes the SQL statement again thus triggering the error routine again - and so on There is a log entry for every time the error occurs in the loop. I have tried tracing the code but keep getting the dreaded 'Source Not Available' when it gets to the error handling routine which is in a separate program (but still in the project). Any suggestions gratefully received. John Weller 01380 723235 07976 393631 [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 ** 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.
CABuilder for Access databases
Hi all Hope everyone had a great xmas! Does anyone know of any tools which will build ca's for tables in an Access MDB. I need to do a one off data merge between two access databases. The CABuilder tool supports VFP, SQL and Oracle. but not access. Thanks all Graham Brown CompSYS Software Solutions Telephone: 0870 753 8480 General fax: 0870 753 8490 Support fax: 0845 009 4480 Mobile: 07973 988939 email: [EMAIL PROTECTED] web: http://www.compsys.co.uk CompSYS is a member of the BNI (Business Network International). If you'd like to know how the BNI could grow your business or would like to visit one of the weekly meetings held throughout the area, please let me know. BNI Plains chapter members cover the following professions: - Graphic Design, Financial Advisor, Telecoms, Computer Hardware, Banking Services, Solicitors, Accountancy, Civil Engineers, Estate Agency, Double Glazing Specialist, Sign Maker, Painting and Decorating and Training Services. If you require any of these please let me know and I'll put you in touch. IMPORTANT: This email (including all attachments) is confidential and may be privileged. It may only be read, copied and used by the intended recipients. If you are not the intended recipient, you should not disseminate, distribute or copy this email. Please notify the sender immediately and delete this email from your system. The security and reliability of emails is not guaranteed. Verification should be sought from a mailed or faxed copy. Whilst we operate anti-virus programmes, emails can become infected after being transmitted. You should therefore take full responsibility for virus checking. --- StripMime Report -- processed MIME parts --- multipart/related multipart/alternative text/plain (text body -- kept) text/html image/jpeg --- ___ 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 ** 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: CABuilder for Access databases (Graham Brown (CompSYS))
Hi Garry Not sure, The data is the backend to an ASP website so I'm trying to copy the data so I can install the updates which consists of loads of new fields. Have been playing around with remote views all day but can't get them to update the mdb even though I have a primary key set. Will have a play. Cheers -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Garry Bettle Sent: 29 December 2006 15:53 To: profox@leafe.com Subject: Re: CABuilder for Access databases (Graham Brown (CompSYS)) On 12/29/06, Graham Brown \(CompSYS\) wrote: Hi all Hope everyone had a great xmas! Does anyone know of any tools which will build ca's for tables in an Access MDB. I need to do a one off data merge between two access databases. The CABuilder tool supports VFP, SQL and Oracle. but not access. Thanks all Graham Brown CompSYS Software Solutions Hi Graham, Could you get away with something like the following and then use CABuilder?: Getting Data from Microsoft Access in VFP: http://www.utmag.com/wconnect/wc.dll?LevelExtreme~9,7,10,1295 or How to import table structures and data from Microsoft Access to Visual FoxPro: http://support.microsoft.com/kb/260405 or MDBtoDBC Conversion Utility: http://www.inspironix.com/mdbtodbc.htm Cheers, Garry Bettle MCP, Security+, MCTS SQL 2005 --- 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 ** 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] 6GB pocket drive for $49.98 USD from Staples
Yep I was talking to the young 'uns about the good old days when we had to contend with 5 1/4 360k floppies. Seems like a life time ago doesn't it. God I'm getting old, what have I done with my life... G -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Lou Syracuse Sent: 04 December 2006 18:45 To: 'profox@leafe.com' Subject: RE: [NF] 6GB pocket drive for $49.98 USD from Staples I think the item is Staples# 608525 Listing says 3600 RPM, must be a small hard drive in there. Can you say rebate. Grrr. I hate buying things with mail-in rebates - you rarely get them. -Original Message- From: Hal Kaplan [mailto:[EMAIL PROTECTED] = Subject: [NF] 6GB pocket drive for $49.98 USD from Staples = Sheeshthis technology is getting cheaper for bigger = sizes all the time...you could have you're whole freakin' = app and database and a boat load of other stuff all on your = thumb drive! = = What'll they think of next?!? = WonkaVision ... That sounds too good to be true 'cuz last week the 1GBs were $50 and the 2GBs were $100. Is there a link? B+ HALinNY _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error please notify the originator of the message. This footer also confirms that this e-mail message has been scanned for the presence of computer viruses. Any views expressed in this message are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Merle Norman Cosmetics. [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 ** 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: File Differencing
When I were a young lad, this was a util from BlinkINC.com. I used DeltaPatch with Clipper S87 and 5.3 so the exes fit on a 5 1/4 360kb floppy disk! Now those were the days. From memory not sure if it ever supported fox exes though, the Blink website is still there so you may want to give the demo a go. Just done a quick google search for like products http://www.pocketsoft.com Didn't turn up anything else. hth Please post back with your findings, I'd certainly be interested to hear. Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tristan Leask Sent: 29 November 2006 09:14 To: profox@leafe.com Subject: File Differencing Hi Guys, Got an interesting one for you... I have got file A (original) and file B (modified original) and I want to difference these files to produce file C (difference). File C is then sent and received by another program which has a copy of file A (original). File A is to be combined with file C to produce file B (modified original). Has anyone ever done anything like this before in VFP? I'm just looking for ideas at the moment. Thanks Tristan Leask Software Developer Marine Software Ltd [EMAIL PROTECTED] www.marinesoftware.co.uk -- This email was sent to [EMAIL PROTECTED] Unless otherwise agreed expressly in writing by Marine Software Limited, this communication and attachments are to be treated as confidential and the information in it may not be used or disclosed except for the purpose for which it was sent. If you are not the intended recipient of this communication you should destroy it without copying, disclosing or otherwise using its contents. Please notify the sender immediately of the error. [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 ** 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: MAPI hell
Hi Alan I always thought MAPI was an OE thing, CDONTS for Win2k and CDOSys for Win2k3. I stopped using MAPI when my users moved to Outlook. Knowledge base articles do refer to Outlook installing MAPI though. What else has changed in your environment? What version of Windows is on the pc/TS client? Is it only when Win2k3 is involved or when Outlook is involved? Does anything in your environment still run MAPI ok? Is OE still installed? Perhaps if OE has been uninstalled might this have screwed up the MAPI control? Do you have anything locked down by antivirus software? Script blocking? Are you able to log on with full administrator rights to the domain and try the application, this may point to privilege issues? Regards Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Alan Bourke Sent: 24 November 2006 13:09 To: profox@leafe.com Subject: RE: MAPI hell I've been through all those - mine dies at the initial SignOn command. Thanks anyway. -- Alan Bourke [EMAIL PROTECTED] -- http://www.fastmail.fm - The professional email service [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 ** 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.