Re: [NF] Is it really this quiet, or is the eMail service having problems?

2008-09-17 Thread Garrett Fitzgerald
On Wed, Sep 17, 2008 at 13:51, Gil Hale <[EMAIL PROTECTED]> wrote: > I have not seen any ProFox eMail come across for a while. Just wondering if > it is something to do with my end of the connection, me getting booted for > abusing ProFox , or if everyone else is getting nothing also.. So, > rath

Re: Calling program

2008-09-18 Thread Garrett Fitzgerald
On Thu, Sep 18, 2008 at 11:27, Al <[EMAIL PROTECTED]> wrote: > Hi foxgang. > Is there a way to find the calling program / method in another method ? > > I have a method that seems to be called too much and I want to bebugout the > calling method to see why Are you looking for the PROGRAM() functio

Re: VFP9 - ADIR

2008-10-09 Thread Garrett Fitzgerald
On Thu, Oct 9, 2008 at 01:37, Sytze de Boer <[EMAIL PROTECTED]> wrote: > In help, it says > gnfile = ADIR(gafiles, '*.DBC') > > In my case, this represents > gnfile = ADIR(gafiles, '*.JPG') > > Assume, the variable reads K:\FILELOC\*.JPG > I can't find a way for this to work Does JUSTFNAME("K:\FIL

[NF] PL/SQL Optimization

2008-10-10 Thread Garrett Fitzgerald
I just wrote a query against our EMR database to give me the first and last of a series of observations. I came up with the following, which appears to work, but I was wondering if anyone had any thoughts on how to do it more efficiently. I don't like those correlated subqueries just to get a max a

Re: [NF] PL/SQL Optimization

