date:20180124


Forgive Stephen - as he now plays with the Big Boys like M$ SQL!

:-)

-K-


On 1/24/2018 5:53 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:

On 2018-01-24 15:19, Stephen Russell wrote:
I expect the update of .cdx to be at the same time that the .dbf is 
done.


223 meg is a tiny index size and reducing it down to 1/4 probably didn't
make anything faster, did it?  Now an index of  20 gig that would 
probably

be noticed if you brought it in line to only 5 gig.



VFP files can't be more than 2 GB, Stephen.


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/50f879eb-6caf-1ddd-8d28-9c4e1a4d2...@optonline.net
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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: Indexes on VFP tables--when do they get updated

2018-01-24 Thread Gene Wirchenko


At 12:21 2018-01-24, Ted Roche  wrote:

[snip]



I once worked on an app where the original developer thought it would
be a "clever" idea to define index expressions as UDFs. Yes, it's


  It seems to me that it might be useful in some very limited 
circumstances.



possible. In his UDFs, he would switch work areas, open tables if not
already opened, look up values, and then return the value, cleaning up
work areas and tables as he went. For every index definition for every
record. A reindex with more than a couple hundred records brought the
entire system to its knees.



  That does seem like a lot of unnecessary work.  Wouldn't the 
tables needed already have been open?  Or did he have SET 
ARCHITECTUREASTRONAUT ON?


[snip]

Sincerely,

Gene Wirchenko


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/6e7b9230bff28829fb9ec4becdc8f54d@mtlp84
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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: Indexes on VFP tables--when do they get updated

2018-01-24 Thread Fernando D. Bozzo

When the index is evaluated initially, VFP knows exactly what fields affect
what index, so really just affected indexes are updated.

It's easy to test it. just make an old index (IDX) on two different fields:

CREATE TABLE test (field1 C(10), field2 I)
INDEX on field1 TO test_f1 additive
INDEX on field2 TO test_f2 additive

Add some data, wait a minute, replace one of the fields and do a FLUSH
FORCE, and you will see that only the affected index changes his timestamp.

2018-01-24 23:57 GMT+01:00 :

> On 2018-01-24 15:21, Ted Roche wrote:
>
>> First off, don't do that. REPLACE (or better, UPDATE) once. Especially
>> in high network traffic situations, the amount of time it takes to
>> assemble a field and value list to issue one:
>>
>> UPDATE TableName SET  WHERE FilterCriteria
>>
>> saves an enormous amount of I/O and CPU cycles: one lock, one
>> transaction, one row re-write, one set of reindexes.
>>
>
>
> Yes, I retooled some code to replace (pun not intended) a whole bunch of
> REPLACE commands in the same area with a SCATTER to object, do the voodoo,
> then just ONE REPLACE afterwards for that very purpose.  I specifically
> listed that "multiple conditions" example thinking if I didn't, someone
> would say as you did to avoid the multiple REPLACEs.  :-)
>
>
>
>> Second, in VFP, all indexes have to be evaluated, as there's no
>> backlink to which fields are used in which expressions. Indexes are
>> defined at the table level, not the row, so can have multiple field
>> names, functions (UPPER() or DELETED(), for example), concatentations
>> or just random stuff.
>>
>
>
> So you're contending that ALL of the indexes--not just those affected by
> the field that was changed--would have to be reevaluated?
>
>
>
>> 
>> I once worked on an app where the original developer thought it would
>> be a "clever" idea to define index expressions as UDFs. Yes, it's
>> possible. In his UDFs, he would switch work areas, open tables if not
>> already opened, look up values, and then return the value, cleaning up
>> work areas and tables as he went. For every index definition for every
>> record. A reindex with more than a couple hundred records brought the
>> entire system to its knees.
>> 
>>
>
>
> YIKES  Thanks for sharing that one!
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGQ_Ju=4VNPRZZ5QXsK2iY9eY55thp4vpiO=vyrhthxwdeu...@mail.gmail.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: Indexes on VFP tables--when do they get updated

I thought that the dbf had that limit.  What if you had 25 indexes on a 50
column table.  You would probably blow out the .cdx space before the dbf.

On Wed, Jan 24, 2018 at 4:53 PM, <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> On 2018-01-24 15:19, Stephen Russell wrote:
>
>> I expect the update of .cdx to be at the same time that the .dbf is done.
>>
>> 223 meg is a tiny index size and reducing it down to 1/4 probably didn't
>> make anything faster, did it?  Now an index of  20 gig that would probably
>> be noticed if you brought it in line to only 5 gig.
>>
>
>
> VFP files can't be more than 2 GB, Stephen.
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAJidMYKDa-wVxNFxeTdVHqFf55=rya3ktvsd4tr0mehzbv+...@mail.gmail.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: Timers in VFP

Point in question is knowing what time it is now.  When you start the timer
it just keeps running till you turn it off.  If you want to know if 10 min
has transpired then it is still running for that 10 min.

