RE: Anyone heard of MV.Base?

2008-04-29 Thread Graham Brown (CompSYS)
riginal 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

Anyone heard of MV.Base?

2008-04-28 Thread Graham Brown (CompSYS)
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 --- S

[NF] Exists query from mySQL table

2008-04-24 Thread Graham Brown (CompSYS)
ers 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 bo

[NF] Any Ajax gurus out there please!

2008-04-16 Thread Graham Brown (CompSYS)
Http.readyState==4) { document.write(xmlHttp.responseText) } } xmlHttp.open("GET","<a rel="nofollow" href="http://www.bni-plains.co.uk/higson.asp",true">http://www.bni-plains.co.uk/higson.asp",true&l

SQL Pass Thru question

2008-04-14 Thread Graham Brown (CompSYS)
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

RE: Form off side of the screen VF6

2008-04-01 Thread Graham Brown (CompSYS)
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 s

Disable one cell in a grid

2008-04-01 Thread Graham Brown (CompSYS)
.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" .Column

RE: [OT] Red Light Cameras work too well

2008-03-31 Thread Graham Brown (CompSYS)
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

RE: Which version of Vista for Fox

2008-03-31 Thread Graham Brown (CompSYS)
raham -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 >

Which version of Vista for Fox

2008-03-30 Thread Graham Brown (CompSYS)
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 Referr

RE: Getting at Excel data from VFP

2008-03-28 Thread Graham Brown (CompSYS)
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 suggest

RE: [OT] Smart ForTwo by Mercedes

2008-03-26 Thread Graham Brown (CompSYS)
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

RE: Any Quickbooks experts out there?

2008-03-26 Thread Graham Brown (CompSYS)
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

RE: Any Quickbooks experts out there?

2008-03-26 Thread Graham Brown (CompSYS)
] 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. > T

Any Quickbooks experts out there?

2008-03-26 Thread Graham Brown (CompSYS)
need to buy for them. 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

RE: [NF] PDF to DOC

2008-03-25 Thread Graham Brown (CompSYS)
Hi I downloaded this http://www.bluesquad.com/uk/prod.php?pid=1185&tr1=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 Pau

RE: [NF] Unix webhosting - directory password protection

2008-03-19 Thread Graham Brown (CompSYS)
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. > -- Ted Ro

[NF] Unix webhosting - directory password protection

2008-03-19 Thread Graham Brown (CompSYS)
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 Or

RE: Getting at Excel data from VFP

2008-03-17 Thread Graham Brown (CompSYS)
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

RE: Getting at Excel data from VFP

2008-03-16 Thread Graham Brown (CompSYS)
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 20

RE: Getting at Excel data from VFP

2008-03-15 Thread Graham Brown (CompSYS)
Hi What about this on technet? http://www.microsoft.com/technet/scriptcenter/resources/officetips/jun05/tip 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

RE: Getting at Excel data from VFP

2008-03-14 Thread Graham Brown (CompSYS)
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

RE: [NF] Search Engine Ranking Software

2008-03-05 Thread Graham Brown (CompSYS)
un 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 Subje

RE: [NF] Search Engine Ranking Software

