RE: VFP(9) to ACT!

2007-08-22 Thread Dave Crozier
Sytze,
If you are using ACT V6 up to ACT 2000 then the databases were certainly dbf
files but generated using Codebase. In certain circumstances I think
Codebase removed the 254 field limit in a table hence becoming non standard
and I think they actually name tables as .dat files if I'm not mistaken.

Also the fields are simply numbered such as Field_1, Field_2 etc as they
use an internal data dictionary for user defined fields - yet another
problem!

The indexes certainly are non standard so you can't do anything with them
which could cause problems when finding information as a lot of it is pseudo
encrypted.

I only did data transfer one way ACT into VFP and did this using the export
feature which is really quirky. However if you want to go the other way
(which is what I assume) then you may need to go onto the Codebase site and
see if they have an SDK.

Dave Crozier


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Sytze de Boer
Sent: 22 August 2007 06:09
To: profox@leafe.com
Subject: VFP(9) to ACT!

I need to run a VFP app and connect to a ACT! database to sync client
information.
Is there anyone here who is familiar with this program ?

At one time, I thought ACT! was based on dbf formats and I opened my
big mouth and announced at a meeting that I could access the
data..

Please help me out of the hole !

Sytze


[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(9) to ACT!

2007-08-22 Thread Sytze de Boer
Hi Dave, thanks for that
It is in fact ACT! Version 9 and I think data is in a PAD file
It seems a hopeless task
Version 9 won't even import it's own ACT! Version 6 or 7 files
Sytze


On 8/22/07, Dave Crozier [EMAIL PROTECTED] wrote:
 Sytze,
 If you are using ACT V6 up to ACT 2000 then the databases were certainly dbf
 files but generated using Codebase. In certain circumstances I think
 Codebase removed the 254 field limit in a table hence becoming non standard
 and I think they actually name tables as .dat files if I'm not mistaken.

 Also the fields are simply numbered such as Field_1, Field_2 etc as they
 use an internal data dictionary for user defined fields - yet another
 problem!

 The indexes certainly are non standard so you can't do anything with them
 which could cause problems when finding information as a lot of it is pseudo
 encrypted.

 I only did data transfer one way ACT into VFP and did this using the export
 feature which is really quirky. However if you want to go the other way
 (which is what I assume) then you may need to go onto the Codebase site and
 see if they have an SDK.

 Dave Crozier


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
 Of Sytze de Boer
 Sent: 22 August 2007 06:09
 To: profox@leafe.com
 Subject: VFP(9) to ACT!

 I need to run a VFP app and connect to a ACT! database to sync client
 information.
 Is there anyone here who is familiar with this program ?

 At one time, I thought ACT! was based on dbf formats and I opened my
 big mouth and announced at a meeting that I could access the
 data..

 Please help me out of the hole !

 Sytze


[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: FormSet ???

2007-08-22 Thread Allen
Thanks Paul. I was using the if you cant say something nice, don’t say
anything (nearly anything) method
:)
Allen 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Paul Newton
Sent: 22 August 2007 02:21
To: [EMAIL PROTECTED]
Subject: Re: FormSet ???

Allen

Congratulations on the most most succinct reply ever posted in response to a
non-trivial question.  Your economy of words elevates brevity to the level
of terseness.

g

Paul Newton

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.484 / Virus Database: 269.12.1/965 - Release Date: 21/08/2007
16:02
 



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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: [JOB] Outsourced to Mexico

2007-08-22 Thread Allen
Depends on the size of the catch :)
Allen 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Pete Theisen

How much does a .net developer get in Mexico?
--
Regards,

Pete
http://www.pete-theisen.com/


No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.484 / Virus Database: 269.12.1/965 - Release Date: 21/08/2007
16:02
 



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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: FormSet ???

2007-08-22 Thread Andy Davies
I use tabs - just as old hat but not as complicated as formsets g

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.

**



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: VFP(9) to ACT!

2007-08-22 Thread Brian Abbott
Sytze

There is an SDK which will enable what you want.  However you have to be 
in the Sage Dev program ($$) to get it ...

Sytze de Boer wrote:
 Hi Dave, thanks for that
 It is in fact ACT! Version 9 and I think data is in a PAD file
 It seems a hopeless task
 Version 9 won't even import it's own ACT! Version 6 or 7 files


-- 
Cheers


Brian Abbott



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: FormSet ???

2007-08-22 Thread Paul Newton
Dave Crozier wrote:
 Paul,
 I don’t really grasp Al's feelings on the matter. Maybe you could précis it
 for others on the group.

 Dave Crozier
   
Certainly Dave. Unfortunately, Allen's reply was not only brief to the 
point of terseness but terse to the point of ambiguity. The question 
was: is it a formset good or not ?. Like all OR questions, this is 
really two questions:

Is it good ?
Is it not good ?

Allens respone of No could have referred to either of these questions, 
but not both, and, depending on which of the two questions he was 
answering, would convey opposite opinions.

However there is the addded problem facing the reader when trying to 
tease the meaning out of the reply to a question framed in the negative. 
Consider the example

Is is not good ?

This can be answered, and the answers interpreted as follows

YES, it is not good - meaning agreement with the assertion implied 
in the question, ie the response means it is not good
NO, it is not good - meaning disagreement with the assertion implied 
in the question, ie the response means it is good.

There are two lessons to be learned here:

1. Do not frame questions in the negative
2. Do not give either a YES or a NO answer in response to an OR 
question.

HTH gdr

Paul





___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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: FormSet ???

2007-08-22 Thread Allen
Ok ok can I add one more letter to the reply.
t
:)
Allen 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Paul Newton

Is it good ?
Is it not good ?

Allens respone of No could have referred to either of these questions, but
not both, and, depending on which of the two questions he was answering,
would convey opposite opinions.

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.484 / Virus Database: 269.12.1/965 - Release Date: 21/08/2007
16:02
 



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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: FormSet ???

2007-08-22 Thread Jean Laeremans
On 8/22/07, Allen [EMAIL PROTECTED] wrote:
 Ok ok can I add one more letter to the reply.
 t
 :)
 Allen

Please don't be too generous Al...and btw shouldn't it have been 'non' now ?

A+
jml


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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: FormSet ???