On Wed, Jan 24, 2018 at 4:52 PM, <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> On 2018-01-24 15:37, Stephen Russell wrote:
>
>> I thought it was a CPU hog.  Making the call to the system for the time
>> 100,000 time in a single min.
>>
>
>
> Well that's why you have to be smart about it, Stephen, and only call it
> every X minutes.  In my case, anywhere between 5-15 minutes.  Resources
> have shown it to be not even noticeable, at least in terms of memory.
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cajidmykzjp_nilne4i8rdo82sc5rpjeghpeap7e1hvnuqro...@mail.gmail.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: Indexes on VFP tables--when do they get updated

On 2018-01-24 15:21, Ted Roche wrote:

First off, don't do that. REPLACE (or better, UPDATE) once. Especially
in high network traffic situations, the amount of time it takes to
assemble a field and value list to issue one:

UPDATE TableName SET WHERE FilterCriteria

saves an enormous amount of I/O and CPU cycles: one lock, one
transaction, one row re-write, one set of reindexes.

Yes, I retooled some code to replace (pun not intended) a whole bunch of
REPLACE commands in the same area with a SCATTER to object, do the
voodoo, then just ONE REPLACE afterwards for that very purpose. I
specifically listed that "multiple conditions" example thinking if I
didn't, someone would say as you did to avoid the multiple REPLACEs.
:-)

Second, in VFP, all indexes have to be evaluated, as there's no
backlink to which fields are used in which expressions. Indexes are
defined at the table level, not the row, so can have multiple field
names, functions (UPPER() or DELETED(), for example), concatentations
or just random stuff.

So you're contending that ALL of the indexes--not just those affected by
the field that was changed--would have to be reevaluated?

I once worked on an app where the original developer thought it would
be a "clever" idea to define index expressions as UDFs. Yes, it's
possible. In his UDFs, he would switch work areas, open tables if not
already opened, look up values, and then return the value, cleaning up
work areas and tables as he went. For every index definition for every
record. A reindex with more than a couple hundred records brought the
entire system to its knees.

YIKES Thanks for sharing that one!

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/5d9cee85aa2f46822511932265fab...@mbsoftwaresolutions.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: Indexes on VFP tables--when do they get updated


On 2018-01-24 15:19, Stephen Russell wrote:
I expect the update of .cdx to be at the same time that the .dbf is 
done.


223 meg is a tiny index size and reducing it down to 1/4 probably 
didn't
make anything faster, did it?  Now an index of  20 gig that would 
probably

be noticed if you brought it in line to only 5 gig.



VFP files can't be more than 2 GB, Stephen.

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


On 2018-01-24 15:37, Stephen Russell wrote:

I thought it was a CPU hog.  Making the call to the system for the time
100,000 time in a single min.



Well that's why you have to be smart about it, Stephen, and only call it 
every X minutes.  In my case, anywhere between 5-15 minutes.  Resources 
have shown it to be not even noticeable, at least in terms of memory.


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

Re: [NF] RE: Timers in VFP

Ken and I have been in touch offlist in the past and recently. I 
actually grew up in Cortland, and my Dad had a cousin w/kids in 
Binghamton - so I spent a bit of time there in my childhood!


-K-


On 1/24/2018 1:09 PM, Paul H. Tarver wrote:

Something make me click on your website link, Ken, and I was surprised to
see you work in the Binghamton, NY area. My wife is the from Elmira/Corning
and I've been through your pretty town many times.

Paul


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ken
Dibble
Sent: Wednesday, January 24, 2018 11:32 AM
To: profoxt...@leafe.com
Subject: Re: Timers in VFP



  I vaguely recall somebody saying timers in VFP were bad (at some point).

I have a timer that tracks user activity and shuts down my application if
there has been no activity for a period of time. It generally works well,
but I've had a few issues with it:

1. Time is *very* approximate. If I configure it to shut down after
15 minutes without activity, I can expect it to go at least 15 minutes, but
as long as 20 to 25 minutes. This seems to be affected by whatever else is
happening on the machine.

2. Timers complicate debugging. I think they contribute to the fact that the
debugger doesn't always land on the actual line of code where an error
occurred. And if the timer is going to force a jump to some other place, or
shut down the application, you need to have a routine to turn it off for
your "debug mode", or you won't be able to spend much time analyzing things
in the debugger.

3. I have speculated--with no proof--that timers contribute to incidents
where VFP doesn't necessarily execute code in the order in which it is
encountered. For example, various screen painting/updating issues. Sometimes
you can call .Refresh() or
.Paint() until you're blue in the face and it just doesn't happen until VFP
gets done doing whatever it thinks is more important.

I, too, recall this issue being discussed and I think some people had some
even more esoteric points.

Ken Dibble
www.stic-cil.org



[excessive quoting removed by server]

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

RE: [NF] RE: Timers in VFP

2018-01-24 Thread John Weller

I visited Binghamton in 1981 to attend a meeting at Singer Link, wish I
could have stayed longer.  Are Singer Link still there?

John Weller
01380 723235
07976 393631

> 
> HI Paul. Pleased to hear that you think it's pretty. I do too--you can be
> anywhere in this town and look up and see forested hillsides.
> 


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/001b01d39559$0594eb70$10bec250$@johnweller.co.uk
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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: Timers in VFP

