Re: List box issues

[Fletcher Johnson]

Joe,

It's been a while for me, but I seem to recall having to use "into 
cursor xxx" to prevent the results from appearing.


Fletcher

-- Original Message --

From "Joe Yoder" 

To profoxt...@leafe.com
Date 4/23/2024 1:21:48 PM
Subject List box issues


I have 2 files:
  Spaces with fields space_id and  descript
  Units with fields : unit_id, space_id, and descript

I have a form with a list box for each
 the Spaces list box has the row source set  to 6 (Fields) of Spaces
 the Units list box has the Row Source type set to 3  (SQL Statement)
 and the Row Source to:
  select Spaces.Descript from Spaces  where Units.space_id = Spaces.space_id

The Spaces listbox lost focus event calls the requiry event of the Units
listbox to update the choices that appear in the Units list box

Each time the SQL executes the results show up in a query window on the
screen.

How do I suppress the unwanted display?  Should I use another technique?

Thanks in advance.

Joe


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


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/eme947a82b-de2b-4555-bd98-35ee123d5...@8aba0f7c.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: vfp9 exe

[Fletcher Johnson]

Ken,

I am still a little fuzzy or am missing something.  But here are some ideas
that might help.

When VFP starts, you can ask it for the folder in which it is located (A SYS
function?).
When you open a table, you can get the table path using a different
function.
If the exe and tables are in the same place, you can then have a table with
a single row.  If some process is going on, it will open the table either
exclusively or open it and put a lock on it.

The table could include the name of the respective folders that were used.
If the data is somehow opened by a combination that is allowed, then you
would add a second record (if/as appropriate) and put the lock on that
record (so no exclusive option here.)

So now you know the folders where the exe and data are stored.  

After that, you can then have your code continue or alert the user and exit.

Fletcher


Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ken McGinnis
Sent: Tuesday, July 23, 2019 10:37 AM
To: ProFox@leafe.com >> ProFox Email List
Subject: vfp9 exe

We have a vfp9 SP2 program that has been running nearly bug free for 
over 10 years. Only now we have a need to find out if anyone else is 
using the exe in a specific folder. We allow many users to have their 
own unique folder with their patient data files.

So we log into folder 1 and another user is in folder 2. No problem.

If we log into folder 1 and another user is in that same folder, again 
no problem. Our software is multi-user down to the individual record 
level. The problem is when the 2nd user comes in and needs to lock many 
or all files to reindex or other procedures. How can the 2nd user know 
that another user is there? Again it is not a problem until that 1st 
user starts to do something, almost anything that requires accessing 
files. All files are locked by the 2nd user so the 1st user starts 
getting errors.

We could try to lock the exe and that would fail so we would know 
someone else is using the software. However, if that other user is 
working with data in a different folder, we don't care so we do not want 
to lock the exe.

Hope that is clear



>
>
>
[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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/070c01d54586$4049a4c0$c0dcee40$@yahoo.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.

[OT] Missing messages....

[Fletcher Johnson]

I moved this to OT since it really isn't FP related

Like you, Paul's initial email re Event Viewer icons also didn't get to my
inbox either, just the replies.

I wonder if there is a black list somewhere that isn't well monitored - and
that some of us somehow got on it.

Any ideas how we might track that down?

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Frank Cazabon
Sent: Wednesday, July 17, 2019 5:40 AM
To: profox@leafe.com
Subject: Re: Missing messages

I never get yours or Paul Newton's, they always end up in spam in gmail. 
I'm only made aware of them when someone replies to your messages. 
However in this case Paul's original message isn't even in spam!

Frank.

Frank Cazabon

On 16/07/2019 11:34 AM, Fletcher Johnson wrote:
> Hi all,
>
> I saw this and realized that I hadn't received the original message sent
by
> Paul.
>
> But Darren did.
>
> I checked spam and other folders and can't find any messages other than
> Darren's replies - I even did a search based on the subject (which
included
> junk/spam) and couldn't find it.
>
> Did anyone else have this issue?  Or am I the only one not getting all the
> messages..?
>
> Thanks,
>
> Fletcher
>
> Fletcher Johnson
> fletchersjohn...@yahoo.com
> LinkedIn.com/in/FletcherJohnson
> twitter.com/fletcherJ
> strava.com/athletes/fletcherjohnson
> 408-946-0960 - work
> 408-781-2345 - cell
>
> -Original Message-
> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Darren
> Sent: Tuesday, July 16, 2019 1:36 AM
> To: profox@leafe.com
> Subject: RE: Class has disappeared from class library
>
> Open the VCX as a DBF - browse and you'll likely see multiple definitions
> for the class in question. The solution I adopted in these instances was
to
> simply delete all the records pertaining to the latest entry of that
class,
> pack and then all should be sweet. The downside is that the latest changes
> will be lost.
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul
> Newton
> Sent: Tuesday, 16 July 2019 6:30 PM
> To: profoxt...@leafe.com
> Subject: Class has disappeared from class library
>
> I posted this yesterday but it never got through so am trying again ...
>
>
>
> Hi all
>
>
>
> I had a visual class library containing one class.  This morning something
> has happened which is of great concern - the class library (VCX/VCT) is
> still there but it is empty - the class it contained has vanished.  Is
there
> any way it might be lurking in a temporary file somewhere?  Any idea what
> might have happened?  All suggestions gratefully received.
>
>
>
> Many thanks
>
>
>
> Paul Newton
>
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
>text/plain (text body -- kept)
>text/html
> ---
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/03f401d53d72$05c2db80$11489280$@yahoo.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.

Missing messages....

[Fletcher Johnson]

Hi all,

I saw this and realized that I hadn't received the original message sent by
Paul.

But Darren did.  

I checked spam and other folders and can't find any messages other than
Darren's replies - I even did a search based on the subject (which included
junk/spam) and couldn't find it.

Did anyone else have this issue?  Or am I the only one not getting all the
messages..?

Thanks,

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Darren
Sent: Tuesday, July 16, 2019 1:36 AM
To: profox@leafe.com
Subject: RE: Class has disappeared from class library

Open the VCX as a DBF - browse and you'll likely see multiple definitions
for the class in question. The solution I adopted in these instances was to
simply delete all the records pertaining to the latest entry of that class,
pack and then all should be sweet. The downside is that the latest changes
will be lost.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul
Newton
Sent: Tuesday, 16 July 2019 6:30 PM
To: profoxt...@leafe.com
Subject: Class has disappeared from class library

I posted this yesterday but it never got through so am trying again ...



Hi all



I had a visual class library containing one class.  This morning something
has happened which is of great concern - the class library (VCX/VCT) is
still there but it is empty - the class it contained has vanished.  Is there
any way it might be lurking in a temporary file somewhere?  Any idea what
might have happened?  All suggestions gratefully received.



Many thanks



Paul Newton



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

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/00f201d53beb$e864a140$b92de3c0$@yahoo.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: Remote FoxPro Work???

[Fletcher Johnson]

Kurt,

Wes Wilson (wes.wil...@yahoo.com) is advertising on LinkedIn that he does
VFP conversions.  My guess is that companies that use VFP may see that and
reach out to him, looking for VFP developers - even if just to maintain code
until he can get it converted.  

And I know of at least 2 companies in the bay area that depend on VFP.  One
has an application that is used around the country (with lots of very active
customers.)  The other uses it to manage all their deliveries, truck routes,
and accounting.  They currently have all the staff they need (or are willing
to pay for.)  And no, I am not one of those staff.

My point is that there are companies out there who need your talents.  The
hard part is letting them know you exist and are available.

Take care,

Fletcher 

Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Kurt @ Gmail
Sent: Thursday, July 4, 2019 12:12 PM
To: profox@leafe.com
Subject: Re: Remote FoxPro Work???

Wow - you really must be a Fan! Will be honest - and it probably sounds 
bad - but, I never heard of A-frame. I have, of course, heard of Unity - 
and I have merely dabbled in it. But, most co's want SERIOUS Unity 
experience in order to hire. And, FYI - the current gig - which does NOT 
Pay enough - and thus my current financial stress - its running a 3D 
Printing farm - and also doing 3D designs for clients. But, it simply 
does NOT pay well enough...

-K-

On 7/2/2019 3:39 PM, Paul Hemans wrote:
> You also have 3d skills. Can you use them to segue into A-Frame, Unity or
> photorealism etc?
>
> On Wed, Jul 3, 2019 at 7:56 AM Kurt at VR-FX  wrote:
>
>> Yeah - I know - these days - that's a pretty crazy request.
>>
>> I know some of you have followed me a bit - and know I lost my job in
>> Nov 2017 - where I was working down on Wall Street. Then, moved to Cali
>> to look for a job - could NOT find work in San Francisco. Even applied
>> to UCLA for a programming job - did 2 rounds of interviews - and the
>> people there saying they were impressed with me - during both
>> interviews. Only to NOT get the job. Then, finally, getting a "job" down
>> here in San Diego. Actually getting to do 3D Design work for clients, as
>> well as running 3D Printing jobs. But, sadly - its SUCKING! Its not a
>> regular job - not salaried - not even part time pay. Its contractor pay
>> - per job - and it does NOT pay well enough. Been here for over 9 weeks
>> now - and its again put me in a BAD financial situation...
>>
>> So - as a total "shot in the dark" - I figured I would post here again
>> and see if there is any possible remote FoxPro work.
>>
>> And, I know - almost no companies these days are still working w/VFP.
>> And, sure, I know it would be better to work in some other newer more
>> modern tech. - but, I don't have any  of those tools in my tool belt. So
>> - all I really have is VFP & MS SQL.
>>
>> Anyway - just figured I would take a stab and post here...
>>
>> Regards   -Kurt
>>
>>
[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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/117301d53349$a97da2b0$fc78e810$@yahoo.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: Odd Error Message

[Fletcher Johnson]

We did have a test to see if the temp folder existed.  If it didn't we tried
to create it.  But it did exist.  Given the purpose of the temp folder is to
hold temporary data, we didn't bother with code to actually try to create a
file, write to it, and then verify that it was written to.  I mean, who
would ever make a temporary folder read-only

Anyway, once we figured it out, it was easy to fix.  

I don't know why VFP (I can't remember which version we were using) didn't
complain about the problem - it's been too long.  But I do know that our
error handler did not get called and the code happily continued executing
even though the write was not actually performed.  We used both On Error as
well as Try Catch when it was finally added.

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Man-wai Chang
Sent: Thursday, June 27, 2019 4:23 AM
To: ProFox Email List
Subject: Re: Odd Error Message

You better double-check the error handler! It should not have ignored
the write error to that TEMP folder.

To verify whether a folder was writable, you could test write then
delete a file in that folder and look for errors. You might need to
temporarily use ON ERROR to trap file write errors before restoring
the original error handler. I have done this kind of things many
times.

But then, why would someone lock down temporary folders? They are
supposed to be TEMPORARY! But then, if the limit was on folder size,
your code might still failed. So, your program still had to be fixed
to detect that. A virus scanner could also produce the same error.

Happy hunting anyway! :)

On Thu, Jun 27, 2019 at 1:05 AM Fletcher Johnson
 wrote:
>
> folder)  Anyway, it turns out that the IT folk at the time had decided
> to lock down the Temp folder on all machines - but only by making it read
> only..
>
> The worst part is that, while we couldn't write to the file, we could open
> it, etc.  And when we tried to write to it, it acted like it did, even
> though it didn't But then crashed later when we used it again and the
> necessary values weren't there...

-- 
 .~. Might, Courage, Vision. SINCERITY!
/ v \ 64-bit Fedora 25 Server Spin
/( _ )\ http://sites.google.com/site/changmw
^ ^ May the Force and farces be with you!

[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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/04f601d52d28$1c615420$5523fc60$@yahoo.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: Odd Error Message

[Fletcher Johnson]

That reminds me of a bug I encountered once.  We had an app that kept
crashing and couldn't figure it out.

Finally, I went to the location and did some digging around.  It turns out
that our code used a file in the Temp folder for some reason I can't
remember.  Our code checked to verify that the temp folder existed.

What it didn't do was to see if it was read-only or not (this is a "Temp"
folder)  Anyway, it turns out that the IT folk at the time had decided
to lock down the Temp folder on all machines - but only by making it read
only.. 

The worst part is that, while we couldn't write to the file, we could open
it, etc.  And when we tried to write to it, it acted like it did, even
though it didn't But then crashed later when we used it again and the
necessary values weren't there...

This was back in the very late 90s, so don't bother asking me for more
details 

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Tracy Pearson
Sent: Tuesday, June 25, 2019 6:30 AM
To: profox@leafe.com
Subject: RE: Odd Error Message

Hello Gene,

That just raises more questions about what COM object is being used to
create the XLS file. 
Is it shipping with the latest Windows 10 computer?
Is it built in to the VFP runtimes?
Is this functionality suddenly going to stop working one day after the DLL
is identified and removed by some anti-virus software?

All things I don't have time to investigate.

Due to a different control having the same "Unknown COM status" message when
attempting to have it write a file to a non-existent path, or a locked file,
I have put checks in before calling the functions. Sometimes I think I
should change my behavior to write to a temporary file, then move the bytes
from the temporary file in to the destination. It would mean a longer save
time, but I would be able to deal with anti-virus and on-demand backup tools
putting a lock on the files. It's not an exercise for this month.

All things in their time,

Tracy

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gene
Wirchenko
Sent: Monday, June 24, 2019 6:15 PM
To: profoxt...@leafe.com
Subject: Odd Error Message

Hello:

  I got an interesting error message today.  It was another 
example of an error message indicating that an error had occurred 
with the message not terribly useful for determining the actual error.

  Try the following
   use sometable
   copy to nothere\nothere\sometable
   copy to nothere\nothere\somecopy type xl5
where sometable is some table and nothere\nothere is a non-existent 
subdirectory chain.

  The error message for the first copy command is "Invalid path 
or filename."  This is sensible.

  The error message for the second copy command is "OLE error 
code 0x80030003: Unknown COM status code."  Huh?

  Copying to a directory that does not exist results in an 
error.  You even get a choice of error messages.

Sincerely,

Gene Wirchenko


[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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/032101d52c41$36a0ec70$a3e2c550$@yahoo.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: Filtering Oddity

[Fletcher Johnson]

Peter,

It's been a while But I do know that this became a big issue when people 
found out that changes to what they thought was a temporary table/cursor were 
being made back to the actual table.  I was able to demonstrate this in a 
session I gave at one of the Devcons.  

The addition of the NoFilter clause was made specifically to overcome this 
issue.  

In any case, my original point was that I wasn't sure who was being accused of 
"bad coding" - MS or someone else.  

I never really used the set filter - I always used "browse for " (when I 
did want to edit in the table directly) or Select (using noFilter only when 
I wanted to be able to edit the resulting cursor without updating the source 
table.)   Even better, "Browse For ... " gave me flexibility that Set Filter 
did not and could be done in one line (which is what I believe was the 
objective of the original post.)  Not to mention how great "Browse last" was as 
well.

Anyway, I think this dead horse is suitably beaten (sorry PETA)  :)

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Peter Cushing
Sent: Tuesday, May 21, 2019 5:13 AM
To: profox@leafe.com
Subject: Re: Filtering Oddity

So if you leave off the NOFILTER/READWRITE you have a read only file, so
"edits to this cursor would be written to the actual source table" would
not apply.  It sounds like there are no circumstances where you could
write data back from the select statement, or am I missing something?

Peter

On 21/05/2019 12:59, Richard Kaye wrote:
> VFP's query engine decides what has less overhead; running the query or doing 
> a USE...AGAIN with a filter. NOFILTER and READWRITE force VFP to create a 
> temp file with the results. 
>
> --
>
> rk
>
> -Original Message-
> From: ProfoxTech  On Behalf Of Peter Cushing
> Sent: Tuesday, May 21, 2019 6:35 AM
> To: profoxt...@leafe.com
> Subject: Re: Filtering Oddity
>
> On 20/05/2019 19:39, Fletcher Johnson wrote:
>> Not sure where the "Had to be bad coding" comes in.
>>
>> For example, if you did "select * from employee where last name = 'Smith'"
>> you would get a cursor of only those employees.  The employee table 
>> would still be open, but VFP opened it again, in a different work 
>> area, with a different alias, and then put a set filter.  Edits to 
>> this cursor would be written to the actual source table.
>>
>>
> Are you sure about that?  Never heard of that behaviour before.
> If I do a "Select * from picorder where vt_desc = 'India' into cursor 
> mycursor" I get a standalone cursor that I can't update (DBF() =
> C:\TEMP\FABT02AV.TMP)
> If I do a "Select * from picorder where vt_desc = 'India' into cursor 
> mycursor READWRITE" I still get a stand alone cursor that can be updated but 
> won't affect the source table.
> If I leave off the into cursor mycursor then I still get a stand alone cursor 
> called query.
>
> I don't know if that behaviour was from an older VFP version but I don't 
> remember it.  Am I getting Alzheimer's?  Somebody put me out of my misery :-)
>
> Peter
>
> This communication is intended for the person or organisation to whom it is 
> addressed. The contents are confidential and may be protected in law. 
> 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. 
>
> www.whisperingsmith.com
>
> Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR. 
> Tel:0161 831 3700
> Fax:0161 831 3715 
>
> London Office: 101 St. Martin's Lane,London, WC2N 4AZ  Tel:0207 299 7960
>
>
[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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/00e301d510b3$27746eb0$765d4c10$@yahoo.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: Filtering Oddity

[Fletcher Johnson]

Not sure where the "Had to be bad coding" comes in.

For example, if you did "select * from employee where last name = 'Smith'"
you would get a cursor of only those employees.  The employee table would
still be open, but VFP opened it again, in a different work area, with a
different alias, and then put a set filter.  Edits to this cursor would be
written to the actual source table.

Originally, we would add a calculated field which then forced VFP to create
a truly new cursor.  So we might do something like "select employee.*,
date() as somedate from employee where last name = 'Smith'".  Finally, MS
added the nofilter clause that we could use instead.  This insured that when
we used Select, we always had a new cursor and could edit it as we desired
without affecting the source table.

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Man-wai Chang
Sent: Sunday, May 19, 2019 9:42 PM
To: ProFox Email List
Subject: Re: Filtering Oddity

On Sat, May 18, 2019 at 12:01 AM Fletcher Johnson
 wrote:
> 1) It used to be that a Select statement would be optimized by VFP to open
> the source table again, in another work area, and then set a filter on it.
> This was a problem when people thought they had a cursor and updated the
> contents, only to find out they had edited the actual data.  So they added
a
> "nofilter" clause that forced VFP to create a new cursor and not use the
> original approach.

Had to be bad coding, possibly mixing up aliases in the process.

> 5) I can't remember, but did set filter allow you to reference a variable?
> And, if so, did changing that variable then change the effect of the
filter?
> If so, this might also be an option.

SET FILTER can use variables. Changing the values of the variables
should not affect executed SET FILTER if I remember correctly.

-- 
 .~. Might, Courage, Vision. SINCERITY!
/ v \ 64-bit Fedora 25 Server Spin
/( _ )\ http://sites.google.com/site/changmw
^ ^ May the Force and farces be with you!

[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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/06a401d50f3b$5d441e10$17cc5a30$@yahoo.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: Filtering Oddity

[Fletcher Johnson]

Gene,

Not to beat a dead horse While I think these may have been mentioned in
various places

1) It used to be that a Select statement would be optimized by VFP to open
the source table again, in another work area, and then set a filter on it.
This was a problem when people thought they had a cursor and updated the
contents, only to find out they had edited the actual data.  So they added a
"nofilter" clause that forced VFP to create a new cursor and not use the
original approach.

2) I haven't seen any discussion on set relation - which might also do what
you want (but I haven't actually tested it so may be wrong.)

3) You can use the browse for  command (I tended to use this over set
filter, especially since I could then use "browse last" as well.)  As I
recall, this worked the same as set filter but didn't require the literal
values that set filter do.

4) Of course, Select is an option - but then you may have to guess if VFP
did #1 or if it actually created a cursor and your edits are thrown away
when you close it.

5) I can't remember, but did set filter allow you to reference a variable?
And, if so, did changing that variable then change the effect of the filter?
If so, this might also be an option.

Take care,

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Gene Wirchenko
Sent: Tuesday, May 14, 2019 3:46 PM
To: ProFox Email List
Subject: Filtering Oddity

Hello:

  I was looking over a program preparatory to an enhancement.  I 