2007-08-22 Thread Dave Crozier
Andy,
We are not discussing your involvement with hallucinogenic substances in the
60's here BG

Dave Crozier

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Andy Davies
Sent: 22 August 2007 10:37
To: profox@leafe.com
Subject: Re: FormSet ???

I use tabs - just as old hat but not as complicated as formsets g

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: Missing Parameters in Main.prg

2007-08-22 Thread Garry Bettle
On 8/22/07, Dave Crozier wrote:
 Gary,
 Scrap that,
 I meant:
  Program Param1||Param2||Param3

 Just be careful you don't have spaces in the parameters and parse the string
 using Getwordcount()and Getwordnum() with the terminating parameter ||

 I wasn't thinking in the first example!

 Dave Crozier

Hi Dave,

Essentially I'm trying to make my program generic, in the sense that
the user can run it manually and select options on the main form.  Or,
they can run it scheduled in a DOS batch file, with options coming in
via the parameter line.  i.e. myprogram 123456879 /Option1 /Option2
... /Optionn.

Should I be doing this another way?  Like with an *.ini file?

It also seems strange that if I remove the / from in front of an
Option, it comes into the program  ok - first in Main.prg, then into
the form via it's Init method.

Cheers,

Garry


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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: FormSet ???

2007-08-22 Thread Allen
You just cant win can you :)
Allen 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Jean Laeremans

Please don't be too generous Al...and btw shouldn't it have been 'non' now ?


No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.484 / Virus Database: 269.12.1/965 - Release Date: 21/08/2007
16:02
 



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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: Missing Parameters in Main.prg

2007-08-22 Thread Garry Bettle
On 8/22/07, Gianni Turri wrote:
 Hi Garry,

 are you sure?

 I have created a shortcut to MyProgram.exe and added the following parameters:
 12345678 /Option1 /Option2

 The messagebox displays

 tcMarketId = 12345678, tcParam1 = /Option1, tcParam2 = /Option2, tcParam3 = 
 .F.

 Gianni

Hi Gianni,

Thanks for your reply.

I wouldn't be running the form from a shortcut - it could be scheduled
to run at a certain time inside a batch file or at the command line.

Cheers,

Garry


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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.


codeplex

2007-08-22 Thread Al
Hi foxgang
Anyone used the codeplex stuff. There seems to be some neat bits there but
very sadly lacking in how to use them.
Im looking at two items. The desktop alerts and the outlook bar. Both look
useful but there seems not much other than the downloads there. Also the
forum, such as it is, is in disarray. There seems no order and all projects
are thrown in the same bowl.
Anyway first things first. Anyone tried the desktop alerts and have a quick
start I can see.
Allen

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.484 / Virus Database: 269.12.1/965 - Release Date: 21/08/2007
16:02
 



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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: [JOB] Outsourced to Mexico

2007-08-22 Thread Stephen the Cook
MB Software Solutions  wrote:

 
 With all due respecthow many gigs do you go through in a year on
 average?  Man, you must really make the dough going through them like
 you do!  

This was a 3 month gig and the prior one was 3 and it went 5.  This is .NET
were we get the stuff completed.  ;-

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.484 / Virus Database: 269.12.1/963 - Release Date: 8/20/2007
5:44 PM
 




___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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: FormSet ???

2007-08-22 Thread Paul Newton
Allen wrote:
 You just cant win can you :)
   

We can, you can't !

Paul

 Allen 

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
 Behalf Of Jean Laeremans

 Please don't be too generous Al...and btw shouldn't it have been 'non' now ?


 No virus found in this outgoing message.
 Checked by AVG Free Edition. 
 Version: 7.5.484 / Virus Database: 269.12.1/965 - Release Date: 21/08/2007
 16:02
  



[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: [JOB] Outsourced to Mexico

2007-08-22 Thread Stephen the Cook
Pete Theisen  wrote:
 On Tuesday 21 August 2007 14:16, [EMAIL PROTECTED] wrote:
 Looks like a new Director and fiscal year means that all .NET
 development will be done in our Mexican facility from now on.
 
 Hi Stephen!
 
 How much does a .net developer get in Mexico?

I don't know if they are going to continue on with .NET?  From the
grumblings at my last meeting they are going to stay with VB6 for patches
and look to a java online application for the rewrite.  They are going to
release the ONLINE2 product in 2 or 4 weeks which was written in c for about
80% of the product.  There is some java in there.  Oh it's all based on AIX
or Linux servers.  

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.484 / Virus Database: 269.12.1/963 - Release Date: 8/20/2007
5:44 PM
 




___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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: [JOB] Outsourced to Mexico

2007-08-22 Thread Jean Laeremans
On 8/22/07, Stephen the Cook [EMAIL PROTECTED] wrote:

 I don't know if they are going to continue on with .NET?

hmmm

This is .NET were we get the stuff completed.  ;-

A+
jml


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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: Excel question

2007-08-22 Thread Jaime Vasquez
Ricardo Aráoz wrote:
 Jaime, it works! And it solves my problem.
 Only glitch is that the second 'CopyFromRecordset(loRs, 150)   copy
 next 150' does not copy the next 150 but copies the first 150 records
 again. Not a problem, I can copy my chunks of records to a cursor and
 then do a cursor at a time (rs.Delete(150) does not work either).
 
 Anyway if you can see a more elegant solution I'll appreciate it.
 Thanks for your help.
 
 Here is my test code :
 ---
 loWorkBook = loExcel.WorkBooks.Add
 loWorkBook.ActiveSheet.name = 'PrimeraHoja'
 
 loWorkBook.Worksheets(PrimeraHoja).Range('a2').CopyFromRecordSet(lors,20)
 
 loWorkBook.WorkSheets.Add(, loWorkBook.ActiveSheet)
 loWorkBook.ActiveSheet.Name = 'SegundaHoja'
 
 loWorkBook.WorkSheets(SegundaHoja).Range('a2').CopyFromRecordSet(lors,20)
 
 loWorkBook.Application.Visible = .T.
 
 
 and the same first 20 records are copied in both pages.
 So I do :
 -
 go top in MyCursor
 lors = dbf2rs('MyCursor', 'Next 20')
 
 loWorkBook = loExcel.WorkBooks.Add
 loWorkBook.ActiveSheet.name = 'PrimeraHoja'
 
 loWorkBook.Worksheets(PrimeraHoja).Range('a2').CopyFromRecordSet(lors,20)
 
 go 21 in MyCursor
 lors = dbf2rs('MyCursor', 'Next 20')
 
 loWorkBook.WorkSheets.Add(, loWorkBook.ActiveSheet)
 loWorkBook.ActiveSheet.Name = 'SegundaHoja'
 
 loWorkBook.WorkSheets(SegundaHoja).Range('a2').CopyFromRecordSet(lors,20)
 
 loWorkBook.Application.Visible = .T.
 -
 

Ricardo,

This behavior is because the recordset is a client recordset, you
can't delete records, and everytime you copy records it will start from
the beginning.

With a server recordset you can use the method I suggested of copy
records by chunks, or delete them.

You can create a server recordset converting your cursor to a temporary 
phisical table and next read it with ADO.

I thing the solution you found is the best, create a recordset with the
number of records you want to copy in every page.

I just have 2 observations:
If the recordset has the number of records you want, there's no need for
the sencond parameter in copyfromrecordset method.

The copy will be a bit faster if you set excel visible = .t. before copy
the recordset.



HTH



Saludos,
Jaime Vasquez


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Creating RSS Feed w/ VFP

2007-08-22 Thread John Harvey
Anyone written code to produce an rss feed in vfp?

John



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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]@shelbynet.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.