I thought it was a CPU hog.  Making the call to the system for the time
100,000 time in a single min.

On Wed, Jan 24, 2018 at 2:35 PM, Tracy Pearson 
wrote:

> mbsoftwaresoluti...@mbsoftwaresolutions.com wrote on 2018-01-24:
> >  I've got a timer in a very small "listener" app that checks a web
> >  service and changes data in the local database based on WS returned
> >  records.  I vaguely recall somebody saying timers in VFP were bad (at
> >  some point).  Was it a memory leak or something?  Tapping into this
> >  list's vast years of experience with this question.  So far, my app
> >  works flawlessly, pretty much on timer cue, and doesn't appear to have
> >  any memory issues.
> >
> >  Was just curious about this vague recollection.  Thanks.
> >
>
> Mike,
>
> I don't remember it being a memory leak.
> I know, in most cases, it will stop other running code to run.
> If your executable is only there to run your timer, and the one process, it
> will probably be fine.
>
> Tracy Pearson
> PowerChurch Software
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAJidMYLXq8t=Etm6Ovf3yZ39OXc=wpp0vl+1z2yhy7aazn-...@mail.gmail.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: Timers in VFP

2018-01-24 Thread Tracy Pearson

mbsoftwaresoluti...@mbsoftwaresolutions.com wrote on 2018-01-24: 
>  I've got a timer in a very small "listener" app that checks a web
>  service and changes data in the local database based on WS returned
>  records.  I vaguely recall somebody saying timers in VFP were bad (at
>  some point).  Was it a memory leak or something?  Tapping into this
>  list's vast years of experience with this question.  So far, my app
>  works flawlessly, pretty much on timer cue, and doesn't appear to have
>  any memory issues.
>  
>  Was just curious about this vague recollection.  Thanks.
>  

Mike,

I don't remember it being a memory leak. 
I know, in most cases, it will stop other running code to run.
If your executable is only there to run your timer, and the one process, it
will probably be fine.

Tracy Pearson
PowerChurch Software


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/001201d39552$dc2f7170$948e5450$@powerchurch.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: Indexes on VFP tables--when do they get updated

2018-01-24 Thread Ted Roche

First off, don't do that. REPLACE (or better, UPDATE) once. Especially
in high network traffic situations, the amount of time it takes to
assemble a field and value list to issue one:

UPDATE TableName SET  WHERE FilterCriteria

saves an enormous amount of I/O and CPU cycles: one lock, one
transaction, one row re-write, one set of reindexes.

Second, in VFP, all indexes have to be evaluated, as there's no
backlink to which fields are used in which expressions. Indexes are
defined at the table level, not the row, so can have multiple field
names, functions (UPPER() or DELETED(), for example), concatentations
or just random stuff.

I once worked on an app where the original developer thought it would
be a "clever" idea to define index expressions as UDFs. Yes, it's
possible. In his UDFs, he would switch work areas, open tables if not
already opened, look up values, and then return the value, cleaning up
work areas and tables as he went. For every index definition for every
record. A reindex with more than a couple hundred records brought the
entire system to its knees.

On Wed, Jan 24, 2018 at 1:29 PM,
 wrote:
>
> I understand that ADDing and DELETEing records updated all indexes; I would
> think the UPDATEs--regardless of what fields updated--would cause index
> updates for every indexed field on every update as well.
>

I don't know if it actually caused *UPDATES* but I think VFP would
have to go through each index expression and test to see if the value
had changed. Perhaps they'd skip the write if it was unchanged.

Other database engines do this differently

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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cacw6n4vqfjixaq93golmpma3j8ld8_1magxrjqf3ganwngc...@mail.gmail.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: Indexes on VFP tables--when do they get updated

I expect the update of .cdx to be at the same time that the .dbf is done.

223 meg is a tiny index size and reducing it down to 1/4 probably didn't
make anything faster, did it?  Now an index of  20 gig that would probably
be noticed if you brought it in line to only 5 gig.

On Wed, Jan 24, 2018 at 2:11 PM, <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> Thanks.  In this app, they indexed EVERY field, and the table in question
> had a CDX size of 233 MB before I pruned it.  Now it's down to 56 MB.
>
>
> On 2018-01-24 14:35, Alan Bourke wrote:
>
>> Only the indexes that involve a 'touched' field. And even then it's
>> just a small update.
>>
>> --
>>   Alan Bourke
>>   alanpbourke (at) fastmail (dot) fm
>>
>> On Wed, 24 Jan 2018, at 6:29 PM,
>> mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
>>
>>> Question for you legends of the Fox (data):
>>>
>>> Say Table1 has "X" number of indexes.  Program code does something like
>>> the following:
>>>
>>> IF Condition1 THEN
>>>REPLACE Field1 with SomeValue in Table1
>>> ENDIF
>>>
>>> IF Condition2 THEN
>>>REPLACE Field48 with Datetime() in Table1
>>> ENDIF
>>>
>>> Are each of the "X" indexes updated for each replace, even if those
>>> indexes do not include any reference to Field1 or Field48, or only
>>> indexes that are affected by the data value change?
>>>
>>> I understand that ADDing and DELETEing records updated all indexes; I
>>> would think the UPDATEs--regardless of what fields updated--would cause
>>> index updates for every indexed field on every update as well.
>>>
>>> tia,
>>> --Michael
>>>
[excessive quoting removed by server]

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

