Re: [NF] Unusal WHERE clause

[Garrett Fitzgerald]

Boy, there was a time when I could spell "UnusUal". And this is Oracle SQL,
but similar would probably work in whatever flavor you needed.

On Wed, Aug 2, 2023 at 9:37 AM Garrett Fitzgerald 
wrote:

> I just had cause to write the following, because it fit into the framework
> slightly better than the procedural equivalent would have. It's code to
> clear out a hash table on a weekly basis to provide a delta export:
>
> DELETE FROM ps_um_accom_std_hsWHERE
> to_char(sysdate, 'DAY') = rpad('SATURDAY', 9);
>
>


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

___
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/CAGd8MrcfQA6KVL2nzqZ7ODZzW4fYhcLia69hOep7GbSkx0J=w...@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.

[NF] Unusal WHERE clause

[Garrett Fitzgerald]

I just had cause to write the following, because it fit into the framework
slightly better than the procedural equivalent would have. It's code to
clear out a hash table on a weekly basis to provide a delta export:

DELETE FROM ps_um_accom_std_hsWHERE
to_char(sysdate, 'DAY') = rpad('SATURDAY', 9);


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

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

Re: [NF] SQL ALL, but not quite

[Garrett Fitzgerald]

Most probably not. We were looking for test students for a new integration.
While our student records system has dev, test, and prod, the immunization
tracker is live, so we can only mess with it Very Carefully. :)

I'll read up on those other two options just in case, though. I know what
they look like, but not how to code them.

On Thu, Jun 22, 2023, 16:35 Ted Roche  wrote:

> As usual, the devil's in the details. With more details, there might
> have been more elegant solutions. Oracle has options like
> Cross-tabulation and Pivot that might give you the results you want,
> especially if this turns out to be an ongoing request with new
> vaccines coming around.
>
> On Thu, Jun 22, 2023 at 3:50 PM Garrett Fitzgerald
>  wrote:
> >
> > Yeah, that was the q way I ended up implementing it - with 7 child
> > tables. :) I just couldn't believe nobody had added an idiomatic way to
> do
> > it in the language without jumping through hoops to get them. It's an
> > immunization record - I wanted all the students that had shots for
> Measles
> > 1, Measles 2, Mumps 1, Mumps 2, Rubella 1, Rubella 2, and NOT MMR1.
> > Surprisingly enough, we actually have 12 active students who meet that
> > criteria. :)
> >
> > On Thu, Jun 22, 2023 at 3:41 PM Ted Roche  wrote:
> >
> > > What's the relationship between parents and children (Isn't that the
> > > universal question?)
> > >
> > > If parents can have many children and children can have many parents,
> > > is there a M:M table to link them?
> > >
> > > If a child record has a single ParentFK, that's kinda sad.  If you
> > > want Parents that have *ALL FOUR* of those children, then a 4-times
> > > join is the most likely simplest and easiest to read and maintain
> > > later:
> > >
> > > SELECT * FROM Parent
> > > join Child Child1 on ParentPK=Child1.ParentFK
> > > join Child Child2 on ParentPK=Child2.ParentFK
> > > join Child Child3 on ParentPK=Child3.ParentFK
> > > join Child Child4 on ParentPK=Child4.ParentFK
> > > Where Child1.field = 'a' and Child2.field='b' and Child3.field='c' and
> > > Child4.field='d'
> > >
> > > While awkward to look at, it should be using only key fields and
> > > optimized even by Oracle.
> > >
> > > On Thu, Jun 22, 2023 at 7:23 AM Garrett Fitzgerald
> > >  wrote:
> > > >
> > > > Is there an idiomatic way to get parent records that have all of the
> > > child
> > > > records a, b, c, and d, short of joining the child table 4 times?
> Oracle
> > > > 19, if it's relevant.
> > > >
> > > >
> > > > --- 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/cagd8mrej1mzhvpw693hpzvvlf4gf9aqlc4_ngb8wbkzddn-...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] SQL ALL, but not quite

[Garrett Fitzgerald]

Yeah, that was the q way I ended up implementing it - with 7 child
tables. :) I just couldn't believe nobody had added an idiomatic way to do
it in the language without jumping through hoops to get them. It's an
immunization record - I wanted all the students that had shots for Measles
1, Measles 2, Mumps 1, Mumps 2, Rubella 1, Rubella 2, and NOT MMR1.
Surprisingly enough, we actually have 12 active students who meet that
criteria. :)

On Thu, Jun 22, 2023 at 3:41 PM Ted Roche  wrote:

> What's the relationship between parents and children (Isn't that the
> universal question?)
>
> If parents can have many children and children can have many parents,
> is there a M:M table to link them?
>
> If a child record has a single ParentFK, that's kinda sad.  If you
> want Parents that have *ALL FOUR* of those children, then a 4-times
> join is the most likely simplest and easiest to read and maintain
> later:
>
> SELECT * FROM Parent
> join Child Child1 on ParentPK=Child1.ParentFK
> join Child Child2 on ParentPK=Child2.ParentFK
> join Child Child3 on ParentPK=Child3.ParentFK
> join Child Child4 on ParentPK=Child4.ParentFK
> Where Child1.field = 'a' and Child2.field='b' and Child3.field='c' and
> Child4.field='d'
>
> While awkward to look at, it should be using only key fields and
> optimized even by Oracle.
>
> On Thu, Jun 22, 2023 at 7:23 AM Garrett Fitzgerald
>  wrote:
> >
> > Is there an idiomatic way to get parent records that have all of the
> child
> > records a, b, c, and d, short of joining the child table 4 times? Oracle
> > 19, if it's relevant.
> >
> >
> > --- 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/CAGd8Mrd8ck7VQdr85D_s=kpw_cz7y7m+2cfj4i6msswxnn8...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Queries re: Python & Such...

[Garrett Fitzgerald]

Is 3 days good enough? :) https://www.youtube.com/watch?v=4SP9iCnZ4NI

On Thu, Feb 16, 2023 at 2:37 PM Eric Selje  wrote:

> That sounds really interesting. If you can post a pic of something that
> takes 5 days to 3D print I'd love to see it.
>


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

___
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/cagd8mre_muzf3nqxze6ms3uynobof0urzhsugivrxoh+v+h...@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.

[NF] SQL ALL, but not quite

[Garrett Fitzgerald]

Is there an idiomatic way to get parent records that have all of the child
records a, b, c, and d, short of joining the child table 4 times? Oracle
19, if it's relevant.


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

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

Re: Retire the CSV?

[Garrett Fitzgerald]

Rght

On Mon, Aug 23, 2021 at 9:25 AM Stephen Russell 
wrote:

> https://www.bitsondisk.com/writing/2021/retire-the-csv/
>
> It's so simple they say.
>
> --
> Stephen Russell
> Sr. Analyst
> Ring Container Technology
> Oakland TN
>
> 901.246-0159 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: 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/cagd8mrd1fidrh57buaj_juyyfsbcabkezwgmebbw2ume79f...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Unit tests (was Re: [NF] I will .....)

[Garrett Fitzgerald]

I still have trouble conceptualizing how to write unit tests for data
access.

On Thu, Jul 23, 2020, 11:37 MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> I have done it that way before, and it works well.  I wrote the DataObj
> and BizObj first before the UI for those purposes.  But alas, those are
> mere validation and data access classes; those are not Unit Tests, by my
> definition anyway.  Ever since I did this n-tier design after watching
> Bob Lee's WhilFest presentation in 2003, it's worked out great.  It's
> much easier to connect the UI to those processes.  But my comment still
> stands:  I bet less than 5% of VFP devs write unit tests in their apps.
>
>
> On 7/21/2020 8:09 PM, Stephen Russell wrote:
> > Why not?
> >
> > Design by Test.  You create your functionality in TESTS and then use
> those
> > functions in a UI.
> >
> > On Tue, Jul 21, 2020 at 5:53 PM MB Software Solutions, LLC <
> > mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
> >
> >> I would wager that less than 5% of devs (in VFP anyway) have unit tests
> >> in their solution setup.
> >>
> >>
> >> On 7/21/2020 10:04 AM, Johan Nel wrote:
> >>> Ah my child, I have to confess I have never in my complete development
> >>> career had a plan or unit test done...
> >>>
> >>> On 2020/07/21 15:13, Eric Selje wrote:
>  Forgive me father, for I have started coding without having a plan or
>  even
>  a unit test written first. It's been 51 years since my last
> confession.
> 
>  On Sat, Jul 18, 2020 at 1:57 PM Dennis Schuette 
>  wrote:
> 
> > That's such an easy change, I won't even bill you for it.
> >
> > 1 hour of programming, 5 hours of debugging, and 3 customer requested
> > enhancements later, I'm almost done!
> >
> > Customized Business Services, LLC (928) 580-6352
> > Dennis Schuette Primary:
> > den...@cbsds.com
> > 49 NW 130 Avenue Alternate:
> > schuette.den...@gmail.com
> > Great Bend, KS  67530
> >
> > -Original Message-
> > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> > Stephen Russell
> > Sent: Friday, July 17, 2020 11:06 AM
> > To: profoxt...@leafe.com
> > Subject: [NF] I will .
> >
> > Alright, I'm not a priest, but I am a programmer.
> >
> > Confess to me your programming sins, and I shall absolve you.
> >
> >
> >
> > --
> > Stephen Russell
> > Sr. Analyst
> > Ring Container Technology
> > Oakland TN
> >
> > 901.246-0159 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: 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/CAGd8MrdTpEmtFZpug4DfvNEayud=q_bxn7qmkeaarptkyjq...@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.