RES: FormSet ???

2007-08-22 Thread Ailsom F. Heringer (Osklen)
Rick,
Thank you for your reply.
I have never used formsets and I think that I will never use.
The third party software that I mentioned works very fine using formsets. 
But I think that this software has been developed since the first version of
VFP. This can be the reason why they use Formsets.
 
-- 
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

 -Mensagem original-
 De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
 Em nome de Rick Schummer
 Enviada em: terça-feira, 21 de agosto de 2007 18:18
 Para: [EMAIL PROTECTED]
 Assunto: RE: FormSet ???
 
 Aílsom,
 
 It is my understanding that formsets were originally included in VFP to
 help with the conversion of
 a FPD/FPW screen set.
 
 I believe the reputation of formsets being bad is related to the basis
 of why they were originally
 included in the product. The converter/transporter from a 2.6 app will
 use formsets and add layers
 and layers to the object hierarchy for a screen converted to a form. It
 also added a Read
 Compatibility special mode to the converted form. It really is horrible
 and a pain to deal with in
 the designer. The special Read Compatibility also makes the converted
 form behave differently than a
 normal VFP form (one such thing is the Themes property set to true will
 make objects disappear from
 the form).
 
 So are they inherently bad? Not really. Are they necessary? Not really.
 As others have said, it
 depends.
 
 I personally have not needed formsets for a few reasons.
 1) I tested the converter when learning VFP 3 and it left a bad taste
 in my mouth.
 2) I heard from gurus that formsets were evil and should not be used.
 3) I did not want the overhead of the formset when running forms since
 they are not as flexible as
 my other techniques to coordinate forms.
 
 When I need multiple forms to work together I have the forms register
 with each other and have the
 object references to make them do what the users want them to do. A
 formset can help with the
 references via the thisformset object reference.
 
 One of the disadvantages of the formset is the dependency. If you
 include a form in a formset and
 wanted to later use the form independent of the formset you have to
 bust it out, or build another
 form. It is an all or nothing deal (or you could probably write code to
 make certain forms invisible
 if needed, but why when you can have them separate?). You also have a
 new reference to thisformset
 which is not something you normally see in code. So if you decide to
 bust out the form from a
 formset you have to eliminate these references.
 
 All this said, just because a company uses formsets does not mean the
 system is bad. There are some
 frameworks out there that use the formset for an application object.
 Some advantage was determined
 by the framework designer in this regard. They could have adopted this
 framework and might be using
 it because they have to flow with the framework, or recognize some
 advantage we may not have
 considered.
 
 All this means is I would not judge the software on this alone. I am
 sure great software was
 developed that included formsets.
 
 
 Rick
 White Light Computing, Inc.
 
 www.whitelightcomputing.com
 www.swfox.net
 www.rickschummer.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: Creating RSS Feed w/ VFP

2007-08-22 Thread Ted Roche
On 8/22/07, John Harvey [EMAIL PROTECTED] wrote:

 Anyone written code to produce an rss feed in vfp?

I did, and you were at the conference in 2004 in Kansas City when I
presented it!

http://www.tedroche.com/papers.php

Code similar to what I used there went on to produce RSS feeds for
FoxCentral and the Fox wiki until they took over their own generation.