Re: [NF] RE: Timers in VFP

2018-01-24 Thread Ken Dibble




Something make me click on your website link, Ken, and I was surprised to
see you work in the Binghamton, NY area. My wife is the from Elmira/Corning
and I've been through your pretty town many times.


HI Paul. Pleased to hear that you think it's pretty. I do too--you 
can be anywhere in this town and look up and see forested hillsides.


Ken 



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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: Indexes on VFP tables--when do they get updated

Thanks. In this app, they indexed EVERY field, and the table in
question had a CDX size of 233 MB before I pruned it. Now it's down to
56 MB.

On 2018-01-24 14:35, Alan Bourke wrote:

Only the indexes that involve a 'touched' field. And even then it's
just a small update.

--
Alan Bourke
alanpbourke (at) fastmail (dot) fm

On Wed, 24 Jan 2018, at 6:29 PM,
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:

Question for you legends of the Fox (data):

Say Table1 has "X" number of indexes. Program code does something
like

the following:

IF Condition1 THEN
REPLACE Field1 with SomeValue in Table1
ENDIF

IF Condition2 THEN
REPLACE Field48 with Datetime() in Table1
ENDIF

Are each of the "X" indexes updated for each replace, even if those
indexes do not include any reference to Field1 or Field48, or only
indexes that are affected by the data value change?

I understand that ADDing and DELETEing records updated all indexes; I
would think the UPDATEs--regardless of what fields updated--would
cause

index updates for every indexed field on every update as well.

tia,
--Michael

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/10bea5ce89d4529241c443c5d9ef1...@mbsoftwaresolutions.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: Indexes on VFP tables--when do they get updated

2018-01-24 Thread Alan Bourke

Only the indexes that involve a 'touched' field. And even then it's just a 
small update.

-- 
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm

On Wed, 24 Jan 2018, at 6:29 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com 
wrote:
> Question for you legends of the Fox (data):
> 
> Say Table1 has "X" number of indexes.  Program code does something like 
> the following:
> 
> IF Condition1 THEN
>REPLACE Field1 with SomeValue in Table1
> ENDIF
> 
> IF Condition2 THEN
>REPLACE Field48 with Datetime() in Table1
> ENDIF
> 
> Are each of the "X" indexes updated for each replace, even if those 
> indexes do not include any reference to Field1 or Field48, or only 
> indexes that are affected by the data value change?
> 
> I understand that ADDing and DELETEing records updated all indexes; I 
> would think the UPDATEs--regardless of what fields updated--would cause 
> index updates for every indexed field on every update as well.
> 
> tia,
> --Michael
> 
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/1516822508.1275799.1246932120.5664a...@webmail.messagingengine.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: Indexes on VFP tables--when do they get updated

2018-01-24 Thread Paul H. Tarver

It would only be missed if you didn't report your results and included a
spreadsheet and a graph! :)

Paul

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Wednesday, January 24, 2018 12:58 PM
To: profoxt...@leafe.com
Subject: Re: Indexes on VFP tables--when do they get updated

On 2018-01-24 13:48, Kurt at VR-FX wrote:
> Mike,
> 
> If I was to look at this from a totally Logical stand point - I would 
> think the Indexes are ONLY update if you update a field in a record 
> where that field is contained in one or more of the Indices.
> 
> However, Why not do a simple test - and generate your Own answer!??
> 
> Take a chunk of the data from your table in question - or even take a 
> copy of the Whole thing, along with the Indices, drop into another 
> folder. Then - simply do some updates based upon your criteria below - 
> and then you can confirm Exactly what happens!
> 
> Right???
> 
> :-)
> 
> -K-

But if I did that, think of the discussion and thread that would be missed
here.  LOL

This question relates to VFP CDX files but is something in theory too for
other systems (although I realize they may do things differently).

I just dropped a boatload of nonsense indexes from a client's legacy app
database and believe that it (theoretically) should improve network traffic
by lessening these unneeded updates.

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/023701d39548$1698e860$43cab920$@tpcqpc.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: Indexes on VFP tables--when do they get updated


On 2018-01-24 13:48, Kurt at VR-FX wrote:

Mike,

If I was to look at this from a totally Logical stand point - I would
think the Indexes are ONLY update if you update a field in a record
where that field is contained in one or more of the Indices.

However, Why not do a simple test - and generate your Own answer!??

Take a chunk of the data from your table in question - or even take a
copy of the Whole thing, along with the Indices, drop into another
folder. Then - simply do some updates based upon your criteria below -
and then you can confirm Exactly what happens!

Right???

:-)

-K-




But if I did that, think of the discussion and thread that would be 
missed here.  LOL


This question relates to VFP CDX files but is something in theory too 
for other systems (although I realize they may do things differently).