[NF] University of Maine System - Business Intelligence and Data Warehouse Team Lead

[Garrett Fitzgerald]

If anyone is interested in living in the Great State of Maine, check out
the below. :-)

https://maine.hiretouch.com/job-details?jobID=60402=business-intelligence-and-data-warehouse-team-lead=true


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

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

Re: Looking for a "side by side" editor for PRGs

[Garrett Fitzgerald]

I swear by Beyond Compare -
https://www.scootersoftware.com/features.php?zz=features_multifaceted. It's
not free, but it's worth every penny. You can configure it to ignore
whatever needs ignoring (don't want to know about updated datestamps in
comments? no problem), and its Table Compare mode is priceless for
debugging exports to CSV files. :-)

On Fri, Jan 24, 2020 at 1:54 PM Vince Teachout  wrote:

> I've been very happy with Winmerge, for several years.
>
> On 01/24/20 12:52 PM, Paul Newton wrote:
> > Hi all (Happy New Year)
> > I have two PRGs with about 60 differences between them.  I am looking
> for an editor that will allow me to view and edit them side by side.  I
> have CodeCompare but I can't seem to get on with it and I don't have time
> to get to grips with it.  Basically I want a one way copy-and-paste
> facility (copy from one file, paste into the other).  If it highlighted
> differences that would be a bonus but not absolutely essential.  All
> suggestions most welcome.
> > Paul Newton
> >
>
>
>
[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/CAGd8Mrf=f=yde6qowb+61ja49ewpqhwyozto-xfwh60unnb...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Funny bug

[Garrett Fitzgerald]

https://www.ioccc.org/ , anybody? :-)

On Thu, Jun 6, 2019 at 6:17 PM Paul H. Tarver  wrote:

> This made me think that we should hold a contest on this support network to
> create the most convoluted way to do something simple like assign a
> particular value to a variable. A Rube Goldberg Programming challenge. I
> believe with the sense of humor the members here have, it would be an
> absolute hoot to see how complicated we could make a simple variable
> assignment and extra points for obfuscating the code as well.
>
> Then again, I've been so busy lately, I fell off the stats two months in a
> row. A blessing for sure, but still...
>
> Paul H. Tarver
>
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> juer...@wondzinski.de
> Sent: Thursday, June 06, 2019 3:17 PM
> To: profoxt...@leafe.com
> Subject: AW: Funny bug
>
> Cool thing! But:
>
> STORE .F. TO Next(1)
>
> && no kaboom :)
>
>
> -Ursprüngliche Nachricht-
> Von: ProFox  Im Auftrag von Bill Anderson
> Gesendet: Donnerstag, 6. Juni 2019 01:59
> An: ProFox Email List 
> Betreff: Funny bug
>
> DECLARE Next(1, 1)
> Next(1) = .F. && Boom!
>
> Bill Anderson
>
>
> --- 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/cagd8mrf6gpbo1wh-9xbo_ypljdrl_+r7jz4hhn4a5a3...@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.

[NF] Conditions in JOIN clause instead of WHERE

[Garrett Fitzgerald]

Hey, all. I had a general SQL question. Often, I find myself needing to use
the syntax:

FROM a
LEFT JOIN b ON a.key = b.key AND b.field = 'Value'

because if I filter b.field in the WHERE clause, I've effectively made the
LEFT JOIN an inner one.

That makes me wonder, at what point do we stop moving conditions to the
JOIN clause? Obviously, some can't move for syntactical reasons, such as
subqueries. But short of that, when does it make sense to limit a non-outer
join in the join criteria? Never?


--- 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/CAGd8Mrc_OLPhNMoXcZCT70zvDh0bhA5zZM+4WU=qs-ys3yl...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Silly VFP9 Issue....

[Garrett Fitzgerald]

Definitely the font settings. Later versions of Windows don't play nicely
with FoxFont.

On Thu, Feb 7, 2019 at 2:49 PM Desmond Lloyd 
wrote:

> This is really silly,  never the less...  Recently have installed VFP9 on
> a  new computer (Windows 10).   Whenever I do a display stru the columns
> are super wide and wrapped??
>
> Have looked at my other installs and for the life of me cannot find what I
> need to adjust/change?  (they display fine by the way)
>
> Does anyone remember how to fix this?
>
> Regards,
> 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/cagd8mreeyjke6lcyfb_aebu9sbuokvxrhdfjz0b_4mrmqxa...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: MCP ID

[Garrett Fitzgerald]

Did you click on Your Dashboard? That takes me to a page where I can see my
transcript, certificates, wallet cards, etc.

On Fri, Aug 24, 2018 at 4:14 PM 
wrote:

> On 2018-08-24 13:57, Garrett Fitzgerald wrote:
> > You should be able to log in and look it up at
> > https://www.microsoft.com/en-us/learning/certification-overview.aspx.
>
>
>
> I logged into my account but don't see anything about my MCP status.
> It's just advertising for their latest tracks:
> https://www.microsoft.com/en-us/learning/certification-overview.aspx
>


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

Re: MCP ID

[Garrett Fitzgerald]

You should be able to log in and look it up at
https://www.microsoft.com/en-us/learning/certification-overview.aspx.

On Fri, Aug 24, 2018 at 1:11 PM 
wrote:

> Current Corporate gig is asking for anyone with MCP status to provide
> their MCP ID, regardless of its status.  I got my MCP for both desktop
> and distributed systems years ago, but I can't recall what the ID was.
> Do other MCPs here know their ID?  I'm wondering if they even had IDs
> way back when (it was 2002 when I got it).
>
[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/CAGd8Mrei+pno17PDM=0nBuGY76H5hBJJue7j=2=scarpqrp...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: between clause in TSQL (from VFP9)

[Garrett Fitzgerald]

where name >= 'AA%' and name <= 'MZ%'

might do the trick, but make sure you check the edge cases.

On Wed, Aug 8, 2018 at 4:07 PM Rafael Copquin 
wrote:

> I have a SQL Server table with client names. I need to select a range of
> names from this list, but the between clause does not work well
>
> Example; select all names begininng with A up to M
>
> sql statement
>
> select name from mydatabase.dbo.customers
> where name between 'A%' and 'M%'
> order by name
>
> The result is a list of names beginning with A and up to L
>
> To get the names beginning with M I need to write the where clause as
> follows
>
> where name between 'A%' and 'N%'
>
> I also tried :
>
> where name >= 'A%' and name <= 'M%'
>
> The resultant list goes from A to L, it does not show the names beginning
> with 'M'
>
> What is the solution, please?
>
> BTW, is there a range function in T-SQL, similar to Excel (A:M)?
>
>
>
> Rafael Copquin
>


--- 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/CAGd8MrfCs4sGd+GPjq=wwowozr0_c465nvpgnxzbcdyrvc+...@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.

Bounces

[Garrett Fitzgerald]

Anybody else getting too-many-bounces warnings from the list today, or is
it just me?


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

Re: [NF] Bluetooth option in laptops

[Garrett Fitzgerald]

Are Bluetooth printers still a thing, or are they all WiFi now?

On Nov 20, 2017 11:25 AM, "Alan Bourke"  wrote:

> Racking my brains I'd have to say the only time I've used BT on a laptop
> is to connect it to the phone for internet access, and a few times to
> pull pictures and stuff off the phone when I didn't have a USB cable.
>
>
>
> --
>   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/cagd8mre+cdok8jb0dxvnnepog4wyj3cg4qh1nhqna6hpdl1...@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.

[NF] PeopleSoft learning resources

[Garrett Fitzgerald]

Hi, all. I've been offered a job working on UMaine's PeopleSoft system, and
I want to do some research before I actually start. Does anyone know any
good learning resources for it? Thanks.


--- 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/CAGd8MrfT-2=to-7pd7myiqjpc9e_suxjnekfbwahell8tsk...@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.

[NF] Online databases

[Garrett Fitzgerald]

Hey, all. I'm playing with the idea of writing an app for community band
librarians to store their catalogs in. I actually use a Google Sheets file
for the Bangor Band, because I'm worried about maintainability for the next
person, but I've had a couple of ideas that would make sense to do this as
a shared online database app. Since hosting the database myself right now
isn't practical, I was wondering if anyone has experience with using a
cloud database, and how to get started. I'm leaning towards VB.Net (as a
learning project), which makes me think about SQL Azure, but I don't really
know anything about it. Cost is a big factor here, if for no other reason
that I don't want to waste much money during the development phase. Thanks!


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

Re: Fuzzy Name Searching

[Garrett Fitzgerald]

Aha in turn!
https://web-beta.archive.org/web/20101216062156/http://blog.donnael.com:80/2008/04/creating-an-fll/#more-1965


On Apr 12, 2017 4:19 PM, "Ted Roche" <tedro...@gmail.com> wrote:

> Ah! The algorithm rang a bell!
>
> Garrett: have you tried searching Archive.org? A LOT of your stuff
> appears archived:
> https://web-beta.archive.org/web/*/garrett%20fitzgerald%20
>
> The equivalent FoxPro code, by the way is in the leafe downloads at
> https://leafe.com/dls/vfp. Bob Calco wrote it up.
>
> Also on Fox Wikis at: http://fox.wikis.com/wc.dll?
> Wiki~LevenshteinAlgorithm
>
> Craig Boyd's blog about Spell Checking  at
> http://www.sweetpotatosoftware.com/spsblog/CommentView.aspx?guid=
> 8800bdb9-a9c2-484f-942f-6a08947d903a
>
> On Wed, Apr 12, 2017 at 3:31 PM, Garrett Fitzgerald
> <sarekofvul...@gmail.com> wrote:
> > I wrote a FLL to do Levenshtein distances for fuzzy name matching, but
> > everything was posted to my blog, which is no longer online. It wasn't
> > amazingly hard to figure out, though, so it might be worth finding the
> > algorithm in C and recreating my steps. It ran much faster than
> equivalent
> > Fox code did.
> >
> > On Wed, Apr 12, 2017 at 12:49 PM, Stephen Russell <srussell...@gmail.com
> >
> > wrote:
> >
> >> I remember this joy of searching names in a system that had 2+ million
> >> customers and names were all varchar() instead of a key to a secondary
> >> table.  My indexes sure took a beating when I got another "Williams",
> the
> >> number one last name in the system, and it had to tear a page to make a
> new
> >> page in this area.
> >>
> >> I found that making a table called NAMES fixed the search time I was
> >> experiencing.  Two text boxes had input for whatever they keyed.  I
> added
> >> the % for wildcard after any text in each box and one of the keypress
> >> events was the trigger to run it.
> >>
> >> Select 
> >> from customer
> >> where lNameID in (
> >> select nameID from names
> >> where Name like @Lname)
> >> and
> >> fNameID in (
> >> select nameID from names na
> >> where na.Name like @Fname)
> >>
> >> That has been 10-13 years ago.
> >>
> >>
> >>
> >>
> >> On Wed, Apr 12, 2017 at 9:55 AM, Ken Dibble <krdib...@stny.rr.com>
> wrote:
> >>
> >> > Hi folks,
> >> >
> >> > I've been thinking of how I can improve the ability of my users to
> find
> >> > people's names in a system that has over 30,000 people in it.
> >> >
> >> > I've looked at soundex, and I've considered munging names to remove
> >> > spaces, apostrophes, hyphens, etc. The thing about those approaches is
> >> that
> >> > in order to be efficient, they require pre-processing all of the
> names in
> >> > the system and storing the results, which can then be queried to find
> >> > matches.
> >> >
> >> > Unfortunately, that would require modifications to the database,
> which I
> >> > try to avoid due to the downtime they require.
> >> >
> >> > I'm looking for suggestions on how to produce results that include
> close
> >> > matches on last names that doesn't require pre-processing.
> >> >
> >> > I've played with various schemes to assign "weights" to matches based
> on
> >> > the number of matching letters, but they all end up being very
> slow
> >> and
> >> > also producing too many false positives.
> >> >
> >> > I suppose there are no easy answers, but if anyone has an algorithm
> for
> >> > this kind of thing that they would be willing to share, I'd be
> grateful.
> >> >
> >> > Thanks.
> >> >
> >> > Ken Dibble
> >> > www.stic-cil.org
> >> >
> >> >
[excessive quoting removed by server]

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

Re: Fuzzy Name Searching

[Garrett Fitzgerald]

I wrote a FLL to do Levenshtein distances for fuzzy name matching, but
everything was posted to my blog, which is no longer online. It wasn't
amazingly hard to figure out, though, so it might be worth finding the
algorithm in C and recreating my steps. It ran much faster than equivalent
Fox code did.

On Wed, Apr 12, 2017 at 12:49 PM, Stephen Russell 
wrote:

> I remember this joy of searching names in a system that had 2+ million
> customers and names were all varchar() instead of a key to a secondary
> table.  My indexes sure took a beating when I got another "Williams", the
> number one last name in the system, and it had to tear a page to make a new
> page in this area.
>
> I found that making a table called NAMES fixed the search time I was
> experiencing.  Two text boxes had input for whatever they keyed.  I added
> the % for wildcard after any text in each box and one of the keypress
> events was the trigger to run it.
>
> Select 
> from customer
> where lNameID in (
> select nameID from names
> where Name like @Lname)
> and
> fNameID in (
> select nameID from names na
> where na.Name like @Fname)
>
> That has been 10-13 years ago.
>
>
>
>
> On Wed, Apr 12, 2017 at 9:55 AM, Ken Dibble  wrote:
>
> > Hi folks,
> >
> > I've been thinking of how I can improve the ability of my users to find
> > people's names in a system that has over 30,000 people in it.
> >
> > I've looked at soundex, and I've considered munging names to remove
> > spaces, apostrophes, hyphens, etc. The thing about those approaches is
> that
> > in order to be efficient, they require pre-processing all of the names in
> > the system and storing the results, which can then be queried to find
> > matches.
> >
> > Unfortunately, that would require modifications to the database, which I
> > try to avoid due to the downtime they require.
> >
> > I'm looking for suggestions on how to produce results that include close
> > matches on last names that doesn't require pre-processing.
> >
> > I've played with various schemes to assign "weights" to matches based on
> > the number of matching letters, but they all end up being very slow
> and
> > also producing too many false positives.
> >
> > I suppose there are no easy answers, but if anyone has an algorithm for
> > this kind of thing that they would be willing to share, I'd be grateful.
> >
> > Thanks.
> >
> > Ken Dibble
> > www.stic-cil.org
> >
> >
[excessive quoting removed by server]

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

Re: Anybody there?

[Garrett Fitzgerald]

I saw the brainteaser post.

On Jan 6, 2017 9:18 AM, "Dave Crozier"  wrote:

Posted 3 messages today and none have appeared Just a test

Dave

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

RE: [NF] Software recommendations: Sharing photo album for comments & ID?

[Garrett Fitzgerald]

SmugMug is good for privacy and comments. It doesn't have any photo ID, but
it has manual tagging. I have a coupon around somewhere if you need it.

On Dec 12, 2016 11:32 AM, "Dave Crozier"  wrote:

> Ted,
> I have used jAlbum with great success. It is fully featured and skinnable
> and can handle large volumes.
>
> Also 30 day free trial and not very expensive anyway.
>
> Dave
>
> -Original Message-
> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche
> Sent: 12 December 2016 15:48
> To: profox@leafe.com
> Subject: [NF] Software recommendations: Sharing photo album for comments &
> ID?
>
> I'm looking for a web-based photo album I can share with a few friends and
> relatives in order to ID folks in a photo album from the 1940s I'm
> digitizing. I'm not comfortable with posting them to Facebook, but I like
> the style of ID'ing faces it uses. Ideally, I'd limit access to a list of
> folks who could comment and download but not delete.
>
> Anyone got suggestions, experiences to share?
>
>
> --
> 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/cagd8mrfyslkbodk8gbh7cvcs3zrrcdk05hj3x4b8tvbu5d7...@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.

[NF] Job hunting humor

[Garrett Fitzgerald]

I just found the following requirement in a job listing, and had to share
it.

"Strong understanding of WCF (windows complication framework or foundation)"


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

[NF] Android learning apps

[Garrett Fitzgerald]

I've gotten interested in Android's potential to teach me programming
instead of just games and social media. I enjoyed the SoloLearn LearnPython
app. Their PHP one wasn't as good, but i felt I got something out of it.
I'm currently using Enki, but I'm not sure i like their 5-a-day workout
style.

What have other people enjoyed? Or not? Thanks.


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

Re: "PATROL" is the same as .NULL.???

[Garrett Fitzgerald]

That wouldn't happen to be the current record when you do the browse, would
it?
On Jun 13, 2016 11:13 AM, "Vince Teachout"  wrote:

> I have a departments table, and when I open it in browse mode, and type
> the following:
>
> BROWSE FOR vehdept = 'PATROL'
>
> It pulls up a single record, which has .NULL. in the vehdept field. There
> are other records with .NULL. in that field, but it only pulls up this
> one.  ? IsnNull(VehDept) returns .t., so it's not a case of a string
> ".NULL." (Which shouldn't match either.)
>
> Luckily, this isn't anything I was actually working on, just something I
> came across while trying to transfer data.  But any ideas what could
> cause this?
>
[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/CAGd8Mredn=quvu2fhmerpa1mj-muhjzhoj_5wcuamo0iegh...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [ADMIN] Help Garrett Fitzgerald

[Garrett Fitzgerald]

Thanks, Ed. It's very frustrating putting days at Microsoft and begging
for help in the same post. I really appreciate all the assistance I've
gotten over the past week -- it's done a lot for my state of mind to see
all the caring people out there.
On Jun 16, 2015 9:40 AM, Ed Leafe e...@leafe.com wrote:

 I think many of you remember Garrett from his days at Microsoft. Well, it
 looks like he's going through a rough patch, so I thought that I'd pass on
 his request in case others on this list remember him and would like to help
 out.

 http://www.gofundme.com/wn6y22a


 -- Ed Leafe







 --- StripMime Report -- processed MIME parts ---
 multipart/signed
   text/plain (text body -- kept)
   application/pgp-signature
 ---

[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/cagd8mrfmruugfs8e7ob9vgnboul543rg7rmm9ury3mofokz...@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.

[NF] Google Drive problems

[Garrett Fitzgerald]

Is anyone else having trouble with Google Drive? Neither my wife and I can
access it, on my XP machine or my daughter's Win8 machine. drive.google.com
loads, but then the wheel just spins indefinitely. When I checked Google
Docs, I was able to load the Docs, but the Sheets wouldn't load. Gmail
works just fine, both accounts, both computers.

Thanks.


--- 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/cagd8mrcut7_dujhveyd7uuzptrhgfxkvq2_q2zjept2+ebo...@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.

[NF] T-shirt

[Garrett Fitzgerald]

I'd get this if it weren't so close to accurate

http://teespring.com/progr


--- 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/CAGd8MrePReq_Peyt=qx4A2Pfun1wOMHMbjjEaW6erqWtgH=o...@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.

[NF] Oracle Data Redaction

[Garrett Fitzgerald]

I'm looking at configuring Oracle Data Redaction on a server we're using to
block out some SSNs we don't really need to see. Unfortunately, our SSNs
are stored as numeric, which means that here in New England, we have a lot
that come out short. I set it up with the
format DBMS_REDACT.REDACT_NUM_US_SSN_F5, which means they should look like
96789. However, some of them come out as 989.

Does anybody know how to get this to come out right? I tried configuring
them as RegExps, but that apparently only works for strings. I could leave
it as it is, but that bothers my sense of aesthetics.


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

Re: Source Code Version Control

[Garrett Fitzgerald]

I use Subversion/TortoiseSVN along with Christof's TwoFox utility to
convert the binary files.

http://www.foxpert.com/docs/cvs.en.htm
https://subversion.apache.org/
http://tortoisesvn.net/

Various other people here swear by git, though

On Thu, Feb 19, 2015 at 6:07 AM, Dave Crozier da...@flexipol.co.uk wrote:

 Sorry to bring this old chestnut up again but now we are two here
 (myself and Tom) at Flexipol it has become very clear that we need some
 sort of versioning software for VFP 9 and I am wondering what is the
 current flavour of the day with you folks out there.

 Obviously Visual SourceSafe is available but I must admit to having mixed
 feelings about it after using it in VFP 6 days after the database became
 corrupted and we couldn't access any versions of the source code never mind
 the older revision so I will take council on its use. We have MSDN so the
 latest Team Foundation is available but I must admit t knowing diddly squat
 about it!

 So, any recommendations/likes/hates/gotchas would be helpful.

 Dave



--- 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/CAGd8MrciXzma_Ctcc9KLR7mMjf=fMZpKSO+Gca+TaYP=rr8...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: New Assistant

[Garrett Fitzgerald]

On Wed, Feb 4, 2015 at 2:15 AM, Dave Crozier da...@flexipol.co.uk wrote:

 My new assistant has now started work here at Flexipol so I would like to
 introduce you to him.
 His name is Tom Dawson and no doubt he will be posting to the list when he
 is in need of any assistance when I am not available.


How sweet. Fresh meat.


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

Re: New Assistant

[Garrett Fitzgerald]

On Wed, Feb 4, 2015 at 4:57 AM, Peter Cushing pcush...@whisperingsmith.com
wrote:

 Welcome aboard Tom.  Just ask him not to mention tabs v spaces.  I did
 once but I think I got away with it ;-)


Everyone knows it's spaces!


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

Re: SQL Group By Question

[Garrett Fitzgerald]

If you could post some fake data to http://sqlfiddle.com/, and let us know
what you want the results to look like, that might help.

On Thu, Jan 29, 2015 at 3:31 PM, Stephen Russell srussell...@gmail.com
wrote:

 On Thu, Jan 29, 2015 at 2:22 PM, Jeff Johnson j...@san-dc.com wrote:

  Let's assume I have a select statement:
 
  SELECT cname, ccity, cnumber sum(1) as groupcount from mytable group by
  cname, ccity, cnumber orger by cname
 
  I have to put all of the fields in the group by but the sum will give me
  each individual cname, ccity, cnumber which is not what I want.
 
  How do I get just the number of cnames?
  ---


 Do you want a count of rows by name, city?

 select  cname, ccity, count(*) as groupcount from mytable group by cname,
 ccity




 --
 Stephen Russell
 Sr. Analyst
 Ring Container Technology
 Oakland TN

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

Re: Report Writer Question

[Garrett Fitzgerald]

On Fri, Jan 23, 2015 at 3:25 PM, Jeff Johnson j...@san-dc.com wrote:

 I have a field on a label.  A UDF returns a name GEORGIANNA
 HEWWIT-CRONKIDE.  The field does not have enough room for the whole name
 so I get GEORGIANNA.  I made the field two lines and it didn't wrap.  I
 then tried Stretch with overflow and it still did not produce the
 HEWWIT-CRONKIDE on the second line.  What am I missing.  I seem to do
 this all the time.


I don't have VFP9 in front of me, but if you check the properties for that
field, there should be an option on what to do when a field is too long.
(If it's not 9, not sure. Make it wider so the last name fits across?)


--- 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/CAGd8MrdtO+0Dq0ihzWQQbbVo73tYV=xOkEH5jDvFmz1xhrK=m...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Visual FoxPro 9 is 10 years old today.

[Garrett Fitzgerald]

Hippo birdie two foxes,
Hippo birdie two foxes,
Hippo birdie deer fox,
Hippo birdie two foxes!

On Wed, Dec 17, 2014 at 2:50 PM, Alan Bourke alanpbou...@fastmail.fm
wrote:

 Happy birthday old girl.
 --
   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/cagd8mrdd_amkzytvejylhoirzdc1fawpxkahwhnh1ywxvvs...@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.

Powerbuilder

[Garrett Fitzgerald]

Hmm. I just started working with PowerBuilder, and out of curiosity checked
my archives to see if anyone else out here was. The most recent email I
found was from 2008. Hmm


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

Re: Powerbuilder

[Garrett Fitzgerald]

I wanted to look at moving things in the WPF direction, but for some
reason, I get compilation errors in PB12.NET that I don't get in
PB12Classic, so barring a good business reason to put the effort into
moving it properly, no.

On Wed, Dec 3, 2014 at 11:18 AM, Stephen Russell srussell...@gmail.com
wrote:

 What version, 12?

 Are you doing all that WPF stuff?

 On Wed, Dec 3, 2014 at 10:05 AM, Garrett Fitzgerald 
 sarekofvul...@gmail.com
  wrote:

  Hmm. I just started working with PowerBuilder, and out of curiosity
 checked
  my archives to see if anyone else out here was. The most recent email I
  found was from 2008. Hmm
 
 
  --- 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/cagd8mrfuhkqql-hmr_fg2_bre0zgfmccj2dcmt13stcpsy6...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Surd do miss Visual SourceSafe

[Garrett Fitzgerald]

Agreed. When I presented on Subversion, I spent all but the last 5
minutes of the presentation on command line, and then switched to TSVN
once I had all the concepts in place.

On Thu, Oct 23, 2014 at 12:30 PM, Paul McNett p...@mcnettware.com wrote:
 I think the waters get muddied by the GUI front ends. Git is a powerful tool 
 which takes a while to understand. Do yourself a favor and interact with it 
 at the command line terminal at least at first.

 On Oct 17, 2014, at 10:49, Virgil Bierschwale vbier...@gmail.com wrote:

 Push is what I bet I'm missing..

 Thanks Ted,

 Virgil


 -Original Message-
 From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche
 Sent: Friday, October 17, 2014 12:48 PM
 To: profox@leafe.com
 Subject: Re: [NF] Surd do miss Visual SourceSafe

 I wrote a book on Visual SourceSafe, but I don't miss using it every day.

 Git, and other distributed version control systems, work in a different
 manner than the client-server model of VSS, CVS and SVN.

 You have a repository locally on your machine, in the .git subdirectory,
 usually. You 'git add' and 'git commit' your changes from your working
 directories to the repository. You 'git push' changes in the local repo to
 remote repos, which you need to configure.

 There are a number of different utilities to use git on Windows, like the
 GitHub tools, or TortoiseGit. Some of these change the names of the commands
 in their gui (for example, Tortoise calls push 'sync' iirc.) I think this
 just muddies the waters. Now you have two tools to use.

 The Fine Manuals should help you set this up. Yell if you have questions.

 On Fri, Oct 17, 2014 at 10:30 AM, Virgil Bierschwale vbier...@gmail.com
 wrote:

 https://github.com/vbierschwale/kaaw_custom



 What am I missing here?



 When I use the git gui (windows), it shows my files, etc. are
 there/have been added.



 Yet when I go to that site I see nothing?



 Thanks,



 Virgil





 Virgil Bierschwale

 www.VirgilBierschwale.com



 Keep America At Work

 www.KeepAmericaAtWork.com



 Where Are The Jobs?

 http://keepamericaatwork.com/?page_id=53







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

Re: What are you using for source control with VFP?

[Garrett Fitzgerald]

I use TortoiseSVN with Christof Wollenhaupt's TwoFox -
http://www.foxpert.com/docs/cvs.en.htm.



On Mon, Aug 11, 2014 at 4:01 PM, Fred Taylor fbtay...@gmail.com wrote:

 I'm using TortoiseSVN, but I'm not using any conversion tools on binary
 files to text.(.SCX,.SCT/.VCX,.VCT/etc)  I'm also  not using SVN within the
 VFP IDE, strictly from Windows Explorer.

 Fred


 On Mon, Aug 11, 2014 at 12:46 PM, Fernando D. Bozzo fdbo...@gmail.com
 wrote:

  [I'm using Google Translate]
 
  I find the sad reality that VFP developers do not know or do not use
 source
  control. At least most people I know do not use it in their daily lives
 as
  if is technology out of reach or can not be used with FoxPro or would
 be
  very difficult or even unnecessary or tedious.
 
  This thread is to ask who of you use source control tools with FoxPro
 code,
  what tools you use, or if you know what tools are available, and share
  information about it.
 
  I think the responses, or lack thereof, you can get a better idea about
  this lack crawling on FoxPro. It will be something interesting at least.
 
 
  To begin with, I tell a little of my experience with this topic:
 
  Like many of you, I use FoxPro from the beginning, I made contact with
  source control in the late 90's with SourceSafe 6 (VFP 6, included in VS
  6), and until last year (2013) it was used in all team developments I've
  participated, including personal mine.
 
  Since late last year at my workplace have made a technological renovation
  in which have unified all source control tools in use (svn, cvs, vss,
 etc)
  for various languages (Java, web development, Oracle 
  http://www.oracle.com,
  Cobol, etc) into a more modern source control tool (PlasticSCM) for
 which I
  have developed an Open Source (FoxBin2Prg) component to use with Visual
  FoxPro 9, that can be used indepently.
 
  Since April this year (2014) we can use source control in FoxPro 9 in the
  same manner as used in other languages ​​like Java or other for many
 years,
  but recently it is now possible because the development team (10 members
  about) can work even on the same components (forms, classes, etc) and mix
  changes visually, without having to edit them using the FoxPro IDE to
  copy/past methods manually.
 
  I am interested to hear your experiences.
 
  Regards,
 
  Fernando D. Bozzo
 
  PD: I may ask this in other forums to have a broader idea.
 
 
  --- 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/CAGd8MrdOdnGzpS=-nqanltrjfoz1a5p-zxyn2vxu_kkt2fa...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Icon Editor

[Garrett Fitzgerald]

I was going to suggest the Gimp as well -- I've used it to do icons that
include everything from 16x16 to 256x256.

On Wed, Aug 6, 2014 at 11:31 AM, Gary Jeurink g.jeur...@charter.net wrote:

 I took a CCC website class at the local community college and they taught
 me
 how to use gimp-2.8... it does everything and its open source. You can do
 logos / icons / GIFS / BMP / PNG... anything, and you can even open pdf's
 as
 layers per page and recover the art work... there is a couple of gimp books
 ... valuable tool FREE

 Gary Jeurink



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

[NF] Database to build Band Library on?

[Garrett Fitzgerald]

Hey, folx. I've been thinking about how to get the Bangor Band's music
library out of Excel and into something a bit more functional. I can, of
course, think of how to do it relationally -- what I'm wondering is, would
anyone care to suggest another platform to do it on? And why? :-)

Thanks!


--- 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/CAGd8MrebYJsvRn9mTnD2V+j8yWuD35okX24LJ33ee=rxh4t...@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.

Cleverbot knows...

[Garrett Fitzgerald]

http://www.cleverbot.com/j2log-aIjCSeGAWQGSPABAUIBE-detail

___
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/CAGd8MrcXOEC=+4z7gZam7VsFoT=-f+tb9hakxjtozqcmz3w...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Cleverbot knows...

[Garrett Fitzgerald]

For those who are justifiably paranoid about clicking links, I asked
CleverBot Why Visual FoxPro?, and it answered Its better than IE.
:-)

On Fri, Sep 20, 2013 at 8:07 AM, Kurt @ VR-FX v...@optonline.net wrote:
 Hey Garret,

 I've seen you post to this group over time - as i just looked you up in the
 Archives in my Inbox.

 So - I found this posting curious. You didn't put [NF] in the subject - and
 NO Content in the message besides the LINK. As such - I am VERY Skeptical as
 to whether I should Click the link - or whether some Bot has Hacked your
 e-mail account - and clicking the link will give me a Virus!

 -K-


 On 9/20/2013 8:02 AM, Garrett Fitzgerald wrote:

 http://www.cleverbot.com/j2log-aIjCSeGAWQGSPABAUIBE-detail



[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/cagd8mrcjxm4sxjtg6_-whekwo3zna+r3u+3m3d-odzqqn5k...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Images

[Garrett Fitzgerald]

That's why I tend to trim them down to the first parameter or two when
I send them out, or post them on Wikipedia. (You would not believe
some of the Google Books links that get used...)

On Thu, May 16, 2013 at 12:22 PM, Michael Oke, II oke...@gmail.com wrote:
 Search URLs tend to look like that, if you really look at them.

 

 Michael Oke, II
 oke...@gmail.com
 661-349-6221

 On May 16, 2013, at 7:57 AM, Ken Kixmoeller (ProFox) 
 foxh...@information-architecture.com wrote:

 On Thu, May 16, 2013 at 1:47 AM, Michael Madigan mmadi10...@yahoo.comwrote:


 https://www.google.com/search?q=free+buttonrlz=1C1CHFX_enUS481US481aq=foq=free+buttonaqs=chrome.0.57j0l3j62l2.2398j0sourceid=chromeie=UTF-8#hl=engs_rn=12gs_ri=psy-abtok=YQHQORnalyCoLqw4stVUkwpq=free%20buttoncp=12gs_id=4xhr=tq=free+buttonses_nrs=truepf=prlz=1C1CHFX_enUS481US481sclient=psy-aboq=free+buttonsgs_l=pbx=1bav=on.2,or.r_cp.r_qf.bvm=bv.46471029,d.dmQfp=bf338de2f8f6biw=1600bih=767


 Holy crap, what a URL.


 --- 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/CAGd8Mrd0jLzZMC4sMRrCtj1-S1KtA=EE0PvdA+Q=zlufsa2...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Version control

[Garrett Fitzgerald]

On Wed, Sep 12, 2012 at 5:56 AM, Dave Crozier da...@flexipol.co.uk wrote:

 Never having used alternative software, I think Paul McNett dabbled with
 subversion using VFP and wonder if anyone has any comments on what to use
 and why. I know about the format of VFP forms etc. being a pain as they are
 not simple text.


I've been using Subversion with Christof's TwoFox tool to convert the
binary files to and from text. A lot of people swear by git, but it doesn't
make as much sense to me as svn does. YMMV, of course.

http://subversion.apache.org/
http://www.foxpert.com/docs/cvs.en.htm


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

Re: [NF] Ergonomic Keyboard Recommendation

[Garrett Fitzgerald]

On Thu, Aug 30, 2012 at 2:31 PM, Paul McNett p...@ulmcnett.com wrote:

 Hey Garrett, I tried to convert to Dvorak keyboard layout around 2004 I
 think, but
 found that the repositioning of programming symbols like {}:(). and the
 dread of
 remapping vim to still have the classic hjkl for movement seemed like a
 showstopper
 for me. Any input on that? (pun not intended)


That remapping doesn't really sound like a showstopper for me, as long as
it's easy to do. As far as the moving symbols, that was an easy adjustment.
The only problem I had was when I borrowed a Kinesis keyboard and remapped
_that_ for Dvorak, instead of using the Kinesis Dvorak keyboard. The
brackets wound up on different hands, for some odd reason.


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

Re: REPORT FORM...FOR problems

[Garrett Fitzgerald]

Ah, you mean do it the way you've been doing all your other reports for
the past 5 years. But that makes too much sense

On Sat, Aug 25, 2012 at 5:10 PM, Fred Taylor fbtay...@gmail.com wrote:

 Why screw with the relations?  Use SQL to gather everything you need into a
 single cursor for reporting.  Much easier to debug as you can see what's
 happening.

 Fred


 On Sat, Aug 25, 2012 at 2:01 PM, Garrett Fitzgerald 
 sarekofvul...@gmail.com
  wrote:

  It's been too long since I tried to get cute with reports. I just
 created a
  form for a wedding registry which would fire off a report at the end
  listing the items. To do this, I related the RegistryHdr to the
 RegistryDet
  to the Catalog to the Dept tables. I then selected the Detail table and
  fired off the report with REPORT FORM registry PREVIEW FOR
  RegistryDet.iRegistryID = liRegistryID. That gives me the detail lines I
  need, but no header information or department information. If I drop the
  FOR clause, it works fine. What am I missing here?
 
  Thanks.
 
 
  --- 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/CAGd8MrcEM7sFUrguFNRSyBBv9OdbLMfw9Nr4Pf92FFoAU1f=w...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Check for Running VFP .EXE

[Garrett Fitzgerald]

On Mon, Jun 18, 2012 at 4:55 PM, Jeff Johnson j...@san-dc.com wrote:
 I have a program that checks for the caption of a running VFP
 application.  It uses these API's:

 GetActiveWindow in Win32API
 GetWindow in Win32API
 GetWindowText in Win32API

 The question is, will this work on Windows7 to check for a VFP9
 application or do I need to use different API's

I get suspicious when checking captions -- I prefer the Mutex code
from this thread.
http://social.msdn.microsoft.com/Forums/en-US/visualfoxprogeneral/thread/f76d5b25-25a7-4ba1-b192-378729f3a437
(http://preview.tinyurl.com/vfpSingle).

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

Re: [NF] Is there a script or program that will remove all known games on a pc?

[Garrett Fitzgerald]

On Thu, Jun 14, 2012 at 9:55 AM, Gérard Lochon g-loc...@wanadoo.fr wrote:
 - Original Message -
 From: Alan Bourke alanpbou...@fastmail.fm

 Is there company policy around it? You might be better with a solution
 that allows you to remotely monitor installations, and make it known
 that you have it.

 Absolutely.
 It is also easy using Windows (please don't laugh) to prevent many things ;
 you can deactivate the authorization to execute installation of third-part
  softwares, or monitor when even if it's done.

Spiceworks includes software inventory tools, for example.

___
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/CAGd8Mrc2yeemAWr=My-XM_p7o+gmSD7Yw3GqX+kE=pdd2px...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Recommend forum software?

[Garrett Fitzgerald]

On Sat, Jun 2, 2012 at 10:19 AM, Malcolm Greene pro...@bdurham.com wrote:
 simplePress
 http://simple-press.com/

I loathe this. I'm on one forum that just converted over from
vBulletin, which is nice and as customizable as all get-out. It's not
freeware, but it has free support and a large community working on
plugins.

___
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/cagd8mrfjz4j4xzn+u5nhd45mr7ccbav7akgrcsj4fbo6lge...@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.

Importing from VFP into SQL2012

[Garrett Fitzgerald]

Hi, all. Last week, I installed SQL Server 2012 Express on a 64-bit Windows
7 machine, and tried to import some VFP data into it. I selected the
Import Data (32-bit) utility and picked the Fox OLE DB provider, only to
have the app promptly hang and go bye-bye, without even letting me select a
DBC/directory. I checked the Data Explorer in the VFP Task Pane to make
sure it wasn't an issue with running the provider on that machine, but it
worked fine.

Any thoughts? Thanks.


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

Re: Microsoft SQL Server 2012 licensing

[Garrett Fitzgerald]

On Fri, Mar 23, 2012 at 05:13, Alan Bourke alanpbou...@fastmail.fm wrote:
  I was reading a bit about this last night and some of the comments as
  to why people would still shell out for MSSQL over, say, PostGres were
  interesting. A lot of it seems to come down to meeting strict corporate
  standards for security and support.

Or, the company selling the app keeping your business running  says
You're using this, so you use this. :-)

___
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/CAGd8Mrc1XZ1hM-h=ohe+nrbntjsQ+0DiwM84CUbz=hzmqqt...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Scanners and how to use them

[Garrett Fitzgerald]

On Sat, Feb 18, 2012 at 15:37, Mike Copeland m...@ggisoft.com wrote:
 It depends on what you're doing...if you are processing one item at a
 time (1. scan item, 2. process scanned data, 3. scan next item, etc.)
 then a wireless scanner using bluetooth will be pretty effective. But if
 you are scanning several items at once, i.e., a semi-truck load, then I
 would use a scanner that collects data then uploads a batch.

It's halfway between those -- the clerks would be walking around the
store scanning items for a wedding registry. :-) So, not quite a semi,
but neither is it line-by-line. And I'd hate to walk all the way
around the store and find out the input screen crapped out on the
first scan Guess that answers my question. Any recommendations on
decent store-and-upload scanners?

___
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/CAGd8MreyiAG4X9VMfH_nd0b=oywkx7xluvtpik8bejdkcc7...@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.

Keyboard navigation

[Garrett Fitzgerald]

If anyone else out there is going crazy because you can't get the focus to
go to a particular textbox using the keyboard, you might want to check the
TabStop property.

That is all.


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

Re: [NF] When your clients are confused with lorem ipsum

[Garrett Fitzgerald]

On Wed, Jan 4, 2012 at 14:14, Stephen Russell srussell...@gmail.com wrote:
 http://hipsteripsum.me/?paras=4type=hipster-centric

 The new text could be:
 Iphone photo booth carles scenester vice, skateboard fixie fanny pack
 twee williamsburg chambray terry richardson gentrify VHS gluten-free.
 Banksy freegan mustache wolf shoreditch single-origin coffee brooklyn
 sustainable viral. Pitchfork shoreditch 8-bit, salvia high life
 tattooed four loko yr. Raw denim portland cosby sweater scenester,
 irony single-origin coffee PBR. Gluten-free raw denim portland, vice
 tofu +1 bicycle rights DIY sartorial american apparel fanny pack cred
 PBR VHS. Banh mi brooklyn 8-bit 3 wolf moon +1 dreamcatcher mixtape
 williamsburg, yr keffiyeh butcher gluten-free seitan. Shoreditch fixie
 messenger bag squid, 8-bit hoodie beard terry richardson chambray
 mustache jean shorts 3 wolf moon.

Or, for the sadists in the crowd:

Dearest creature in creation studying English pronunciation, I will teach you
in my verse sounds like corpse, corps, horse and worse. I will keep you,
Susy, busy, make your head with heat grow dizzy; tear in eye, your dress
you'll tear; queer, fair seer, hear my prayer. Pray, console your loving poet,
make my coat look new, dear, sew it!  Just compare heart, hear and heard,
dies and diet, lord and word. Sword and sward, retain and Britain (mind the
latter how it's written). Made has not the sound of bade, say-said, pay-paid,
laid but plaid. Now I surely will not plague you with such words as vague and
ague, but be careful how you speak, say: gush, bush, steak, streak, break,
bleak, previous, precious, fuchsia, via recipe, pipe, studding-sail,
choir; woven,
oven, how and low, script, receipt, shoe, poem, toe. say, expecting fraud and
trickery: daughter, laughter and Terpsichore, branch, ranch, measles,
topsails, aisles, missiles, similes, reviles.

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

Re: [NF] Useful list of bootable recovery CDs for disinfecting machines.

[Garrett Fitzgerald]

On Fri, Dec 23, 2011 at 04:15, Alan Bourke alanpbou...@fastmail.fm wrote:

 http://www.metafilter.com/110822/For-those-family-computer-rescue-sessions

Oh, goodness. I needed this badly. Wish me luck! :-)

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

Re: date handling in sql server 2005 express

[Garrett Fitzgerald]

On Thu, Dec 15, 2011 at 16:34, Rafael Copquin rcopq...@fibertel.com.arwrote:

 Thank you, it works very well. In the Spanish SQL it returns Español and
 in the English one it returns us_english

 How about the date format?


In Oracle, I use DATE '2011-12-15', which I believe is ANSI standard.
Does that format work for you here?


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

Re: [NF] Way to legally download (and own) movies?

[Garrett Fitzgerald]

On Thu, Dec 8, 2011 at 14:09, Vincent Teachout tea...@taconic.net wrote:

 I'm a neophyte when it comes to online entertainment.   I know about bit
 torrent, and pirate sites, but is there a way to legally purchase,
 download, and *own* a movie (as opposed to you can watch it for up to
 48 hours)?

 I'm trying to get a movie for my mom, but also trying to get her more
 hooked on the laptop we got her.  If I just give her a DVD, she'll watch
 the boob tube.  But if I can install it on her laptop, she may actually
 click something on her laptop.

 Any suggestions?


Archive.org has some fairly-surprising entries in the free category.
Check out
http://tech.blorge.com/Structure:%20/2010/08/11/top-40-best-free-legal-movies-you-can-download-right-now/
for
a list of some she might be interested in.


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

Re: Wish for the VFP Report Writer -- ZOOM in Design mode

[Garrett Fitzgerald]

On Wed, Oct 19, 2011 at 16:32, Paul McNett p...@ulmcnett.com wrote:
 I know it doesn't help, but I specifically put in zooming in the Dabo Report 
 Designer
 because it bugged me so much in VFP...

Is it bad that I went for the Like button?

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

Re: VFP9 SP2 I need a report writer recommendation for a non-programmer

[Garrett Fitzgerald]

On Thu, Oct 13, 2011 at 11:42,  kamcgin...@gmail.com wrote:
 This user would not want to spend a lot of money. They only need some simple 
 reports and probably would not access more
 than 3 tables in the report.

 Any suggestions?

I'd suggest Crystal - it's great at hand-holding, but can get out of
the way when you need it to.

Of course, my recommendation is probably heavily biased by working
with it every day. :-)

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

Re: [NF] Default Directory for Pictures in WIN7

[Garrett Fitzgerald]

On Mon, Oct 3, 2011 at 16:44, Charles Hart Enzer, M.D., FAACP
charles.en...@uc.edu wrote:
 I am using WIN7 Ultimate 64-bit.

 Which is the default folder for Pictures:

  * *C:\Users\Charles\Pictures*
  * *C:\Users\Charles\Documents\My Pictures*

 Thank you.

Is http://www.news2news.com/vfp/?function=659 helpful?

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

Re: [NF] Default Directory for Pictures in WIN7

[Garrett Fitzgerald]

On Mon, Oct 3, 2011 at 19:52, PabloSr prive...@nycap.rr.com wrote:
 On my win7 ultimate, it is: C:\Users\DonPablo\Pictures

And for that matter, mine is mapped to a network drive, so any program
that assumes C:\ will create a folder I never look at.

___
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/CAGd8Mre=egThiJ3=QiUaQ3ji=s+00l8yxee9rmjdfddpb+j...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Ah memories ...

[Garrett Fitzgerald]

On Fri, Sep 30, 2011 at 09:45, Ed Leafe e...@leafe.com wrote:
        I have one of the rarest Fox items: a CD of VFP 4!

I worked somewhere that had a copy in the software cabinet. I should
have looted it while I had the chance -- it wasn't like it was ever
going to actually be used. :-)

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

Re: [NF] Firefox 7

[Garrett Fitzgerald]

On Wed, Sep 28, 2011 at 12:40, Alan Bourke alanpbou...@fastmail.fm wrote:
 On Wednesday, September 28, 2011 3:22 PM, Dave Crozier
 da...@flexipol.co.uk wrote:
 Firefox 6 has only officially been out 6 weeks and 7 has now been
 released.

 Yeah apparently they had a major focus olong the lines of what the
 Lockheed Skunk Works credo used to be - 'simplify and add lightness'.

Or as Calvin would say, they took out the slow parts. :-)