-- 
Ted Roche
Ted Roche  Associates, LLC
http://www.tedroche.com


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[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: Missing Parameters in Main.prg

2007-08-22 Thread Gianni Turri
- Original Message - 
From: Garry Bettle [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wed, 22 Aug 2007 11:30:12 +0100
Subject: Re: Missing Parameters in Main.prg

On 8/22/07, Gianni Turri wrote:
 Hi Garry,

 are you sure?

 I have created a shortcut to MyProgram.exe and added the following 
 parameters:
 12345678 /Option1 /Option2

 The messagebox displays

 tcMarketId = 12345678, tcParam1 = /Option1, tcParam2 = /Option2, tcParam3 = 
 .F.

 Gianni

Hi Gianni,

Thanks for your reply.

I wouldn't be running the form from a shortcut - it could be scheduled
to run at a certain time inside a batch file or at the command line.

Cheers,

Garry

I have created a batch file named MyProgramCmd.bat with three way to pass 
parameters:

MyProgram.exe 12345678 /Option1 /Option2
result:
tcMarketId = 12345678, tcParam1 = /Option1, tcParam2 = /Option2, tcParam3 = .F.

MyProgram.exe 12345678/Option1/Option2
result:
tcMarketId = 12345678/Option1/Option2, tcParam1 = .F., tcParam2 = .F., tcParam3 
= .F.

MyProgram.exe 12345678 /Option1 /Option2
result:
tcMarketId = 12345678 /Option1 /Option2, tcParam1 = .F., tcParam2 = .F., 
tcParam3 = .F.

Gianni


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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: codeplex

2007-08-22 Thread Rick Schummer
 There seems to be some neat bits there but very sadly lacking in how to use 
 them.
Im looking at two items. The desktop alerts and the outlook bar. Both look
useful but there seems not much other than the downloads there. Also the
forum, such as it is, is in disarray. There seems no order and all projects
are thrown in the same bowl.

Sadly lacking, hardly Al. Both the Desktop Alert and the OutlookBar (and most 
of the other projects)
have plenty of examples and the Desktop Alerts has a complete white paper 
detailing how to use them.
The white paper is available on the VFPX site:

http://www.codeplex.com/VFPX/Release/ProjectReleases.aspx?ReleaseId=3534

The OutlookBar download comes with a work-in-progress HTML Help file, and 
honestly is simple to use.

http://www.codeplex.com/VFPX/Release/ProjectReleases.aspx?ReleaseId=815 

Please note that all the work here is done on your behalf for free, based on 
the developers free
time as are most open source projects. Better yet, if you think things are 
lacking, volunteer to
help out. The entire site is a Wiki and like all Wikis, is completely open to 
your contributions.

If you are so inclined, come out to Southwest Fox 2007. Several of the project 
authors and all the
VFPX admins will be there. I am very confident that each is willing to chat 
about their projects and
contributions, and are open to your ideas on how they can be improved. I am 
also giving a session on
VFPX and show you how easy it is to implement several of the ongoing projects.

Rick
White Light Computing, Inc.

www.whitelightcomputing.com
www.swfox.net
www.rickschummer.com




___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[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.


Internet Update

2007-08-22 Thread Chris Davis
Hi,
Has anyone implemented a Check for Updates kind of thing?  Either
one just to say Yes there is an update or one which also downloads
and installs the update.
Thanks
Chris.


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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] Palm Treo experiences (and Google Calendar)

2007-08-22 Thread Whil Hentzen (Pro*)
Richard Kaye wrote:
 And let me add that browsing on any device with a screen this small 
 (leaving aside the religious experience that is the iPhone) is 
 essentially an exercise in frustration for anything other than the most 
 basic needs.

Richard, Dave,

Couldja do me a quick, 5 minute favor? If you've got a gmail account, 
use your Treo to log in Google Calendar and see if it works? I've read 
varying accounts (mytreo.net, for example) on whether Blazer will render 
google calendar at all. We can get it to sort of show up on a Mobile Web 
2.0 (Verizon Product) but it's highly limited.

I understand that it won't be like viewing on a 19 flat screen g, but 
for reference and look up purposes, it should be usable. There's even a 
'quick add' feature in google cal that allows you to type something like

   dinner w/ wife tomorrow 7 pm

and it will translate this into the correct entry. Pretty nice, actually.

But the Verizon folks are clueless (BIG surprise) and the research on 
the Web conflicts. I don't want to commit to $45/mo only to find out 
that GCal is still a work in progress. :) And I don't want to write my 
own web-based calendar app either. :( Well, I'd like to write it. I 
don't want to support it. BG

Ken: We've been playing around with using multiple calendars and it 
looks like this might be a workable (although not optimal) solution 
right now.

Essentially, each family member has their own calendar, and then you all 
share your calendars with each other. Then when you look at your 
calendar, you can see other folks events in different colors, but all on 
the same calendar.

We've found one glitch with the google cal and SMS, but this feature is 
SO limited (you can only get your own calendar's events, even if you're 
sharing other people's cals, and you can only get the next 24 hrs of 
events) that we're not even going to do any more investigation on it.

I have not looked at printing, because I'm a New Age, High Tech kind of 
guy. Me and my IBM 3270 phone, that is.

Whil



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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: [JOB] Outsourced to Mexico

2007-08-22 Thread MB Software Solutions
Jean Laeremans wrote:
 On 8/22/07, Stephen the Cook [EMAIL PROTECTED] wrote:

   
 I don't know if they are going to continue on with .NET?
 

 hmmm

 This is .NET were we get the stuff completed.  ;-

 A+
 jml
   

lol!  Talk about loading your own bullets into the gun that shoots you!  ;-)

-- 
Michael J. Babcock, MCP
MB Software Solutions, LLC
http://mbsoftwaresolutions.com
http://fabmate.com
Work smarter, not harder, with MBSS custom software solutions!



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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: FormSet ???

2007-08-22 Thread MB Software Solutions
Rick Schummer wrote:
 I also don't like the fact that the VCXs get bloat, whereas the benefit of 
 the SCXs is that they
   
 don't bloat.

 Both VCXs and SCX suffer from DBF bloat during normal development since both 
 store properties and
 code in memos. Once you do a Rebuild ALL, VFP will PACK them as they are 
 compiled. You can also PACK
 both with the Class Browser, or write a simple program to do the same.

 Or are you referring to some other kind of bloat?

   

I thought that you had to occasionally pack the VCXs but not the SCXs.  
The VCXs kept the deleted records but the SCX purged them upon saving 
every time.  I admit I didn't delve into this to prove it, but was going 
on recollections of the past.  ??I like to use the VCXs to store 
objects that I'll use in the SCXs.  ymmv.

-- 
Michael J. Babcock, MCP
MB Software Solutions, LLC
http://mbsoftwaresolutions.com
http://fabmate.com
Work smarter, not harder, with MBSS custom software solutions!



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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: Internet Update

2007-08-22 Thread MB Software Solutions
Chris Davis wrote:
 Hi,
 Has anyone implemented a Check for Updates kind of thing?  Either
 one just to say Yes there is an update or one which also downloads
 and installs the update.
 Thanks
 Chris.

   

Rick Strahl had a white paper on this several years ago.  I would have 
loved to implement it, but never got around to doing it. 

http://www.west-wind.com/presentations/wwCodeUpdate/codeupdate.asp

-- 
Michael J. Babcock, MCP
MB Software Solutions, LLC
http://mbsoftwaresolutions.com
http://fabmate.com
Work smarter, not harder, with MBSS custom software solutions!



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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: Internet Update

2007-08-22 Thread Allen
This is the same as I do. I would have liked to have found a way to beat the
problem of updates to a running prog. However it works ok as the users start
up it updates before running. Its probably better than several users all
going to the web site for updates. This way only one needs to.
Allen 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of [EMAIL PROTECTED]
Sent: 22 August 2007 16:44
To: [EMAIL PROTECTED]
Subject: RE: Internet Update

I do this by parsing the text in the download page. I look for a version
marker and compare it to the running version. 

As for the program running issue, I avoid this by using a launcher. The
download simply puts files in the Setup folder. On the next launch, files
are updated from Setup.

Henry


No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.484 / Virus Database: 269.12.1/965 - Release Date: 21/08/2007
16:02
 



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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: Internet Update

2007-08-22 Thread MB Software Solutions
[EMAIL PROTECTED] wrote:
 I do this by parsing the text in the download page. I look for a version 
 marker and compare it to the running version. 

 As for the program running issue, I avoid this by using a launcher. The 
 download simply puts files in the Setup folder. On the next launch, files are 
 updated from Setup.

   
The LOADER8 utility I posted on Ed's download's page operates similarly 
to Henry's description above.

http://leafe.com/dls/vfp


-- 
Michael J. Babcock, MCP
MB Software Solutions, LLC
http://mbsoftwaresolutions.com
http://fabmate.com
Work smarter, not harder, with MBSS custom software solutions!



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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: Internet Update

2007-08-22 Thread henry.dagher
That's what I call positive reinforcement!

Thanks, Allen and Michael for sharing your similar approaches.

Henry

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MB Software 
Solutions
Sent: 2007-08-22 10:48 AM
To: [EMAIL PROTECTED]
Subject: Re: Internet Update


[EMAIL PROTECTED] wrote:
 I do this by parsing the text in the download page. I look for a version 
 marker and compare it to the running version. 

 As for the program running issue, I avoid this by using a launcher. The 
 download simply puts files in the Setup folder. On the next launch, files are 
 updated from Setup.

   
The LOADER8 utility I posted on Ed's download's page operates similarly 
to Henry's description above.

http://leafe.com/dls/vfp


-- 
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] Palm Treo experiences (and Google Calendar)