inserted a debugging browse statement in a branch that I was going to 
add some error reporting to.  The branch, oddly, did not get 
executed.  Dig, dig ...

   use cwkf
   set filter to validto>={^2019.01.01}
   count
   browse

  Lots of rows.  Oh, the filter needs to be extended.

   set filter to filter()+" and empty(wfd)"

VFP: Nice try.  (Actually, "Command contains unrecognized phrase/keyword."

   set filter to (filter()+" and empty(wfd)")

VFP: Don't be silly.  (Same error.)

  Putting an avaluate() around it does not work either.  ("Syntax
error.")

  I do know that I can do
   f=filter()+" and empty(wfd)"
   set filter to 
but in the heat of debugging, I would prefer just one statement.

  Is there a way to extend a filter in one statement without 
retyping the current filter expression?

Sincerely,

Gene Wirchenko


[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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/034101d50cc9$d43e4c30$7cbae490$@yahoo.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] Advice about Phone from eBay

[Fletcher Johnson]

Charles,

The way it's presented makes it sound rather suspicious.  You may want to query 
Google how to find out if a phone has been reported stolen.  Or if it is a 
counterfeit.

I have a couple of S7s that work just fine.  Yeah, the battery no longer lasts 
as long as I like, but that's minor (and typical.)

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Charles Hart Enzer, 
M.D.
Sent: Monday, May 13, 2019 5:40 AM
To: Profox
Subject: [NF] Advice about Phone from eBay

Please advise

I bought a new Galaxy S7 on eBay

Serial number on phone's label on the back back different than software - -
*#06#
The IMEs are the same

My tests of phone 100%:

https://lv.testm.com/latest-test?testId=5194455


Seller says:

New message from: is.prime  (3,029)

The issue you mentioned may caused by the unlock procedure

Would you mind keeping the phone to use if we refund $20 to you make as
compensation and send a B earphone to you ?

The B earphone value is 50USD.

We wait for your news
best regards
Lotus

Your previous message

The Serial Number on the Back of the phone is not the same as in the phone.

And the sticker was loose -- not glued.

Thank you


New Samsung Galaxy S7 G930T T-MOBILE 5.1" Unlocked Smartphone/Black
Onyx/32GB
eBay sent this message to Charles Enzer (enzerch). Learn more about account
protection. eBay is committed to your privacy. Learn more about our privacy
notice and user agreement.


*Shai / שי **Charles Hart Enzer, MD(Ohio, USA), FAACAP*
*Aliyah <https://en.wikipedia.org/wiki/Aliyah>: Cincinnati to Jerusalem
<http://www.gojerusalem.com/items/263/German-Colony/>'s German Colony
<https://en.wikipedia.org/wiki/German_Colony,_Jerusalem> May, 2017*



*Volunteer Associate Professor of PsychiatryUniversity of Cincinnati
Medical CenterWebSite: **EnzerMD.com <http://EnzerMD.com>*
*Publications* <http://www.enzermd.com/CV.html#Publications>

*Tiny Country, Huge Dreams*
*ארץ זעירה, **חלומות ענקיים*
*עם ישראל חי*


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

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/016301d50a83$0f216ce0$2d6446a0$@yahoo.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: ProFox Messages are not showing up

[Fletcher Johnson]

I get this message every once in a while, with the last one on 5/1 at 8:49 am.

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ed Leafe
Sent: Friday, May 3, 2019 2:01 PM
To: ProFox Mailing List
Subject: Re: ProFox Messages are not showing up

On May 3, 2019, at 2:20 PM, Charlie-gm  wrote:
> 
> Not sure what is going on. I got a weird message the other day saying my 
> account has gotten a lot of bounces.
> 
> Could someone drop a note when they see this in the list (I should have 
> prefixed this with [OT] or [NF] but I wanted to see if the most "visible" 
> target is going through).

I got about 70 “Bounce Action Notification” messages this morning, and it looks 
like they are all from gmail accounts. So my question to gmail users: have you 
been getting posts regularly?

I will unblock those addresses as soon as I have time. I’m currently at a 
conference[0].


-- Ed Leafe

[0] https://www.openstack.org/ptg




[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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/026101d50550$154eb560$3fec2020$@yahoo.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: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

[Fletcher Johnson]

Alan,

I picked an easy to understand example.  The point I was trying to make was
that Mike had a question that was ambiguous - the best options really
depended on what he needed to accomplish - audit logs or time aware data.

But, to be nit-picky, if I generate thousands of invoices per day (or more),
does it make more sense (especially considering normalization rules) to have
one date aware record or an additional field(s) in the invoice table showing
the purchase price (and any other time sensitive data)?   

I do agree that, in a many  cases, your approach should work just fine.

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Alan Bourke
Sent: Wednesday, April 24, 2019 1:46 AM
To: profoxt...@leafe.com
Subject: Re: How best to do an audit trail of changes (EASILY WITHOUT THE
NEED FOR A DBA)

On Tue, 23 Apr 2019, at 5:04 PM, Fletcher Johnson wrote:

> The second is much more critical.  If the price of an item changes, 
> when an invoice is printed, it needs to show the price in effect when 
> it was printed.  If I sell something today, the current price is 
> usually appropriate.  But if I re-print an invoice from last month, I 
> need to know the price (and quite likely, other values) in effect at 
> that time.  In other words, time is just one more critical data point 
> used to identify the correct data.
> 
> The downside to the first is that, unless you re-write your code, the 
> solution requires either triggers or stored procs - both of which 
> require a DBA (in most work environments.)
> 
> The downside to the second is that not only will it require a dba 
> (structure changes), 

In the case of re-printing an invoice, store the price at the time of
initial creation in your invoice line details table and use that when
reprinting. Or store a PDF of the emailed\printed invoice, and re-use that.


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

[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/058801d4fabf$d8261920$88724b60$@yahoo.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: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)

[Fletcher Johnson]

Mike,

Your question has evoked answers that address 2 separate issues.

1) How are changes to data saved so an audit can identify who changed what and 
when?
2) How can someone have time appropriate data?

For the first, the answers on audit all appear quite good.  Separate tables 
that can be reviewed via some special UI.  But this approach is only auditing, 
not for ongoing business.

The second is much more critical.  If the price of an item changes, when an 
invoice is printed, it needs to show the price in effect when it was printed.  
If I sell something today, the current price is usually appropriate.  But if I 
re-print an invoice from last month, I need to know the price (and quite 
likely, other values) in effect at that time.  In other words, time is just one 
more critical data point used to identify the correct data.

The downside to the first is that, unless you re-write your code, the solution 
requires either triggers or stored procs - both of which require a DBA (in most 
work environments.)

The downside to the second is that not only will it require a dba (structure 
changes), but it will also require work to make your queries time aware.

Just a thought,

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of MB Software 
Solutions, LLC
Sent: Monday, April 22, 2019 12:34 PM
To: profox@leafe.com
Subject: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR 
A DBA)

VFP9SP2 app, MariaDB 10 (MySQL) backend.

One of my clients asked about a history of price changes.  Easy enough 
to implement programmatically for the few price fields, but then I got 
to wondering if simply putting code in the ON UPDATE trigger to send the 
old record to a "history" table would be a more complete (and long term 
EASIER) solution, whereby my app would query the "history" table for 
changes.

Your thoughts for tracking price (or other) changes?

tia,
--Mike



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


[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/039301d4f9ee$2f914810$8eb3d830$@yahoo.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: To type or not to type

[Fletcher Johnson]

Johan,

I am curios, is the code below standard X#?  If so, how do you anticipate
the VFP code version to work, a converter or modifications so that it can
use standard VFP?  And will there be a way to easily update types (i.e. a
search for not typed, week typed, etc.) so that we can then choose to
specify a type? 

Also, VFP uses a lot of classes and forms, mostly built on a UI builder.
Will X# be able to convert the VFP classes/forms to code that can then be
rendered using the VS form builder?

I did notice that you defined dStartas, but didn't use it - not that it
would have any effect on the performance.

This is not meant to be judgmental, I think what you are doing is great, I
am just curious.

Thanks,

Fletcher 


Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Johan Nel
Sent: Sunday, April 14, 2019 10:29 PM
To: profox@leafe.com
Subject: X#: To type or not to type

Hi all VFP'ers,

As you probably know by now X# plans to have VFP syntax support by 
October 2019.

A question I am asked a lot by VFP coders is: Do I have to strict type 
my code in X#? Well, X# allows both lazy declaration and strict declaration.

Here is a small benchmark to compare the results:

function Start( ) as void

   local  nWeak
   local  nStrongas  int
   local  dStartas  DateTime

   System.Console.WriteLine("Starting, non typed")&& The .NET way of "?
"
   dStart :=DateTime.Now
   for  nWeak := 1to  1000
 nop&& A X# way of saying No operating procedures, will not produce a 
compiler warning message
   next
   System.Console.WriteLine("Terminated, non typed, duration "  +
(DateTime.Now - dStart ):ToString() )

   System.Console.WriteLine("Starting, typed")
   dStart :=DateTime.Now
   for  nStrong := 1to  1000
 nop
   next
   System.Console.WriteLine("Terminated, typed, duration "  + (DateTime.Now
- dStart ):ToString() )

return

&& Results:
&& Starting, non typed
&& Terminated, non typed, duration 00:00:00.6469739

&& Starting, typed
&& Terminated, typed, duration 00:00:00.0210397

&& A speed improvement of 30.75 times

Hope this is of interest to some.

Johan Nel
George, South Africa
FOX member: Friends of XSharp
X# Website: https://xsharp.info <https://xsharp.info/>
X# Runtime: https://github.com/X-Sharp/XSharpPublic
X# VFP forum: https://www.xsharp.info/forum/public-vfp

[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/002501d4f3d6$1957ea90$4c07bfb0$@yahoo.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] What happens on the Wednesday after the 2nd Tuesday?

[Fletcher Johnson]

Ted,

I finally found a way to stop the updates from crashing my computer (which
was a big deal because I run a number of VMs and when windows rebooted, it
was as if I had a power failure not good.

Anyway, I followed the process at this page:
https://www.windowscentral.com/how-prevent-windows-10-rebooting-after-instal
ling-updates

I have a batch file that I run via a shortcut that temporarily
enables/disables windows doing this.  It's not perfect - MS still tries to
run the software, but it can't force the computer to reboot anymore.

Not great, but it sure helps...

Fletcher


Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche
Sent: Thursday, April 11, 2019 3:05 PM
To: profox@leafe.com
Subject: [NF] What happens on the Wednesday after the 2nd Tuesday?

Windows machines crash, or fail to start:

https://www.bleepingcomputer.com/news/microsoft/microsofts-april-2019-update
s-are-causing-windows-to-freeze/

Just the usual. Avoid updates for a while, lock up your machines if you can.

Happy Patch Tuesday Hangover!

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


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

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://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/0dca01d4f0bc$8034f860$809ee920$@yahoo.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: A FoxPro Transition @ UCLA...

[Fletcher Johnson]

Kurt,

As with some of the others, my thought is that you can't realistically
recommend some other product until you are much more familiar with what
parts they currently use and how they use them.  And what they would hope to
accomplish with those once moved to the new environment.  There are lots of
tools out there and no way to know which is best until you understand what
they have.

Also, X# has a considerable amount of interest, simply because it will (in
theory) allow you to run the current VFP code as well as add new features in
C#, F#, VB.  But it's all a guessing game until they are able to release
something.

It may also be that you are the only candidate they can find.  And you do
hang out with some of the best names in the industry (heck, if the current
developer has any VFP books, chances are they were written by folks here -
who might even give you a recommendation.)

Anyway, I wish you the best,

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Kurt at VR-FX
Sent: Tuesday, March 19, 2019 10:45 PM
To: ProFox Email List
Subject: A FoxPro Transition @ UCLA...

Hello there folks,
I'm looking to get some feedback from the hive mind of this group. And, 
I will admit, I'm doing this kind of last minute. Too many things going 
on lately, and I have not had a chance to do my true due diligence! Such 
as thorough research via prior postings in this forum.

So as some of you may already know, I had a first interview for a 
programmer job at UCLA. The second interview is coming up, it's supposed 
to be this Thursday, but I might try to postpone until Friday. Too much 
stuff going on in my life lately, including doing 2 different part time 
jobs and an extended relative who passed away recently, that's the 
reason I'm going down to LA for an in-person interview, since the last 
interview I did via Skype.
It looks like UCLA really wants to move away from Foxpro, as they know 
it's a dead language. But, they want to move to something similar to 
VFP. I suspect its also because the 1 and only programmer there, who's 
been there for like 30 years and may be retiring soon - doesn't want to 
learn something Totally new. And, also wants to minimize the transition! 
They are asking me to propose what I think is the best option. They have 
mentioned several options such as Fox-in-Cloud, the Alpha software, and 
even Servoy. They did not bring up things like Lianja, XoJo, or X# the 
open source X-base language.

I know that Fox-in-Cloud even offers a type of Conversion Assistant - 
which looks really Great! But, once its converted and running in the 
cloud - I'm assuming that making updates to the system actually means 
programming in something that is not actually FoxPro - as I think its 
Javascript & HTML. But, I could be wrong - and am sure Thierry will 
correct me.

There was also some recent discussion on X# which looked like a 
potentially great option. But, I heard that via the last posting - the 
FoxPro version of the code wasn't really ready yet!

They also told me that they have already been working with Alpha SW - 
and in discussions with them for several months. Which makes me think 
they are already leaning towards Alpha. A quick review of old postings 
in this forum did not show a lot of discussion or users of Alpha. It 
would really be great to hear from some Alpha users!

Anyway - any and all input would be greatly appreciated. I've seen 
Numerous discussions about a number of these technologies here in the 
forum over the years. But, honestly - I never truly got involved with 
any of them - until NOW!

Regards,
Kurt


[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/000601d4e018$f15b5ac0$d4121040$@yahoo.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] Looking for current summary of VFP clones

[Fletcher Johnson]

Stephen,

The problem is that the money isn't available for a re-write in a totally new 
language - essentially using the current product as a specification.  

So they are exploring options to see what is currently out there. Of course, 
one option is to just stay with VFP.  But they want to consider other options 
if they are available. They did this about five or six years ago and didn't see 
anything, so this is just a check to see if things have changed since then.

Fletcher


Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Stephen Russell
Sent: Thursday, March 14, 2019 1:17 PM
To: ProFox Email List
Subject: Re: [NF] Looking for current summary of VFP clones

In all the years of writing apps have you ever had a talented user who told
you what they wanted to be even close to what they ended up with?

That being said, a rewrite allows the developer to "fix" the poor decisions
and tweaks to fix them.  If you had that commitment from the champion why
not get it off the desktop and make it contemporary to apps in the 2020
time frame?  That could be cloud, web, tablet/phone,  as well as PC.  Those
may be what the user wants in the re-write anyway.




On Thu, Mar 14, 2019 at 12:01 PM Kevin J Cully 
wrote:

> I think this is key.  You all know that I'm a huge Xojo fan, however I
> can't ever believe that rewriting an application for something other than a
> real concrete reason is a good idea.  Basically if you are wondering if you
> should rewrite a VFP application, then the answer is "no" already.  If you
> know you need to rewrite a VFP application, then you already know why it
> needs to be rewritten, by definition.  (Examples: Needs cross platform.
> Needs 64-bit.  Can't interface with 'X'. etc.)
>
> Great post Thierry.
>
>
> -Original Message-
> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Thierry
> Nivelet
> Sent: Thursday, March 14, 2019 6:24 AM
> To: profox@leafe.com
> Subject: Re: [NF] Looking for current summary of VFP clones
>
> Hi Fletscher,
>
> Does your client really knows that, since 10 is the last version of
> Windows, VFP will work as long as Windows 10 will work, and re-write and/or
> migration will bring nothing but cost and risk without a single benefit
> (except for those who rewrite): learning, moving data to SQL if not
> already, rewriting, testing, retraining users, managing the transition with
> part of the app in VFP and part in the new system (no new app ever work
> overnight), etc., maybe loss of functionalities, and risk that the
> transition works out badly…
>
> Seeking alternatives to FoxPro was valid until Microsoft announced that
> Windows 10 was the last version (in may 2015, almost 4 years ago), today
> it's just seeking cost and risk for no other benefit than 'doing someting
> new'.
>
> VFP is incredibly reliable; some FoxInCloud clients have FoxInCloud web
> apps with over 50 forms (could be more), 50 concurrent users (could be
> more), PostgreSQL database, 8 logical servers in parallel (stateless,
> many-to-many relation between users and servers), running full weeks
> without a single error (100% availability) while reading and writing
> thousands of files, tables, memos, indexes and so forth. The busiest server
> runs 25k user requests per day, that we can estimate over 1.2 billion VFP
> instructions, without a single error…
>
> Bringing additional value to the existing VFP app is probably more worthy
> and interesting than rewriting; eg. with FoxInCloud.
>
> (I know I don't really answer your original question, just trying to open
> new pathes).
>
> Thierry Nivelet
> FoxInCloud
>
> Le 13/03/2019 à 16:45, Fletcher Johnson a écrit :
> > Hi all,
> >
> >
> >
> > I was asked for a list of current options for someone who has a VFP
> > application and wants to migrate it to a supported language, with the
> > least amount of re-work.
> >
> >
> >
> > I have seen many options listed, but am sure how compatible the
> > various alternatives are.  X# looks promising, but so do some of the
> > others.  And some that I thought were good options now appear to be
> > dormant or discontinued.  So I thought I would check with you fine
> > folks to see if you know where I might find a list of current
> > alternatives and their level of compatibility.
> >
> >
> >
> > Thanks,
> >
> >
> >
> > Fletcher
> >
> >
> >
> > Fletcher Johnson
> >
> >   <mailto:fletchersjohn...@yahoo.com> fletchersjohn...@

RE: [NF] Windows 10 versions (was Looking for current summary of VFP clones)

[Fletcher Johnson]

Alan,

At some point, the updates need to be implemented.  Enterprises can delay
it.  Small companies with no (or limited) internal tech usually can't.  Or
they come up with kludges to stop them.  But in essence the Windows 10 you
have today will not be the same Windows 10 you have in 1.5 years.  I am
wondering why they even bother with keeping the 10. Why not call it Windows
build 1803 (in your case)  The 10 is just irrelevant now.

Just my 2 cents...

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Alan Bourke
Sent: Friday, March 15, 2019 7:45 AM
To: profox@leafe.com; profoxt...@leafe.com
Subject: Re: [NF] Looking for current summary of VFP clones

> Since the upgrades are forced on everyone, unless you have a computer 
> like one of mine that crashes when MS tries to push an upgrade (and 
> then reverts), in theory, everyone is running on the same version.

Not true. Windows 10 Pro, Education and Enterprise versions can defer
feature updates (i.e. the big semi-annual ones) for up to a year. This would
need to be specifically configured in Group Policy though. Our organisation
has thousands of Windows 10 boxes I imagine, and we're all still on 1803.

You cannot normally defer these updates in Windows 10 Home without fiddling
in the registry. But hey, what business is using that version, right?


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

[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/084901d4db6a$d56f6250$804e26f0$@yahoo.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] Looking for current summary of VFP clones

[Fletcher Johnson]

John,

That's what I heard too - that Windows 10 will simply keep getting upgraded.  
What matters now is the version (which is what the "10" used to represent.)  

Since the upgrades are forced on everyone, unless you have a computer like one 
of mine that crashes when MS tries to push an upgrade (and then reverts), in 
theory, everyone is running on the same version. So why change the name?

But I don't think that it means that Windows is going away anytime soon.

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of John Weller
Sent: Thursday, March 14, 2019 6:51 AM
To: profox@leafe.com
Subject: RE: [NF] Looking for current summary of VFP clones

No we keep getting 6-monthly 'Feature' updates .  

John Weller
01380 723235
07976 393631


Will admit - I'd not heard that Win10 is last version. What happens next? 
Windows goes way of Dodo bird???



[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/062b01d4da85$59de1860$0d9a4920$@yahoo.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] Looking for current summary of VFP clones

[Fletcher Johnson]

Thierry,

All I know is that there have been a number of comments about various options 
that are similar to VFP that have come out (X# is one) where VFP code will more 
or less run, especially with some of the built in conversion tools.  

So the question isn't whether to stay with VFP, but if there are any 
alternatives that will run the VFP code without significant re-writes.  

Thanks,

Fletcher


Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Thierry Nivelet
Sent: Thursday, March 14, 2019 3:24 AM
To: profox@leafe.com
Subject: Re: [NF] Looking for current summary of VFP clones

Hi Fletscher,

Does your client really knows that, since 10 is the last version of Windows, 
VFP will work as long as Windows 10 will work, and re-write and/or migration 
will bring nothing but cost and risk without a single benefit (except for those 
who rewrite): learning, moving data to SQL if not already, rewriting, testing, 
retraining users, managing the transition with part of the app in VFP and part 
in the new system (no new app ever work overnight), etc., maybe loss of 
functionalities, and risk that the transition works out badly…

Seeking alternatives to FoxPro was valid until Microsoft announced that Windows 
10 was the last version (in may 2015, almost 4 years ago), today it's just 
seeking cost and risk for no other benefit than 'doing someting new'.

VFP is incredibly reliable; some FoxInCloud clients have FoxInCloud web apps 
with over 50 forms (could be more), 50 concurrent users (could be more), 
PostgreSQL database, 8 logical servers in parallel (stateless, many-to-many 
relation between users and servers), running full weeks without a single error 
(100% availability) while reading and writing thousands of files, tables, 
memos, indexes and so forth. The busiest server runs 25k user requests per day, 
that we can estimate over 1.2 billion VFP instructions, without a single error…

Bringing additional value to the existing VFP app is probably more worthy and 
interesting than rewriting; eg. with FoxInCloud.

(I know I don't really answer your original question, just trying to open new 
pathes).

Thierry Nivelet
FoxInCloud

Le 13/03/2019 à 16:45, Fletcher Johnson a écrit :
> Hi all,
>
>   
>
> I was asked for a list of current options for someone who has a VFP
> application and wants to migrate it to a supported language, with the least
> amount of re-work.
>
>   
>
> I have seen many options listed, but am sure how compatible the various
> alternatives are.  X# looks promising, but so do some of the others.  And
> some that I thought were good options now appear to be dormant or
> discontinued.  So I thought I would check with you fine folks to see if you
> know where I might find a list of current alternatives and their level of
> compatibility.
>
>   
>
> Thanks,
>
>   
>
> Fletcher
>
>   
>
> Fletcher Johnson
>
>   <mailto:fletchersjohn...@yahoo.com> fletchersjohn...@yahoo.com
>
>   <http://linkedin.com/in/FletcherJohnson> LinkedIn.com/in/FletcherJohnson
>
> twitter.com/fletcherJ
>
>   <https://www.strava.com/athletes/fletcherjohnson>
> strava.com/athletes/fletcherjohnson
>
> 408-946-0960 - work
>
> 408-781-2345 - cell
>
>   
>
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
>text/plain (text body -- kept)
>text/html
> ---
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://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/062a01d4da85$596761c0$0c362540$@yahoo.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: VF9 - Running an app on a schedule....

[Fletcher Johnson]

Desmond,

A couple of questions.

1) Any idea if you are getting any error messages?  Any logs you might look
at?
2) Will the scheduler run a batch file?  If so, could that start the VFP
app?
3) You could always write your own scheduler using VFP and set it so it runs
on startup.
4) You might try creating a simple VFP app that simply starts up, writes a
message to a file, then closes down to see if that works.  If so, then it
may be a matter of tracking down what is preventing the real app from
running (memory allocation, thread conflict, etc.)