___
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/cagd8mrfh2_t+4n+cxfi0wciugg4bwhmolfto_4scocvv5qo...@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.

[NF] Pinning a .VBS to the Win7 Taskbar

[Garrett Fitzgerald]

Afternoon, all. I have a client who just had to upgrade her WinXP box
to Win7. She was used to using a shortcut in her QuickLaunch toolbar
that would run a VBS that updated and/or launched her Fox EXE.
However, we can't figure out how to set it so that it works from the
Win7 Taskbar. The shortcut works fine, but if I drag it onto the
Taskbar and try to launch the VBS, it tries to run a VFP .FXP instead,
and I have no idea _where_ it's coming up with that behavior. Any
thoughts? Thanks!

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

Re: [NF] Stanford university is offering free computer science courses online

[Garrett Fitzgerald]

On Mon, Aug 22, 2011 at 12:16,  kamcgin...@gmail.com wrote:
 http://db-class.com/

XPATH? NoSQL? Maybe I _should_ do this class. :-)

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

Re: Nominees for the 2011 FoxPro Lifetime Achievement Award

[Garrett Fitzgerald]

On Wed, Aug 17, 2011 at 13:55, Ed Leafe e...@leafe.com wrote:
        Submit your nominees here:

 http://doughennig.blogspot.com/2011/08/2011-foxpro-lifetime-achievement-award.html