2008-10-10 Thread Garrett Fitzgerald
On Fri, Oct 10, 2008 at 13:56, MB Software Solutions General Account <[EMAIL PROTECTED]> wrote: > What is the optimization plan showing? (...Using EXPLAIN or whatever > the equivalent is in PL/SQL. It's been a long time for me...late > 2004/early 2005 for that. Liked it better than T-SQL though!

Re: [NF] PL/SQL Optimization

2008-10-10 Thread Garrett Fitzgerald
On Fri, Oct 10, 2008 at 13:35, Ted Roche <[EMAIL PROTECTED]> wrote: > While the code is a bit difficult to read How would you format that query? I'm always interested in making my code more readable, since it might be me that has to read it later. :-)

Weird report I'm trying to match

2008-10-20 Thread Garrett Fitzgerald
I'm trying to write a report to get the Uniform Data System information out of our EMR. On page 26 of ftp://ftp.hrsa.gov/bphc/pdf/uds/2008UDSManualSept08final2.pdf, there's a report with several sections, all of which are formatted differently. Now, I know I could do this (probably) with Print Whe

Re: Weird report I'm trying to match

2008-10-21 Thread Garrett Fitzgerald
On Mon, Oct 20, 2008 at 17:18, Tracy Pearson <[EMAIL PROTECTED]> wrote: >> I'm trying to write a report to get the Uniform Data System information out >> of our EMR. On page 26 of >> ftp://ftp.hrsa.gov/bphc/pdf/uds/2008UDSManualSept08final2.pdf, there's a >> report with several sections, all of whi

Re: Weird report I'm trying to match

2008-10-23 Thread Garrett Fitzgerald
On Tue, Oct 21, 2008 at 15:38, Cathy Pountney <[EMAIL PROTECTED]> wrote: >> It would be a cursor I generated, so the big detail band would be the >> way to go. Thanks for reminding me that I don't have to put them on >> top of each other, but can Print When... and Suppress Blank Line. > > But ... i

Re: VFP9 report behaviour

2008-10-31 Thread Garrett Fitzgerald
On Fri, Oct 31, 2008 at 14:39, Cathy Pountney <[EMAIL PROTECTED]> wrote: > Not much .. but I pretend to know a lot! Hey, I resemble that remark! ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox

Re: [OT]Stock market not impressed with Obama

2008-11-05 Thread Garrett Fitzgerald
News flash, Nick: Bush is president for the next two months. On Wed, Nov 5, 2008 at 16:48, Nicholas Geti <[EMAIL PROTECTED]> wrote: > The Dow fell 500 points today. Guess investors don't think too much of Obama > doing anything about helping Wall Street.

RE: [OT]Stock market not impressed with Obama

2008-11-06 Thread Garrett Fitzgerald
> > > News flash, Nick: Bush is president for the next two months. > > > > The analysis I saw said that the Dow fell because the > > indicators for retail > > holiday sales were lower than expected. > > Yeah, it had nothing to do with a candidate being elected who wants to rob > from the productiv

RE: [OT]Stock market not impressed with Obama

2008-11-06 Thread Garrett Fitzgerald
> Well, how stupid are you? Anyone who watches the stock market at all knows > that it anticipates the future economic picture by six months. Analysts are > already speculating about the Obama effects and making their trades. It is > obvious you know nothing about how our economy works. Right. Tha

Re: [OT]Stock market not impressed with Obama

2008-11-06 Thread Garrett Fitzgerald
> This guy is sitting in his Star Trek Pajamas masturbating to Captain Kirk and > Sulu, not educating himself on the stock markets and taxes. It's an old nickname. These days, it's Captain Jack and Ianto Jones, not Denny Crane and Kaito Nakamura _

Re: McCain and Obama

2008-11-08 Thread Garrett Fitzgerald
On Sat, Nov 8, 2008 at 23:31, Cecil Champenois <[EMAIL PROTECTED]> wrote: > It may be "drivel" to you, but there is enough evidence here to justify an > investigation, but it will never happen. It's drivel. Barack Hussein Obama was born in Hawaii, to an American mother. End of story. __

Re: [OT] McCain and Obama

2008-11-10 Thread Garrett Fitzgerald
On Sun, Nov 9, 2008 at 01:27, Michael Madigan <[EMAIL PROTECTED]> wrote: > Sure, that's why he won't produce a birth certificate, and he Grandmother and > two siblings >say he was born in Kenya. Let's depose them under oath in a courtroom. Um, he _did_ produce a birth certificate. http://www.pol

Re: [OT] McCain and Obama

2008-11-10 Thread Garrett Fitzgerald
> > The Hawaii Department of Health's birth > > record request form DOES NOT GIVE THE OPTION to request a photocopy of > > your long-form birth certificate, but their short form has enough > > information to be acceptable to the State Department. We tried to ask > > the Hawaii DOH why they only off

Re: [OT] McCain and Obama

2008-11-11 Thread Garrett Fitzgerald
> Hi Garrett! > > He is the President- elect. He can order the production of the original. No. He is the President-elect. He is not the dictator-elect. After 8 years of the Decider, I can understand your confusion, except that there never should have been that confusion in the first place. _

[NF] Parameterized Excel query - how to do it?

2008-11-17 Thread Garrett Fitzgerald
I have a Pivot Table worksheet in Excel 2007 that's running off a SQL command. The dates in this statement are hardcoded at the moment: I'd like to link them into a couple of cells in the sheet, but Excel is being more unhelpful than usual. There's a greyed-out Parameters button at the bottom of t

Re: Naming convention for custom Methods?

2008-11-17 Thread Garrett Fitzgerald
On Sun, Nov 16, 2008 at 23:11, Matt Slay <[EMAIL PROTECTED]> wrote: > I follow the common practice of using type prefixes when naming custom > Properties in classes and forms like this: > > lAddMode > cName > > Now then, is it also common to use those same prefixes when naming custom > Methods that

Re: VFP9 - Movers.VCX

2008-12-04 Thread Garrett Fitzgerald
On Thu, Dec 4, 2008 at 09:01, Paul Newton <[EMAIL PROTECTED]> wrote: > I'm finding the _Mover class in Movers.VCX a bit flaky - has anybody else had > any problems with it ? Yes. It allows multiple columns going in, but when you move an item, it redimensions the array to be 1-dimensional. Is this

Re: Nominees for the 2011 FoxPro Lifetime Achievement Award

2011-08-17 Thread Garrett Fitzgerald
On Wed, Aug 17, 2011 at 13:55, Ed Leafe 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. :-) ___ P

Re: Nominees for the 2011 FoxPro Lifetime Achievement Award