2007-08-22 Thread Richard Kaye
I just tried this and it works after a fashion. You have to have 
javascript installed/enabled in Blazer, which can be a bit of a feat in 
itself. The first time it went to the calendar page it downloaded at 
least 1/2MB of stuff before giving me an error page indicating that the 
browser couldn't load the page so you better have that unlimited data 
plan. I followed the first suggestion there to clear the cache and poked 
at it a bit and it did bring up my calendar. Finally, it was slow but I 
find most pages in Blazer to be slow in rendering, even if designed for WAP.

Whil Hentzen (Pro*) wrote:
 Richard, Dave,

 Couldja do me a quick, 5 minute favor? If you've got a gmail account, 
 use your Treo to log in Google Calendar and see if it works? I've read 
 varying accounts (mytreo.net, for example) on whether Blazer will render 
 google calendar at all. We can get it to sort of show up on a Mobile Web 
 2.0 (Verizon Product) but it's highly limited

-- 
Richard Kaye
Vice President
Artfact/RFC Systems
Voice: 617.219.1038
Fax:  617.219.1001

For the fastest response time, please send your support
queries to:

Technical Support - [EMAIL PROTECTED]
Australian Support - [EMAIL PROTECTED]
Internet Support - [EMAIL PROTECTED]
All Other Requests - [EMAIL PROTECTED]

-
This message has been checked for viruses before sending.
-



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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] Palm Treo experiences (and Google Calendar)

2007-08-22 Thread Ted Roche
On 8/22/07, Whil Hentzen (Pro*) [EMAIL PROTECTED] wrote:

 Couldja do me a quick, 5 minute favor? If you've got a gmail account,
 use your Treo to log in Google Calendar and see if it works?

Are you using the mobile version? It's supposed to be at:
http://www.google.com/calendar/m

according to:
http://wapreview.com/blog/?p=320

Works for me.

-- 
Ted Roche
Ted Roche  Associates, LLC
http://www.tedroche.com


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: VFP(9) to ACT!

2007-08-22 Thread MB Software Solutions
Sytze de Boer wrote:
 I need to run a VFP app and connect to a ACT! database to sync client
 information.
 Is there anyone here who is familiar with this program ?

 At one time, I thought ACT! was based on dbf formats and I opened my
 big mouth and announced at a meeting that I could access the
 data..

 Please help me out of the hole !

 Sytze


   

I believe ACT! uses dBase dbf tables, iirc.  You might check Doug 
Hennig's Stonefield site, as I believe he's done integrations with ACT!

-- 
Michael J. Babcock, MCP
MB Software Solutions, LLC
http://mbsoftwaresolutions.com
http://fabmate.com
Work smarter, not harder, with MBSS custom software solutions!



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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] Palm Treo experiences (and Google Calendar)

2007-08-22 Thread Jean Laeremans
On 8/22/07, Ted Roche [EMAIL PROTECTED] wrote:
 On 8/22/07, Whil Hentzen (Pro*) [EMAIL PROTECTED] wrote:
 
  Couldja do me a quick, 5 minute favor? If you've got a gmail account,
  use your Treo to log in Google Calendar and see if it works?

 Are you using the mobile version? It's supposed to be at:
 http://www.google.com/calendar/m


Works sort of..no quick add though. (Nokia N95)

A+
jml


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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] Palm Treo experiences (and Google Calendar)

2007-08-22 Thread Richard Kaye
I have the quick add and it worked but there doesn't seem to be a way to 
edit/delete the event details after it is created.

Jean Laeremans wrote:
 Works sort of..no quick add though. (Nokia N95)

 A+
 jml
   

-- 
Richard Kaye
Vice President
Artfact/RFC Systems
Voice: 617.219.1038
Fax:  617.219.1001

For the fastest response time, please send your support
queries to:

Technical Support - [EMAIL PROTECTED]
Australian Support - [EMAIL PROTECTED]
Internet Support - [EMAIL PROTECTED]
All Other Requests - [EMAIL PROTECTED]

-
This message has been checked for viruses before sending.
-



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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.


[Fwd: FoxPro]

2007-08-22 Thread James Roark
 From a Friend of mine...
Jim
 
Jim,
 
