Re: ODBC Problem

2014-06-10 Thread Richard Quilhot
Is the test on the first row truncated? I've seen vfp set column width based on first record's data. Rick Q quilh...@gmail.com On Tue, Jun 10, 2014 at 6:10 PM, Chris Davis wrote: > Hi Dave > > It is FileMaker v11. I have setup a 32bit DSN. I can do the query from > both Excel and VFP using

Re: VFP9 SP2 Runtimes

2014-06-10 Thread Jeff Johnson
Richard: I got it. I got it at the same time I was thanking everyone for the link. Appreciate it! On 6/10/2014 3:06 PM, Richard Kaye wrote: I tried to email you something off list but our evil doer's detection system decided the zip file was filled with evil and apparently blocked it. IAC y

Re: Interesting GOTCHA from 16-byte binary key

2014-06-10 Thread mbsoftwaresolutions
Found that the leading \0 was the cause/reason-to-blame for the cbo's misbehavior. Retooled the CreateKey method by adding this before the return: IF LEFT(lcKey,1) = '\' THEN && try again..don't like those as it caused issue with cboJobType lcKey = this.CreateKey(tiLevel) ENDIF On 2014-0

RE: ODBC Problem

2014-06-10 Thread Chris Davis
Hi Dave It is FileMaker v11. I have setup a 32bit DSN. I can do the query from both Excel and VFP using SPT. Excel displays the results fine, VFP truncates the text. Thanks Chris. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier Se

RE: VFP9 SP2 Runtimes

2014-06-10 Thread Richard Kaye
I tried to email you something off list but our evil doer's detection system decided the zip file was filled with evil and apparently blocked it. IAC you got what you needed. (Time to go harass my IT guys...) -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com

Re: VFP9 SP2 Runtimes

2014-06-10 Thread Jeff Johnson
Thanks Guys! That is what I was looking for! On 6/10/2014 2:45 PM, Fred Taylor wrote: Looks like Christof may have what you need: http://www.foxpert.com/runtime.htm Fred On Tue, Jun 10, 2014 at 2:27 PM, Jeff Johnson wrote: I can't locate vfp9sp2rt.exe. I found one but it does not insta

Re: VFP9 SP2 Runtimes

2014-06-10 Thread mbsoftwaresolutions
Fox.wikis.com should have something too. wOOdy used to have them (probably still does) too. On 2014-06-10 17:45, Fred Taylor wrote: Looks like Christof may have what you need: http://www.foxpert.com/runtime.htm Fred On Tue, Jun 10, 2014 at 2:27 PM, Jeff Johnson wrote: I can't locate vf

Re: VFP9 SP2 Runtimes

2014-06-10 Thread Jeff Johnson
Thanks Richard. I have all that and I can put together an installer. I had a customer have the vc++ dll disappear into thin air and I needed it quickly. I have sp1 so I used that. Thanks, On 6/10/2014 2:42 PM, Richard Kaye wrote: Not sure where that EXE name comes from. I can email you th

Re: VFP9 SP2 Runtimes

2014-06-10 Thread Fred Taylor
Looks like Christof may have what you need: http://www.foxpert.com/runtime.htm Fred On Tue, Jun 10, 2014 at 2:27 PM, Jeff Johnson wrote: > I can't locate vfp9sp2rt.exe. I found one but it does not install. It > bombs out. Where can I find a good version of this? > > TIA > > -- > Jeff > > J

RE: VFP9 SP2 Runtimes

2014-06-10 Thread Richard Kaye
Not sure where that EXE name comes from. I can email you the SP2 dlls, Jeff, but it's not an "installer". -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff Johnson Sent: Tuesday, June 10, 2014 5:27 PM To: profoxt...@leafe.com Subject: VFP9

VFP9 SP2 Runtimes

2014-06-10 Thread Jeff Johnson
I can't locate vfp9sp2rt.exe. I found one but it does not install. It bombs out. Where can I find a good version of this? TIA -- Jeff Jeff Johnson j...@san-dc.com SanDC, Inc. 623-582-0323 Fax 623-869-0675 http://www.san-dc.com ___ Post Messag