2011-08-17 Thread Garrett Fitzgerald
On Wed, Aug 17, 2011 at 14:19, Ed Leafe 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

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

2011-08-22 Thread Garrett Fitzgerald
On Mon, Aug 22, 2011 at 12:16, 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

[NF] Pinning a .VBS to the Win7 Taskbar

2011-09-03 Thread 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 w

Re: [NF] Firefox 7

2011-09-28 Thread Garrett Fitzgerald
On Wed, Sep 28, 2011 at 12:40, Alan Bourke wrote: > On Wednesday, September 28, 2011 3:22 PM, "Dave Crozier" > 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 cre

Re: Ah memories ...

2011-09-30 Thread Garrett Fitzgerald
On Fri, Sep 30, 2011 at 09:45, Ed Leafe 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. :-) _

Re: [NF] Default Directory for Pictures in WIN7

2011-10-03 Thread Garrett Fitzgerald
On Mon, Oct 3, 2011 at 16:44, Charles Hart Enzer, M.D., FAACP 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 helpf

Re: [NF] Default Directory for Pictures in WIN7

2011-10-03 Thread Garrett Fitzgerald
On Mon, Oct 3, 2011 at 19:52, PabloSr 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: Pr

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

2011-10-13 Thread Garrett Fitzgerald
On Thu, Oct 13, 2011 at 11:42, 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

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

2011-10-19 Thread Garrett Fitzgerald
On Wed, Oct 19, 2011 at 16:32, Paul McNett 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: ProFo

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

2011-12-08 Thread Garrett Fitzgerald
On Thu, Dec 8, 2011 at 14:09, Vincent Teachout 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 tryin

Re: date handling in sql server 2005 express

2011-12-15 Thread Garrett Fitzgerald
On Thu, Dec 15, 2011 at 16:34, Rafael Copquin wrote: > 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

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

2011-12-26 Thread Garrett Fitzgerald
On Fri, Dec 23, 2011 at 04:15, Alan Bourke 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:

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

2012-01-04 Thread Garrett Fitzgerald
On Wed, Jan 4, 2012 at 14:14, Stephen Russell wrote: > > > 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

Keyboard navigation

2012-01-21 Thread 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

Re: [NF] travel advise

2008-06-06 Thread Garrett Fitzgerald
On Fri, Jun 6, 2008 at 8:52 AM, Gil Hale <[EMAIL PROTECTED]> wrote: > Nothing can help insure disruption within our ranks more completely > than having a language breakdown. Well played, sir. :-) Of course, I'm completely disinterested in the result of this discussion...

[OT] Kucinich on C-SPAN right now...

2008-06-09 Thread Garrett Fitzgerald
...introducing 35 articles of impeachment against George W. Bush. http://c-span.org/Watch/C-SPAN_wm.aspx Talk amongst yourselves. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version

Re: SQL Passthru and long commands

2008-06-10 Thread Garrett Fitzgerald
On Thu, Jun 5, 2008 at 12:30, Ricardo Araoz <[EMAIL PROTECTED]> wrote: >>> I mentioned earlier this year that I was using tricks when building >>> statements to send through SQL passthru. I just ran across the >>> following one, and figured I'd share FWIW. > > Maybe I'm not getting the point. You a

Re: SQL Passthru and long commands

2008-06-10 Thread Garrett Fitzgerald
On Tue, Jun 10, 2008 at 15:30, MB Software Solutions General Account <[EMAIL PROTECTED]> wrote: > Big thanks to the VFP team for putting in the TEXTEND intellisense macro!!! Lately, my favorite macro is the WINX one I created. LPARAMETER oFoxCode LOCAL loShellEx as _shellExecute OF HOME(1) + "ffc

Re: [NF] Don't die any younger than you have to....

2008-06-13 Thread Garrett Fitzgerald
On Thu, Jun 12, 2008 at 16:19, Paul McNett <[EMAIL PROTECTED]> wrote: > My eye doctor told me I need to break every 40 minutes, and go outside > and gaze at faraway things for 5 minutes. Sounded impractical. I use http://www.workrave.org/ to remind me to take breaks. Sometimes I ignore it, but it'