Hope one of these helps,

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Desmond Lloyd
Sent: Wednesday, March 13, 2019 4:39 PM
To: ProFox Email List
Subject: VF9 - Running an app on a schedule

Have a small app that queries a table,  pus it in a spreadsheet and emails
it out.  Worked fine for several months using the Windows Task Scheduler.
Now all of a sudden it's refusing to run the app.  If I run it from outside
of the schedule it works fine!

Is there a way to run the app using another VFP app?

TIA,
Desmond


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

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://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/052e01d4d9fa$4cd47370$e67d5a50$@yahoo.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] Looking for current summary of VFP clones

[Fletcher Johnson]

Hi all,

 

I was asked for a list of current options for someone who has a VFP
application and wants to migrate it to a supported language, with the least
amount of re-work.

 

I have seen many options listed, but am sure how compatible the various
alternatives are.  X# looks promising, but so do some of the others.  And
some that I thought were good options now appear to be dormant or
discontinued.  So I thought I would check with you fine folks to see if you
know where I might find a list of current alternatives and their level of
compatibility.

 

Thanks,

 

Fletcher

 

Fletcher Johnson

 <mailto:fletchersjohn...@yahoo.com> fletchersjohn...@yahoo.com

 <http://linkedin.com/in/FletcherJohnson> LinkedIn.com/in/FletcherJohnson

twitter.com/fletcherJ

 <https://www.strava.com/athletes/fletcherjohnson>
strava.com/athletes/fletcherjohnson

408-946-0960 - work

408-781-2345 - cell

 



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

___
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/046201d4d9b3$bf0caf80$3d260e80$@yahoo.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.

[OT] RE: Test Message - Please ignore

[Fletcher Johnson]

Dave,

No worries, it was just a joke reply anyway I tend to procrastinate at 
times, (hard as it may be to believe) so the whole thing was tongue in cheek... 

Fletcher


Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier
Sent: Wednesday, March 13, 2019 1:54 AM
To: 'ProFox Email List'
Subject: RE: Test Message - Please ignore

Sorry, should have marked it [OT]. My bad

Dave Crozier
Software Development Manager
Flexipol Packaging Ltd.

﴾⚆ᨎ⚆﴿


-Original Message-
From: ProFox  On Behalf Of Fletcher Johnson
Sent: 11 March 2019 19:51
To: 'ProFox Email List' 
Subject: RE: Test Message - Please ignore

Dave,

Thanks for sending a message I can ignore.  I am really busy right now and 
appreciate the effort you made so that I don't get distracted from my important 
work by a message that I can simply ignore.  I mean, it's not like I have tons 
of time to write long, boring responses to trivial emails right now.  Your 
effort to help me stay on track and not get distracted is greatly appreciated.

Speaking of which, I really think that message subjects should have much more 
detail so that all are as easy to ignore as this one is.  Just like we have the 
little flags to indicate humor, not fox, off topic, etc. we should have some 
that really matter, such as musings, trivial, please ignore, etc. that will 
help all of us not get distracted and waste time we should be spending on some 
stupid project.

Anyway, that all said, I guess I will get back to said project.  Unless, of 
course, you feel the need to send out another message I should ignore, in which 
case, I will have yet another good reason to procrastinate because, like all 
good ProFox participants, we simply can't ignore such a message, any more than 
a cat can ignore a laser pointer, a dog ignore anything that even remotely 
seems like food, etc.

So, in parting, thanks for your delightful email, providing me a way to expound 
upon the virtues of said tags.

Have a great day while I get back to the project that really needs more 
procrastination 

Fletcher


Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier
Sent: Monday, March 11, 2019 5:00 AM
To: 'profox@leafe.com'
Subject: RE: Test Message - Please ignore

Test to see if SPF change is now active.. Please ignore

Dave Crozier
Software Development Manager
Flexipol Packaging Ltd.

﴾⚆ᨎ⚆﴿



Flexipol® Packaging Ltd
T 01706 222 792
E dcroz...@flexipol.co.uk
W https://www.flexipol.co.uk/
Follow us: 
Unit 14 Bentwood Road, Carrs Industrial Estate, Haslingden, Lancashire, BB4 5HH

​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.

-
​​
​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 
o

RE: Test Message - Please ignore

[Fletcher Johnson]

Dave,

Thanks for sending a message I can ignore.  I am really busy right now and 
appreciate the effort you made so that I don't get distracted from my important 
work by a message that I can simply ignore.  I mean, it's not like I have tons 
of time to write long, boring responses to trivial emails right now.  Your 
effort to help me stay on track and not get distracted is greatly appreciated.

Speaking of which, I really think that message subjects should have much more 
detail so that all are as easy to ignore as this one is.  Just like we have the 
little flags to indicate humor, not fox, off topic, etc. we should have some 
that really matter, such as musings, trivial, please ignore, etc. that will 
help all of us not get distracted and waste time we should be spending on some 
stupid project.

Anyway, that all said, I guess I will get back to said project.  Unless, of 
course, you feel the need to send out another message I should ignore, in which 
case, I will have yet another good reason to procrastinate because, like all 
good ProFox participants, we simply can't ignore such a message, any more than 
a cat can ignore a laser pointer, a dog ignore anything that even remotely 
seems like food, etc.

So, in parting, thanks for your delightful email, providing me a way to expound 
upon the virtues of said tags.

Have a great day while I get back to the project that really needs more 
procrastination 

Fletcher


Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier
Sent: Monday, March 11, 2019 5:00 AM
To: 'profox@leafe.com'
Subject: RE: Test Message - Please ignore

Test to see if SPF change is now active.. Please ignore

Dave Crozier
Software Development Manager
Flexipol Packaging Ltd.

﴾⚆ᨎ⚆﴿



Flexipol® Packaging Ltd
T 01706 222 792
E dcroz...@flexipol.co.uk
W https://www.flexipol.co.uk/
Follow us: 
Unit 14 Bentwood Road, Carrs Industrial Estate, Haslingden, Lancashire, BB4 5HH

​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.

-
​​
​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: ProfoxTech  On Behalf Of Ted Roche
Sent: 04 March 2019 13:59
To: profoxt...@leafe.com
Subject: Re: Test Message - Please ignore

Dave:

I used "View Original" in GMail to look at your actual message, after 
processing through the leafe.com mailing list, and the headers are just smaller 
than war and peace, in the original Klingon.

It looks like you are using Outlook 365 (I always wondered what happens on leap 
year) and that goes through outlook.com and that post-processes through 
websphere.com (eu2.mailsphere.mx) before getting to leafe.com and relaying, for 
me, to Gmail. Your original message has a softfail on SPF, reporting that 
"domain of

RE: Creating a copy of a database -- best practice?

[Fletcher Johnson]

Mike,

I am assuming that the backup has to happen while the tables are in use (or
you would just copy over the data folder via windows.)
\
Creating the DBC programmatically should be easy (I seem to remember there
is an option in VFP that generates the code to do so - which includes all
the rules, RI, structures, etc. )  Just no data.  You could use this to
create a destination with no data and then append the source data to the
empty backup tables.

This would create a very clean, packed, set of data.  

Of course, it's not that simple if anyone is using it at the time.  

You probably want to lock the source tables (and related) before appending.
Or if you have a last modified record in the tables, use that to check for
any changes since the data was copied.  Or you might use cursors/views so
that changes made by others don't affect you while copying.  In fact, if you
use a view or have buffering on, once the append is complete, you can check
for changes.  

Anyway, I am sure you will find something that works best for you,


Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Wednesday, February 27, 2019 9:23 AM
To: ProFox
Subject: Creating a copy of a database -- best practice?

I can easily do something like this:

CREATE DATABASE C:\Backup\MyDBC.dbc
OPEN DATABASE C:\Production\MyDBC.dbc
liNumTables = adbobjects(laTables,'TABLE')
for ii = 1 to liNumTables
   lcFile = forceext("C:\BACKUP\" + laTables[ii],'dbf')
   use laTables[ii]
   copy to (lcFile) database C:\Backup\MyDBC.dbc with cdx
   use
endfor


..and that would get me a copy of all of the tables with their indexes. 
  Great.  But what's the easiest way to get all of the DBC meta-data into 
that new Backup database copy?  I can't USE the MyDBC.dbc and do a COPY 
TO as that only makes the result a DBF and FPT.

Trying to think about a good disaster recovery plan (besides using 
CleverFox from Rick Schummer and Frank Perez...which is probably the 
best option!) for automating backups at the client who just got that 
ransomware virus.

tia,
--Mike

[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/043701d4d2dd$02e16bc0$08a44340$@yahoo.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: UCLA & FoxPro...

[Fletcher Johnson]

Kurt,

It might not hurt to point out to them that there aren't many VFP developers 
available (certainly not good ones) and that they may find that they need to 
adjust the pay or not be able to find anyone.  

You might try to get some idea of how hard it's been for them to find someone 
and, if so, consider discussing salary when they offer you the job...  

Anyway, hope it all works out for you!

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Kurt @ Gmail
Sent: Saturday, March 2, 2019 1:19 PM
To: profox@leafe.com
Subject: Re: UCLA & FoxPro...

HA ha - Nice one Mike!

Nope - its mainly FoxPro dev. in a logistics type dept. w/in UCLA. 
Downside - pay is TERRIBLE!!! Its a tad more than 1/2 my last salary! Ugh...

I can't believe they want someone with Exp. - serious VFP/FoxPro exp. - 
yet, only want to pay 60K! Although, I hear this is common in Uni's!

:-(

-K-

On 3/1/2019 1:57 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
> On 2019-03-01 15:53, Vince Teachout wrote:
>> On 03/01/19 2:33 PM, Kurt @ Gmail wrote:
>>> Yup - if you can believe (which I am sure you folks can - since 
>>> Uni's at time tend to be a bit behind in Tech.) - they actually have 
>>> a job opening with FoxPro being the core of the job. Just finished 
>>> doing a Skype interview with 4 people. Was actually kinda fun!
>>>
>>> They will probably be contacting me for the next phase. In which 
>>> they also let me know I will be doing a kind of programming test - 
>>> then a 2nd interview.
>>
>> Best of luck in the new job!!!
>
>
> Yes, best wishes!  What would the job title be?  A professor teaching 
> "Database Fundamentals 101" or "Database Applications Made Easy with 
> VFP"
>
> :-)
>
[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/043601d4d2dd$0280fc40$0782f4c0$@yahoo.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] Looking for a little Python/Django help

[Fletcher Johnson]

Kurt,

Ok, to summary:

You want to use virtual environments.  Microsoft Code and PyCharm both support 
them as well.  Not sure about Visual Studio.

Microsoft Code appears to be pretty good debugging server side code (running 
locally.)

The Django (if you use that) environment is really "interesting". It's a 
complete framework including the back end data access, server side code, and 
UI. You can create restful interfaces or write the html out directly..  That 
said, it does take quite a bit of buy in.  And, you can write your code using 
functions or classes. Classes mean less work and repetition, but having both 
approaches used does make finding answers sometimes a little confusing.

Python uses classes, but the implementation will make your brain hurt.  And 
python supports multiple inheritance, which is also a mind twist.  The rational 
is cool, but you want to be careful playing with it.

The DjangoGirls tutorial really is a good (and fast) way to get started.  They 
also have a forum where you can post more novice questions and not be shot down 
like you might on StackOverflow.  

Feel free to ping me directly if you have any questions.  Don't know if I will 
have the answer, but I might... :)

And if I stumble on something that the kids might like, I will let you know.

Fletcher 

Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Kurt @ Gmail
Sent: Monday, January 28, 2019 8:49 AM
To: profox@leafe.com
Subject: Re: [NF] Looking for a little Python/Django help

I'm actually going to read your Blog post - since, if you can believe it 
- I'm actually starting to teach a class to kids, in an after school 
type program. One class is 3D Design/3D Printing - but, the other class 
is Python based.  Am also going to look around at some older threads 
here talking about Python - so I can truly get a quick jump start in 
Python. Of course, needless to say - I need only stay 1 or 2 steps ahead 
of the kids!

And - if ANYONE has a suggestion for something Cool I could teach the 
kids in Python - feel free to give me a shout out!

Fletcher - sorry to Hi-Jack your thread. At least its not a total 
hi-jacking and steering it into a wrong direction...

I give you back the steering wheel now!

-K-

On 1/24/2019 4:55 PM, Ed Leafe wrote:
> On Jan 24, 2019, at 5:07 PM, Fletcher Johnson  
> wrote:
>> My most interesting python question is related to the "file... import ..." 
>> command.  Apparently, you can't specify a parent folder in the file portion, 
>> just the current one.  But there is a way to designate where other files may 
>> be found, I just haven't figured out where that gets set, especially when 
>> using environments.
> You can't specify operating system paths in the import command; those modules 
> need to be in known locations where Python can find them. When you install 
> something (usually with `pip install`), it is placed in the 'site-packages' 
> directory of your environment. I started to write a big long explanation 
> here, but decided that it would be better as a blog post:
>
> https://blog.leafe.com/using-a-python-virtual-environment/
>
> Of course, if you have any questions about that, let me know.
>
>
> -- Ed Leafe
>
>
>
[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/037301d4b798$91d2a480$b577ed80$@yahoo.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] Looking for a little Python/Django help

[Fletcher Johnson]

Ed,

Actually, the Djangogirls link that Alan provided is amazingly good.  While it 
is geared to beginners (this is what a variable is, etc.) it doesn't waste time 
on details and you can actually get a working model up rather quickly. I wish I 
could find more tutorials like that.  Most would have used 3-4 days to get to 
what they do in an hour or so. 

My most interesting python question is related to the "file... import ..." 
command.  Apparently, you can't specify a parent folder in the file portion, 
just the current one.  But there is a way to designate where other files may be 
found, I just haven't figured out where that gets set, especially when using 
environments.  Then the other part of the environments question is how to know 
if the code (or whatever) is coming from the main system or from the 
environment.  I know I will get this figured out soon, but getting Django 
working first is a much higher priority as I need to write a backend demo 
system using it 

Thanks,

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ed Leafe
Sent: Thursday, January 24, 2019 8:53 AM
To: ProFox Mailing List
Subject: Re: [NF] Looking for a little Python/Django help

On Jan 23, 2019, at 8:29 PM, Fletcher Johnson  
wrote:
> 
> I can write a simply python app and have it run without issue. But trying to
> get Python running inside a virtual environment and getting Django
> configured correctly is giving me a head ache.  I know what I need to do,
> just not where to set the values I need to set.

I haven’t played much with Django, so I wouldn’t be of any help with 
Django-specific settings/questions. But feel free to ping me with questions, 
either to my personal email, or the near-moribund ProPython email list

-- Ed Leafe






[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/043101d4b439$8c68c900$a53a5b00$@yahoo.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] Looking for a little Python/Django help

[Fletcher Johnson]

Alan,

I agree about the Mac/Linux thing As I have a Pycharm license, I will
try that (and DjangoGirls) out.

Appreciate the tips,

Fletcher


Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Alan Bourke
Sent: Thursday, January 24, 2019 3:48 AM
To: profoxt...@leafe.com
Subject: Re: [NF] Looking for a little Python/Django help

What you'll find also is that the vast bulk of Django and a lot of Python
learning material assumes you are Mac or Linux based.

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

[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/03a601d4b403$d235f4c0$76a1de40$@yahoo.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] Looking for a little Python/Django help

[Fletcher Johnson]

Hi all,

 

I have to work on a small Python project using Django.  Given what I have
seen, it shouldn't be too difficult.  But I haven't really used either
product and have a few, relatively easy questions. 

 

Currently, I am using Microsoft Code (although I could use Visual Studio,
PyCharm, or some other IDE) on a windows platform.  

 

I can write a simply python app and have it run without issue. But trying to
get Python running inside a virtual environment and getting Django
configured correctly is giving me a head ache.  I know what I need to do,
just not where to set the values I need to set.

 

Anyway, if anyone out there is available for Skype chat, Google hangout, or
even an old fashioned phone call, I would really appreciate it.

 

Thanks,

 

Fletcher

 

Fletcher Johnson

 <mailto:fletchersjohn...@yahoo.com> fletchersjohn...@yahoo.com

 <http://linkedin.com/in/FletcherJohnson> LinkedIn.com/in/FletcherJohnson

twitter.com/fletcherJ

 <https://www.strava.com/athletes/fletcherjohnson>
strava.com/athletes/fletcherjohnson

408-946-0960 - work

408-781-2345 - cell

 



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

___
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/030a01d4b38c$961f3d10$c25db730$@yahoo.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: Hey, can you test this...

[Fletcher Johnson]

Malcolm,

I agree about using various password managers, but it's not uncommon for
people to have some passwords saved in a browser (sometimes without even
realizing it.)  

I am more interested if this is repeatable or if it's just something weird
with my computer/configuration.  If it is repeatable, it's a good thing for
us to know.

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Malcolm Greene
Sent: Monday, January 14, 2019 4:35 PM
To: profox@leafe.com
Subject: Re: Hey, can you test this...

Fletcher,

> I use Chrome.  I have a number of passwords saved ...

Stop. Disable your browser(s) password saving features.  Use a password
manager like 1Password or LastPass.

I'm a big 1Password fan myself.

Malcolm

[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/04f401d4ac8a$e2fc0ae0$a8f420a0$@yahoo.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.

Hey, can you test this...

[Fletcher Johnson]

Hi all,

 

I use Chrome.  I have a number of passwords saved.  But I think I found a
security issue and was wondering if anyone wanted to see if they had the
same result (or already knows about it.)

 

Today, I was messing around with Chrome.  I clicked on log out and then use
another account.  I created a new one using a non gmail account.  When it
came up, I still had all the same bookmarks, etc.  So I went into settings
and chose reset (advanced, at the bottom) as well as changed the default
startup to be a new page.  I then closed Chrome and rebooted the computer.  

 

I start Chrome, and log in using the new email ID, I still see all the
previous bookmarks.  And if I go to settings, passwords, I can see all the
passwords for all the sites that belonged to my real Gmail account.  But I
am logged in using the new email ID account.

 

The funny thing is if I go to settings/passwords, I can see all the
passwords.  But if I click on the option to view and manager saved passwords
in your Google Account - on that web page, it says I have none... Very
strange.

 

And yes, the passwords are *'ed out, but if you click on the eye icon and
enter the windows login password, you can then see them as pure text.

 

Just curious to see if anyone else can replicate it.

 

Fletcher

 

Fletcher Johnson

 <mailto:fletchersjohn...@yahoo.com> fletchersjohn...@yahoo.com

 <http://linkedin.com/in/FletcherJohnson> LinkedIn.com/in/FletcherJohnson

twitter.com/fletcherJ

 <https://www.strava.com/athletes/fletcherjohnson>
strava.com/athletes/fletcherjohnson

408-946-0960 - work

408-781-2345 - cell

 



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

___
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/04be01d4ac69$3e76e5b0$bb64b110$@yahoo.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.

Genes scroll bar - DBC usage question

[Fletcher Johnson]

Gene,

Given the cool things that you get from a DBC, why do you choose not to use
it?  

Just curious,

Fletcher


Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Gene Wirchenko
Sent: Monday, January 14, 2019 3:28 PM
To: ProFox Email List
Subject: Re: AW: Custom Scrollbar

At 06:06 2019-01-10, Frank Cazabon  wrote:
>Gene, I've knocked up a quick demo which I hope meets your 
>requirements and emailed you the link to the download on google drive.

  I was beat last week, and did not get to it.  I have a couple 
days off (today and tomorrow) and am digging into it.  Preliminary:

  I should have stated code only.  Never mind.  Converting it to 
code only will help me learn.  

  I do not use database containers.  I hope this does not break 
your solution.  I was concerned because of the validation rules, but 
this, at least, does not appear to be an issue.

  Focus should be set on a control in the grid at the start.   I 
assume that there is a simple statement to do that.

  Validation of each column is not done at the start of row-level 
validation.  This is important.  What if the data displayed is 
invalid?  I may be able to get this myself.

  I have not done much yet, but this looks as if it works.  So 
how did I miss it?  I think bad documentation is to blame, but while 
converting it to code, I ought to find out.  I think I probably got 
snookered by Before/AfterRowColChange().

[snip]

Sincerely,

Gene Wirchenko


[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/04b401d4ac65$07b1bc70$17153550$@yahoo.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: AW: Custom Scrollbar

[Fletcher Johnson]

Gene,

I am sure you have tried all of the following, but thought I might check 
regarding the record validation thing.

Are you using data from a table that is part of a database?  If so, do you have 
both field and row level validations specified in the dbc?

Are you using buffering and CursorGetProp() and related functions/methods to 
check for field/row level changes?

If yes to all above, just ignore this message..
If no to any of the above, that might be part of the problems you are having 
with the validations.

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
beknown.com/FletcherJohnson
twitter.com/fletcherJ
twitter.com/svcsug
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Gene Wirchenko
Sent: Monday, January 7, 2019 7:35 PM
To: ProFox Email List
Subject: RE: AW: Custom Scrollbar

At 14:47 2019-01-07, "Darren"  wrote:
>Been watching this thread and decided to pipe in 
>- I have to observe that I have done some pretty 
>tricky stuff with the VFP grid. Granted some not 
>so straight forward but subclass columns and 
>headers etc. and you can go for broke. Not found 
>anything that can’t be done with the VFP grid. 
>Not to say it can do everything but I'm yet to 
>find what that is. Spend a bit of time (a few 
>hours) and enlightened you will be.

   I have spent *manweeks* trying to get Grid 
to work for my needs.  It has resisted quite effectively.

[snip]

Sincerely,

Gene Wirchenko


[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/084a01d4a7bc$4af1fc50$e0d5f4f0$@yahoo.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: VSS to git conversion

[Fletcher Johnson]

Tracy,

Now I remember.  I actually had a program that I could run that would
re-sort the scx (or the generated code) and then re-format the code so that
the code was always in more or less the same sequence and format. I am
guessing that whoever wrote FoxBin2PRG had some of the same frustrations and
was nice enough to build something more robust and then publish it.  

When VSS support was first added, the theory was that any source control
could be used.  I often wondered if the hooks were still there so that Git
could be used as (more or less) seamlessly as VSS.

I hope things work out,

Fletcher


Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
beknown.com/FletcherJohnson
twitter.com/fletcherJ
twitter.com/svcsug
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Tracy Pearson
Sent: Friday, January 4, 2019 1:25 PM
To: profox@leafe.com
Subject: RE: VSS to git conversion

Fletcher,

We used the default SCCTEXT.PRG is what creates the VCA and SCA files stored
in VSS next to the binary files. However, attempting to DIFF that did not
always work out well. VFP would move some records around when editing a
method. It would look like a big chunk of the form or class library had been
removed from higher up, and then added back in down below. Which is actually
the case, since that code is stored in a memo field. Change a memo field.
The old value is still in the FPT until it's packed out. The new value is
added to the end.

I understand the FoxBin2PRG fixes that problem. It also enables just the
text version to be stored in the source control because it can be turned
back in to a binary file. 


Thank you,
Tracy


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Fletcher
Johnson
Sent: Friday, January 04, 2019 3:38 PM
To: profoxt...@leafe.com
Subject: RE: VSS to git conversion

Tracy,

My understanding is that bin2prg (or something like it) was created
expressly to support what you want to do.  The idea was that the dbf (.scx,
etc.) would be used to create a comparable prg file and then both would be
checked in.  The prg was used for change tracking only.  It worked great
with VSS - not sure how well it will work with Git using the VFP project
manager, but you should be able to create a script that will do effectively
the same thing.

Fletcher 


Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
beknown.com/FletcherJohnson
twitter.com/fletcherJ
twitter.com/svcsug
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Friday, January 4, 2019 12:21 PM
To: ProFox Email List
Subject: Re: VSS to git conversion

On 2019-01-03 11:29, Tracy Pearson wrote:
> We are looking at changing things over from VSS to git. There are about 
> 20
> projects that we want to transfer the history of the files in to git.
> However, we do not want to transfer the binary files over. We haven't 
> been
> using the FoxBin2PRG since we have been just working directly in the
> standard project manager in VFP.


Hi Tracy...Happy New Year!

Did you mean to say that you ARE or ARE NOT using FoxBin2PRG?  I'd think 
you would have to use it to achieve the non-binary source code control 
process.

[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/083a01d4a7b9$ec4b8e70$c4e2ab50$@yahoo.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: VSS to git conversion

[Fletcher Johnson]

Tracy,

My understanding is that bin2prg (or something like it) was created
expressly to support what you want to do.  The idea was that the dbf (.scx,
etc.) would be used to create a comparable prg file and then both would be
checked in.  The prg was used for change tracking only.  It worked great
with VSS - not sure how well it will work with Git using the VFP project
manager, but you should be able to create a script that will do effectively
the same thing.

Fletcher 


Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
beknown.com/FletcherJohnson
twitter.com/fletcherJ
twitter.com/svcsug
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Friday, January 4, 2019 12:21 PM
To: ProFox Email List
Subject: Re: VSS to git conversion

On 2019-01-03 11:29, Tracy Pearson wrote:
> We are looking at changing things over from VSS to git. There are about 
> 20
> projects that we want to transfer the history of the files in to git.
> However, we do not want to transfer the binary files over. We haven't 
> been
> using the FoxBin2PRG since we have been just working directly in the
> standard project manager in VFP.


Hi Tracy...Happy New Year!

Did you mean to say that you ARE or ARE NOT using FoxBin2PRG?  I'd think 
you would have to use it to achieve the non-binary source code control 
process.

[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/031f01d4a46d$6f3b3a10$4db1ae30$@yahoo.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] Anyone seen pricing on Java fees for 2019?

[Fletcher Johnson]

I just find it funny that now Oracle is selling their language and MS is
giving theirs away (more or less).  I had figured that Oracle would simply
borrow the MS approach but I guess the $$ were more important to them.

I wonder if this affects Android (or maybe losing that battle with Google is
what prompted this...)

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
beknown.com/FletcherJohnson
twitter.com/fletcherJ
twitter.com/svcsug
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ed Leafe
Sent: Wednesday, November 14, 2018 10:02 AM
To: ProFox Mailing List
Subject: Re: [NF] Anyone seen pricing on Java fees for 2019?

On Nov 14, 2018, at 11:21 AM, Stephen Russell  wrote:
> 
> We agree on seeing the monetary potential for java ownership was going to
> bite us all.

One of the most compelling reasons for adopting Python is that such
practices are impossible. It is permissibly licensed, so the threat of some
corporation holding a critical part of an app hostage for licensing fees is
simply not possible. Same is true for Go.

When I realized that Microsoft was killing VFP because it could make more
money on other products, I swore I would never get suckered into such a
situation ever again.


-- Ed Leafe






[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/003b01d47d44$4ad94c70$e08be550$@yahoo.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: Big Changes & Fox Work in SF Bay Area?

[Fletcher Johnson]

Kurt,

Welcome to CA!  Nice to know another VFP/FP guy in the area (there aren't
that many left)  The last time I searched for VFP type jobs, I found a
few scattered over the east coast and a couple down in LA. 

Given that I also have grey hair syndrome, I can commiserate with your
struggle.  If you want, get in touch and I may be able to give you some
ideas.

The one takeaway I have found is that the top companies (Amazon, Facebook,
etc.) all get a huge hit because everyone wants to work there.  But that
makes it easier to focus on the companies that don't generate the same
prestige.  

Otherwise, have a very happy Thanksgiving!

Fletcher


Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
beknown.com/FletcherJohnson
twitter.com/fletcherJ
twitter.com/svcsug
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Kurt @ Gmail
Sent: Wednesday, November 7, 2018 10:16 AM
To: profox@leafe.com
Subject: Big Changes & Fox Work in SF Bay Area?

Hey there folks,

Yeah - I've been MIA for a little while now. I struggled to find work in 
NYC area - and things just went from Bad to Worse! So - towards the end 
of Sept. I made a big life change. Packed up my car - putting most of my 
life in Storage - then hit the road and drove West Old Man...

About 8 days later I arrived in San Francisco - where I am now living at 
my sister's place. So, I've been looking for work out here. Even applied 
to a job at "X" - the special hi-tech lab of Google. They had a job for 
a 3D Printing specialist. I would have been Perfect for the job - as I 
had everything they wanted. But, maybe they saw me as too old, working 
too many years, and probably thought I would need more $$$ than they 
wanted to pay for the position - and, as such - I never heard back from 
them. I even had not One but TWO Internal referrals - but, alas, that 
didn't help...

I'm even looking for possible FoxPro work - which is the main reason I 
am making this posting.

Anyone know of any FoxPro work in the Cali area? Preferably in the SF 
Bay area. Although, I will consider elsewhere in Cali.

TIA!
-K-

[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/001801d47d43$898eb960$9cac2c20$@yahoo.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] Broken Windows

[Fletcher Johnson]

Or you might ask them why Visual Studio is only a 32 bit application
Yes, it can build 64 bit apps, but they can't figure out how to compile it
as a working 64 bit app.  And if they can't fix that in all the time they
have had, how would you expect them to redo windows 

Maybe they are hoping we will all move to Linux and run our apps on Azure
instead Much less work for them to support... All I know is that they
are doing their best to piss off everyone they can.


Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
beknown.com/FletcherJohnson
twitter.com/fletcherJ
twitter.com/svcsug
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche
Sent: Thursday, October 25, 2018 7:34 AM
To: profox@leafe.com
Subject: Re: [NF] Broken Windows

On Thu, Oct 25, 2018 at 9:28 AM Man-wai Chang  wrote:

>
> Which means Micro$oft might need to rewrite it again? ;)
>
>
Well, they bought DOS, slapped a gui on it, sold that for nearly 20 years,
moving it from 16- to 32-bit, yay Win32s!

Windows, 2.0, 3.1, 3.1, 3.11, W4Workgroups, W4Tablets, w4Work, Win95, 98,
Millenium

They teamed up with IBM to write OS/2 later "WARP," using Windows New
Technology with the New Technology File System.

Then they torpedoed IBM and released it as Windows NT. And that's what we
are running today, Windows NT 3, 3.5, 3.51, 4, 7, Windows Vista, Windows 8,
Windows 10. They've glommed a lot of stuff on top, but it's Windows NT on
NTFS with its lousy security model, patched over with a new domain model
and Policy enforcement, but it's the Registry and LAN Man and the same old
print queue.

It's tens of millions of lines of code, written mostly by people who don't
work there any more. It's huge, it's heavy, it's buggy. And it runs on
Desktops. And Servers. And not much else. Not smartphones, not lightweight
tables, not the internet. Ignoring Windows CE (which still exists, running
my settop box -*shudder), WindowsPhone, and XBox OS, all speciality
spinoffs.

Perhaps they should rewrite it. Third time's the charm, or so they
mythology goes within MS.

Highly recommended: https://en.wikipedia.org/wiki/Microsoft_Windows for a
refresher on the history. Good overview.

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


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

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://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/032d01d46fe5$332b0bc0$99812340$@yahoo.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] Mac PC infected with MacKeeper

[Fletcher Johnson]

Charlie,

It sounds more like a browser attack, not system.  I have seen a number like 
this on other browsers and often, the fix is quite simple.  But they can be 
very annoying!

I would be interested to hear how you end up solving it.

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
beknown.com/FletcherJohnson
twitter.com/fletcherJ
twitter.com/svcsug
strava.com/athletes/fletcherjohnson
greatcyclechallenge.com/Riders/FletcherJohnson (stop cancer)  
408-946-0960 - work
408-781-2345 - cell

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Charlie-gm
Sent: Wednesday, July 25, 2018 11:34 AM
To: ProFox Email List
Subject: [NF] Mac PC infected with MacKeeper

Hi all,

I have a friend that thinks he got infected with "MacKeeper" (whatever 
that is). He thinks it happened when he clicked on a link in Safari that 
was supposed to be updating his Adobe Flash.

I'm not sure that is the name of the malware. He says that whenever he 
tries to do a google search it says something about needing to go to 
Apple (apple.mac-xperts.com ???)  - and any link he clicks on that 
result takes him to a "phone number" (I did not see his screen either). 
It also appears that his default web page gets switched to Firefox or 
something like that.

Does anyone know about that, and if so, how to get rid of the problem on 
the Mac?

TIA,
-Charlie

[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/019501d4251d$8e0f6580$aa2e3080$@yahoo.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: Anyone remember this?

[Fletcher Johnson]

Does the email list remove attachments?

Fletcher


Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
beknown.com/FletcherJohnson
twitter.com/fletcherJ
twitter.com/svcsug
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Jürgen
Wondzinski
Sent: Thursday, March 22, 2018 1:10 AM
To: 'ProFox Email List'
Subject: AW: Anyone remember this?

No picture in your posting... 

-Ursprüngliche Nachricht-
Von: ProFox <profox-boun...@leafe.com> Im Auftrag von Fletcher Johnson
Gesendet: Donnerstag, 22. März 2018 03:47
An: 'ProFox Email List' <profox@leafe.com>
Betreff: Anyone remember this?

Hi all,

 

I was digging through some boxes and saw this shirt.. Too bad it no longer
applies, that was a good decade.. J  For those of you who don't get it, at
one Devcon, a number of us realized that we were all turning 40 the same
year. Which means that many of us are probably turning 60 this year.. 

 

Anyway, it's good to see all the chatter still going on this list! 

 

Fletcher

 

Fletcher Johnson

 <mailto:fletchersjohn...@yahoo.com> fletchersjohn...@yahoo.com

 <http://linkedin.com/in/FletcherJohnson> LinkedIn.com/in/FletcherJohnson

 <https://www.strava.com/athletes/fletcherjohnson>
strava.com/athletes/fletcherjohnson

 



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

[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/06ed01d3c489$90e2c260$b2a84720$@yahoo.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.

Anyone remember this?

[Fletcher Johnson]

Hi all,

 

I was digging through some boxes and saw this shirt.. Too bad it no longer
applies, that was a good decade.. J  For those of you who don't get it, at
one Devcon, a number of us realized that we were all turning 40 the same
year. Which means that many of us are probably turning 60 this year.. 

 

Anyway, it's good to see all the chatter still going on this list! 

 

Fletcher

 

Fletcher Johnson

 <mailto:fletchersjohn...@yahoo.com> fletchersjohn...@yahoo.com

 <http://linkedin.com/in/FletcherJohnson> LinkedIn.com/in/FletcherJohnson

 <https://www.strava.com/athletes/fletcherjohnson>
strava.com/athletes/fletcherjohnson

 



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

___
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/01b501d3c187$ffb9aaa0$ff2cffe0$@yahoo.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: hellooo-o

[Fletcher Johnson]

Andy,

Ach

Ach who?

Guesuntight!

Fletcher


Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
beknown.com/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of AndyHC
Sent: Saturday, January 13, 2018 5:23 AM
To: profox@leafe.com
Subject: hellooo-o

Knock knock!
Is there anybody there?

[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/089a01d38e32$55a78fb0$00f6af10$@yahoo.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: Reminder about VFP compound indexes and best strategy

[Fletcher Johnson]

Hi all,

As I recall, as long as the value to the left of the "=" matches a key, then
Rushmore will use it.  

So if you use a compound key (index on city + state +
padl(allt(str(radius)),6,'0') tag MyTag) , it will only be fast if you use
something like:

Select * from MyTable
where city + state + padl(allt(str(radius)),6,'0') = "some value with padded
spaces, etc."

In most cases, this would be silly.  But there are exceptions - yours is not
apparently one of them as indexes on the individual fields will always be
faster.

Keep in mind that if you have an index on radius or even str(radius), the
following still will not be optimized:
Select * from MyTable
where padl(allt(str(radius)),6,'0') = "  342342"

You would have to actually have an index build on
padl(allt(str(radius)),6,'0') - not very useful.

The key question is, once you have filtered by city and state, how many
records will you then have?  If many (>10,000 or so), then an additional
filter option might help. But VFP can filter 10,000 (and usually much more)
records very fast, even without indexes - so only testing would help.

Anyway, hope things worked out for you,

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
beknown.com/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Frank Cazabon
Sent: Friday, November 3, 2017 5:22 PM
To: profox@leafe.com
Subject: Re: Reminder about VFP compound indexes and best strategy

Individual indexes on each field should work, not an index on the compound
expression.

On 3 November 2017 17:09:39 GMT-04:00,
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
>VFP9SP2 free table
>
>I've got a table with this structure:
>
>city c(30)
>state c(2)
>radius i
>distance i
>
>My query is looking for city, state, and radius, to get back those 
>whose distance is <= InputParameter.
>
>select *
>   from MyTable
>  where city = m.tcCity and state = m.tcState and radius <= m.tiRadius
>
>Not sure if I should
>index on city tag city
>index on state tag state
>index on radius tag radius
>
>or
>
>index on city + state + padl(allt(str(radius)),6,'0') tag MyTag
>
>???
>
>I know I can use SYS(3054) to get my answer but I'm getting ready to be
>
>away from the office for a bit and was hoping someone knew the obvious 
>answer.  Otherwise I'll run my testing later tonight.
>
>(At the very least, hopefully somebody learned about SYS(3054,x,y)
>today.)
>
[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/056301d359b1$ce55a880$6b00f980$@yahoo.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: Weird font behavior on project tabs, table designer, etc.

[Fletcher Johnson]

Alan, Bill, Richard, et. al.,

Ok, I have attached a screen shot.  This should make it clear where I am
having the problem.

All the ideas you mentioned work quite well for changing what they are
supposed to change - but none of those have any effect on the fonts that are
showing incorrectly.

If you are here in the states, have a Happy Thanksgiving, otherwise, have a
happy rest of the week :)

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
beknown.com/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Bill Anderson
Sent: Tuesday, November 22, 2016 7:14 AM
To: ProFox Email List
Subject: Re: Weird font behavior on project tabs, table designer, etc.

Fletcher,

There's a setting for the project font in the options dialog. Look for where
to set the font for programs and memo fields, etc. I think it's the last
setting on the dropdown (from memory, I don't have VFP open at the
moment...)

Bill Anderson

On Tue, Nov 22, 2016 at 6:15 AM Fletcher Johnson
<fletchersjohn...@yahoo.com>
wrote:

> Alan,
> But the only place I seem to have this problem is with vfp.
> Fletcher
> Sent from Yahoo Mail on Android
>
>   On Tue, Nov 22, 2016 at 5:51 AM, Alan Bourke<alanpbou...@fastmail.fm>
> wrote:   > The font for the projects form is in Tools->Options->IDE.
>
> That's only for the treeviews - all the form title bars are controlled 
> by the Windows font settings.
>
> --
>   Alan Bourke
>   alanpbourke (at) fastmail (dot) fm
>
[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/207801d249ad$60b6d390$22247ab0$@yahoo.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: Weird font behavior on project tabs, table designer, etc.

[Fletcher Johnson]

Alan, Bill, Richard, et. al.,

Ok, I have attached a screen shot.  This should make it clear where I am
having the problem.

All the ideas you mentioned work quite well for changing what they are
supposed to change - but none of those have any effect on the fonts that are
showing incorrectly.

If you are here in the states, have a Happy Thanksgiving, otherwise, have a
happy rest of the week :)

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
beknown.com/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Bill Anderson
Sent: Tuesday, November 22, 2016 7:14 AM
To: ProFox Email List
Subject: Re: Weird font behavior on project tabs, table designer, etc.

Fletcher,

There's a setting for the project font in the options dialog. Look for where
to set the font for programs and memo fields, etc. I think it's the last
setting on the dropdown (from memory, I don't have VFP open at the
moment...)

Bill Anderson

On Tue, Nov 22, 2016 at 6:15 AM Fletcher Johnson
<fletchersjohn...@yahoo.com>
wrote:

> Alan,
> But the only place I seem to have this problem is with vfp.
> Fletcher
> Sent from Yahoo Mail on Android
>
>   On Tue, Nov 22, 2016 at 5:51 AM, Alan Bourke<alanpbou...@fastmail.fm>
> wrote:   > The font for the projects form is in Tools->Options->IDE.
>
> That's only for the treeviews - all the form title bars are controlled 
> by the Windows font settings.
>
> --
>   Alan Bourke
>   alanpbourke (at) fastmail (dot) fm
>
[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/1ac001d245d2$967319a0$c3594ce0$@yahoo.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: Weird font behavior on project tabs, table designer, etc.

[Fletcher Johnson]

Bill,
I tried that. it doesn't apply to the tabs, only the text used for shoeing the 
contents for each tab.
Later today, I will post some examples (assume Ed let's us include images)
Fletcher

Sent from Yahoo Mail on Android 
 
  On Tue, Nov 22, 2016 at 7:14 AM, Bill Anderson<billan...@gmail.com> wrote:   
Fletcher,

There's a setting for the project font in the options dialog. Look for
where to set the font for programs and memo fields, etc. I think it's the
last setting on the dropdown (from memory, I don't have VFP open at the
moment...)

Bill Anderson

On Tue, Nov 22, 2016 at 6:15 AM Fletcher Johnson <fletchersjohn...@yahoo.com>
wrote:

> Alan,
> But the only place I seem to have this problem is with vfp.
> Fletcher
> Sent from Yahoo Mail on Android
>
>  On Tue, Nov 22, 2016 at 5:51 AM, Alan Bourke<alanpbou...@fastmail.fm>
> wrote:  > The font for the projects form is in Tools->Options->IDE.
>
> That's only for the treeviews - all the form title bars are controlled
> by the Windows font settings.
>
> --
>  Alan Bourke
>  alanpbourke (at) fastmail (dot) fm
>
[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/1409621909.2265444.1479839866...@mail.yahoo.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: Weird font behavior on project tabs, table designer, etc.

[Fletcher Johnson]

Alan,
But the only place I seem to have this problem is with vfp.
Fletcher
Sent from Yahoo Mail on Android 
 
  On Tue, Nov 22, 2016 at 5:51 AM, Alan Bourke wrote:  
 > The font for the projects form is in Tools->Options->IDE.

That's only for the treeviews - all the form title bars are controlled
by the Windows font settings.

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

[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/897741921.2055157.1479824079...@mail.yahoo.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.

Weird font behavior on project tabs, table designer, etc.

[Fletcher Johnson]

Hi all,

 

Recently installed VFP 9, SP2 on a new laptop.  

 

When I run VFP and open a project, the text for the project tabs (all, data,
document.) are quite large.  This is also true of the tabs and column data
(both titles - name, type, width. and data - field name, character, .)

 

For the life of me, I can't figure out where it found the font.  I checked
options, the registry entry, etc. but can't find anything that seems out of
place.  

 

It sort of looks like the "expanded" font on old Epson printers.

 

The VFP menu is fine as is the data in the properties windows (although the
tabs are screwed up).  The command window and text going to the screen all
appears as expected.

 

The problem is that VFP doesn't account for the size of this weird font and
many labels now overwrite each other or are hidden by the respective data
entry textbox, etc.

 

Any idea what is farkled up and how to fix it?  

 

Thanks,


Fletcher

 

 

Fletcher Johnson

 <mailto:fletchersjohn...@yahoo.com> fletchersjohn...@yahoo.com

 <http://linkedin.com/in/FletcherJohnson> LinkedIn.com/in/FletcherJohnson

 <http://beknown.com/FletcherJohnson> beknown.com/FletcherJohnson

twitter.com/fletcherJ

 <https://www.strava.com/athletes/fletcherjohnson>
strava.com/athletes/fletcherjohnson

408-946-0960 - work

408-781-2345 - cell

 



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

___
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/176b01d24463$999c8af0$ccd5a0d0$@yahoo.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: Friday Poll: What framework(s) do you use?

[Fletcher Johnson]

Ted,

I taught a lot of classes on development and I often built simple frameworks
in the course to demonstrate the power of OOP (and of frameworks).  Over
time, this led to the development of a fairly useful framework that I would
use for projects.  But I also used a few of the others you mentioned for
various projects (usually when they were adopted before I became involved.)

My key guideline was that it was almost always more effective to use a
framework than not (unless you used a framework that required you to do
things in a way you didn't want to do them and ended up with a quagmire)


Now that I am using C#, I tend to use the CODE Framework that Markus
Egger/EPS has published (for free.)  I really like that he has developed it
taking into account many of the objections that we in the VFP community had
when framework discussions were big.

Anyway, that's my 2 cents worth...

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
beknown.com/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche
Sent: Friday, November 4, 2016 7:30 AM
To: profox@leafe.com
Subject: Friday Poll: What framework(s) do you use?

I've been an advocate for frameworks since I read the original Codebook
book, sitting in a parking lot in Cambridge (our fair city), Massachusetts.

Imagine starting an application and not having to worry about how to get the
menu working (Help, About, Copy/Cut/Paste, Print settings) and getting basic
dialogs for things like managing reports, managing state between multiple
non-modal forms, a rational (usually!) set of strategies for data handling,
locking, conflict resolution, primary key generation, relational integrity,
grids on tabbed pageframes, etc.

I think frameworks are a great tool for fast startups, well-documented base
classes, and handy utilities. Please feel free to disagree.

In the 90's I was the manager for a group of developers and we worked as
"experts" with clients with pre-existing apps, or designed and developed
apps on our own. As such we got a lot of exposure to most of the frameworks.
Drew Speedie (RIP!) started MaxFrame, now "Professional" while working as
tech editor on Hacker's Guide, and I was an early and eager beta-tester,
also shipping one of the first client-server MaxFrame apps. We worked with
Visual Extend and with Mere Mortals and others. Sadly, I never got to work
with FoxExpress, although I have the greatest of respect for Mike and Toni's
knowledge and skills.

So, what framework(s) do you work with, and why (or why not)?

__ Built my own

__ Whatever the client runs

__ Codebook

__ COMCodebook

__ MaxFrame Professional

__ Visual Express

__ Visual Extend

__ Mere Mortals

__ VFP Foundation Classes

__ Visual ProMatrix

__ Mere Mortals

__ Other (please specify)

__ All of the Above

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

[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/100d01d23950$50ae68e0$f20b3aa0$@yahoo.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: M$ giving more support to dbf?

[Fletcher Johnson]

Hey all,

FWIW, while I think all this conspiracy stuff is just that, I do have to
point out that the US military has specific requirements which make no sense
to me.  One of them states that if a software (or many other) product is
specified in a contract, it cannot be changed for any reason without some
tedious process being followed.  

I have a client that is a major defense contractor and they occasionally
call me in to help with some of their apps that were written in VFP.  Not
only can they not move to a new app, they can't even have me re-write it in
something else even if the new app did the exact same thing with the exact
same interface.  

Even worse, when they found out that an in house developed tool was being
used by 2 different project teams, they required that a totally separate set
of source code be kept for each project team and changes made for one team
could NOT be applied to the other project teams source code.  And if the
other project team needed the same feature, it had to be written again using
that teams source code.

So yeah, I could actually see there being someone in the government
pressuring MS to not obsolete VFP.  But do I really think it happened?  It
sounds too intelligent for me to believe.

Fletcher


Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
beknown.com/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Man-wai Chang
Sent: Thursday, September 22, 2016 4:48 AM
To: ProFox Email List
Subject: Re: M$ giving more support to dbf?

On Wed, Sep 21, 2016 at 10:01 PM,
<mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
> On 2016-09-16 08:31, Man-wai Chang wrote:
>
> Actually I'd wager the US Govt--if anything--had a hand in keeping it 
> from behind totally taken off the table LONG ago.  You may recall that 
> several speculated that the govt had LOTS of Foxpro stuff and they 
> didn't want M$ to drop all support and/or do anything to prevent the 
> legacy stuff from working.  (DR-DOS anyone?)

You got an insider in US Government that is dealing with all Foxpro
projects? :)

--
 .~. Might, Courage, Vision. SINCERITY!
/ v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3) /( _ )\
http://sites.google.com/site/changmw
^ ^ May the Force and farces be with you!

[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/058601d215e0$d5319620$7f94c260$@yahoo.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: ODBC connections to Oracle problem

[Fletcher Johnson]

Ted,

Great to chat with you again.

While we have only been focusing on the ODBC 32 console, it didn't occur to
me that the default install may not have installed the 32 bit drivers since
we can see the Oracle option on the ODBC 32 manager.  But this could be the
old generic Oracle.  Let me check into this possibility.

Thanks!

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
beknown.com/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche
Sent: Thursday, August 4, 2016 12:04 PM
To: profox@leafe.com
Subject: Re: ODBC connections to Oracle problem

Fletcher:

Long time indeed! Hope life is treating you well.

The first thing to check is the "bit-ness" -- VFP is 32-bit only. If they
are on a 64-bit WIndows plarform, and if they are talking to Oracle via
ODBC, then they need to install the 32-bit ODBC drivers, and use the 32-bit
ODBC Administrator (not the one that's easy to find in the Control Panel) to
connect VFP to Oracle.

https://support.microsoft.com/en-us/kb/942976


On Thu, Aug 4, 2016 at 2:37 PM, Fletcher Johnson
<fletchersjohn...@yahoo.com> wrote:
> Hi all,
>
>
>
> Long time, no chat.. But I still lurk.  It's good to see this much 
> chatter on such a great product.
>
>
>
> Anyway, I have a former (and now current) client who has 2 
> applications written in VFP 8 or 9 that talk to an Oracle server.  The 
> programs were written back in 2000, with the last build being around 
> 2006 or so.  At that time, it was working with Oracle 8i.
>
>
>
> They have set up some new computers and installed Oracle 11.  They 
> have no access to Oracle 8i (Oracle long since discontinued it.)  Even 
> if a 3rd party still has it available, due to various reasons, they 
> could not use a version from any source other than the original
manufacturer.
>
>
>
> The problem is that their initial attempts to get it working did not work.
> They have some people working on it, but I thought I would check with 
> you to see if any of you have any ideas why it might not work (and 
> better, what to do to fix it.)  The problem seems to be around the TNS 
> approach they used to route to the correct server.
>
>
>
> I did find some source code, but not sure if it is the same as what is 
> in the .exe they run.  So my preference is to get it to run without 
> having to create a new exe.
>
>
>
> Anyway, I appreciate any suggestions you may have.
>
>
>
> Fletcher
>
>
>
> Fletcher Johnson
>
>  <mailto:fletchersjohn...@yahoo.com> fletchersjohn...@yahoo.com
>
>  <http://linkedin.com/in/FletcherJohnson> 
> LinkedIn.com/in/FletcherJohnson
>
>  <http://beknown.com/FletcherJohnson> beknown.com/FletcherJohnson
>
> twitter.com/fletcherJ
>
>  <https://www.strava.com/athletes/fletcherjohnson>
> strava.com/athletes/fletcherjohnson
>
> 408-946-0960 - work
>
> 408-781-2345 - cell
>
>
>
>
>
> --- StripMime Report -- processed MIME parts --- multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://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/0ed501d1eea1$38c699e0$aa53cda0$@yahoo.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: ODBC connections to Oracle problem

[Fletcher Johnson]

Stephan,

Good to hear from you, it's been a while.  Nice to hear from a friendly
face.

The TNSNames.ora file was around back in the 8i days, so we are used to it.
But we can't figure out why we are not connecting yet.

But we keep looking...

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
LinkedIn.com/in/FletcherJohnson
beknown.com/FletcherJohnson
twitter.com/fletcherJ
strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Stephen Russell
Sent: Thursday, August 4, 2016 12:40 PM
To: ProFox Email List
Subject: Re: ODBC connections to Oracle problem

Then you have to have access to the:
 http://www.orafaq.com/wiki/Tnsnames.ora

For Oracle to let you in and play.

On Thu, Aug 4, 2016 at 2:03 PM, Ted Roche <tedro...@gmail.com> wrote:

> Fletcher:
>
> Long time indeed! Hope life is treating you well.
>
> The first thing to check is the "bit-ness" -- VFP is 32-bit only. If 
> they are on a 64-bit WIndows plarform, and if they are talking to 
> Oracle via ODBC, then they need to install the 32-bit ODBC drivers, 
> and use the 32-bit ODBC Administrator (not the one that's easy to find 
> in the Control Panel) to connect VFP to Oracle.
>
> https://support.microsoft.com/en-us/kb/942976
>
>
> On Thu, Aug 4, 2016 at 2:37 PM, Fletcher Johnson 
> <fletchersjohn...@yahoo.com> wrote:
> > Hi all,
> >
> >
> >
> > Long time, no chat.. But I still lurk.  It's good to see this much
> chatter
> > on such a great product.
> >
> >
> >
> > Anyway, I have a former (and now current) client who has 2 
> > applications written in VFP 8 or 9 that talk to an Oracle server.  
> > The programs were written back in 2000, with the last build being 
> > around 2006 or so.  At
> that
> > time, it was working with Oracle 8i.
> >
> >
> >
> > They have set up some new computers and installed Oracle 11.  They 
> > have
> no
> > access to Oracle 8i (Oracle long since discontinued it.)  Even if a 
> > 3rd party still has it available, due to various reasons, they could 
> > not use
> a
> > version from any source other than the original manufacturer.
> >
> >
> >
> > The problem is that their initial attempts to get it working did not
> work.
> > They have some people working on it, but I thought I would check 
> > with
> you to
> > see if any of you have any ideas why it might not work (and better, 
> > what
> to
> > do to fix it.)  The problem seems to be around the TNS approach they
> used to
> > route to the correct server.
> >
> >
> >
> > I did find some source code, but not sure if it is the same as what 
> > is in the .exe they run.  So my preference is to get it to run 
> > without having
> to
> > create a new exe.
> >
> >
> >
> > Anyway, I appreciate any suggestions you may have.
> >
> >
> >
> > Fletcher
> >
> >
> >
> > Fletcher Johnson
> >
> >  <mailto:fletchersjohn...@yahoo.com> fletchersjohn...@yahoo.com
> >
> >  <http://linkedin.com/in/FletcherJohnson> LinkedIn.com/in/
> FletcherJohnson
> >
> >  <http://beknown.com/FletcherJohnson> beknown.com/FletcherJohnson
> >
> > twitter.com/fletcherJ
> >
> >  <https://www.strava.com/athletes/fletcherjohnson>
> > strava.com/athletes/fletcherjohnson
> >
> > 408-946-0960 - work
> >
> > 408-781-2345 - cell
> >
> >
> >
> >
> >
> > --- StripMime Report -- processed MIME parts --- 
> > multipart/alternative
> >   text/plain (text body -- kept)
> >   text/html
> > ---
> >
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://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/0ed601d1eea1$39224e70$ab66eb50$@yahoo.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.

ODBC connections to Oracle problem

[Fletcher Johnson]

Hi all,

 

Long time, no chat.. But I still lurk.  It's good to see this much chatter
on such a great product.  

 

Anyway, I have a former (and now current) client who has 2 applications
written in VFP 8 or 9 that talk to an Oracle server.  The programs were
written back in 2000, with the last build being around 2006 or so.  At that
time, it was working with Oracle 8i.

 

They have set up some new computers and installed Oracle 11.  They have no
access to Oracle 8i (Oracle long since discontinued it.)  Even if a 3rd
party still has it available, due to various reasons, they could not use a
version from any source other than the original manufacturer.

 

The problem is that their initial attempts to get it working did not work.
They have some people working on it, but I thought I would check with you to
see if any of you have any ideas why it might not work (and better, what to
do to fix it.)  The problem seems to be around the TNS approach they used to
route to the correct server.

 

I did find some source code, but not sure if it is the same as what is in
the .exe they run.  So my preference is to get it to run without having to
create a new exe.

 

Anyway, I appreciate any suggestions you may have.

 

Fletcher

 

Fletcher Johnson

 <mailto:fletchersjohn...@yahoo.com> fletchersjohn...@yahoo.com

 <http://linkedin.com/in/FletcherJohnson> LinkedIn.com/in/FletcherJohnson

 <http://beknown.com/FletcherJohnson> beknown.com/FletcherJohnson

twitter.com/fletcherJ

 <https://www.strava.com/athletes/fletcherjohnson>
strava.com/athletes/fletcherjohnson

408-946-0960 - work

408-781-2345 - cell

 



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

___
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/0e1201d1ee7f$473a10a0$d5ae31e0$@yahoo.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.

FW: HOT Software Engineer II Opportunity - VFP in Orlando gig

[Fletcher Johnson]

Hi all,

 

I just saw this (it went to an account I don't use much anymore) and thought
some of you might be interested.

 

Happy Holidays!

 

Fletcher

 

From: Emily Barcoso [mailto:ebarc...@kavaliro.com] 
Sent: Wednesday, December 4, 2013 9:52 AM
To: Fletcher Johnson
Subject: HOT Software Engineer II Opportunity
Importance: High

 

Hello Fletcher,

 

Hope everything is well with you. My name is Emily and I'm a Technical
Recruiter with Kavaliro. I came across your profile at Universal Thread
while hoping to find candidates for a Software Engineer II position to fill
a 3 months contract-to-hire spot in Orlando, FL. This position needs someone
who has an experience in developing FoxPro applications, developing SQL
Server databases using T-SQL and a good background in utilizing C#.Net. 

 

Please share this great opportunity if you are not currently available as I
am always looking to network with the best IT professionals and a rock star
candidate like yourself!

 

Thank you in advance for your time and consideration as I am looking forward
to your response.

 

Have a great day!

 

 

Best Regards,

 



Description: Description: cid:image003.gif@01CCBFC8.7F73ED50

Emily Barcoso
Technical Recruiter
Kavaliro 
Fueling Success


 

Website:

 http://www.kavaliro.com/ www.kavaliro.com


 

Email:

ebarc...@kavaliro.com


 

LinkedIn:

http://www.linkedin.com/in/mebarcoso


 

Phone:

571-318-5831


 


 

 

 

 



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

___
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/175c01cefa7d$b5089e60$1f19db20$@yahoo.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: SET REPORTBEHAVIOR 90

[Fletcher Johnson]

Alec,

Did you ever get a reply to this?  

Just curious,

Fletcher


Fletcher Johnson
fletchersjohn...@yahoo.com
408-781-2345 - Cell
408-946-0960 - Work
501-421-9629 - Fax


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of
pro...@crimestar.com
Sent: Monday, September 30, 2013 1:28 PM
To: 'ProFox Email List'
Subject: RE: SET REPORTBEHAVIOR 90

Hi Eurico,

Thanks for the quick reply.  The report printer environment is already
unchecked and never saved on any of my frx files. 

Alec Gagne
Crimestar Corporation
San Jose, California, USA


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Eurico Chagas
Filho
Sent: Monday, September 30, 2013 1:15 PM
To: ProFox Email List
Subject: Re: SET REPORTBEHAVIOR 90

In report properties, go to Page layout, under Printer, you can chose the
printer and there is a checkbox = Save printer environment, uncheck that.

E.



 From: pro...@crimestar.com pro...@crimestar.com
To: 'ProFox Email List' profox@leafe.com
Sent: Monday, September 30, 2013 4:56 PM
Subject: SET REPORTBEHAVIOR 90
 

Hi Folks,

I need a bit of help (again)!

I have a series of reports that I have run under SET REPORTBEHAVIOR 80 
and all has worked.  Part of my generic code creates a dialog which 
allows the user to set the default VFP printer using something similar 
to

X= getprinter()
SET PRINTER TO NAME (x)

Before calling the report form command.   This has always worked fine. 
In order to render text at a rotation on a specific report I have SET 
REPORTBEHAVIOR 90 and now the output is going to the default windows 
printer rather than the default VFP printer.  Does the report listener 
created when using REPORTBEHAVIOR 90 not honor the  SET PRINTER TO NAME 
command.  Is there a report listener object setting that I need to 
check to make sure my reports go to the default VFP printer?

Thanks

Alec Gagne


[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/164c01cec077$dc8dba00$95a92e00$@yahoo.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: Passing structs to COM objects

[Fletcher Johnson]

Tracy and Ted,

Your responses were just what I needed!

I miss hanging out here.  All the off the wall discussions, not to mention
the really cool tips on things I can do with VFP.  Too bad MS has done such
a good job of mucking it all up  But it's good to hear from you (and the
others).

Anyway, thanks again,

Fletcher 


Fletcher Johnson
fletchersjohn...@yahoo.com
408-781-2345 - Cell
408-946-0960 - Work
501-421-9629 - Fax


-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf
Of Tracy Pearson
Sent: Tuesday, September 06, 2011 2:11 PM
To: profox@leafe.com
Subject: RE: Passing structs to COM objects

Fletcher Johnson wrote on 2011-09-06: 
  Hi all,
 
 
  Long time, no chat..
 
 
  I am working on a VFP project that requires that I pass a struct.  
 For my  current problem, it wants an array of structs that simply have 2
doubles.
 
 
  I seem to remember there being a fairly straightforward way to create 
 a  variable that, to the COM objects method, looks like a struct, 
 when, in  fact, it is a string of values patched together.
 
 
  So the code in .net might look like
 
 
  Dim pt(2) as somestruct
  
  Pt(0).x = 123.9876
  
  Pt(0).y = 456.789
  
  Pt(1).x = 123.1
  
  Pt(1).y = 789
 
 
  Comobj.SomeSillyMethod(pt)
 
 
  And the structure looks something like:
  
  Structure Somestruct
Double x

Double y
 
 
  I assume I should be able to use a VFP array, but not sure how to 
 model
the
  struct.
 
 
  I am also not sure how to do it so that it sees it as a double and 
 not a  decimal or some other data type.
 
 
  Any and all ideas are welcome!
 
 
  Take care,
 
 
  Fletcher
  
  (who lurks here when time permits or problems require)
 
 
  Fletcher Johnson
  

Fletcher,

You cannot use the VFP Array. 

BINTOC(xValue, 4RS)+BINTOC(yValue, 4RS) should give you the structure. 

The DECLARE of the API will need to have that parameter be STRING.

If you need the information back, because it's an in/out parameter, it may
work. 

When I worked with the ShellExecuteEx() API, it worked fine. When I worked
with AllocateAndInitializeSid() and CheckTokenMembership() I needed to
allocate memory and free it with HeapAlloc(), HeapFree(). When I initialized
the allocated memory, I used SYS(2600). API's are a fun puzzle (for some).


Tracy Pearson
PowerChurch Software


[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/04c201cc7292$a9f48db0$fddda910$@yahoo.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.

Passing structs to COM objects

[Fletcher Johnson]

Hi all,

 

Long time, no chat..

 

I am working on a VFP project that requires that I pass a struct.  For my
current problem, it wants an array of structs that simply have 2 doubles.

 

I seem to remember there being a fairly straightforward way to create a
variable that, to the COM objects method, looks like a struct, when, in
fact, it is a string of values patched together.

 

So the code in .net might look like

 

Dim pt(2) as somestruct

Pt(0).x = 123.9876

Pt(0).y = 456.789

Pt(1).x = 123.1

Pt(1).y = 789

 

Comobj.SomeSillyMethod(pt)

 

And the structure looks something like:

Structure Somestruct

  Double x

  Double y

 

I assume I should be able to use a VFP array, but not sure how to model the
struct.

 

I am also not sure how to do it so that it sees it as a double and not a
decimal or some other data type.

 

Any and all ideas are welcome!

 

Take care,

 

Fletcher

(who lurks here when time permits or problems require)

 

Fletcher Johnson

fletchersjohn...@yahoo.com

408-781-2345 - Cell

408-946-0960 - Work

501-421-9629 - Fax

 



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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/051901cc6ccf$7300e3d0$5902ab70$@yahoo.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] Questions on migrating VFP app

[Fletcher Johnson]

Thierry,

You have some good points.  But our customers don’t have or want to manage a 
webserver. They just want to install the application and go.  And they also 
feel that using a browser opens them up to potential hacks - which is not a 
good thing in their case.  So regardless of what I think, I have to give them 
what they want or they will just go to another vendor who will.

But I will certainly keep your comments in mind for other situations.

Thanks,

Fletcher 


Fletcher Johnson
fletchersjohn...@yahoo.com
408-781-2345 - Cell
408-946-0960 - Work
501-421-9629 - Fax

-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of 
Thierry Nivelet
Sent: Friday, June 24, 2011 12:08 AM
To: profox@leafe.com
Subject: Re: [NF] Questions on migrating VFP app

Yeap, I understand, they do fall in the irrational, technophobe group I was 
mentioning.

And, strangely enough, even in this case a web-based solution can help...

In any scenario you need some kind of open door for upgrade, maintenance and 
other stuff; unless you physically come to the client's place with your toolbox 
on every issue, you probably have some kind of inward access to act upon 
workstations, server, LAN resources.

A Web-based solution like FoxInCloud acts exactly the same except you only need 
a http access for maintenance: no 'remote desktop' or the like needed for 99% 
maintenance tasks. Just execute a VFP program to upload and substitute the new 
app version; users just see a 'maintenance in progress' message for 30 seconds 
and resume working without any loss of data or work context.
It's just 'transparent': no need to warn them, ask them to log off, etc.

Another strong point is the freedom of choice for users regarding their 
equipment: go for Mac if you like, or Linux, or pad, or whatever you see fit 
for your taste and needs. No constraint on 'windows xx', no pollution of your 
app by 3rd party software like antivirus, less administrative burden to control 
OS upgrades or the like: your users are totally free, even on their preferred 
browser.

So, IMHO, offering a LAN server-based app can be a very pertinent offer to such 
a tech-agnostic client, especially if, with a tool like FoxInCloud, you can 
offer it at 1/5 th of your competitor's cost while making good money.

Thierry Nivelet
http://foxincloud.com/
Give your VFP app a second life in the cloud

Le 24 juin 2011 à 01:43, Fletcher Johnson fletchersjohn...@yahoo.com a 
écrit :

 Thierry,
 
 In addition to being very security conscious, they are also not very 
 technical.  So they need a very easy to use application that doesn't 
 use resources that are open to the web.  Desktop apps accessing a 
 local SQL network tend to fit this category.  Many of them use .dbf 
 tables because they can't even set up an SQL server (which the current 
 VFP app also supports.)
 
 With my other gig (a defense contractor), your approach would work just fine.
 
 Take care,
 
 Fletcher
 
 Fletcher Johnson
 fletchersjohn...@yahoo.com
 408-946-0960 - Work
 501-421-9629 - Fax
 
 
 -Original Message-
 From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On 
 Behalf Of Thierry Nivelet
 Sent: Wednesday, June 22, 2011 8:47 PM
 To: profox@leafe.com
 Subject: Re: [NF] Questions on migrating VFP app
 
 Just completing my previous point ...
 
 If your client has real irrational concerns about security, you can always 
 install the 'web' server in his LAN, and keep maintenance control over it 
 (upgrade, clean up, etc.) through a dedicated port specifically opened for 
 your IP at your expressed request. 
 
 That's how our more security addicts clients operate. 
 
 Thierry Nivelet
 http://foxincloud.com/
 Give your VFP app a second life in the cloud
 
 Le 23 juin 2011 à 04:48, Thierry Nivelet tnive...@foxincloud.com a écrit :
 
 Fletcher, Jeff,
 
 Regarding web apps, what security issue do you think of ?
 
 We have clients with professional secret duty using web apps !
 
 In the past data used to travel over the web; with Ajax web apps, only user 
 events and UI change orders travel, nothing significant or compromising; and 
 SSL easily fills this residual security 'leak'. 
 
 Thierry Nivelet
 http://foxincloud.com/
 Give your VFP app a second life in the cloud
 
 Le 22 juin 2011 à 23:23, Fletcher Johnson fletchersjohn...@yahoo.com a 
 écrit :
 
 Mike,
 
 Due to security reasons, it cannot be a web or cloud based app.  So 
 that limits some of the choices.  Also, it is for one of those 
 markets where Windows desktops prevail almost universally.  So there 
 is limited need for cross platform support.
 
 We are planning on a long term conversion, with our goal being to 
 have the entire application suite converted by the 2015.  This is 
 not a trivial application.
 
 So we will continue to support/enhance the VFP products.  But we are 
 running into IT departments that are making roadblocks to new sales 
 because of the
 2015 deadline

RE: [NF] Questions on migrating VFP app

[Fletcher Johnson]

Thierry,

Due to security reasons, our apps are desktop only and operate behind 
firewalls.  All over the air communication is done via a totally different type 
of signal transmission.  That's not to say it can't be hacked, but we try to 
make it more difficult.

So I can't say much about web security issues as they don't apply to me.

Take care,

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
408-946-0960 - Work
501-421-9629 - Fax

-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of 
Thierry Nivelet
Sent: Wednesday, June 22, 2011 7:48 PM
To: profox@leafe.com
Subject: Re: [NF] Questions on migrating VFP app

Fletcher, Jeff,

Regarding web apps, what security issue do you think of ?

We have clients with professional secret duty using web apps !

In the past data used to travel over the web; with Ajax web apps, only user 
events and UI change orders travel, nothing significant or compromising; and 
SSL easily fills this residual security 'leak'. 

Thierry Nivelet
http://foxincloud.com/
Give your VFP app a second life in the cloud

Le 22 juin 2011 à 23:23, Fletcher Johnson fletchersjohn...@yahoo.com a 
écrit :

 Mike,
 
 Due to security reasons, it cannot be a web or cloud based app.  So 
 that limits some of the choices.  Also, it is for one of those markets 
 where Windows desktops prevail almost universally.  So there is 
 limited need for cross platform support.
 
 We are planning on a long term conversion, with our goal being to have 
 the entire application suite converted by the 2015.  This is not a 
 trivial application.
 
 So we will continue to support/enhance the VFP products.  But we are 
 running into IT departments that are making roadblocks to new sales 
 because of the
 2015 deadline.
 
 What other languages would you recommend, now that you know more?
 
 Thanks,
 
 Fletcher
 
 Fletcher Johnson
 fletchersjohn...@yahoo.com
 408-946-0960 - Work
 501-421-9629 - Fax
 
 
 -Original Message-
 From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On 
 Behalf Of MB Software Solutions, LLC
 Sent: Wednesday, June 22, 2011 1:07 PM
 To: ProFox Email List
 Subject: Re: [NF] Questions on migrating VFP app
 
 On 6/22/2011 3:58 PM, Fletcher Johnson wrote:
 Hi all,
 
 I am working with a new company that has a successful VFP app that 
 they need to convert to .NET as MS will be cancelling support for VFP 
 soon and the customers IT departments are getting nervous.  So I have 
 been asked to help with a rewrite.
 
 I am sure there have been many discussions on this topic.  Can anyone 
 point me to some of the more current and complete discussions on this 
 topic (on this list or otherwise)?
 
 The new app will continue to be a desktop app and will have the same 
 interface (so there is no retraining required to implement the new
 version).
 It currently has the option to have data stored as local .dbf tables 
 or on an MS SQL table.  So we also need to continue to support 
 local/disconnected data sets.
 
 We are looking for suggestions on application frameworks, data 
 libraries (ORM, etc.), VS technologies
 (Silverlight/WPF/Winform/ADO/etc.)  and other resources that will aid 
 in the conversion.  We are not looking for something that will just 
 convert the code to .net as there are some key architectural 
 changes we
 want to implement under the hood.
 
 Any links or other references to point me in the right direction will 
 be greatly appreciated.
 
 
 Wow!  Support doesn't officially end until 2015 I think, and even 
 after that, it should last for YEARS!  Look at the large number of 
 FPD, FPW and
 pre-VFP9 apps out there yet!  BUT, I realize you're just a soldier 
 following orders.  Are you familiar with any of the DotNet languages?
 Must it be a Microsoft language?
 
 --
 Mike Babcock, MCP
 MB Software Solutions, LLC
 President, Chief Software Architect
 http://mbsoftwaresolutions.com
 http://fabmate.com
 http://twitter.com/mbabcock16
 
[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/01a801cc31fd$3cdc4fe0$b694efa0$@yahoo.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] Questions on migrating VFP app

[Fletcher Johnson]

Thierry,

In addition to being very security conscious, they are also not very technical. 
 So they need a very easy to use application that doesn't use resources that 
are open to the web.  Desktop apps accessing a local SQL network tend to fit 
this category.  Many of them use .dbf tables because they can't even set up an 
SQL server (which the current VFP app also supports.)

With my other gig (a defense contractor), your approach would work just fine.

Take care,

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
408-946-0960 - Work
501-421-9629 - Fax


-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of 
Thierry Nivelet
Sent: Wednesday, June 22, 2011 8:47 PM
To: profox@leafe.com
Subject: Re: [NF] Questions on migrating VFP app

Just completing my previous point ...

If your client has real irrational concerns about security, you can always 
install the 'web' server in his LAN, and keep maintenance control over it 
(upgrade, clean up, etc.) through a dedicated port specifically opened for your 
IP at your expressed request. 

That's how our more security addicts clients operate. 

Thierry Nivelet
http://foxincloud.com/
Give your VFP app a second life in the cloud

Le 23 juin 2011 à 04:48, Thierry Nivelet tnive...@foxincloud.com a écrit :

 Fletcher, Jeff,
 
 Regarding web apps, what security issue do you think of ?
 
 We have clients with professional secret duty using web apps !
 
 In the past data used to travel over the web; with Ajax web apps, only user 
 events and UI change orders travel, nothing significant or compromising; and 
 SSL easily fills this residual security 'leak'. 
 
 Thierry Nivelet
 http://foxincloud.com/
 Give your VFP app a second life in the cloud
 
 Le 22 juin 2011 à 23:23, Fletcher Johnson fletchersjohn...@yahoo.com a 
 écrit :
 
 Mike,
 
 Due to security reasons, it cannot be a web or cloud based app.  So 
 that limits some of the choices.  Also, it is for one of those 
 markets where Windows desktops prevail almost universally.  So there 
 is limited need for cross platform support.
 
 We are planning on a long term conversion, with our goal being to 
 have the entire application suite converted by the 2015.  This is not 
 a trivial application.
 
 So we will continue to support/enhance the VFP products.  But we are 
 running into IT departments that are making roadblocks to new sales 
 because of the
 2015 deadline.
 
 What other languages would you recommend, now that you know more?
 
 Thanks,
 
 Fletcher
 
 Fletcher Johnson
 fletchersjohn...@yahoo.com
 408-946-0960 - Work
 501-421-9629 - Fax
 
 
 -Original Message-
 From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On 
 Behalf Of MB Software Solutions, LLC
 Sent: Wednesday, June 22, 2011 1:07 PM
 To: ProFox Email List
 Subject: Re: [NF] Questions on migrating VFP app
 
 On 6/22/2011 3:58 PM, Fletcher Johnson wrote:
 Hi all,
 
 I am working with a new company that has a successful VFP app that 
 they need to convert to .NET as MS will be cancelling support for 
 VFP soon and the customers IT departments are getting nervous.  So I 
 have been asked to help with a rewrite.
 
 I am sure there have been many discussions on this topic.  Can 
 anyone point me to some of the more current and complete discussions 
 on this topic (on this list or otherwise)?
 
 The new app will continue to be a desktop app and will have the same 
 interface (so there is no retraining required to implement the new
 version).
 It currently has the option to have data stored as local .dbf tables 
 or on an MS SQL table.  So we also need to continue to support 
 local/disconnected data sets.
 
 We are looking for suggestions on application frameworks, data 
 libraries (ORM, etc.), VS technologies
 (Silverlight/WPF/Winform/ADO/etc.)  and other resources that will 
 aid in the conversion.  We are not looking for something that will 
 just convert the code to .net as there are some key architectural 
 changes we
 want to implement under the hood.
 
 Any links or other references to point me in the right direction 
 will be greatly appreciated.
 
 
 Wow!  Support doesn't officially end until 2015 I think, and even 
 after that, it should last for YEARS!  Look at the large number of 
 FPD, FPW and
 pre-VFP9 apps out there yet!  BUT, I realize you're just a soldier 
 following orders.  Are you familiar with any of the DotNet languages?
 Must it be a Microsoft language?
 
 --
 Mike Babcock, MCP
 MB Software Solutions, LLC
 President, Chief Software Architect
 http://mbsoftwaresolutions.com
 http://fabmate.com
 http://twitter.com/mbabcock16
 
[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

[NF] Questions on migrating VFP app

[Fletcher Johnson]

Hi all,

 

I am working with a new company that has a successful VFP app that they need
to convert to .NET as MS will be cancelling support for VFP soon and the
customers IT departments are getting nervous.  So I have been asked to help
with a rewrite.

 

I am sure there have been many discussions on this topic.  Can anyone point
me to some of the more current and complete discussions on this topic (on
this list or otherwise)?

 

The new app will continue to be a desktop app and will have the same
interface (so there is no retraining required to implement the new version).
It currently has the option to have data stored as local .dbf tables or on
an MS SQL table.  So we also need to continue to support local/disconnected
data sets.

 

We are looking for suggestions on application frameworks, data libraries
(ORM, etc.), VS technologies (Silverlight/WPF/Winform/ADO/etc.)  and other
resources that will aid in the conversion.  We are not looking for something
that will just convert the code to .net as there are some key
architectural changes we want to implement under the hood.

 

Any links or other references to point me in the right direction will be
greatly appreciated.

 

Thanks,

 

Fletcher

 

Fletcher Johnson

fletchersjohn...@yahoo.com

408-946-0960 - Work

501-421-9629 - Fax

 



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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/012401cc3116$d3505300$79f0f900$@yahoo.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] Questions on migrating VFP app

[Fletcher Johnson]

Mike,

Due to security reasons, it cannot be a web or cloud based app.  So that
limits some of the choices.  Also, it is for one of those markets where
Windows desktops prevail almost universally.  So there is limited need for
cross platform support.

We are planning on a long term conversion, with our goal being to have the
entire application suite converted by the 2015.  This is not a trivial
application.

So we will continue to support/enhance the VFP products.  But we are running
into IT departments that are making roadblocks to new sales because of the
2015 deadline.

What other languages would you recommend, now that you know more?

Thanks,

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
408-946-0960 - Work
501-421-9629 - Fax


-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf
Of MB Software Solutions, LLC
Sent: Wednesday, June 22, 2011 1:07 PM
To: ProFox Email List
Subject: Re: [NF] Questions on migrating VFP app

On 6/22/2011 3:58 PM, Fletcher Johnson wrote:
 Hi all,

 I am working with a new company that has a successful VFP app that 
 they need to convert to .NET as MS will be cancelling support for VFP 
 soon and the customers IT departments are getting nervous.  So I have 
 been asked to help with a rewrite.

 I am sure there have been many discussions on this topic.  Can anyone 
 point me to some of the more current and complete discussions on this 
 topic (on this list or otherwise)?

 The new app will continue to be a desktop app and will have the same 
 interface (so there is no retraining required to implement the new
version).
 It currently has the option to have data stored as local .dbf tables 
 or on an MS SQL table.  So we also need to continue to support 
 local/disconnected data sets.

 We are looking for suggestions on application frameworks, data 
 libraries (ORM, etc.), VS technologies 
 (Silverlight/WPF/Winform/ADO/etc.)  and other resources that will aid 
 in the conversion.  We are not looking for something that will just 
 convert the code to .net as there are some key architectural changes we
want to implement under the hood.

 Any links or other references to point me in the right direction will 
 be greatly appreciated.


Wow!  Support doesn't officially end until 2015 I think, and even after
that, it should last for YEARS!  Look at the large number of FPD, FPW and
pre-VFP9 apps out there yet!  BUT, I realize you're just a soldier following
orders.  Are you familiar with any of the DotNet languages? 
Must it be a Microsoft language?

--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
http://fabmate.com
http://twitter.com/mbabcock16

[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/000301cc3122$a8b44fa0$fa1ceee0$@yahoo.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] Questions on migrating VFP app

[Fletcher Johnson]

Ed,

As per my other response, we are not locked into anything right now.  My
whole purpose in this was to take some time to do some research now, rather
than go blithely down some avenue, only to run into a brick wall.

On the other hand, Windows and its related technology are firmly entrenched
in our customer base.  And it has to be a desktop app, etc. (see other
post).  

I have written code in a fairly wide number of languages (except for the new
strain of functional languages), so I am not uncomfortable with another
option.  But .NET currently meets all the existing requirements as well as a
number for down the road.  And yes, I am aware of the whole Windows 8
discussion, but our customers would freak out if used such an interface
:)

Given all that, what would you recommend as an alternative to MS?

Thanks,

Fletcher

Fletcher Johnson
fletchersjohn...@yahoo.com
408-946-0960 - Work
501-421-9629 - Fax


-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf
Of Ed Leafe
Sent: Wednesday, June 22, 2011 1:07 PM
To: ProFox Email List
Subject: Re: [NF] Questions on migrating VFP app

On Jun 22, 2011, at 3:58 PM, Fletcher Johnson wrote:

 We are looking for suggestions on application frameworks, data 
 libraries (ORM, etc.), VS technologies 
 (Silverlight/WPF/Winform/ADO/etc.)  and other resources that will aid 
 in the conversion.  We are not looking for something that will just 
 convert the code to .net as there are some key architectural changes we
want to implement under the hood.
 
 Any links or other references to point me in the right direction will 
 be greatly appreciated.


Ask them if they want to remain subject to the whims of Microsoft
marketing, which can (and has) dropped or deprecated the products people
have depended on, like VFP, LINQ, Silverlight, etc., sometimes within months
of promoting said technology as the way to go.

That should be your first question to them before committing their
business to a closed source, single-vendor solution. If they decide to
accept such a lock-in, at least they'll be doing it with their eyes open.



-- Ed Leafe




[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/000e01cc3124$c0e10da0$42a328e0$@yahoo.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: VFP and Source control

[Fletcher Johnson]

Lou,

Ok, some info.

VFP is designed to work with VSS and can do so quite well.  The default way you 
use it doesn't work quite right, so I have a work around that solves it.  The 
end result is that, within VFP, if I edit or create a form, class, code, etc., 
it is automatically updated to VSS.

I also have or currently use subversion and mercurial (there are others, but I 
will reference these 2 as they are most common and representative of the 
others.)  Overall, I think that mercurial is a better choice due to the way it 
works - especially giving the develop the ability to work with the local 
repository to check things in while working without updating the main 
repository.

While the other 2 don't integrate, they can be set to effectively work the same 
way.  Again, mercurial is better in that you don't need to check out the code 
before you work due to the way it manages files.

None do binary files (.scx, .frx, etc.)  When you integrate VSS into VFP, as 
you 
work on the non text type files, it produces a .xxa file that is a textual 
version of the file and uses that for diffs, etc.  If you want the same benefit 
with mercurial or subversion, I recommend the following approach:

Add code to your project class so that whenever you build a project and it 
senses it needs to recompile a .scx, .frx, etc., (which it already does) it 
also 
runs a module that generates a text version of that file (like VSS does.)  You 
can use the one built into VFP (just call it manually from the project class) 
or 
one of the others mentioned in other emails.  All that matters is that when you 
diff one text file to the other, you can figure out what has really changed.

Now, when you check things in, you check in not only the .scx/.sct, but also 
the 
text file.  If you need to diff one .scx/.sct version against another, ignore 
those and diff the text versions instead.  


One issue with the VFP code generator is that if you edit a method, the 
resulting change is usually put in a different place in the generated code - 
this makes diffing much more difficult.  So I would recommend a 3rd party text 
generating tool regardless of the approach you use.
Oh, and I would definately make sure you know where the source code can really 
be found.  If only one person knows, you are ill prepared for an unplanned 
incident (and that has happened to more companies that you think.)

Good luck,

Fletcher

 




From: Lou Syracuse l...@iconmediadirect.com
To: profoxt...@leafe.com
Sent: Fri, February 4, 2011 8:24:55 AM
Subject: VFP and Source control

Is anyone using source control with VFP?



I really need to push for something here.  We have source code in at least 3
network locations, on each of the developer machines (including one from a
developer who no longer works here).  I specifically set today aside to
work on converting a reporting program that uses VFP tables to use SQL (we
are upgrading our main application to the vendor's SQL version soon) - but
the only code I can find on the network doesn't have any code - it just says
data call goes here or insert fancy SQL call here.    I KNOW we have
code that was being worked on as I have seen it running, but the developer
of that system works part-time and won't be back in the office until Monday
so my day is shot.



We need a solution that handles VFP and .NET projects.    Documents and SQL
Server code would be good too.    In my last company we used Subversion and
with Tortoise as the front-end and it worked pretty well; however Subversion
is Apache-based and I know nothing about Apache.  I've had too many issues
with VSS to consider it (plus I think it has been discontinued).  I don't
know much/anything about TFS, can it be used (easily) with VFP projects?
We're a small (but growing) department, security is not so much an issue -
we need a solution that is dependable, easy to use and fairly
low-maintenance.



It may be an uphill battle to sell it, but the fact I'm spending most of
today NOT coding should be an indicator that something need to change.



Thanks in advance,

Lou





LouS





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

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


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body 

Re: VFP and Source control

[Fletcher Johnson]

Ted,

So which one are you using?  You seem to be referring to Mercurial, but that's 
just a WAG.  I am just curious if there is something else out there similar to 
Mercurial, that's all.

Take care,

Fletcher




From: Ted Roche tedro...@gmail.com
To: profox@leafe.com
Sent: Fri, February 4, 2011 2:47:35 PM
Subject: Re: VFP and Source control

On Fri, Feb 4, 2011 at 2:36 PM, Lou Syracuse l...@iconmediadirect.com wrote:
 Well you've certainly bailed a few companies out of a SourceSafe jam over
 the years, Ted.  Some without even knowing it. My E-copy of your VSS book is
 almost worn out. :)

Well, that's nice to hear.

 I don’t see us moving out of the Micro$oft world here.

And, that's too bad :)

I have to say, for all the fun I had in 15 years with FoxPro, it's
pretty awesome out here.

 We have MSDN here, but I don't know what level.   The big reason we got it
 was to set up a test environment for SQL server.   I asked if I could
 install Visio and was turned down, still haven't figured out why...

That doesn't bode well. MS has some proprietary Team Server offerings
that supposedly integrate well with their tools. That's not my area
any more, so I can't provide any guidance there.

 I wasn't involved in the setup of SVN at Premier so I don’t know all the
 details, but I know apache was involved somehow.   I need to dig into it now
 that I am somewhere else, and hopefully management will follow my lead.  But
 I don't want to lock myself into SVN based on my limited knowledge of it.
 I'm getting lots of good suggestions from those using something else and
 that is what I was hoping for.  :)

Short form of a decade long conversation: Subversion was intended as a
drop-in replacement for CVS, developed by a group that was tired of
some really gnarly hacks you had to go to get CVS to do simple things
like renaming folders and moving batches of files. In that aspect,
mission accomplished. But Subversion and CVS both adhere to the
dumb-workstation-client-data-store model that SourceSafe (v.6) had as
well: one central repository to rule them all. And the assumption that
branching, forking and merges were things to avoid at all costs.
Worked okay in the pre-distributed-Internet world, but is pretty
limiting today.

Today, I'm more likely to be working on a project that:
  - has a branch that's released to production that occasionally needs
an emergency patch, which will then be backfilled through QA into the
main development line.
  - has some older branches / tagged versions that some clients insist
on not upgrading.
  - has two or three separate efforts to upgrade / update particular
pieces of functionality, which if they work will be merged back into
the next version. Some are shared between a couple developers and some
are solo efforts.
  - another branch that an outside group is developing some new feature.

Even if there's only a few of you, or even if it's just you, a good
version control system can let you juggle this kind of stuff.

You really want to see what distributed version control can do for you.


-- 
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/aanlktin0n24acomeqr4ygkncb20v6ypf4r7nvfhla...@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.


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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/18385.92234...@web37906.mail.mud.yahoo.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] Anyone with webDAV experience out there?

[Fletcher Johnson]

Hi all,

Please reply to me off list, but I am looking for someone who can work with
people in the CA, USA time zone on a small project.  I am trying to get a
WebDAV (and then a CalDav) server going and running into some problems.
This is a PHP type app.

If you are familiar with the issues involved, please let me know.

Thanks,

Fletcher (who has been lurking about but not commenting much)




___
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/011101cbab9b$a101ee50$e305ca...@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.

Resources for VFP developers who need to use VS.NET

[Fletcher Johnson]

Hi all,

 

Sorry I haven't been around much lately.  The VFP work I have had hasn't
required me to think too hard or resort to this forum.  And the other work
has kept me busy enough to not have time to hang out here much.

 

As with some of you, I have had to resort to using other languages now that
MS has officially announced the demise of VFP.  

 

I am using VS.NET and find that many of the sites are either too basic or
too advanced.  What sites do you recommend as places to get answers when VS
doesn't do what I want it to do and I can't figure out what command/object I
need to resolve the problem.

 

2 examples:

1) I wanted to get the ascii value of a character.  There is no (obvious)
method to do so.  I found a number of objects that apparently convert arrays
or strings to arrays of binary values (which I could have used, but it was a
kludge).  I finally settled on the old VB 5/VFP command, but I really wanted
to avoid using what should be legacy code.  

 

2) I have to write an application to talk to an Oracle server.  I can do so
in VFP using ODBC.  VS wants me to use OLE DB - what do I do differently to
make that work.  And what's the best approach to getting remote data (ADO,
LINQ, etc.) and passing it between objects (XML, ADO, etc.)?

 

I am not really expecting an answer here.  I would rather find some good
resource (say something similar to this list.)  Ideally, it would be a list
that had a number of VFP developers who understand that I know programming,
just not the specifics of VS.NET.

 

I tried the archives, but didn't find a message that listed such resources.

 

Thanks,

 

Fletcher

 

Fletcher Johnson
 mailto:fletchersjohn...@yahoo.com fletchersjohn...@yahoo.com
408-781-2345 - Cell
408-946-0960 - Work
501-421-9629 - Fax

 



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

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

Showing the Report Controls Toolbar

[Fletcher Johnson]

Hi all,

 

Long time, no see.  But I have a friend with a problem and thought I would
check here.

 

Does anyone know how to show the report controls toolbar programmatically
when showing the report writer from within an application?  

 

Yes, I know that show/hide window work if it is defined.  But suppose a user
clicked on the X to close it and wants it back again..

 

I know there is a way, I just can't remember what it was.

 

Thanks,

 

Fletcher

 

Fletcher Johnson
 mailto:fletchersjohn...@yahoo.com fletchersjohn...@yahoo.com
408-781-2345 - Cell
408-946-0960 - Work
501-421-9629 - Fax

 



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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/015601c960a3$6d4c1c10$47e454...@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] Desert code camp Phx May 31

[Fletcher Johnson]

David,

And we are having a Code Camp out in the Silicon Valley in Nov., so you all
have time to get it on your schedule.  www.siliconvalley-codecamp.com 

Take care,

Fletcher (who still lurks around when he can)

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of MB Software Solutions General Account
Sent: Thursday, May 29, 2008 9:51 AM
To: ProFox Email List
Subject: Re: [NF] Desert code camp Phx May 31

David Crooks wrote:
 On Thursday, May 29, 2008 12:37 PM Michael wrote:
 
 Very cool!  Thanks.  It'd be nice to attend one of those, but it'll
 need to be out here on the East Coast within driving distance for me.
 
 Keep an eye on this website:
 http://www.cmap-online.org/CodeCamp/
 
 They probably have the next one in the fall.
 
 David L. Crooks


Darn...just missed it!  Thanks, David!



[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: VFP9 Wierd Behaviour

[Fletcher Johnson]

Dave,

This reminds me of a bug I found once in program somewhere:

on error resume

Or in the error code of one of the objects involved - similar code.  This
last part is especially tricky since the object's error method overrides the
ON ERROR.  Did you get any of the object code from an outside source?  

While I doubt this is the problem, I am always amazed when I get stumped by
code like this that I just never expect to exist in real code...

Take care,

Fletcher

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Dave Crozier
Sent: Wednesday, March 19, 2008 1:12 AM
To: 'ProFox Email List'
Subject: VFP9 Wierd Behaviour

Guys,
I have a really, really weird behavioural problem here with VFP and I'm
pulling my hair out - what little I have.

Simple scenario:

1. A form subclassed from a base form.

2. The base form contains code in the Load() event

3. The production form calls the default code in the base class Load() using
Default()

4. In the Baseclass I instantiate a few business Objects and drill down
about 3 or 4 stack levels to create various objects etc.

90% of time this works fins, but about 10% of the time the Dodefault() in
the production form simply refuses to run the baseclass Load() code. Note
that this is only in design mode and when you trace through the program and
step into the DoDefault() nothing happens and execution is immediately
passed to the line following the DoDefault().

Once this happens once you can cancel the form and re-run it as many times
as you like with EXACTLY the same effect - a skip over DoDefault(). I have
tried all of the individual close statements e.g. close procedures etc
and nothing resets the problem apart from a close all, reopening of the
project and running the form again.

The only thing that I have done differently to my normal procedures is to
make more use of try...endtry and I am wondering if there is a dangling
reference somewhere which is firing me back from the baseclass code
immediately so I never even get into the subclassed coding, but how to find
it easily I can't work out - if it is in fact that problem. Ideally I would
like a clear try command or the equivalent!

I am not convinced that the try...endtry is the cause of the problem but
thought I would ask around to see if anyone else has had similar
experiences.

Dave Crozier





[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.

Current reference for .NET - VFP?

[Fletcher Johnson]

Hi all,

I have been asked to help some VFP developers who want to learn .NET.  For
now, let's skip the comments about why they would want to do such a silly
thing.

I am looking for a reference that has a list of VFP commands and
corresponding .NET commands.  I would prefer one that is current and, where
possible, uses the OOP approach vs. the legacy VB 5x and before commands.

I know that some were done when .NET first came out, but am trying to find a
source that is as current as possible (one that references .NET 2008 would
be best)

I do not need a library that emulates VFP commands or anything that allows
VFP commands to work in .NET.  On the other hand, a library of classes that
give functionality that is not available in .NET without programming might
be nice.

Thanks,

Fletcher
 



___
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: Current reference for .NET - VFP?

[Fletcher Johnson]

Alan,

Thanks, I should have been more specific.  Initially, our focus will be with
VB.NET since that is most Fox-like.  But I see the demand to use C# as
well, so the reference you gave is a good start.  And I would guess that
many of the commands use the same approach, regardless of if it is C# or VB.

But a VB specific list would be nice

Thanks,

Fletcher

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Alan Bourke
Sent: Tuesday, March 18, 2008 1:40 PM
To: profox@leafe.com
Subject: Re: Current reference for .NET - VFP?

Fletcher Johnson wrote:
 Hi all,

 I have been asked to help some VFP developers who want to learn .NET.  For
 now, let's skip the comments about why they would want to do such a silly
 thing.

   
Nothing silly about up-skilling.


 I am looking for a reference that has a list of VFP commands and
 corresponding .NET commands. 
In what? VB? C#? J#?

You might find some stuff like this: 
http://fox.wikis.com/wc.dll?Wiki~CSharpToVFP~VFP .

*

*



[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: Current reference for .NET - VFP?

[Fletcher Johnson]

My experience is that lots of the Fox people have chosen C#.  I don't quite
know why.  Like Java and C/C++, it is nothing like VFP.  VB, on the other
hand, uses syntax almost totally like VFP.  

My only thought is that C# is like Java and C++ and is, therefore, a real
language.  I do agree that there are a few things that C# can do that VB
can't, but the opposite is also true.  And I can write those things in C#
and then subclass them in VB anyway, so I lose nothing by staying with a
similar syntax.  Or it might just be the Basic stigma - it's a beginner
language, not a real one

But this is probably not the forum for a discussion on VB vs. C#.  Which is
good.  And MS is good enough to make it so that, whatever I use, I still get
the same IL code and performance, so who cares?

Thanks,

Fletcher


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of MB Software Solutions General Account
Sent: Tuesday, March 18, 2008 2:09 PM
To: ProFox Email List
Subject: Re: Current reference for .NET - VFP?

Fletcher Johnson wrote:
 snipped Initially, our focus will be with
 VB.NET since that is most Fox-like.  

Really?  That's nice to know.  I thought the prevailing attitude from 
those that left Fox was that C# was the easier/better migration path.  
Hmmmthanks for that comment, FJ.



[excessive quoting removed by server]

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

OT - Long time no see

[Fletcher Johnson]

I have been around, just busy with lots of other activities.  Unfortunately,
not enough of them have been programming related or those that have were in
some other language  But I still hang out here to see what's going on.  

But MS hasn't made it easy for me in the VFP world although VFPx is looking
rather interesting.

Take care,

Fletcher 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of MB Software Solutions General Account
Sent: Tuesday, March 18, 2008 1:59 PM
To: ProFox Email List
Subject: Re: Current reference for .NET - VFP?

Fletcher Johnson wrote:
 Hi all,

 I have been asked to help some VFP developers who want to learn .NET.  For
 now, let's skip the comments about why they would want to do such a silly
 thing.

 I am looking for a reference that has a list of VFP commands and
 corresponding .NET commands.  I would prefer one that is current and,
where
 possible, uses the OOP approach vs. the legacy VB 5x and before commands.

 I know that some were done when .NET first came out, but am trying to find
a
 source that is as current as possible (one that references .NET 2008 would
 be best)

 I do not need a library that emulates VFP commands or anything that allows
 VFP commands to work in .NET.  On the other hand, a library of classes
that
 give functionality that is not available in .NET without programming might
 be nice.

 Thanks,

 Fletcher
  
   

Wowlong time no post, Fletcher!  Check out Les Pinter's site.  He 
had a concordance at one point for VB6--VFP; perhaps he did one for 
DotNet too.

btw, expanding your toolset is never a bad thing.  Just go to 
Monster.com or Dice.com and check out the future...if the tool is not 
found in a search, then it's probably not worth learning!  lol



[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] Good .NET email lists?

[Fletcher Johnson]

Graham,

Thanks.  There doesn't seem to be much traffic, but I will give it a shot.

Take care,

Fletcher

Fletcher Johnson
[EMAIL PROTECTED]
408-929-5678 - Cell
408-946-0960 - Work
501-421-9629 - Fax


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Graham Dobson
Sent: Thursday, July 12, 2007 9:53 AM
To: ProFox Email List
Subject: Re: [NF] Good .NET email lists?

http://discuss.develop.com/


- Original Message -
From: Fletcher Johnson [EMAIL PROTECTED]
To: 'ProFox Email List' profox@leafe.com
Sent: Tuesday, July 10, 2007 6:19 PM
Subject: [NF] Good .NET email lists?


 Hi all,



 Like some of you, I have been using .NET for a while.  Do you know of 
 any email lists like this one that focus on .NET?



 Thanks,



 Fletcher



 Fletcher Johnson
 [EMAIL PROTECTED]
 408-929-5678 - Cell
 408-946-0960 - Work
 501-421-9629 - Fax





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

[excessive quoting removed by server]

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

RE: [NF] Good .NET email lists?

[Fletcher Johnson]

Stephen,

Yeah, I was planning to check those out, but thought I would at least see if
anyone here knows a good place to start.

Thanks,

Fletcher

Fletcher Johnson
[EMAIL PROTECTED]
408-929-5678 - Cell
408-946-0960 - Work
501-421-9629 - Fax


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Stephen the Cook
Sent: Wednesday, July 11, 2007 4:09 AM
To: 'ProFox Email List'
Subject: RE: [NF] Good .NET email lists?

Fletcher Johnson  wrote:
 Hi all,
 
 
 
 Like some of you, I have been using .NET for a while.  Do you know of 
 any email lists like this one that focus on .NET?

This is an incredible list for quality of content as well as beating the
crap out of a thread.

On the .Net side I have not seen near the continuous content that ProFox
has.  There are a few via groups.yahoo.com or the same for google.  

There will be a closer focus to the language so you can find an ASP.NET as
well. 



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.476 / Virus Database: 269.10.2/893 - Release Date: 7/9/2007
5:22 PM
 



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
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] Good .NET email lists?

[Fletcher Johnson]

Michael,

Do you have the link for Tek Tips?  And yes, you are right about the UT.  At
one point, I was told they were going to support email, but I don't think it
ever happened.

Thanks,

Fletcher

Fletcher Johnson
[EMAIL PROTECTED]
408-929-5678 - Cell
408-946-0960 - Work
501-421-9629 - Fax

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of MB Software Solutions
Sent: Wednesday, July 11, 2007 5:32 AM
To: profox@leafe.com
Subject: Re: [NF] Good .NET email lists?

Stephen the Cook wrote:
 Fletcher Johnson  wrote:
   
 Hi all,



 Like some of you, I have been using .NET for a while.  Do you know of 
 any email lists like this one that focus on .NET?
 

 This is an incredible list for quality of content as well as beating 
 the crap out of a thread.

 On the .Net side I have not seen near the continuous content that 
 ProFox has.  There are a few via groups.yahoo.com or the same for google.

 There will be a closer focus to the language so you can find an 
 ASP.NET as well.


   

I know Tek-Tips (for VFP anyway) had a great forum...perhaps you want to
check there?  And then there's always the UT.  Oh wait...you wanted just
listserve, eh?

--
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.

[NF] Good .NET email lists?

[Fletcher Johnson]

Hi all,

 

Like some of you, I have been using .NET for a while.  Do you know of any
email lists like this one that focus on .NET?

 

Thanks,

 

Fletcher 

 

Fletcher Johnson
[EMAIL PROTECTED]
408-929-5678 - Cell
408-946-0960 - Work
501-421-9629 - Fax

 



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

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

RE: Buffer overruns stuff

[Fletcher Johnson]

Derek,

I wouldn't bother writing such a system (which I plan to do for my next
projects) since I already have one that works quite well.  Let me know if you
are interested.  It gets around many of the issues with using the debugger and
works well if you accidentally leave the code in your application.  

Take care,

Fletcher

Fletcher Johnson
[EMAIL PROTECTED]
408-929-5678 - Cell
408-946-0960 - Work
501-421-9629 - Fax 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Derek Kalweit
Sent: Wednesday, February 07, 2007 2:56 PM
To: profox@leafe.com
Subject: Re: Buffer overruns  stuff

 The source is a VFP cursor created by querying an MSSQL db. My app 
 reads from  parses the data in the cursor into native VFP tables 
 stored locally. There's no user interface. Crash about every 15min.

If it's that re-creatable, then it's time to start adding trace code,
IMO-- to find where the problem is happening. I use STRTOFILE for
this:

STRTOFILE(Some meaningful string + CHR(13) + CHR(10), c:\out.log, .T.)

This will append a line to the c:\out.log file-- change your strings to
something useful to know where in the code it's happening(put it in key spots
right before something you suspect to be the potential
problem-- it can be very high level in the code, especially at first).

You can also write a more robust tracing mechanism, which I plan to do for my
next projects. Basically, you call the function throughout your code, and the
function queries a setting to see if tracing is 'on', and potentially at what
level, and if so outputs it to the text file with a date/time stamp, etc. I've
used it in C++ programs as a debugging mechanism and it's been extremely
valuable. I turn it on with a registry setting. One of the key things I like to
do is add
start:functionname() and end:functionname() things to the beginning and ending
of functions/methods when I write my code initially-- this lets me know very
early on what overall function/method the crash is occuring in...


--
Derek


[excessive quoting removed by server]

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

RE: [WEB] Storing code in tables

[Fletcher Johnson]

Ken,

Anything that is done differently than the way you do it is wrong.  If it was
right, then you would be doing it that way.

In some cases, we see the benefit and then adjust our style.  But, more often,
it is easier for our approach to be right.

I can argue this either way.  Certainly, if the code is in a table, it is
subject to modification (potentially malicious), is not easy to control (via
current source control approaches), and can create some very difficult to track
problems (since you may not realize that the code is being called from the wrong
record than you expect.)  I can go on, but you get the idea.

On the other hand, you get all the benefits from such an approach.  But, as has
been mentioned, you have lived with this approach and are comfortable with it.
Also, you have the benefits of macro expansion () and ExecScript() - both of
which were unavailable in most languages - at least until recently.  The ability
to use these two options makes using a table viable and the lack makes it
impractical.

Anyway, my thought on the matter is simple.  Does this approach allow you to
create code that works better and/or faster than the code written the right
way?

I remember the first application I saw by Ken Levy.  It was for the CHP (as I
recall).  What made it so cool is that he used all the controls the wrong way.
He was able to implement drag and drop in Fox 2.x by using windows that looked
like buttons, etc.  The fact that it was not the correct way to right code did
not stop him from creating a killer app that could not have been written
otherwise.

Anyway, just my 2 cents on this topic (hey, why is there a $ on the keyboard,
but no cents symbol?)

Fletcher

Fletcher Johnson
[EMAIL PROTECTED]
408-929-5678 - Cell
408-946-0960 - Work
501-421-9629 - Fax 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Kenneth Kixmoeller/fh
Sent: Sunday, February 04, 2007 10:49 AM
To: Profox
Subject: [WEB] Storing code in tables

Hey - --  -

Since I see y'all chatting...

I am working on my framework for designing Web applications using PHP, and in
this case, MySQL. One of the goals I have had for a long time in my development
(in any language) is to keep things flexible by putting lots of stuff in tables.
This includes metadata tables which specify ordinary validation rules:
mandatory?, typical formats, encrypted?, stuff like that. The typical ones
result in a function call to a utility object embedded in a data object:
IsValidFormat (string,Telephone), for example. For exceptional validation,
this includes a field for a bit-o'-code for custom validation or table- level
validation.

Also, for the same flexibility reason, my framework design keeps page- related
information, including display code in a table, too. This is never core code
like login validation or data object definitions, only again, function calls to
data and UI objects. All of the class definition code is kept in files, not
tables, off of the Web tree.

When I posted a question related to this strategy in a PHP group, I got an
individual who said that this strategy is very dangerous, and (in so many words)
I'm an idiot for even contemplating it. Mind you, he only knew the code in
tables part, without the level of detail above. I subsequently supplied it, but
so far without response.

Whadaya think? Is this an ill-conceived strategy?

Ken


[excessive quoting removed by server]

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

RE: Buffer overruns stuff

[Fletcher Johnson]

Lew,

I was using a dual core cpu based XP system to work with an MS SQL database.
Using both remote views as well as SQL pass-through, I did not encounter this
problem.  The application is in use at locations throughout the U.S. again
without such a problem (although I doubt these installations are using similar
cpus)

I can offer you two ideas.

1) Try the basic approach of narrowing down the code to the fewest number of
lines that still reproduce the problem.  Just doing this often identifies it.
But if not, post that code and we can test it on our computers.  Unfortunately,
mine is in the shop until 2-20 so I hope others here can help you before then.

2) Does this happen when you are stepping through the code or only during run
time when the debugger is not active? If the latter, I have a debugging tool
that might still help you identify the problem, should you be so interested.

Take care 

Fletcher

Fletcher Johnson
[EMAIL PROTECTED]
408-929-5678 - Cell
408-946-0960 - Work
501-421-9629 - Fax 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Lew Schwartz
Sent: Tuesday, February 06, 2007 7:34 AM
To: profox@leafe.com
Subject: RE: Buffer overruns  stuff

The problem predates SetMemory(), there are no other api calls. This is XP pro.
I haven't tested the difference between app's vs exe's. I'm using apps for now,
but a standalone exe is in the near future. I'll try to see if there's a
particular place or routine that blows up today, but I don't think so.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Derek Kalweit
Sent: Monday, February 05, 2007 5:41 PM
To: [EMAIL PROTECTED]
Subject: Re: Buffer overrins  stuff

No, it isn't a native VFP error. VFP is written in MS c++ so 
 the undelying libraries have MS c++ error messages. When a pointer 
 references a memory location outside of the space allocated for vfp,
 c++ generates this error. It's a boiler plate message; it never
 changes and it never gives any additional information.

Yes-- I'm primarily making sure it's created by the VFP process and not
something you're observing through a c++ debugger you've attached to the
process or anything.


No flls or api calls in the app.

You are using API calls in Ed's setmemory.prg. What O/S are you running
under? interpretted and/or compiled?

Have you commented Ed's setmemory.prg to see if that's causing the
issue? I'm curious, considering you're bringing it up-- unless it's the
cause, it shouldn't matter-- a buffer over-run is an error in code and
shouldn't be related to available memory whatsoever.

Have you been able to narrow it down to any part of your code? I've had
many VFP functions with known buffer overrun problems, such as
TEXTMERGE() in VFP7. There was a work-around then that you can pass the
string with a chr(0) at the end(effectively zero-terminating the
c++ buffer properly). I wrote simple Z() and NZ() functions for this
purpose-- adding and removing the trailing nulls..


--
Derek


[excessive quoting removed by server]

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

RE: Buffer overruns stuff

[Fletcher Johnson]

Lew,

The manager is probably protecting the connection code because it usually
includes a valid access account and password in an unencrypted format.  One way
I got around this was to have them create a QA account and use that in a
temporary connection until the problem was resolved.  Then they could just
disable that account until it was needed again in the future.

I don't know of a way off the top of my head to track when the connection
breaks, but there are ways to do it.  Windows can be set to notify you (usually
when using a wireless card) if the network connection breaks, so I would guess
there would be a similar ability to track data connections.  

Take care,

Fletcher

Fletcher Johnson
[EMAIL PROTECTED]
408-929-5678 - Cell
408-946-0960 - Work
501-421-9629 - Fax 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Lew Schwartz
Sent: Tuesday, February 06, 2007 11:18 AM
To: profox@leafe.com
Subject: RE: Buffer overruns  stuff

Your 2  4 look interesting since I have any number of abends, delibretate and
otherwise, during development. Plus, for reasons I don't understand, my manager
keeps the connection code secret. Is there such a thing as a dangling connection
and/or a way to detect it?
-Lew 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Fletcher Johnson
Sent: Tuesday, February 06, 2007 1:19 PM
To: [EMAIL PROTECTED]
Subject: RE: Buffer overruns  stuff

Lew,

Some things to try:

1) Run MSConfig and turn of everything unless you need it.  Including anti
virus, etc.  Then, do nothing but run the application.  

2) One problem I had that generated weird messages was when I was using a
connection that would occasionally disconnect and then reconnect.
Most apps worked well.  But my SQL connections did NOT like it.  This took a
while to track down

3) It could be that there is a call you are doing that has a memory leak.  This
call may be made a variable number of times.  One example might be a test to see
if the remote server exists before you try to connect to it.  This would have a
loop that would run until we got a timeout or acknowledgement from the server.
Since the loop would run a variable amount of times each time it was called, the
effect of each call can vary.

4) Could you be leaving a connection open?  In one case, I had some code that
created a handle, but never specifically disconnected it.  Over time, this would
accumulate until the computer got upset.  And, in this case, the connection was
only created by a procedure that was doing a verification - so it was easy to
overlook that part of the code.

If this doesn't help, I may have some others for you.

Take care,

Fletcher

Fletcher Johnson
[EMAIL PROTECTED]
408-929-5678 - Cell
408-946-0960 - Work
501-421-9629 - Fax 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Lew Schwartz
Sent: Tuesday, February 06, 2007 9:54 AM
To: profox@leafe.com
Subject: RE: Buffer overruns  stuff

Thanks, Fletcher. Since it never occurs in the same place twice, I can't narrow
down to a reproducable error. I have removed dbc events, changed my on error
from on error createobject(errorhandler) to the old fashioned on error do ...
and threw in a sys(1104). Today, so far, no explosions.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Fletcher Johnson
Sent: Tuesday, February 06, 2007 12:48 PM
To: [EMAIL PROTECTED]
Subject: RE: Buffer overruns  stuff

Lew,

I was using a dual core cpu based XP system to work with an MS SQL database.
Using both remote views as well as SQL pass-through, I did not encounter this
problem.  The application is in use at locations throughout the U.S. again
without such a problem (although I doubt these installations are using similar
cpus)

I can offer you two ideas.

1) Try the basic approach of narrowing down the code to the fewest number of
lines that still reproduce the problem.  Just doing this often identifies it.
But if not, post that code and we can test it on our computers.
Unfortunately, mine is in the shop until 2-20 so I hope others here can help you
before then.

2) Does this happen when you are stepping through the code or only during run
time when the debugger is not active? If the latter, I have a debugging tool
that might still help you identify the problem, should you be so interested.

Take care 

Fletcher

Fletcher Johnson
[EMAIL PROTECTED]
408-929-5678 - Cell
408-946-0960 - Work
501-421-9629 - Fax 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Lew Schwartz
Sent: Tuesday, February 06, 2007 7:34 AM
To: profox@leafe.com
Subject: RE: Buffer overruns  stuff

The problem predates SetMemory(), there are no other api calls. This is XP pro.
I haven't tested the difference between app's vs exe's. I'm using apps for now,
but a standalone exe is in the near future. I'll try to see if there's a
particular place

RE: csv files and memo fields

[Fletcher Johnson]

Judith,

Another option might be to use a cursorToXml.  

Then you can convert that to a comma separated file.  If done right, you could
probably automate the whole things (look up the tag in the structure to
determine what type of delimiter to use.)  You could even make it so you could
choose a separator other than a comma (say a tab).

Of course, depending on why you want it in a CSV format, it may be that an XML
format will work just as well.

Take care,

Fletcher

Fletcher Johnson
[EMAIL PROTECTED]
408-929-5678 - Cell
408-946-0960 - Work
501-421-9629 - Fax 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Judith Barer
Sent: Wednesday, January 31, 2007 8:21 AM
To: profox@leafe.com
Subject: csv files and memo fields

Does anybody have an idea how I could generate a csv file programtically that
would include in it  the info from memo fields.  What would be the simplest way
to do this?

I also would like to take a csv file and append it to a dbf file with memo
fields.  I tried converting the file to a string using strtofile and then using
a alines but the file is so big that it generates a subscript out of range
error. I am using VFP 8.0.  

 

Thanks 

Judith

 

Judith Barer

Star-K Kosher Certification

122 Slade Ave

Baltimore, MD 21208

410 484 4110 

Fax 410 653 9293

 



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


[excessive quoting removed by server]

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

AOL Security center makes VFP.EXE NOT a VFP .EXE with Konxise

[Fletcher Johnson]

Hi all,
 
I ran into a fun experience today.  It seems that People who have the AOL
security center installed are getting error messages along the line of This is
not a valid Visual FoxPro Executable when they try to run any VFP application
on their computer - provided that application has been pre-compiled with Konxise
(by Xitech).
 
They already had to fix one bug that kept Norton from running.  
 
In any case, I thought I would post this in case someone else ran into the same
thing and couldn't figure out why a program that had been running just fine
suddenly won't when nothing on the computer changed (other than getting the
latest security patch from AOL of course.)
 
