RE: [NF] Delphi for PHP

2007-03-01 Thread john harvey
I didn't see any trial downloads from Borland, but here's one from NuSphere: http://www.nusphere.com/download.php.ide.htm John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Malcolm Greene Sent: Wednesday, February 28, 2007 8:58 PM To: profox@leafe.com

RE: Free Vista for UK peps

2007-03-01 Thread Adam Buckland
Nah unfortunately I allow MS to contact me (but not partners), so in this instance I might just have been slow and unlucky! On the other hand I have just won an MP3 player, which will be my father in laws birthday present sorted and with my action pack I do have more copies of vista than I need.

RE: [NF] Vista prices in UK

2007-03-01 Thread Allen
Nah I don’t want vista till it works anyway. Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andy Davies Sent: 01 March 2007 10:44 To: [EMAIL PROTECTED] Subject: [NF] Vista prices in UK ms have pretty much charged $=£ for Vista in the UK - there

RE: [NF] Delphi for PHP

2007-03-01 Thread Malcolm Greene
John, NuSphere: http://www.nusphere.com/download.php.ide.htm Thanks for the link to the NuSphere PHP IDE. I'm curious about the Delphi specific product because I'm interested in their VCL approach to componentizing PHP code. Malcolm ___ Post

ProFox List Statistics for February, 2007

2007-03-01 Thread List Administrator Account
== ProFox List Statistics February, 2007 == Total Posts: 1955 (Down 28.26% relative to January, 2007) Total [OT] Posts: 536 (Down 51.62% relative to January, 2007) Total [NF] Posts: 718 (Down 15.93%

Re: [OT] Aw-w-w-wkward!

2007-03-01 Thread Pete Theisen
On Wednesday 28 February 2007 9:28 pm, Ed Leafe wrote: Imagine being a major donor to a group that smeared someone with a bunch of lies. Then imagine having to face the victim of your smears in order to get a cushy appointment. Major Swift Boat Donor To Kerry: You're A Hero Hi

RE: [OT] Aw-w-w-wkward!

2007-03-01 Thread Adam Buckland
And QED no republican is a poser. A warmongering tosser maybe but a poser never! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pete Theisen Sent: 01 March 2007 12:29 To: ProFox Email List Subject: Re: [OT] Aw-w-w-wkward! The Swift-Boat Vet's message

[OT] Mission Accomplished!

2007-03-01 Thread Ed Leafe
We all know that the Bush family is good friends with the bin Laden family, but who would have guessed that W is working for Osama? New figures show dramatic rise in terror attacks worldwide since the invasion of Iraq http://news.independent.co.uk/world/middle_east/article2311307.ece

Re: Lack of Written Specifications

2007-03-01 Thread Ed Leafe
On Mar 1, 2007, at 3:30 AM, Andy Davies wrote: Written docs *are* verbal. I believe you mean 'oral'. - Ed verbal (adj) ... 2) oral, not written oed http://www.randomhouse.com/wotd/index.pperl?date=20010626 http://www.usaclals.org/?q=node/49 http://www.bartleby.com/68/36/6336.html

Re: Bug in VFP SQLColumns() and MySQL 5 with TEXT fields?

2007-03-01 Thread Kevin Cully
I'm working on a new project that is VFP to a MySQL back end. I'm not using views in the app, but I've created one as a quick way to access the data in development. My Text field is being returned as a memo field in VFP. I'm hitting a MySQL 5.0 install with MySQL ODBC version 3.51.12.00. Steve

Anyone using SQLXMLBulkLoad from VFP into SQL Server?

2007-03-01 Thread Alan Bourke
Doug Hennig's blog (http://doughennig.blogspot.com/2006/07/sqlxmlbulkload-rocks.html) has a sample VFP function to use it. I can't find any indication anywhere if SQLXMLBulkLoad only handles adding records, or will it update existing records based on primary key?

Re: [NF] Delphi for PHP

2007-03-01 Thread Alan Bourke
Calling it Delphi is silly, surely, if it's actually PHP? ___ Post Messages 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

Updating a table for another table

2007-03-01 Thread Tristan Leask
Ok, it's Thursday and I am having issues with my brain. I have one table (table a) which can get updated from another table of the same structure (table b). Now there are records in table A that have been changed in table B, so we want to update these records from table B and import any new

Re: Lack of Written Specifications