Re: [OT] How Neoconservatives Conqu ered Washington – and Launched a War

2008-06-15 Thread Garrett Fitzgerald
On Sun, Jun 15, 2008 at 22:22, Leland F. Jackson, CPA <[EMAIL PROTECTED]> wrote: > I hope going into the 2008 general election we do not forget how the USA > got into the mess she is in today. I also hope the American people take > a very close look at John McCain to ensure he is not a Neoconserva

Re: Simple app questions

2008-07-15 Thread Garrett Fitzgerald
On Tue, Jul 15, 2008 at 13:17, Joe Yoder <[EMAIL PROTECTED]> wrote: > How do I prevent the VFP environment from coming up when the executable is > run? The app is just a single screen. Include a config.fpw file compiled into the project with the line SCREEN=OFF and set your form's ShowWindow p

Re: VFP9- SQL with UNION

2008-07-23 Thread Garrett Fitzgerald
I thought of that, but they aren't dup records: he's adding the SRCE column so the data in each query is different. On Wed, Jul 23, 2008 at 03:21, Dave Crozier <[EMAIL PROTECTED]> wrote: > Use "Union all" not union. The union on its own removes duplicate records. > > -Original Message- > F

Correlated subquery problems

2008-07-29 Thread Garrett Fitzgerald
I'm trying to write a query here that asks what women between 18 and 64 seen in a date range have had a pap smear within 3 years before their visit. I tried the following, but Fox told me to go fornicate myself. Anybody have any thoughts on the way it should actually look? Thanks. SELECT pid, obsD

Re: Correlated subquery problems