If I get an answer to the problem, I will post it, should anyone be interested.
 
Take care,
 
Fletcher
 


Fletcher Johnson
[EMAIL PROTECTED]
408-929-5678 - Cell
408-946-0960 - Work
501-421-9629 - Fax


 


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


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

OLE Error - Name already exists in the library

[Fletcher Johnson]

Hi all,

Sorry I haven't been around much lately, but have been really swamped writing
code.

Anyway, I ran across an interesting error.  I tried to compile a program of mine
into a .EXE using VFP 9.0  In the past, I have compiled it many times with no
problem (using VFP 8 or before.)  

What do I do to get VFP 9 to compile this into a .EXE and not get this error?

Thanks,

Fletcher

Fletcher Johnson
[EMAIL PROTECTED]



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

Framework Evaluation

[Fletcher Johnson]

Hi all,

I am busy evaluating frameworks (again)... I am/have getting information on
the following frameworks:

Visual Fox Express
Visual Extend 
Visual ProMatrix
Visual MaxFrame
Codemine
IAS

Do you have any other recommendations regarding VFP 9.0 frameworks?  I have
based some of my analysis on the work that Mike Yearwood did a while ago and
posted to the FoxWiki.  I will also add my results to that article.

I can also send the current evaluation list (what I am trying to compare) to
any who want it (I don't think the email list allows attachments)

Take care,

Fletcher



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

RE: SET PRINTER TO NAME

[Fletcher Johnson]

Dave,

I have a form where I have one button that says setup printer which calls
Sys(1037).  This does work to set the desired printer.  But if the user
selects duplex (double sided) printing, the printer ignores it.  In this
case, the program has 4 separate calls to report form  so that we can
generate very differently formatted portions.

When I add prompt to the report, it doesn't remember the duplex mode
either (although it will then print in duplex mode).  
  
  If I set the printer as the windows default printer and then set duplex on
(again as the default), it still ignores the setting.

Any idea how I get ask the user once to select a printer and then have those
settings preserved for each report form call after that?  The prompt option
currently works, but they get it four times and each time, they have to
specifically set it to use duplex printing.

Thanks,

Fletcher 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Dave Crozier
Sent: Tuesday, July 18, 2006 2:43 AM
To: 'ProFox Email List'
Subject: RE: SET PRINTER TO NAME

Andy,
I confirm that your observations are in fact true. 

I always use Sys(1037) and select the Printer button to select the desired
printer when working in a networked environment as opposed to Getprinter()
as it ALWAYS sets the VFP Printer to the correct value. It involves users
in one more Click to select the printer but works on all VFP versions
networked or not.

Dave Crozier
 The secret to staying young is to live honestly, eat slowly, and to lie
about your age 

 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Andy Davies
Sent: 18 July 2006 10:31
To: profox@leafe.com
Subject: RE: SET PRINTER TO NAME

Hi,
I did a bit more playing with this (vfp9 ReportBehavior=80):
SET PRINTER TO NAME GETPRINTER( )
*seems to work OK - but see below**
?SET(Printer,2)   Windows Default
?SET(Printer,3)   New Fox Default
select foo, bah from somewhere into cursor xxx READWRITE CREATE REPORT tst
FROM xxx   layout is in tag *but no printer info*
(why?)
REPORT FORM tst to printer   see below

** The first time I tried this I selected a printer that is no longer
connected
** and the report apparently printed to the *Win* default - confirming the
behaviour
** reported by Dave Crozier and others.
** I then tried Devendra's suggestion of using aprinters() and noticed that
my
** selected printer was on lpt1: the same port as the Win default.
** so I tried selecting Paperport (a software printer which uses its own
port)
** - this worked using the aprinters() name. I then tried
**  SET PRINTER TO NAME GETPRINTER( ) again but selecting Paperport - AOK!

So there seems to be no difference between getprinter and aprinters - and I
offer the suggestion that the suspected bug re Win ~ Fox default printers
may be a port thing - i.e. if no printer is in the frx Fox uses the printer
*on the port* specified for the Fox default (I wonder which driver?)

I leave more extensive testing (and networked printers) as an exercise for
the reader (Dave?) VBG

Andrew Davies  MBCS CITP
  - AndyD    8-)#


**

This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you 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
** 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.