2007-03-01 Thread Andy Davies
verbal (adj) ... 2) oral, not written oed in full here - *see 4a* (being an adjective its meaning is defined in the context of its related noun) http://tinyurl.com/3c2nu2 Andrew Davies  MBCS CITP   - AndyD    8-)# **

Re: Updating a table for another table

2007-03-01 Thread Alan Bourke
I don't think the approach you're using is anything to do with the speed issue, unless you are not Rushmore-optimised somewhere in the process. It's more likely an antivirus or opportunistic locking thing. ___ Post Messages to: ProFox@leafe.com

Re: [NF] Delphi for PHP

2007-03-01 Thread Andy Davies
Alan said Calling it Delphi is silly, surely, if it's actually PHP? exactly Andrew Davies  MBCS CITP   - AndyD    8-)# ** This email and any files transmitted with it are confidential and intended solely for the use of

Re: Updating a table for another table

2007-03-01 Thread Andy Davies
offline views??? Andrew Davies  MBCS CITP   - AndyD    8-)# ** 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

Re: Updating a table for another table

2007-03-01 Thread Mike yearwood
Hi Tristan I have one table (table a) which can get updated from another table of the same structure (table b). Now there are records in table A that have been changed in table B, so we want to update these records from table B and import any new records. Pretty simple... A scan with a

RE: Updating a table for another table

2007-03-01 Thread Tristan Leask
Ok, it is because it is a Thursday! I had a function that was doing this and one of the parameters how the tables were linked (PK filed). Turns out I had written it using Macro expansion (). I have just changed that to a named variable () and it has sped up something wonderful! Mike, that's an

Re: Updating a table for another table

2007-03-01 Thread Andy Davies
looking at this I wondered about xmlupdategram() - which I hadn't used so I had a play - I didn't get quite the results I expected - try this cose and see if the browse is what you expect: drop table xgramtst CREATE TABLE xgramtst(key I, txt c(25)) INSERT INTO xgramtst values(1,'one') INSERT INTO

Re: [NF] Delphi for PHP

2007-03-01 Thread Malcolm Greene
Alan said Calling it Delphi is silly, surely, if it's actually PHP? Regardless it looks like an interesting product to me. Malcolm ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free

RE: Updating a table for another table

2007-03-01 Thread Dave Crozier
Andy, Looks fine to me. Just exactly what were you expecting? Records two and three get updated and are shown to be so in the XML. Dave Crozier -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andy Davies Sent: 01 March 2007 14:31 To: profox@leafe.com

Need help with VFP9 SQL JOIN subquery

2007-03-01 Thread MB Software Solutions
I know the new functionality in VFP9 SQL is cool like Oracle had where you can defined joins to subqueries, but I seem to have a flaw in my code. (see below). select v1.iid, ; v1.nMatlID, ; v1.nVendorID, ; d1.nUnitCost, d1.dActive, ; v1.cVendorSKU, ;

RE: Updating a table for another table

2007-03-01 Thread Andy Davies
Andy, Looks fine to me. Just exactly what were you expecting? Records two and three get updated and are shown to be so in the XML. Dave Crozier I get both [pending] updates shown in the xml - but in the browse, record two (the second update) has been updated - despite the tablerevert() record

Re: Bug in VFP SQLColumns() and MySQL 5 with TEXT fields?

2007-03-01 Thread MB Software Solutions
Kevin Cully wrote: I'm working on a new project that is VFP to a MySQL back end. I'm not using views in the app, but I've created one as a quick way to access the data in development. My Text field is being returned as a memo field in VFP. I'm hitting a MySQL 5.0 install with MySQL ODBC

Re: Need help with VFP9 SQL JOIN subquery

2007-03-01 Thread Andy Davies
try: select v1.iid, ; v1.nMatlID, ; v1.nVendorID, ; d1.nUnitCost, d1.dActive, ; v1.cVendorSKU, ; lu1.cCompany; FROM eiwdb!luMaterialVendors v1 ; JOIN eiwdb!luCompanies lu1 ; ON lu1.iid = v1.nMatlID ; join (select iid, nunitcost, max(dActive) from eiwdb!luMaterialVendors) d1 ; on v1.iid = d1.iid ;

Re: Need help with VFP9 SQL JOIN subquery