2008-03-03 Thread Graham Brown (CompSYS)
CTED] [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 a

[NF] Search Engine Ranking Software

2008-03-03 Thread Graham Brown (CompSYS)
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 Or

Tapi Intro

2008-01-30 Thread Graham Brown (CompSYS)
s 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 Ma

RE: [NF] charges on my bank card.

2008-01-21 Thread Graham Brown (CompSYS)
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 !

RE: interactivechange

2008-01-17 Thread Graham Brown (CompSYS)
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

Gantt Chart Source

2008-01-16 Thread Graham Brown (CompSYS)
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

RE: combo box: How to undo changes ???

2008-01-15 Thread Graham Brown (CompSYS)
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

Cursor Adapters and autoinc field in vfp 8

2008-01-08 Thread Graham Brown (CompSYS)
SelectCMDFilter="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

RE: [OT] computer job ads, then and now

2008-01-02 Thread Graham Brown (CompSYS)
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.

RE: vfp9 report question - blank lines in the ASCII text file

2007-12-24 Thread Graham Brown (CompSYS)
I don't know if this helps but way back when I were a lad, blank lines in dos report files were caused by overlapping fields. Could I suggest creating a simpler version of your report and see if that works. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ro

Sub Reports/Joining two reports together

2007-12-23 Thread Graham Brown (CompSYS)
ctors 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 Messag

RE: Refox-concept for CHM?

2007-12-20 Thread Graham Brown (CompSYS)
--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 c

RE: Refox-concept for CHM?

2007-12-20 Thread Graham Brown (CompSYS)
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 ha

Recommendations for UK based touch screens.

2007-12-19 Thread Graham Brown (CompSYS)
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

RE: outlook e-mail help

2007-12-19 Thread Graham Brown (CompSYS)
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

RE: [OT] ? about one

2007-12-10 Thread Graham Brown (CompSYS)
"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 underlyi

RE: [OT] ? about one

2007-12-10 Thread Graham Brown (CompSYS)
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 on

RE: [OT] ? about one

2007-12-10 Thread Graham Brown (CompSYS)
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: [EM

[OT] Finding new business

2007-12-05 Thread Graham Brown (CompSYS)
ons 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 Sol

RE: [NF] Audio Files on Web Page

2007-12-04 Thread Graham Brown (CompSYS)
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

[NF] .Net Crystal Reports

2007-11-24 Thread Graham Brown (CompSYS)
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@leaf

RE: [NF] Deploying a .NET application with Installshield

2007-11-23 Thread Graham Brown (CompSYS)
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.

[NF] Deploying a .NET application with Installshield

2007-11-22 Thread Graham Brown (CompSYS)
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 Organis

RE: Getting a Dropdown List to "loop"

2007-11-22 Thread Graham Brown (CompSYS)
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, ;

RE: setting a form to autocenter based on a condition

2007-11-22 Thread Graham Brown (CompSYS)
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

[OT] Our fantastic government

2007-11-21 Thread Graham Brown (CompSYS)
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 Nat

RE: [OT] Joke

2007-11-17 Thread Graham Brown (CompSYS)
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 ?

RE: [NF] any PHP4 gurus out there?

2007-11-16 Thread Graham Brown (CompSYS)
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

RE: [NF] any PHP4 gurus out there?

2007-11-16 Thread Graham Brown (CompSYS)
ECTED] 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: > What happens if you change this to: or if you want to be finicky, 104857600? S

RE: [NF] Sage question (mainly for UK guys)

2007-11-16 Thread Graham Brown (CompSYS)
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_l

RE: [NF] any PHP4 gurus out there?

2007-11-16 Thread Graham Brown (CompSYS)
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 a

[NF] any PHP4 gurus out there?

2007-11-16 Thread Graham Brown (CompSYS)
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

RE: Explorer at 99% utilisation

2007-11-08 Thread Graham Brown (CompSYS)
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 thi

RE: Explorer at 99% utilisation

2007-11-08 Thread Graham Brown (CompSYS)
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 Nove

Explorer at 99% utilisation

2007-11-08 Thread Graham Brown (CompSYS)
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 g

[NF] Outlook Calendar

2007-11-07 Thread Graham Brown (CompSYS)
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. B

RE: Ideas for trial versions

2007-10-25 Thread Graham Brown (CompSYS)
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

RE: [NF] Animated GIFs

2007-10-23 Thread Graham Brown (CompSYS)
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

RE: [NF] Ordnance survey maps x/y coordinates

2007-10-16 Thread Graham Brown (CompSYS)
Email List' Subject: RE: [OT] Ordnance survey maps x/y coordinates Graham, Shouldn't really be [OT] as other developers may be interested. I'd make it [NF] Dave Crozier -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Graham Brown (Co

[OT] Ordnance survey maps x/y coordinates

2007-10-15 Thread Graham Brown (CompSYS)
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

RE: Reporting differences on HP Laser

2007-10-03 Thread Graham Brown \(CompSYS\)
u tried setting the Print area to "Whole Page" as opposed to Printable Page in the Report Designer File/Page Setup options? Dave Crozier -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Graham Brown (CompSYS) Sent: 03 October 2007 11:42 To:

RE: Reporting differences on HP Laser

2007-10-03 Thread Graham Brown \(CompSYS\)
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 landscap

Reporting differences on HP Laser

2007-10-03 Thread Graham Brown \(CompSYS\)
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 somethin

FW: Highlighting item in a treeview

2007-10-01 Thread Graham Brown (CompSYS)
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 mo

RE: DBFs disappearing when PACKing

2007-09-28 Thread Graham Brown \(CompSYS\)
ng 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

RE: [NF] How to Open CAB File

2007-09-25 Thread Graham Brown \(CompSYS\)
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 comp

RE: DBFs disappearing when PACKing

2007-09-25 Thread 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. 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

RE: DBFs disappearing when PACKing

2007-09-25 Thread Graham Brown \(CompSYS\)
007 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) > Sen