Thanks again for your help. The client is ready to go so please let 
anyone know that this is urgent. If you have any questions, please give 
me a call.
 
 
Location: Columbus, OH
Start 8/27 or 9/4.
LOA-2 Weeks+extensions
Interviews Friday
 
Client needs someone with Visual Foxpro to do development on an existing 
application that needs modifications.
 

The Product Tracking application is written in the Microsoft Visual 
Foxpro 6 (VFP6) development tool.  Both the backend database and the GUI 
are VFP6.  The app uses all of the standard foxpro constructs such as 
forms, reports, code, etc.  I believe the qualifications/experience you 
are looking for would be VFP6 knowledge as well as experience with the 
Windows API and/or MAPI to interface with a Microsoft Outlook client.

 
 

*John Centolella*

*Technical Recruiter*

*Oxford International*

**Information Technology Consulting Services**

a division of* On Assignment*

1201 Jupiter Park Drive

Jupiter, FL 33458

 

888.842.3225 ext 2831 tel

561.277.2831 direct

561.746.4755 fax

[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]

 

www.oxfordcorp.com http://www.oxfordcorp.com/

Oxford Europe http://www.oxfordcorp.com/Europe

 

*The Right Talent. Right Now.^® *

 


This email message is for the sole use of the intended recipient(s) and may 
contain confidential and privileged information. Any unauthorized review, use, 
disclosure or distribution is prohibited. If you are not the intended 
recipient, please contact the sender by reply email and destroy all copies of 
the original message.
No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.484 / Virus Database: 269.12.2/966 - Release Date: 8/22/2007 9:05 
AM



--- StripMime Report -- processed MIME parts ---
multipart/mixed
  multipart/alternative
text/plain (text body -- kept)
text/html
  text/plain (text body -- kept)
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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] Palm Treo experiences (and Google Calendar)

2007-08-22 Thread Whil Hentzen (Pro*)
Richard Kaye wrote:
 I just tried this and it works after a fashion. You have to have 
 javascript installed/enabled in Blazer, which can be a bit of a feat in 

That was one thing that people were arguing about on the mytreo forum. :)

 itself. The first time it went to the calendar page it downloaded at 
 least 1/2MB of stuff before giving me an error page indicating that the 
 browser couldn't load the page so you better have that unlimited data 
 plan. I followed the first suggestion there to clear the cache and poked 
 at it a bit and it did bring up my calendar. Finally, it was slow but I 
 find most pages in Blazer to be slow in rendering, even if designed for WAP.

So, to confirm, what you were looking at was the full google calendar, 
not the mobile version that Ted pointed out, right?

Thanks for poking around. This is looking like a VERY expensive week 
for me g.

Whil


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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: Internet Update

2007-08-22 Thread stephen . russell
You could call your own WS where you have the app name and version # returned 
to the client.  That is compared to what they are running and you could alert 
based on a diff.

 

Then allow them to DL the update.

 

At next start up your app looks for newer version in the \update folder and 
apply if it's available.  





 Original Message 
Subject: Internet Update
From: Chris Davis [EMAIL PROTECTED]
Date: Wed, August 22, 2007 7:07 am
To: profox@leafe.com

Hi,
Has anyone implemented a Check for Updates kind of thing? Either
one just to say Yes there is an update or one which also downloads
and installs the update.
Thanks
Chris.


___
Post Messages to: 
ProFox

@leafe.com

Subscription Maintenance: 
http://leafe.com/mailman/listinfo/profox

OT-free version of 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.







--- StripMime Report -- processed MIME parts ---
text/html (html body -- converted)
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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] Palm Treo experiences (and Google Calendar)

2007-08-22 Thread Richard Kaye

Whil Hentzen (Pro*) wrote:
 That was one thing that people were arguing about on the mytreo forum. :)
   
I think I tried to do this right after I first set up my google calendar 
and had given up on it. I must have gotten it right though because it 
does work.
 So, to confirm, what you were looking at was the full google calendar, 
 not the mobile version that Ted pointed out, right?

   
No. It's the mobile version. It's my understanding that there's 
something in there that recognizes you're browsing from a mobile device 
and it routes you to the WAP pages instead of the full blown calendar. 
It basically gives you a compressed display with the date on one line 
followed by one line for each event on that day. The events are linked 
to the event detail page where I now see the changes I just made to the 
description but I do not see the very exclusive guest list.

-- 
Richard Kaye
Vice President
Artfact/RFC Systems
Voice: 617.219.1038
Fax:  617.219.1001

For the fastest response time, please send your support
queries to:

Technical Support - [EMAIL PROTECTED]
Australian Support - [EMAIL PROTECTED]
Internet Support - [EMAIL PROTECTED]
All Other Requests - [EMAIL PROTECTED]

-
This message has been checked for viruses before sending.
-



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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: Internet Update

2007-08-22 Thread MB Software Solutions
[EMAIL PROTECTED] wrote:
 You could call your own WS where you have the app name and version # returned 
 to the client.  That is compared to what they are running and you could alert 
 based on a diff.

  

 Then allow them to DL the update.

  

 At next start up your app looks for newer version in the \update folder and 
 apply if it's available.  

   

Stephen,

The values returned from the ws---is it in XML?  Alternatives besides 
XML response?

-- 
Michael J. Babcock, MCP
MB Software Solutions, LLC
http://mbsoftwaresolutions.com
http://fabmate.com
Work smarter, not harder, with MBSS custom software solutions!



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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: [JOB] Outsourced to Mexico

2007-08-22 Thread stephen . russell
The mindset for this org is micro oriented.  I say app and you could think a 
few forms.  

 

I got 4 business office apps completed in .NET that center around billing of 
customers via Credit Cards.  

 

I have an approval process that allows AR mgr to identify all new potential 
billing, the generation of all that billing, the batch process for that 
billing, The new sales contract that will kick off the generation, and the 
components configuration that are a part of the contract.

 

All of this because the Banks stated that they had to change the way CC 
information was held.  

 


 




 Original Message 
Subject: Re: [JOB] Outsourced to Mexico
From: Jean Laeremans [EMAIL PROTECTED]
Date: Wed, August 22, 2007 4:39 am
To: ProFox Email List profox@leafe.com