Is there a Lifetime Unachivement Award? I might have a shot at that one. :-)

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

Re: Nominees for the 2011 FoxPro Lifetime Achievement Award

[Garrett Fitzgerald]

On Wed, Aug 17, 2011 at 14:19, Ed Leafe e...@leafe.com wrote:
 On Aug 17, 2011, at 1:18 PM, Garrett Fitzgerald wrote:

 Is there a Lifetime Unachivement Award? I might have a shot at that one. :-)

        Sorry, I have that one locked up!

...which proves I deserve it more. :-)

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

Re: [NF] What's the modern day phpBB forum device?

[Garrett Fitzgerald]

On Wed, Jun 29, 2011 at 12:14, MB Software Solutions, LLC 
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:

 I want to put up a forum on a folder in my website.  Currently, the page
 is http://mbsoftwaresolutions.com/makeitsymple.  Can I put a forum in
 that folder and keep the rest of my site as-is?  And I'm sure phpBB is
 outdated/out-of-fashion now.  What's the latest/greatest for creating a
 simple forum for me to share products with customers (most products will
 be free) and solicit customer feedback?


I use a couple of forums that run on vBulletin. Customizable as all get-out,
and the support seems reasonably good. I have admin rights on one of them,
but don't usually participate in the upgrade/support/customize matters, just
day-to-day ops.


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