RE: DBFs disappearing when PACKing

2007-09-25 Thread Graham Brown \(CompSYS\)
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 Busi

Highlighting item in a treeview

2007-09-21 Thread Graham Brown \(CompSYS\)
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

RE: All Computers on Network Lock up

2007-08-25 Thread Graham Brown (CompSYS)
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:[EMAI

[OT] From a grateful nation...

2007-07-31 Thread Graham Brown \(CompSYS\)
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)

RE: VFP9-CRM

2007-07-26 Thread Graham Brown \(CompSYS\)
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 t

RE: [NF] Moving files off a laptop for an ex-employee

2007-07-24 Thread Graham Brown \(CompSYS\)
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 na

RE: VFP / SQL Performance and Configuration

2007-07-19 Thread Graham Brown \(CompSYS\)
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 us

RE: Slow load of runtimes

2007-07-19 Thread Graham Brown \(CompSYS\)
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 ... Gil > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Gra

RE: Slow load of runtimes

2007-07-19 Thread Graham Brown \(CompSYS\)
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 swit

RE: Trapping system date change.

2007-07-03 Thread Graham Brown \(CompSYS\)
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 h

RE: Trapping system date change.

2007-07-03 Thread Graham Brown \(CompSYS\)
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] O

RE: Trapping system date change.

2007-07-03 Thread Graham Brown \(CompSYS\)
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. A

RE: SQL Server Import Small Date Time

2007-06-26 Thread Graham Brown \(CompSYS\)
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

SQL Server Import Small Date Time

2007-06-26 Thread Graham Brown \(CompSYS\)
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

RE: [NF] Need help with website design

2007-06-18 Thread Graham Brown \(CompSYS\)
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 feature for my website

2007-06-17 Thread Graham Brown \(CompSYS\)
Do you mean like www.compsys.co.uk or www.ecurie25dev.co.uk ? Cheers -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mike Wohlrab Sent: 17 June 2007 03:24 To: profox@leafe.com Subject: [NF] Need help with feature for my website Hello all, I need your

RE: [NF] Any .NET SMTP gurus out there?

2007-06-12 Thread Graham Brown \(CompSYS\)
th 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

[OT] Any .NET SMTP gurus out there?

2007-06-11 Thread Graham Brown \(CompSYS\)
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 chang

###### installshield 1606 errors !!

2007-05-18 Thread Graham Brown \(CompSYS\)
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

RE: Self referencing joins

2007-04-19 Thread Graham Brown \(CompSYS\)
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

Self referencing joins

2007-04-19 Thread Graham Brown \(CompSYS\)
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

[OT] Any C++ programmers out there?

2007-04-19 Thread Graham Brown \(CompSYS\)
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 7

RE: To flush or not to flush, that is the question

2007-02-07 Thread Graham Brown \(CompSYS\)
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 t

RE: To flush or not to flush, that is the question

2007-02-07 Thread Graham Brown \(CompSYS\)
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' Subje

RE: To flush or not to flush, that is the question

2007-02-07 Thread Graham Brown \(CompSYS\)
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 ther

To flush or not to flush, that is the question

2007-02-06 Thread Graham Brown \(CompSYS\)
opefully 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 P

RE: SQLServer Cursor Adapters

2007-01-28 Thread Graham Brown \(CompSYS\)
ject: 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

SQLServer Cursor Adapters

2007-01-28 Thread Graham Brown \(CompSYS\)
rid 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:

RE: New Report Writer?

2007-01-27 Thread Graham Brown \(CompSYS\)
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 wro

  1   2   >