On 8/22/07, Stephen the Cook 
stephen.russell

@adribbers.com
 wrote:

 I don't know if they are going to continue on with .NET?

hmmm

This is .NET were we get the stuff completed. ;-

A+
jml


___
Post Messages to: 
ProFox

@leafe.com

Subscription Maintenance: 
http://leafe.com/mailman/listinfo/profox

OT-free version of 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.







--- StripMime Report -- processed MIME parts ---
text/html (html body -- converted)
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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: Internet Update

2007-08-22 Thread stephen . russell
For VFP it's soap based so you are going to receive xml.  

 

Just parse it and be done with it.

 

I'm not suggesting your delivery of updates this way!  Just the check if you 
need it. 

 


 




 Original Message 
Subject: Re: Internet Update
From: MB Software Solutions [EMAIL PROTECTED]
Date: Wed, August 22, 2007 9:18 am
To: profox@leafe.com


stephen.russell

@adribbers.com
 wrote:
 You could call your own WS where you have the app name and version # returned 
 to the client. That is compared to what they are running and you could alert 
 based on a diff.

 

 Then allow them to DL the update.

 

 At next start up your app looks for newer version in the \update folder and 
 apply if it's available. 

 

Stephen,

The values returned from the ws---is it in XML? Alternatives besides 
XML response?

-- 
Michael J. Babcock, MCP
MB Software Solutions, LLC

http://mbsoftwaresolutions.com


http://fabmate.com

Work smarter, not harder, with MBSS custom software solutions!



___
Post Messages to: 
ProFox

@leafe.com

Subscription Maintenance: 
http://leafe.com/mailman/listinfo/profox

OT-free version of 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.







--- StripMime Report -- processed MIME parts ---
text/html (html body -- converted)
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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: [JOB] Outsourced to Mexico

2007-08-22 Thread stephen . russell






 Original Message 
Subject: Re: [JOB] Outsourced to Mexico
From: MB Software Solutions [EMAIL PROTECTED]
Date: Wed, August 22, 2007 7:34 am
To: profox@leafe.com

Jean Laeremans wrote:
 On 8/22/07, Stephen the Cook 
stephen.russell

@adribbers.com
 wrote:

 
 I don't know if they are going to continue on with .NET?
 

 hmmm

 This is .NET were we get the stuff completed. ;-

 A+
 jml
 

lol! Talk about loading your own bullets into the gun that shoots you! ;-)



I am being told today that they are only hiring VB6 / VB.NET developers for the 
Micico location.  First hire count was 12.  They are going to be doing a SOA 
based system for a variety of vendor based applications.  The deatails that 
they are releasing on a daily basis seem to change a little every day.  :)

 

 







--- StripMime Report -- processed MIME parts ---
text/html (html body -- converted)
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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] Palm Treo experiences (and Google Calendar)

2007-08-22 Thread Whil Hentzen (Pro*)
Richard Kaye wrote:
 Whil Hentzen (Pro*) wrote:
 That was one thing that people were arguing about on the mytreo forum. :)
   
 I think I tried to do this right after I first set up my google calendar 
 and had given up on it. I must have gotten it right though because it 
 does work.
 So, to confirm, what you were looking at was the full google calendar, 
 not the mobile version that Ted pointed out, right?

   
 No. It's the mobile version. It's my understanding that there's 
 something in there that recognizes you're browsing from a mobile device 
 and it routes you to the WAP pages instead of the full blown calendar. 
 It basically gives you a compressed display with the date on one line 
 followed by one line for each event on that day. The events are linked 
 to the event detail page where I now see the changes I just made to the 
 description but I do not see the very exclusive guest list.

Ah. Yes, that's how I understand it too - at least, that's how I was 
explaining it to my technology impaired better 2/3rds.

You can manually navigate to the mobile page via the link that Ted 
posted earlier this morning while trying to avoid client work.

Did I just say that?

Whil


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of 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: [JOB] Outsourced to Mexico

2007-08-22 Thread MB Software Solutions
[EMAIL PROTECTED] wrote:
 I am being told today that they are only hiring VB6 / VB.NET developers for 
 the Micico location.  First hire count was 12.  They are going to be doing a 
 SOA based system for a variety of vendor based applications.  The deatails 
 that they are releasing on a daily basis seem to change a little every day.  
 :)

   
You can probably get a good deal on tacoscheap living!  gdr


-- 
Michael J. Babcock, MCP
MB Software Solutions, LLC
http://mbsoftwaresolutions.com
http://fabmate.com
Work smarter, not harder, with MBSS custom software solutions!



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Creating RSS Feed w/ VFP

2007-08-22 Thread John Harvey
Yeah, but I wasn't paying attention cause I didn't see where I would need
it, duh.G Have you got a snippet of it?

John

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Ted Roche
Sent: Wednesday, August 22, 2007 7:36 AM
To: profox@leafe.com
Subject: Re: Creating RSS Feed w/ VFP

On 8/22/07, John Harvey [EMAIL PROTECTED] wrote:

 Anyone written code to produce an rss feed in vfp?

I did, and you were at the conference in 2004 in Kansas City when I
presented it!

http://www.tedroche.com/papers.php

Code similar to what I used there went on to produce RSS feeds for
FoxCentral and the Fox wiki until they took over their own generation.

-- 
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]@shelbynet.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Internet Update

2007-08-22 Thread Derek Kalweit
 For VFP it's soap based so you are going to receive xml.

 Just parse it and be done with it.

 I'm not suggesting your delivery of updates this way!  Just the check if you 
 need it.


VFP abstracts it so you don't see the XML. Personally, my webservices
all have just 2 parameters in VFP-- inputXML and outputXML. I can then
define in my own code what should be there and handle good defaults if
it's not(i.e. mis-matched client/server versions-- very common when
you distribute software).

As for updates, I use the soap/XML converations for control, and have
a seperate 'pickup' directory for temporary compressed files for
reading/writing(http PUT commands to let the client upload). This
works very well, and we have many thousands of these conversations
take place every day world-wide now.


-- 
Derek


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Creating RSS Feed w/ VFP