2007-03-01 Thread MB Software Solutions
Andy Davies wrote: try: select v1.iid, ; v1.nMatlID, ; v1.nVendorID, ; d1.nUnitCost, d1.dActive, ; v1.cVendorSKU, ; lu1.cCompany; FROM eiwdb!luMaterialVendors v1 ; JOIN eiwdb!luCompanies lu1 ; ON lu1.iid = v1.nMatlID ; join (select iid, nunitcost, max(dActive) from

RE: Updating a table for another table

2007-03-01 Thread Dave Crozier
Andy, Sorry, one of those situations where I saw what I wanted top see not what was actually there. M! Dave Crozier -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andy Davies Sent: 01 March 2007 16:53 To: profox@leafe.com Subject: RE: Updating a

RE: Updating a table for another table

2007-03-01 Thread Dave Crozier
Andy, Also if you issue an additional tablerevert() after the first update the same thing happens. The plot thickens Unless we are being really stupid here - well it is near the end of the week Dave Crozier -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf

Re: Need help with VFP9 SQL JOIN subquery

2007-03-01 Thread MB Software Solutions
Andy Davies wrote: try: select v1.iid, ; v1.nMatlID, ; v1.nVendorID, ; d1.nUnitCost, d1.dActive, ; v1.cVendorSKU, ; lu1.cCompany; FROM eiwdb!luMaterialVendors v1 ; JOIN eiwdb!luCompanies lu1 ; ON lu1.iid = v1.nMatlID ; join (select iid, nunitcost, max(dActive) from

RE: Need help with VFP9 SQL JOIN subquery

2007-03-01 Thread John Baird
You need to add the inner join to the correlated subquery. It must be a standalone query with all parts defined. -Original Message- From: MB Software Solutions [EMAIL PROTECTED] To: Profox profox@leafe.com Sent: 3/1/07 11:24 Subject: Need help with VFP9 SQL JOIN subquery I know the new

RE: Updating a table for another table

2007-03-01 Thread Dave Crozier
Andy, Of course we ARE being stupid aren't we - DOH! You need a TableRevert(.T.) to clear ALL row updates! Dave Crozier -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andy Davies Sent: 01 March 2007 16:53 To: profox@leafe.com Subject: RE: Updating a

RE: Updating a table for another table

2007-03-01 Thread Andy Davies
Unless we are being really stupid here - well it is near the end of the week Dave Crozier You're *right*!!! - - to the pub Andrew Davies  MBCS CITP   - AndyD    8-)# ** This email and any files transmitted with it

Re: Need help with VFP9 SQL JOIN subquery

2007-03-01 Thread Andy Davies
I thought when doing a MAX() function, I had to use a GROUP BY clause? yes - finger trouble - I cut deleted too much Andrew Davies  MBCS CITP   - AndyD    8-)# ** This email and any files transmitted with it are

RE: Updating a table for another table

2007-03-01 Thread Andy Davies
DOH! DOH! that's it! - I'm definitely going to the Pub! Andrew Davies  MBCS CITP   - AndyD    8-)# ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or

How to Copy (not move) Directory, Subdirectories and all files with FoxPro

2007-03-01 Thread George
Trying to Copy a Directory, all subdirectories and all files with VFP. I haven't found an API for this. Any suggestions will be greatly appreciated TIA George. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: Updating a table for another table

2007-03-01 Thread Mike yearwood
Ok, it is because it is a Thursday! I had a function that was doing this and one of the parameters how the tables were linked (PK filed). Turns out I had written it using Macro expansion (). I have just changed that to a named variable () and it has sped up something wonderful! Mike,

Re: How to Copy (not move) Directory, Subdirectories and all files with FoxPro

2007-03-01 Thread Derek Kalweit
Trying to Copy a Directory, all subdirectories and all files with VFP. I haven't found an API for this. Any suggestions will be greatly appreciated I don't think there's a VFP built-in function or a win32 function for this, but you could use VBScript's File System Object to easily do this:

Re: [OT] Mission Accomplished!

2007-03-01 Thread Pete Theisen
On Thursday 01 March 2007 7:54 am, Ed Leafe wrote: Hi Ed! Why, if any of us were to try to float such a non-sequitur you would be all over us! Not to even ask what the data really was or where it came from. Dates are awfully unspecific in the article as well. I know. We see that the study was

Report generation/preview slowness on fastest machine!

2007-03-01 Thread MB Software Solutions
VFP9 app to VFP9 backend, all data local (for demo purposes). On our 2+ old laptop (2.4Ghz?) with 256Meg RAM, it runs our reports super quick, but on a newer laptop with dual-core processors and 2GB of RAM, it takes FOREVER to generate the report preview! Same app deployed to both machines;

Re: Report generation/preview slowness on fastest machine!