Re: [NF] New batteries for old computers

[Garrett Fitzgerald]

On Fri, Jun 17, 2011 at 19:14, Michael Madigan mmadi10...@yahoo.com wrote:

 I have an old Inspiron 1100 notebook that we use for web surfing and
 scanning and stuff.  The original battery that came with it was terrible and
 lasted about a year.

 Are the new replacement batteries better than the ones that came with the
 computer, or is battery life (how many years) a function of the computer?


I'm afraid to replace the battery because the charger is wonky, too -- I
turned off the power-on message that said oops, wrong power supply long
ago. I don't want to replace the battery and find out that I can't charge it
anyway


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

Re: Field type

[Garrett Fitzgerald]

On Wed, Jun 15, 2011 at 01:59, Sytze de Boer sytze.k...@gmail.com wrote:
 Old age or what

 I need to know if the field in a table is logical or character
 Something like
 If fieldtype(16)=L
   blah
 endif

AFIELDS(laFList)
IF laFList(16, 2) = L
   blah
ENDIF

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

Re: [NF] Anyone See This?

[Garrett Fitzgerald]

On Sun, Apr 10, 2011 at 15:53, Jeff Johnson j...@san-dc.com wrote:
 If it's true, I'm in.  I'll put Ubuntu on it.  Raise your hands if you
 didn't start with at Commodore 64.

I can't remember if the Trash-80 came first, or the teletype terminals
at the local college. The first computer I owned, though, was a Vic-20
-- we never got to upgrade to the C64. :-(

___
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/BANLkTi=hr9jj5j-xoprmd7fpjhnfb1f...@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.

[OT] Grammar (was Re: VFP9 Help has died)

[Garrett Fitzgerald]

On Tue, Mar 29, 2011 at 18:25, Mike Copeland mlcopel...@gmail.com wrote:
 ...literally.

What, you had someone standing next to you feeding you information,
and they just croaked?

When did literally and figuratively become synonyms, anyway?

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

Re: OFF OFF Topic -- But important

[Garrett Fitzgerald]

The way I read it was host it myself (Exchange), or host it elsewhere
(Google Apps for My Domain)?

On Thu, Mar 24, 2011 at 14:51, Mike Copeland mlcopel...@gmail.com wrote:
 In this case, they're using it (cloud) to reference email service.

 In my way of thinking, that's like referring to my truck's turn signals
 as transportation. Or my left arm as my reality.

 All email is related to the cloud (Internet) but the cloud is not email.

 I guess in an odd salesperson's way of thinking (trying to minimalize
 concepts to the least common denominator for your
 vicitims...er...customers) referring to email that is received, stored,
 and accessed via an Internet connection as Cloud makes some sense. The
 article reference that Anthony sent confirms that that is what Apple is
 doing.

 Mike

 On 3/24/11 11:22 AM, Mike Copeland wrote:
 Interesting.

 So cloud=email service. I guess because the email service is totally
 contained on the Internet? Odd use of terminology.
 The Internet is The Cloud. Why is it odd?

___
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/AANLkTi=-Dp3o=PkKurR-pZPjOsT=lqqt5k49qxbqw...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Urban SQL injection

[Garrett Fitzgerald]

LMFAO. Almost wish we had those around here now...

2011/2/17 Ricardo Aráoz ricar...@gmail.com:
 LOL

 http://seanbonner.tumblr.com/post/3200064101/jacobjoaquin-r03-urban-sql-injection

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

Re: VFP and Source control

[Garrett Fitzgerald]

On Fri, Feb 4, 2011 at 11:24, Lou Syracuse l...@iconmediadirect.com wrote:
 Is anyone using source control with VFP?
 snip
 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'm using Subversion and TortoiseSVN, but _not_ with Apache. I'm also
using Christof's TwoFox (http://www.foxpert.com/docs/cvs.en.htm) to
convert the binary source files to XML. Axosoft has a package at
http://www.axosoft.com/rocketsvn that looks interesting, especially
has it has Visual Studio integration.

___
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/AANLkTik=4dmk9-n3f+e7xd2p22-ofwpvht8ccexnw...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: VFP and Source control

[Garrett Fitzgerald]

On Fri, Feb 4, 2011 at 12:34, Grigore Dolghin gdolg...@gmail.com wrote:
 There's one catch though: SVN is case sensitive and VFP has the nasty habit
 to capitalize the extensions now and then. We used a projecthook program
 which would iterate through all files and lowercased the extensions upon
 project close. I'm going to look for that prg if you want to go this route.

TortoiseSVN, as a Windows program, is smart enough to work around this
issue, generally. :-)

___
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/AANLkTimrDnqYw7BYhS+68RLqXX2S=nbejmkz5zzym...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: VFP and Source control

[Garrett Fitzgerald]

Taking this slightly [NF], is anyone using source control with SSRS?
I'm using it with Crystal, but that unfortunately isn't much better
than WinZipping the successive versions. If I understand correctly,
SSRS stores the reports in an XML-based format, so it should work
better with version control, right?

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

Re: Slow database performance on Windows 7

[Garrett Fitzgerald]

On Sat, Jan 8, 2011 at 03:09, Alan Bourke alanpbou...@fastmail.fm wrote:
 If the server is Windows 2008 you will want to turn off SMB2 on it.

Why's that? I have a client who's reporting slower performance on
their newer Win7 machines than their older WinXP machines, but I don't
want to just tweak random settings without knowing how come. :-)

___
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/aanlkti=f6hb2_vdl7cg_5itlje-yys3oc7345cy_+...@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.

Network weirdness with COPY TO XL5

[Garrett Fitzgerald]

I just tracked down something that's been bothering me for a while.
My Documents is mapped to a network share here, so that everything
is backed up routinely. Copying to CSV, XLS, DBF, etc. fly as you'd
expect. However, XL5 copies crawl -- 100 records a second or so. I'd
never been sure what was causing this, but a dim memory from PSS days
just stirred, and I tried copying the XL5 file I was working with to
the C drive instead of the network. It flew.

Any thoughts on why XL5 does poorly with the network redirector when
XLS doesn't?

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

Re: Network weirdness with COPY TO XL5

[Garrett Fitzgerald]

On Wed, Dec 29, 2010 at 09:59, Tracy Pearson tr...@powerchurch.com wrote:
 Any thoughts on why XL5 does poorly with the network redirector when
 XLS doesn't?

 Have a look at Process Monitor and filter on the file you are creating on
 the network to see what programs might be accessing it. See if the export
 opens and closes the file frequently. Run Process Monitor on both the
 server and the workstation for a complete picture.