2007-08-22 Thread Ted Roche
On 8/22/07, John Harvey [EMAIL PROTECTED] wrote:

 Yeah, but I wasn't paying attention cause I didn't see where I would need
 it, duh.G Have you got a snippet of it?

Yeah, in the link I sent with the last email. I guess you weren't
paying attention g

http://www.tedroche.com/papers.php

Source code, white paper and even the gratuitous graphics of
powerpoint right there on the page for you to download.

-- 
Ted Roche
Ted Roche  Associates, LLC
http://www.tedroche.com


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Creating RSS Feed w/ VFP

2007-08-22 Thread John Harvey
Dang, sorry about that. Maybe you could just go ahead and write the thing!

John

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Ted Roche
Sent: Wednesday, August 22, 2007 2:05 PM
To: profox@leafe.com
Subject: Re: Creating RSS Feed w/ VFP

On 8/22/07, John Harvey [EMAIL PROTECTED] wrote:

 Yeah, but I wasn't paying attention cause I didn't see where I would need
 it, duh.G Have you got a snippet of it?

Yeah, in the link I sent with the last email. I guess you weren't
paying attention g

http://www.tedroche.com/papers.php

Source code, white paper and even the gratuitous graphics of
powerpoint right there on the page for you to download.

-- 
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]@shelbynet.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Creating RSS Feed w/ VFP

2007-08-22 Thread John Harvey
Hey Ted,

The pinpub link is dead!

http://www.pinpub.com/media/pinpub/FT/405roche_FT04e.zip

Thanks,

JH

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Ted Roche
Sent: Wednesday, August 22, 2007 2:05 PM
To: profox@leafe.com
Subject: Re: Creating RSS Feed w/ VFP

On 8/22/07, John Harvey [EMAIL PROTECTED] wrote:

 Yeah, but I wasn't paying attention cause I didn't see where I would need
 it, duh.G Have you got a snippet of it?

Yeah, in the link I sent with the last email. I guess you weren't
paying attention g

http://www.tedroche.com/papers.php

Source code, white paper and even the gratuitous graphics of
powerpoint right there on the page for you to download.

-- 
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]@shelbynet.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: Creating RSS Feed w/ VFP

2007-08-22 Thread Ted Roche
On 8/22/07, John Harvey [EMAIL PROTECTED] wrote:
 Hey Ted,

 The pinpub link is dead!

 http://www.pinpub.com/media/pinpub/FT/405roche_FT04e.zip


Good catch. Pin Pub's dead, so that makes sense. I'll have to see if I
can dig up the original submissions. Meanwhile, there's links on that
page on my site to similar if not identical code.

-- 
Ted Roche
Ted Roche  Associates, LLC
http://www.tedroche.com


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[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: Excel question

2007-08-22 Thread Ricardo Aráoz
Jaime Vasquez wrote:
 Ricardo Aráoz wrote:
 Jaime, it works! And it solves my problem.
 Only glitch is that the second 'CopyFromRecordset(loRs, 150)   copy
 next 150' does not copy the next 150 but copies the first 150 records
 again. Not a problem, I can copy my chunks of records to a cursor and
 then do a cursor at a time (rs.Delete(150) does not work either).

 Anyway if you can see a more elegant solution I'll appreciate it.
 Thanks for your help.

 Here is my test code :
 ---
 loWorkBook = loExcel.WorkBooks.Add
 loWorkBook.ActiveSheet.name = 'PrimeraHoja'

 loWorkBook.Worksheets(PrimeraHoja).Range('a2').CopyFromRecordSet(lors,20)

 loWorkBook.WorkSheets.Add(, loWorkBook.ActiveSheet)
 loWorkBook.ActiveSheet.Name = 'SegundaHoja'

 loWorkBook.WorkSheets(SegundaHoja).Range('a2').CopyFromRecordSet(lors,20)

 loWorkBook.Application.Visible = .T.
 

 and the same first 20 records are copied in both pages.
 So I do :
 -
 go top in MyCursor
 lors = dbf2rs('MyCursor', 'Next 20')

 loWorkBook = loExcel.WorkBooks.Add
 loWorkBook.ActiveSheet.name = 'PrimeraHoja'

 loWorkBook.Worksheets(PrimeraHoja).Range('a2').CopyFromRecordSet(lors,20)

 go 21 in MyCursor
 lors = dbf2rs('MyCursor', 'Next 20')

 loWorkBook.WorkSheets.Add(, loWorkBook.ActiveSheet)
 loWorkBook.ActiveSheet.Name = 'SegundaHoja'

 loWorkBook.WorkSheets(SegundaHoja).Range('a2').CopyFromRecordSet(lors,20)

 loWorkBook.Application.Visible = .T.
 -

 
 Ricardo,
 
 This behavior is because the recordset is a client recordset, you
 can't delete records, and everytime you copy records it will start from
 the beginning.
 
 With a server recordset you can use the method I suggested of copy
 records by chunks, or delete them.
 
 You can create a server recordset converting your cursor to a temporary 
 phisical table and next read it with ADO.
 
 I thing the solution you found is the best, create a recordset with the
 number of records you want to copy in every page.
 
 I just have 2 observations:
 If the recordset has the number of records you want, there's no need for
 the sencond parameter in copyfromrecordset method.
 
 The copy will be a bit faster if you set excel visible = .t. before copy
 the recordset.
 
 
 
 HTH
 
 
 
 Saludos,
 Jaime Vasquez
 
 


Muchas gracias Jaime. Me ha venido muy bien tu ayuda.

Saludos.





___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Creating RSS Feed w/ VFP

2007-08-22 Thread Rick Schummer
 Pin Pub's dead, so that makes sense.

Understatement of the month! 

Rick
White Light Computing, Inc.

www.whitelightcomputing.com
www.swfox.net
www.rickschummer.com





___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: Creating RSS Feed w/ VFP

2007-08-22 Thread John Harvey
What are you trying to say?VBG

JH

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Rick Schummer
Sent: Wednesday, August 22, 2007 6:32 PM
To: profox@leafe.com
Subject: RE: Creating RSS Feed w/ VFP

 Pin Pub's dead, so that makes sense.

Understatement of the month! 

Rick
White Light Computing, Inc.

www.whitelightcomputing.com
www.swfox.net
www.rickschummer.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]@shelbynet.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.