2007-03-01 Thread MB Software Solutions
MB Software Solutions wrote: VFP9 app to VFP9 backend, all data local (for demo purposes). On our 2+ old laptop (2.4Ghz?) with 256Meg RAM, it runs our reports super quick, but on a newer laptop with dual-core processors and 2GB of RAM, it takes FOREVER to generate the report preview! Same

RE: How to Copy (not move) Directory, Subdirectories and files with FoxPro

2007-03-01 Thread Tracy Pearson
Declare integer MoveFile in WIN32API string@, string@ Clear cFrom = C:\TEMP\MyTestFolder\Test cTo = C:\TEMP\MyTestingFolder\Test If not Directory(cFrom) Md (cFrom + \Level2) EndIf If Directory(cTo) Rd (cTo) EndIf If not Directory(JustPath(cTo)) Md JustPath(cTo) EndIf * 1=Success,

Re: How to Copy (not move) Directory, Subdirectories and files with FoxPro

2007-03-01 Thread Derek Kalweit
On 3/1/07, Tracy Pearson [EMAIL PROTECTED] wrote: Declare integer MoveFile in WIN32API string@, string@ Tracy, the OP said copy, not move. Additionally, the MoveFile() API function has a gotcha that it can't move files between volumes(c:\ to d:\, network drives, etc.). -- Derek

How to join a local and a remote cursor?

2007-03-01 Thread Vassilis Aggelakos
Hi folks, Let's say we have a small local cursor (50 records) and we want to join it (inner join) with a big remote table (100K records). What is the best way to join these two cursors? The obvious solution Select Col1,Col2 From BigTable into cursor qrylocalCursor and then join qrylocalCursor

[NF] Ultra VNC install to remote workstation

2007-03-01 Thread Alan Lukachko
Our application is installed in various branch offices anywhere from a 2 to 6 hour drive from the head office. When I went out to the branches to install the app and train people, I also installed Ultra VNC on each server to help support the app. I didn't get a chance to install Ultra VNC on each

Re: How to Copy (not move) Directory, Subdirectories and all files with FoxPro

2007-03-01 Thread Vassilis Aggelakos
Function CopyDir Lparameters SourcePath, TargetPath *== *| Purpose.. Copies a directory with subfolders *| Author... Vaggelakos *| Created.. June 05, 2006 *| About *| Mod List.

Re: How to join a local and a remote cursor?

2007-03-01 Thread Derek Kalweit
Let's say we have a small local cursor (50 records) and we want to join it (inner join) with a big remote table (100K records). What is the best way to join these two cursors? The obvious solution Select Col1,Col2 From BigTable into cursor qrylocalCursor and then join qrylocalCursor with

Re: [OT] Mission Accomplished!

2007-03-01 Thread Michael Madigan
Not in th United States, however. New figures show dramatic rise in terror attacks worldwide since the invasion of Iraq ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version

Re: How to join a local and a remote cursor?

2007-03-01 Thread Vassilis Aggelakos
Hi Derek, Thank you for answering. A little more info on how you're joining and the end need for the cursor might be helpful for us to give you more suitable suggestions... The resulting cursor will be used as recordsource in a grid. Until now I used to download all the records from the big

Re: [NF] Ultra VNC install to remote workstation

2007-03-01 Thread Ted Roche
On 3/1/07, Alan Lukachko [EMAIL PROTECTED] wrote: Is there a way to install to the remote branch workstations without physically going out to the branch? I'd like to do the installs from the head office location. You don't mention the OS of the workstations nor the network operating system

[NF] Printers That Use Ports That Do Not Begin With COM, LPT, or USB Are Not Redirected in a Remote Desktop or Terminal Services Session

2007-03-01 Thread Alan Lukachko
We found that using Remote Desktop Connection or the Terminal Services Client under Win XP Pro SP2 to connect to and run our app in remote branches wouldn't allow us to print to our local networked printer. The printer was on a standard TCP/IP port - 192.168.22.23. We tried everything and

RE: Report generation/preview slowness on fastest machine!

2007-03-01 Thread Dave Crozier
Mike, Are the Printer Drivers the same on both machines? Dave Crozier -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MB Software Solutions Sent: 01 March 2007 19:37 To: Profox Subject: Report generation/preview slowness on fastest machine! VFP9 app to

RE: [NF] Ultra VNC install to remote workstation