Re: Interesting GOTCHA from 16-byte binary key

2014-06-10 Thread mbsoftwaresolutions
On 2014-06-10 16:15, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: I had a record where the primary key was '\0|±ßpM•wÑ©9†‚' (without the beginning/ending quotes) and the cbo to which it was tied didn't like it. I'm not sure if it was the leading \0 or the , near the end. Thoughts? I'm

Interesting GOTCHA from 16-byte binary key

2014-06-10 Thread mbsoftwaresolutions
I had a record where the primary key was '\0|±ßpM•wÑ©9†‚' (without the beginning/ending quotes) and the cbo to which it was tied didn't like it. I'm not sure if it was the leading \0 or the , near the end. Thoughts? I'm gonna have to retool my key generation routine to reseed it if detect

Re: [NF] don't want to see events in my Google Calendar

2014-06-10 Thread M Jarvis
Virgil- your message got truncated on my end and I can't seem to be able to dig it up in the leafe.com archive. think you could resend it to me, this time directly? mj On Tue, Jun 10, 2014 at 9:29 AM, Virgil Bierschwale wrote: > on the left hand on google calendars, you will see "My calendars"

RE: [NF]HTML Editor

2014-06-10 Thread Dan Covill
Agreed. It has a very nice test run facility that works with multiple browsers. Dan > Date: Tue, 10 Jun 2014 12:14:59 +0200 > Subject: Re: [NF]HTML Editor > From: garry.bet...@gmail.com > To: profoxt...@leafe.com > > Hi Jeff, > > In the past I found Html-Kit pretty good: http://www.htmlkit.com/

Re: [NF] don't want to see events in my Google Calendar

2014-06-10 Thread Virgil Bierschwale
on the left hand on google calendars, you will see "My calendars" Next to your name is a "Down Arrow" Click on it, and choose On Tue, Jun 10, 2014 at 11:27 AM, M Jarvis wrote: > I may be going about this all wrong, but I just can't seem to find the > setting that changes this to display or no

[NF] don't want to see events in my Google Calendar

2014-06-10 Thread M Jarvis
I may be going about this all wrong, but I just can't seem to find the setting that changes this to display or not I put daily reminders in my google calendar, things like gather eggs, do your shoulder exercises, have another beer, etc they repeat every day and kind of clog up my calendar

Re: Single SQL Select or three

2014-06-10 Thread Joe Yoder
Thanks Peter and Tracy, My goal has always been to be able to adjust the length of the summary period easily. My initial period was an hour as that can be unambiguously labeled on a report with two characters. When I drop it to five minutes the jagged details are much more prominent. My live (no

Re: [NF]HTML Editor

2014-06-10 Thread Garry Bettle
Hi Jeff, In the past I found Html-Kit pretty good: http://www.htmlkit.com/ Cheers, Garry --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com S

RE: ODBC Problem

2014-06-10 Thread Dave Crozier
Which version of Filemaker? I have a small system here on V11 with VFP9 SP1 and ODBC works no problem in both reading and writing data. I just inherited it from a Filemaker V8 program and have just updated it as required. Don't forget that by default if you are using 64bit Windows then the 64

Re: SQL select Group by datetime field value puzzle

2014-06-10 Thread Gérard Lochon
Now that I have the grouping issue solved I need to combine multiple selects into one cursor. I'll start another thread unless I find the answer right away. Joe 1) As mentioned above, this select retuns an error unless expressed with SET ENGINEBEHAVIOUR 70. Is it a good way to implement som

ODBC Problem

2014-06-10 Thread Chris Davis
Has anyone encountered any issues using ODBC with a third party product. Query's via Excel work fine, via VFP they don't work full stop using the the View designers and give random results using SQL Pass Through. Thanks Chris. The ODBC Driver in question is for Filemaker. ___