I just dropped a boatload of nonsense indexes from a client's legacy app 
database and believe that it (theoretically) should improve network 
traffic by lessening these unneeded updates.


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cc3f66db9807fa4d1219ea6cc2caf...@mbsoftwaresolutions.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: Indexes on VFP tables--when do they get updated


Mike,

If I was to look at this from a totally Logical stand point - I would 
think the Indexes are ONLY update if you update a field in a record 
where that field is contained in one or more of the Indices.


However, Why not do a simple test - and generate your Own answer!??

Take a chunk of the data from your table in question - or even take a 
copy of the Whole thing, along with the Indices, drop into another 
folder. Then - simply do some updates based upon your criteria below - 
and then you can confirm Exactly what happens!


Right???

:-)

-K-


On 1/24/2018 1:29 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:

Question for you legends of the Fox (data):

Say Table1 has "X" number of indexes.  Program code does something 
like the following:


IF Condition1 THEN
  REPLACE Field1 with SomeValue in Table1
ENDIF

IF Condition2 THEN
  REPLACE Field48 with Datetime() in Table1
ENDIF

Are each of the "X" indexes updated for each replace, even if those 
indexes do not include any reference to Field1 or Field48, or only 
indexes that are affected by the data value change?


I understand that ADDing and DELETEing records updated all indexes; I 
would think the UPDATEs--regardless of what fields updated--would 
cause index updates for every indexed field on every update as well.


tia,
--Michael


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/9ab07317-d4fe-6c03-cba0-3190f0d58...@optonline.net
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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: Searching for FoxPro Work & a Change in Work Status...

A Youngster? HA ha - maybe. I've been working with the Fox since 
Foxbase+ in 1988. Although, will admit - over the years I had chunks of 
time where I wasn't working w/Fox - when I got other Gigs. Like working 
for a year doing programming at a co. for VR games played against a 
green screen. So - although the time span is 30 yrs - it may possibly be 
a total of like 25-27 of actually working with The Fox!


And - thanks for your well wishes.

-K-


On 1/24/2018 1:09 PM, Paul H. Tarver wrote:

I have less than 20 years with Foxpro, but I'm in the 40 range total.

So does that make me the youngster in this group? :)

Good luck Kurt!

Paul

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Fernando D. 
Bozzo
Sent: Tuesday, January 23, 2018 12:12 AM
To: profoxt...@leafe.com
Subject: Re: Searching for FoxPro Work & a Change in Work Status...

Hi Kurt:

You can be sure that there is nobody with less than 40 here (including me:)

Good luck and report back! :-)

Fernando D. Bozzo


El 23 ene. 2018 1:22, "Kurt at VR-FX"  escribió:

FYI -  had a 1st interview via phone today - and, I think I'm a Shoe-In for 
this Gig!

(Is this "shoe-in" still used as a common phrase - or only by OLD people such 
as Me?)

Why? Cause exactly how many VFP programmers are still out there working in the 
world? Well - lucky for me - Seems there is STILL a NEED! Hell - we ALL of us 
here know of some Old Apps still in the field - still in VFP - and STILL 
Working! So - now its my time to quickly get acquainted with this app at this 
new potential Gig!

Tomorrow is an Inperson interview. I should have no problem with that.

But, will report back as to the Outcome.

-K-



On 12/4/2017 10:40 AM, Ted Roche wrote:


On Sun, Dec 3, 2017 at 1:09 PM, Kurt at VR-FX  wrote:


Thus why I am looking around for VFP
work. So - if anyone knows of anything in the NYC area - or even work
that I can do remotely - I would really appreciate it!

Sorry to hear that, Kurt. I'll keep an eye out for opportunities to

send your way.



[excessive quoting removed by server]

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

Indexes on VFP tables--when do they get updated


Question for you legends of the Fox (data):

Say Table1 has "X" number of indexes.  Program code does something like 
the following:


IF Condition1 THEN
  REPLACE Field1 with SomeValue in Table1
ENDIF

IF Condition2 THEN
  REPLACE Field48 with Datetime() in Table1
ENDIF

Are each of the "X" indexes updated for each replace, even if those 
indexes do not include any reference to Field1 or Field48, or only 
indexes that are affected by the data value change?


I understand that ADDing and DELETEing records updated all indexes; I 
would think the UPDATEs--regardless of what fields updated--would cause 
index updates for every indexed field on every update as well.


tia,
--Michael

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

[NF] RE: Timers in VFP

2018-01-24 Thread Paul H. Tarver

Something make me click on your website link, Ken, and I was surprised to
see you work in the Binghamton, NY area. My wife is the from Elmira/Corning
and I've been through your pretty town many times. 

Paul 


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ken
Dibble
Sent: Wednesday, January 24, 2018 11:32 AM
To: profoxt...@leafe.com
Subject: Re: Timers in VFP


>  I vaguely recall somebody saying timers in VFP were bad (at some point).

I have a timer that tracks user activity and shuts down my application if
there has been no activity for a period of time. It generally works well,
but I've had a few issues with it:

1. Time is *very* approximate. If I configure it to shut down after
15 minutes without activity, I can expect it to go at least 15 minutes, but
as long as 20 to 25 minutes. This seems to be affected by whatever else is
happening on the machine.

2. Timers complicate debugging. I think they contribute to the fact that the
debugger doesn't always land on the actual line of code where an error
occurred. And if the timer is going to force a jump to some other place, or
shut down the application, you need to have a routine to turn it off for
your "debug mode", or you won't be able to spend much time analyzing things
in the debugger.

3. I have speculated--with no proof--that timers contribute to incidents
where VFP doesn't necessarily execute code in the order in which it is
encountered. For example, various screen painting/updating issues. Sometimes
you can call .Refresh() or
.Paint() until you're blue in the face and it just doesn't happen until VFP
gets done doing whatever it thinks is more important.

I, too, recall this issue being discussed and I think some people had some
even more esoteric points.

Ken Dibble
www.stic-cil.org 


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/00a201d3953e$80641530$812c3f90$@tpcqpc.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: Searching for FoxPro Work & a Change in Work Status...

2018-01-24 Thread Paul H. Tarver

I have less than 20 years with Foxpro, but I'm in the 40 range total.

So does that make me the youngster in this group? :)

Good luck Kurt!

Paul 

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Fernando D. 
Bozzo
Sent: Tuesday, January 23, 2018 12:12 AM
To: profoxt...@leafe.com
Subject: Re: Searching for FoxPro Work & a Change in Work Status...

Hi Kurt:

You can be sure that there is nobody with less than 40 here (including me:)

Good luck and report back! :-)

Fernando D. Bozzo

El 23 ene. 2018 1:22, "Kurt at VR-FX"  escribió:

FYI -  had a 1st interview via phone today - and, I think I'm a Shoe-In for 
this Gig!

(Is this "shoe-in" still used as a common phrase - or only by OLD people such 
as Me?)

Why? Cause exactly how many VFP programmers are still out there working in the 
world? Well - lucky for me - Seems there is STILL a NEED! Hell - we ALL of us 
here know of some Old Apps still in the field - still in VFP - and STILL 
Working! So - now its my time to quickly get acquainted with this app at this 
new potential Gig!

Tomorrow is an Inperson interview. I should have no problem with that.

But, will report back as to the Outcome.

-K-

On 12/4/2017 10:40 AM, Ted Roche wrote:

> On Sun, Dec 3, 2017 at 1:09 PM, Kurt at VR-FX  wrote:
>
>> Thus why I am looking around for VFP
>> work. So - if anyone knows of anything in the NYC area - or even work 
>> that I can do remotely - I would really appreciate it!
>>
>> Sorry to hear that, Kurt. I'll keep an eye out for opportunities to
> send your way.
>
>

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/00a301d3953e$806b4120$8141c360$@tpcqpc.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: Timers in VFP

2018-01-24 Thread Ken Dibble




 I vaguely recall somebody saying timers in VFP were bad (at some point).


I have a timer that tracks user activity and shuts down my 
application if there has been no activity for a period of time. It 
generally works well, but I've had a few issues with it:


1. Time is *very* approximate. If I configure it to shut down after 
15 minutes without activity, I can expect it to go at least 15 
minutes, but as long as 20 to 25 minutes. This seems to be affected 
by whatever else is happening on the machine.


2. Timers complicate debugging. I think they contribute to the fact 
that the debugger doesn't always land on the actual line of code 
where an error occurred. And if the timer is going to force a jump to 
some other place, or shut down the application, you need to have a 
routine to turn it off for your "debug mode", or you won't be able to 
spend much time analyzing things in the debugger.


3. I have speculated--with no proof--that timers contribute to 
incidents where VFP doesn't necessarily execute code in the order in 
which it is encountered. For example, various screen 
painting/updating issues. Sometimes you can call .Refresh() or 
.Paint() until you're blue in the face and it just doesn't happen 
until VFP gets done doing whatever it thinks is more important.


I, too, recall this issue being discussed and I think some people had 
some even more esoteric points.


Ken Dibble
www.stic-cil.org 



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

Timers in VFP

I've got a timer in a very small "listener" app that checks a web 
service and changes data in the local database based on WS returned 
records.  I vaguely recall somebody saying timers in VFP were bad (at 
some point).  Was it a memory leak or something?  Tapping into this 
list's vast years of experience with this question.  So far, my app 
works flawlessly, pretty much on timer cue, and doesn't appear to have 
any memory issues.


Was just curious about this vague recollection.  Thanks.

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/057122f66dd71df357a9063270a01...@mbsoftwaresolutions.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: Searching for FoxPro Work & a Change in Work Status...


Thanks Dave!


On 1/24/2018 11:31 AM, Dave Crozier wrote:

Fingers crossed for you Kurt!

Dave



---
This communication and the information it contains is intended for the person 
or organisation to whom it is addressed. Its contents are confidential and may 
be protected in law. If you have received this e-mail in error you must not 
copy, distribute or take any action in reliance on it. Unauthorised use, 
copying or disclosure of any of it may be unlawful. If you have received this 
message in error, please notify us immediately by telephone or email.

Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the 
risk of virus transmission through email and therefore any files sent via 
e-mail will have been checked for known viruses. However, you are advised to 
run your own virus check before opening any
attachments received as Flexipol Packaging Ltd will not in any event accept any 
liability whatsoever once an e-mail and/or any attachment is received.