2007-03-01 Thread Dave Crozier
Alan, Take a look at www.Crossloop.com I'm currently talking to them about getting a branded VFP version but it works fine without any firewall/router issues and is based on UltraVNC - and its free. Dave Crozier -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On

Southwest Fox 2007

2007-03-01 Thread Rick Schummer
Southwest Fox 2007 October 18-21, 2007 Arizona Golf Resort and Conference Center in Mesa, Arizona http://swfox.net It is our pleasure to announce the fourth annual Southwest Fox Conference, presenting the latest in Microsoft Visual FoxPro development techniques, new changes in VFP 9.0 SP2,

Re: How to Copy (not move) Directory, Subdirectories and all, files with FoxPro

2007-03-01 Thread George
Vassilis, Thank you. This should do it. Thanks again, George -- Message: 2 Date: Thu, 1 Mar 2007 22:40:33 +0200 From: Vassilis Aggelakos [EMAIL PROTECTED] Subject: Re: How to Copy (not move) Directory,Subdirectories and all files with FoxPro

Re: Report generation/preview slowness on fastest machine!

2007-03-01 Thread MB Software Solutions
Dave Crozier wrote: Mike, Are the Printer Drivers the same on both machines? Do you mean the selected printer on both laptops? It's different, if that's what you mean. The Printer Environment is NOT saved in the reports. Even when exiting the report (via the close button on the

Re: [OT] Electric Cars, let's cut off money to the middle east

2007-03-01 Thread Ricardo Aráoz
Michael Madigan wrote: Why do diesel cars require a new battery? Think it is because they have to heat a big chunk of iron so that the fuel will ignite. Gasoline cars just need a spark, no heating. --- Ricardo Aráoz [EMAIL PROTECTED] wrote: Only problem with Diesel cars is they will

Re: [OT] Mission Accomplished!

2007-03-01 Thread Michael Madigan
My point is that the fine work this administration has done has: 1. Removed Saddam as a benefactor of Palestinian terrorists 2. Has slaughtered countless Al Qaeda terrorists in Iraq. 3. Has prevented terrorists from hitting the United States again. But those countries who have failed to

Re: [OT] Mission Accomplished!

2007-03-01 Thread Ricardo Aráoz
Michael Madigan wrote: My point is that the fine work this administration has done has: 1. Removed Saddam as a benefactor of Palestinian terrorists 2. Has slaughtered countless Al Qaeda terrorists in Iraq. 3. Has prevented terrorists from hitting the United States again. But

RE: Report generation/preview slowness on fastest machine!

2007-03-01 Thread Michael Madigan
1. Try shutting off some optional items in the BIOS. 2. Verify copying to and from the server is as fast as the other computers. 3. Shut off any anti-virus programs. 4. For giggles, try changing ports on the switch --- Dave Crozier [EMAIL PROTECTED] wrote: Mike, Are the Printer

Re: Report generation/preview slowness on fastest machine!

2007-03-01 Thread MB Software Solutions
Michael Madigan wrote: 1. Try shutting off some optional items in the BIOS. Huh? 2. Verify copying to and from the server is as fast as the other computers. All local on the laptop...no server involved. 3. Shut off any anti-virus programs. Did thatno (positive) effect.

Re: [NF] Ultra VNC install to remote workstation

2007-03-01 Thread Michael Madigan
You can remote desktop into them, but you'll have to configure their router to allow port forwarding. If you can do that remotely, then you can talk them into turning on remote desktop. If you have the administrator passwords to those machines, and there's no firewall blocking the ports, you're

RE: [OT] Electric Cars, let's cut off money to the middle east

2007-03-01 Thread Adam Buckland
Sorry, but have to say that diesels do NOT require a new battery every year. Yes the battery is a larger capacity, this is because it has to preheat the glowplugs before pumping fuel etc. My company like most in the UK (since tax rules for Company cars changed) is all diesel and out of

RE: [OT] Mission Accomplished!

2007-03-01 Thread Adam Buckland
And if we'd sent troops to Iraq we'd of been OK, one minute, I'm sure I remember something in the news about the UK and Iraq Nah! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ricardo Aráoz But those countries who have failed to realize the

RE: [OT] Mission Accomplished!

2007-03-01 Thread Michael Madigan
But London has a Bolshevik Mayor who pals around with the Muslims. --- Adam Buckland [EMAIL PROTECTED] wrote: And if we'd sent troops to Iraq we'd of been OK, one minute, I'm sure I remember something in the news about the UK and Iraq Nah! -Original Message- From: [EMAIL