2008-07-29 Thread Garrett Fitzgerald
On Tue, Jul 29, 2008 at 13:28, Ted Roche <[EMAIL PROTECTED]> wrote: > SELECT pid, MAX(obsDate) ; >FROM allObs o1 allObs o2 ; >WHERE o1.sex = "F" ; >AND o1.pid = o2.pid and o1.obsDate > o2.obsDate >AND o1.dateOfBirt BETWEEN GOMONTH(o1.obsDate, -65 *

Re: VFP Tip o' the day

2008-07-30 Thread Garrett Fitzgerald
On Wed, Jul 30, 2008 at 09:11, Richard Kaye <[EMAIL PROTECTED]> wrote: > I needed to review a bunch of prgs in a folder. I didn't want to have to > modi comm each in the command window but I also didn't want to be > bothered dragging and dropping from Explorer. So I added this little bit > of code

Re: VFP Tip o' the day

2008-07-30 Thread Garrett Fitzgerald
On Wed, Jul 30, 2008 at 09:36, Vince Teachout <[EMAIL PROTECTED]> wrote: >> In this week's episode of "There's More Than One Way to Skin a Fox", >> we have a one-liner. :-) >> >> MODIFY COMMAND *.PRG >> > PWNED! :-) Oh, not really -- there are things you can do with an ADIR loop that you can't do

Re: Variable only holding 16777184 bytes of 76million byte memo field

2008-08-05 Thread Garrett Fitzgerald
On Mon, Aug 4, 2008 at 22:50, MB Software Solutions General Account <[EMAIL PROTECTED]> wrote: > We've got a scenario where a 3rd party has polluted our memo fields, and > I'd like to write a cleanup that takes the value of the memo field and > does a STRTRAN to get rid of garbage. Straight forwar

Re: [NF] How do I block the ad sites?

2008-08-08 Thread Garrett Fitzgerald
On Fri, Aug 8, 2008 at 11:28, MB Software Solutions General Account <[EMAIL PROTECTED]> wrote: > Allen wrote: >> I thought ie had a switch to stop navigation across domains. Don't know if >> that works > > > I use FireFox. ...with the NoScript add-on. Very useful tool. __

Re: [NF] Domino's pizza tracker application

2008-08-28 Thread Garrett Fitzgerald
On Wed, Aug 27, 2008 at 18:37, Whil Hentzen <[EMAIL PROTECTED]> wrote: > My wife would be revolted and I'd be eating Hamburger Helper for the > rest of my life. I'm still mad at Betty Crocker for killing off HH Rice Oriental. :-( I was so thrilled to find that I could still get it when I lived in

Re: vfp cannot not start. Could not load resources

2008-09-10 Thread Garrett Fitzgerald
That sounds vaguely familiar -- anything bogus in the system PATH variable? On Wed, Sep 10, 2008 at 22:41, Lew <[EMAIL PROTECTED]> wrote: > I'm attempting to deploy a small app by copying all the rt dll's & my exe > into the same directory. Yet I get > this error which seems to indicate that the

Re: [NF] web site's browser compatibility

2010-04-08 Thread 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 wrote: > I'd say forget about IE6. No reason anyone should still be using it, > unless they

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

2010-04-08 Thread Garrett Fitzgerald
2010/4/8 Ricardo Aráoz : > 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.

Printing from VFP IDE

2010-04-17 Thread 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 th

Re: [NF] Seeking computer purchasing advice

2010-04-23 Thread 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: P

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

2010-05-18 Thread Garrett Fitzgerald
On Tue, May 18, 2010 at 12:43, 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 DreamHos

OLDVAL() return type

2010-05-29 Thread 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 ret

Re: OLDVAL() return type

2010-05-29 Thread 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 wrote: > I'm checking to se

Re: Silly VFP9 Issue....

2019-02-07 Thread 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

[NF] Conditions in JOIN clause instead of WHERE

2019-04-02 Thread 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

Re: Funny bug

2019-06-07 Thread 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 Program

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

2020-01-24 Thread 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 p

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

2020-02-05 Thread 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&job=business-intelligence-and-data-warehouse-team-lead&collection=true --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (

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

2020-07-23 Thread 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

Re: Retire the CSV?

2021-08-23 Thread 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 -- proce

[NF] SQL ALL, but not quite

2023-06-22 Thread 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 --- __

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

2023-06-22 Thread 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 --- mu

Re: [NF] SQL ALL, but not quite

2023-06-22 Thread Garrett Fitzgerald
ld4.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 Ga

Re: [NF] SQL ALL, but not quite

2023-06-22 Thread Garrett Fitzgerald
nt, > 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&d way I ended up implementing it - with 7 child > > tables. :) I just co

[NF] Unusal WHERE clause

2023-08-02 Thread 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',

Re: [NF] Unusal WHERE clause

2023-08-02 Thread 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 > slig

Re: Fuzzy Name Searching

2017-04-12 Thread 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 di

Re: Fuzzy Name Searching

2017-04-12 Thread Garrett Fitzgerald
Algorithm > > 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 > wrote: > > I wrote a FLL to do Levenshtein

[NF] Online databases

2017-05-02 Thread 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

[NF] PeopleSoft learning resources

2017-08-24 Thread 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) te

Re: [NF] Bluetooth option in laptops

2017-11-20 Thread 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 phon

Bounces

2018-07-09 Thread 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 Subscri

Re: between clause in TSQL (from VFP9)

2018-08-08 Thread 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 > >

Re: MCP ID

2018-08-24 Thread 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 des

Re: MCP ID

2018-08-24 Thread 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.micr

Re: Scanners and how to use them

2012-02-18 Thread Garrett Fitzgerald
On Sat, Feb 18, 2012 at 15:37, Mike Copeland 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

Re: Microsoft SQL Server 2012 licensing

2012-03-23 Thread Garrett Fitzgerald
On Fri, Mar 23, 2012 at 05:13, Alan Bourke 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

Importing from VFP into SQL2012

2012-05-04 Thread 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

Re: [NF] Recommend forum software?

2012-06-02 Thread Garrett Fitzgerald
On Sat, Jun 2, 2012 at 10:19 AM, Malcolm Greene 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 pl

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

2012-06-14 Thread Garrett Fitzgerald
On Thu, Jun 14, 2012 at 9:55 AM, Gérard Lochon wrote: > - Original Message - > From: "Alan Bourke" > >> 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

Re: Check for Running VFP .EXE

2012-06-19 Thread Garrett Fitzgerald
On Mon, Jun 18, 2012 at 4:55 PM, Jeff Johnson 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

Re: REPORT FORM...FOR problems

2012-08-25 Thread Garrett Fitzgerald
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 >

Re: [NF] Ergonomic Keyboard Recommendation

2012-08-30 Thread Garrett Fitzgerald
On Thu, Aug 30, 2012 at 2:31 PM, Paul McNett 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 li

ZGDI.DLL was not found

2009-08-31 Thread Garrett Fitzgerald
I just tried to open a report that opened just fine last week, only to get a message stating that ZGDI.DLL was not found, and the landscape report opened as portrait instead. After Googling a bit, I concluded that this was an HP driver problem, and downloaded and installed the latest printer drive

Local parameterized view issue

2009-11-28 Thread Garrett Fitzgerald
I'm converting an old client's system to use VFP9, and repairing some long-term infelicities that have been bugging them. I've just run across a bit of weirdness that is completely baffling me, though. I have one view that is currently bound to the form's PO_ID property. The old version (VFP7, I th

Re: Local parameterized view issue

2009-11-28 Thread Garrett Fitzgerald
On Sat, Nov 28, 2009 at 19:12, John C. Gunvaldson wrote: > Does the view use a Group By that is no longer supported? There were changes > in SQL Engine between old and new? It's an updateable view, so there's no Group By involved. I will double-check the ENGINEBEHAVIOR setting, though __

Re: Local parameterized view issue

2009-12-01 Thread Garrett Fitzgerald
Just checking back to see if I get any more answers by posting this on a weekday. :-) On Sat, Nov 28, 2009 at 18:27, Garrett Fitzgerald wrote: > I'm converting an old client's system to use VFP9, and repairing some > long-term infelicities that have been bugging them. I'v

Re: Local parameterized view issue

2009-12-01 Thread Garrett Fitzgerald
On Tue, Dec 1, 2009 at 10:07, Frank Cazabon wrote: > Is it possible that SET ANSI is different between when your app is > running and when you do it in the command window? It's quite possible, but the length of the variable is the same as the length of the field, so that shouldn't come into play.

Re: Local parameterized view issue

2009-12-02 Thread Garrett Fitzgerald
On Wed, Dec 2, 2009 at 08:03, MB Software Solutions, LLC wrote: > So USEing the view works fine, but REQUERYing the view returns no > records, eh?  Hmmm.can you post the view definition generated by > GENDBC here? If I USE the view outside the form, it works fine, REQUERY and all. If I launch

Re: Local parameterized view issue

2009-12-02 Thread Garrett Fitzgerald
On Wed, Dec 2, 2009 at 11:21, MB Software Solutions, LLC wrote: > At the risk of sounding annoying, why don't you just NOT use the DE in > this case? I'm trying for minimum disruption first. If that fails, I'll try doing it in code, which is the way I would design it now if I were starting from s

Re: Local parameterized view issue

2009-12-02 Thread Garrett Fitzgerald
On Wed, Dec 2, 2009 at 14:14, Rick Schummer wrote: > Garrett, > >>> The old version of the app works fine, so it's presumably a change > between VFP7 (I think) and VFP9.<< > > Is the view based on a different view(s) (not a table)? VFP 9 no longer > requeries the underlying view of the view. You h

Re: [NF] Business Objects

2009-12-04 Thread Garrett Fitzgerald
On Fri, Dec 4, 2009 at 09:36, Stephen Russell wrote: > BO = Crystal Reports or one of another set of reporting tools. > > You could put the query in Excel data | External Data | Import > External Databse Query. While BO/SAP owns CR, BO is a separate reporting tool. She might get better results if

Re: Local parameterized view issue

2009-12-05 Thread Garrett Fitzgerald
On Wed, Dec 2, 2009 at 14:19, Garrett Fitzgerald wrote: > On Wed, Dec 2, 2009 at 14:14, Rick Schummer > wrote: >>> The old version of the app works fine, so it's presumably a change >>> between VFP7 (I think) and VFP9. >> >> Is the view based on a differe

VFP9 printing - maximize windows automatically

2009-12-19 Thread Garrett Fitzgerald
I've read the examples for how to pass a maximized preview container to the reportlistener to produce a fullscreen, appropriately-zoomed report. However, I can't remember if there's any way to do this for a legacy application, that has lots of print preview statements I'd just as soon not completel

  1   2   3   4   >