It is the responsibility of the recipient to ensure that they have adequate 
virus protection.

Flexipol Packaging Ltd.
Unit 14 Bentwood Road
Carrs
Industrial Estate
Haslingden
Rossendale
Lancashire
BB4 5HH

Tel:01706-222792
Fax: 01706-224683
www.Flexipol.co.uk
---

Terms & Conditions:

Notwithstanding delivery and the passing of risk in the goods, the property in 
the goods shall not pass to the buyer until the seller
Flexipol Packaging Ltd. ("The Company") has received in cash or cleared funds 
payment in full of the price of the goods and all other goods agreed to be sold by the 
seller to the buyer for which payment is then due. Until such time as the property in the 
goods passes to the buyer, the buyer shall hold the goods as the seller's fiduciary agent 
and bailee and keep the goods separate from those of the buyer and third parties and 
properly stored protected and insured and identified as the seller's property but shall 
be entitled to resell or use the goods in the ordinary course of its business. Until such 
time as the property in the goods passes to the buyer the seller shall be entitled at any 
time

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Kurt at VR-FX
Sent: 24 January 2018 15:01
To: profox@leafe.com
Subject: Re: Searching for FoxPro Work & a Change in Work Status...

The last commute to work required going into NYC (from LI) - then a subway 
train all the way downtown from Penn St. - the new job would be only a couple 
blocks from Penn St. - so it cuts out the extra subway part of the commute...

-K-

On 1/24/2018 9:40 AM, Stephen Russell wrote:

How bad a commute to the potential client site?

On Tue, Jan 23, 2018 at 6:15 PM, Kurt at VR-FX  wrote:


FYI - its a 2 part process. Today I met with the owner of the
consulting co. - and he likes me. Next, I have to interview with the actual 
client co.
- and hopefully that will happen in the next couple of days...

-K-


On 1/23/2018 10:19 AM, Kurt at VR-FX wrote:


Thank you Stephen and all the rest of your for your kind words and
support.

I will follow-up here later today after the interview this afternoon.

-K-


On 1/23/2018 9:21 AM, Stephen Russell wrote:


Good luck Kurt.

On Mon, Jan 22, 2018 at 6:22 PM, Kurt at VR-FX 
wrote:

FYI -  had a 1st interview via phone today - and, I think I'm a
Shoe-In

for this Gig!

(Is this "shoe-in" still used as a common phrase - or only by OLD
people such as Me?)

Why? Cause exactly how many VFP programmers are still out there
working in the world? Well - lucky for me - Seems there is STILL a
NEED! Hell - we ALL of us here know of some Old Apps still in the
field - still in VFP - and STILL Working! So - now its my time to
quickly get acquainted with this app at this new potential Gig!

Tomorrow is an Inperson interview. I should have no problem with that.

But, will report back as to the Outcome.

-K-


On 12/4/2017 10:40 AM, Ted Roche wrote:

On Sun, Dec 3, 2017 at 1:09 PM, Kurt at VR-FX 

wrote:

Thus why I am looking around for VFP

work. So - if anyone knows of anything in the NYC area - or even
work that I can do remotely - I would really appreciate it!

Sorry to hear that, Kurt. I'll keep an eye out for opportunities
to


send your way.



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/fe876dc1-ba95-196f-65a8-71046e64e...@optonline.net
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical

RE: Searching for FoxPro Work & a Change in Work Status...

2018-01-24 Thread Dave Crozier

Fingers crossed for you Kurt!

Dave

---
This communication and the information it contains is intended for the person 
or organisation to whom it is addressed. Its contents are confidential and may 
be protected in law. If you have received this e-mail in error you must not 
copy, distribute or take any action in reliance on it. Unauthorised use, 
copying or disclosure of any of it may be unlawful. If you have received this 
message in error, please notify us immediately by telephone or email.

Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the 
risk of virus transmission through email and therefore any files sent via 
e-mail will have been checked for known viruses. However, you are advised to 
run your own virus check before opening any
attachments received as Flexipol Packaging Ltd will not in any event accept any 
liability whatsoever once an e-mail and/or any attachment is received.

It is the responsibility of the recipient to ensure that they have adequate 
virus protection.

Flexipol Packaging Ltd.
Unit 14 Bentwood Road
Carrs
Industrial Estate
Haslingden
Rossendale
Lancashire
BB4 5HH

Tel:01706-222792
Fax: 01706-224683
www.Flexipol.co.uk
---

Terms & Conditions:

Notwithstanding delivery and the passing of risk in the goods, the property in 
the goods shall not pass to the buyer until the seller
Flexipol Packaging Ltd. ("The Company") has received in cash or cleared funds 
payment in full of the price of the goods and all other goods agreed to be sold 
by the seller to the buyer for which payment is then due. Until such time as 
the property in the goods passes to the buyer, the buyer shall hold the goods 
as the seller's fiduciary agent and bailee and keep the goods separate from 
those of the buyer and third parties and properly stored protected and insured 
and identified as the seller's property but shall be entitled to resell or use 
the goods in the ordinary course of its business. Until such time as the 
property in the goods passes to the buyer the seller shall be entitled at any 
time

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Kurt at VR-FX
Sent: 24 January 2018 15:01
To: profox@leafe.com
Subject: Re: Searching for FoxPro Work & a Change in Work Status...

The last commute to work required going into NYC (from LI) - then a subway 
train all the way downtown from Penn St. - the new job would be only a couple 
blocks from Penn St. - so it cuts out the extra subway part of the commute...

-K-

On 1/24/2018 9:40 AM, Stephen Russell wrote:
> How bad a commute to the potential client site?
>
> On Tue, Jan 23, 2018 at 6:15 PM, Kurt at VR-FX  wrote:
>
>> FYI - its a 2 part process. Today I met with the owner of the
>> consulting co. - and he likes me. Next, I have to interview with the actual 
>> client co.
>> - and hopefully that will happen in the next couple of days...
>>
>> -K-
>>
>>
>> On 1/23/2018 10:19 AM, Kurt at VR-FX wrote:
>>
>>> Thank you Stephen and all the rest of your for your kind words and
>>> support.
>>>
>>> I will follow-up here later today after the interview this afternoon.
>>>
>>> -K-
>>>
>>>
>>> On 1/23/2018 9:21 AM, Stephen Russell wrote:
>>>
 Good luck Kurt.

 On Mon, Jan 22, 2018 at 6:22 PM, Kurt at VR-FX 
 wrote:

 FYI -  had a 1st interview via phone today - and, I think I'm a
 Shoe-In
> for this Gig!
>
> (Is this "shoe-in" still used as a common phrase - or only by OLD
> people such as Me?)
>
> Why? Cause exactly how many VFP programmers are still out there
> working in the world? Well - lucky for me - Seems there is STILL a
> NEED! Hell - we ALL of us here know of some Old Apps still in the
> field - still in VFP - and STILL Working! So - now its my time to
> quickly get acquainted with this app at this new potential Gig!
>
> Tomorrow is an Inperson interview. I should have no problem with that.
>
> But, will report back as to the Outcome.
>
> -K-
>
>
> On 12/4/2017 10:40 AM, Ted Roche wrote:
>
> On Sun, Dec 3, 2017 at 1:09 PM, Kurt at VR-FX 
>> wrote:
>>
>> Thus why I am looking around for VFP
>>> work. So - if anyone knows of anything in the NYC area - or even
>>> work that I can do remotely - I would really appreciate it!
>>>
>>> Sorry to hear that, Kurt. I'll keep an eye out for opportunities
>>> to
>>>
>> send your way.
>>
>>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox

Re: Searching for FoxPro Work & a Change in Work Status...

The last commute to work required going into NYC (from LI) - then a 
subway train all the way downtown from Penn St. - the new job would be 
only a couple blocks from Penn St. - so it cuts out the extra subway 
part of the commute...


-K-

On 1/24/2018 9:40 AM, Stephen Russell wrote:

How bad a commute to the potential client site?

On Tue, Jan 23, 2018 at 6:15 PM, Kurt at VR-FX  wrote:


FYI - its a 2 part process. Today I met with the owner of the consulting
co. - and he likes me. Next, I have to interview with the actual client co.
- and hopefully that will happen in the next couple of days...

-K-


On 1/23/2018 10:19 AM, Kurt at VR-FX wrote:


Thank you Stephen and all the rest of your for your kind words and
support.

I will follow-up here later today after the interview this afternoon.

-K-


On 1/23/2018 9:21 AM, Stephen Russell wrote:


Good luck Kurt.

On Mon, Jan 22, 2018 at 6:22 PM, Kurt at VR-FX 
wrote:

FYI -  had a 1st interview via phone today - and, I think I'm a Shoe-In

for this Gig!

(Is this "shoe-in" still used as a common phrase - or only by OLD people
such as Me?)

Why? Cause exactly how many VFP programmers are still out there working
in
the world? Well - lucky for me - Seems there is STILL a NEED! Hell - we
ALL
of us here know of some Old Apps still in the field - still in VFP - and
STILL Working! So - now its my time to quickly get acquainted with this
app
at this new potential Gig!

Tomorrow is an Inperson interview. I should have no problem with that.

But, will report back as to the Outcome.

-K-


On 12/4/2017 10:40 AM, Ted Roche wrote:

On Sun, Dec 3, 2017 at 1:09 PM, Kurt at VR-FX 

wrote:

Thus why I am looking around for VFP

work. So - if anyone knows of anything in the NYC area - or even work
that I
can do remotely - I would really appreciate it!

Sorry to hear that, Kurt. I'll keep an eye out for opportunities to


send your way.



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/0d3de098-8fc7-ca63-6764-39d186ec5...@optonline.net
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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: Searching for FoxPro Work & a Change in Work Status...