Bingo. XLS is writing 131K chunks once it gets going -- XL5 is writing
a 30-byte field at a time. 4000 times the overhead, no wonder it
couldn't finish in a reasonable time Thanks for the reminder. I've
used ProcMon before, but not recently.

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

Re: [NF] Nice TShirt for this Croud

[Garrett Fitzgerald]

Or http://shirt.woot.com/shirts/coexist, for everyone who looks at
this after the 29th. :-)

On Mon, Nov 29, 2010 at 07:15, Jeff Johnson j...@san-dc.com wrote:
 http://shirt.woot.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/aanlktikne4jxpobfvnfgh=gkn2tut1gf25-rpfa9y...@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.

VFP9 - themes problem?

[Garrett Fitzgerald]

I have a form that works fine under VFP7. When I run it under VFP9,
moving the mouse over buttons tends to result in the entire form
getting blanked. Other forms in the same app don't have this behavior.
I'm familiar with the READ interactions that cause a similar problem,
but as far as I can tell, that doesn't apply here. Is there anything
else I can do to fix the problem? Thanks.

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

Re: Obama's Indian trip not so costly

[Garrett Fitzgerald]

On Fri, Nov 19, 2010 at 08:51, Pete Theisen petethei...@verizon.net wrote:
 Nicholas Geti wrote:
 The news that Obama's trip to the Far East would cost $2B was false. But 
 even $5.2M per day is still expensive considering he came home empty handed.

 http://www.nytimes.com/2010/11/17/opinion/17friedman.html?nl=todaysheadlinesemc=a212

 Hi Nicholas,

 I heard that it would have been $2B, but they contracted all the techie
 stuff in VFP so it was a little less.

Rarely have I seen such a smooth OT save. :-)

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

Re: Tracking office assets

[Garrett Fitzgerald]

Does http://www.spiceworks.com/ look like it might be helpful? It's free,
ad-supported. We use parts of it here at PCHC. I don't think we use the
Asset Management portions, but if they work as well as the rest of it
does...

On Fri, Jul 30, 2010 at 10:41, MB Software Solutions General Account 
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:

 Well, part of my new responsibilities is to track the office assets
 (computers, printers, tech-related stuff).

 Looking for recommendations on what works well (and cost).



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

Re: Screen display

[Garrett Fitzgerald]

Personally, I use Consolas -- ships with recent MS products, is
designed for programming, and looks a lot prettier than FoxFont. :-)

On Wed, Jun 23, 2010 at 07:35, Rafael Copquin rcopq...@ciudad.com.ar wrote:
 In your startup program for VFP put the following code:

 _screen.fontname ='FoxFont'

 That is a non proportional font.

___
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/aanlktimznfz4erbknv32k7gk6tv8ujzmzktgqdcgz...@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.

OLDVAL() return type

[Garrett Fitzgerald]

I'm checking to see if a UPC field was changed to a duplicate record.
I thought that the easiest way to do this would be to check the
OLDVAL() of the field in the Valid method of the textbox, and if it
changed, use INDEXSEEK to see if the new value was already in the
table. However, OLDVAL() is returning the numeric equivalent of the
character field, which is not exactly ideal. Is this a VFP
bug/misfeature, or do I just need to go downstairs and load up on
coffee?

Thanks.

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

Re: OLDVAL() return type

[Garrett Fitzgerald]

Don't think I need more coffee -- just to finish what I already have. :-)

OLDVAL('table.upc') returns the numeric value: OLDVAL('upc', 'table')
returns the character value.

On Sat, May 29, 2010 at 14:03, Garrett Fitzgerald
sarekofvul...@gmail.com wrote:
 I'm checking to see if a UPC field was changed to a duplicate record.
 I thought that the easiest way to do this would be to check the
 OLDVAL() of the field in the Valid method of the textbox, and if it
 changed, use INDEXSEEK to see if the new value was already in the
 table. However, OLDVAL() is returning the numeric equivalent of the
 character field, which is not exactly ideal. Is this a VFP
 bug/misfeature, or do I just need to go downstairs and load up on
 coffee?

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

Re: [NF] I am looking (again) for web hosting for about 10gb

[Garrett Fitzgerald]

On Tue, May 18, 2010 at 12:43,  kamcgin...@gmail.com wrote:
 Does anyone have any suggestions, best features, price, etc.

 Also, I would like a way to update the web site from local folders using ftp 
 within a batch file. I have a good ftp
 client, but it only has a gui interface.

I've been happy with DreamHost for a while. It's Linux-based, with
shell interface available and all sorts of open-source software set up
for simple installs. I'm paying $120/year for a normal account (the
Happy Hosting plan), but they also have private servers (unique ip,
process isolation, etc.) for another $15/month or so.

Let me know off-list if you'd like a referral code. :-)

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

Re: [NF] Seeking computer purchasing advice

[Garrett Fitzgerald]

I'm strongly considering a MacBook for my next machine. It'll allow me
to run Windows if I have to for VFP purposes, will allow me to dabble
with iP.* applications, and have a power cord that doesn't break if I
look at it crooked.

___
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/h2mcf9c5e351004230734xfb935428w9f1ad11d962ae...@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.

Printing from VFP IDE

[Garrett Fitzgerald]

I can't remember if I ever knew if there was a way to get the
form/method/window name to print when you're trying to print out a
bunch of methods to chase down an annoyance that's somewhere in the
form, but you don't know exactly where. I know I can use the Class
Browser and View Class Code, but that's not quite what I had in mind.
I just want a neat little header to print at the top...

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

Re: [NF] web site's browser compatibility

[Garrett Fitzgerald]

We still use it here at PCHC, because GE's Centricity Practice Manager
2004 launches from a web page, and the scripting isn't compatible with
later versions of IE.

On Tue, Apr 6, 2010 at 04:05, Alan Bourke alanpbou...@fastmail.fm wrote:
 I'd say forget about IE6. No reason anyone should still be using it,
 unless they have a particularly dumb corporate or institutional IT
 department, or a load of applications that require it.

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

Re: Comments are there too many or should syntax explain it all?

[Garrett Fitzgerald]

2010/4/8 Ricardo Aráoz ricar...@gmail.com:
 I've seen that practice. Don't like it. Much prefer a good version
 control system and a good diff tool.
 Comments with initials and date will only clutter your program and
 you'll never really know what was done and what was the state of the
 code before.

I do both. Searching for my initials in a 15-year-old code base that
I've been working on for less than a year makes it a lot easier to
find my last change than asking Subversion what it was. :-)

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

Re: VFP9 Reporting Sample - Zoomed preview

[Garrett Fitzgerald]

On Sun, Jan 31, 2010 at 12:37, MB Software Solutions, LLC
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
 mmkangod wrote:
 why to have that much coding, just to get report to be ZOOMed by default ?

 Agreed.  Why, Garrett??  Perhaps I missed something.

As I mentioned in the initial email, I wanted to use the VFP9 preview,
instead of the old-style one.

___
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/cf9c5e351001311209v6222982bq130c4a5f80c94...@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.

VFP9 Reporting Sample - Zoomed preview

[Garrett Fitzgerald]

As I believe I mentioned in an earlier thread, I wanted to have a VFP9
report preview that was zoomed by default. For a while, I used the
code from Cathy Pountney's Report Writer in Action article, but I
just discovered that makes the ReportListener's OnPreviewClose()
method fail to report that the report had been printed, as the
container didn't close when the print button was hit. After surfing
the docs a bit, I realized that an Extension Handler, as documented in
Leveraging the Default Preview Container, would do the trick.
LPARAMETERS tcReport

DO (_REPORTPREVIEW) WITH loPC
loPC.Caption = tcCaption
loPC.ZoomLevel = 5   100% (default)
loPC.ToolbarIsVisible = .T.

loXH = NEWOBJECT(RLExtHandler)
loPC.SetExtensionHandler(loXH)

loRL = NEWOBJECT(ReportListener)
loRL.PreviewContainer = loPC

REPORT FORM tcReport. ;
TO PRINTER PROMPT ;
OBJECT loRL

DEFINE CLASS RLExtHandler AS Custom
PROCEDURE Show(iStyle)
WITH This.PreviewForm
.WindowState = 2
.Toolbar.Dock(0)
ENDWITH
ENDPROC
ENDDEFINE

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

Re: VFP9 Reporting Sample - Zoomed preview

[Garrett Fitzgerald]

On Sat, Jan 30, 2010 at 16:21, Sytze de Boer sytze.k...@gmail.com wrote:
 Though I use XFRX in preference, I thought I would have a quick look at your
 code
 Why does my test fail on the 2nd line with loPC

Because I removed the LOCAL loPC declaration at the top, forgetting
that LOCAL actually creates the variable. Sorry about that -- I
trimmed it down from running code, forgetting to actually test it
first

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

Re: 10 years ago I was...

[Garrett Fitzgerald]

...not getting called at MS Developer Support, despite volunteering to
work on Y2K. (Ok, 10 years and 4 days, whatever :-) )

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

Re: [NF] December 23, 2009, Software development's winners and losers, 2009 edition

[Garrett Fitzgerald]

On Wed, Dec 30, 2009 at 12:49, Leland F. Jackson, CPA
sm...@mail.smvfp.com wrote:
 Interesting article:

 http://www.infoworld.com/d/developer-world/software-developments-winners-and-losers-2009-edition-207?page=0,0source=IFWNLE_nlt_openenterprise_2009-12-30

Loser: SQL? Not bloody likely...

___
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/cf9c5e351001041306v17ea8a28ja77d5c161ad9b...@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.