date:20181107

Re: SPT and Remote Views

2018-11-07 Thread Stephen Russell

You could add a column for the length of varchar(max) content and sort on
that descending.  Then you will know if the width of Fox cursor is actually
getting all of the data.

On Wed, Nov 7, 2018 at 2:25 PM Kevin J Cully  wrote:

> I was looking for an old blog post but I couldn't find it.  At times there
> may be a problem with the ODBC connection and using CAST(), especially with
> VARCHAR(max).  If you ever experience problem using CAST() and accessing a
> field of type VARCHAR(max), take a look at CONVERT().  This will work with
> VFP ( and Xojo! ) to access these fields where CAST() fails.
>
> -Original Message-
> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Paul H. Tarver
> Sent: Wednesday, November 07, 2018 3:14 PM
> To: profox@leafe.com
> Subject: RE: SPT and Remote Views
>
> +1
>
> Paul H. Tarver
> Tarver Program Consultants, Inc.
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> Charlie-gm
> Sent: Tuesday, November 06, 2018 2:46 PM
> To: profoxt...@leafe.com
> Subject: Re: SPT and Remote Views
>
>
> Just a quick FYI.
>
> If using SQL Pass-through, don't forget you have the "CAST()" syntax
> available (you can convert dates to strings, set a size of the character
> length, etc). I've used it frequently to ensure a "proper" (expected) VFP
> data type output result.
>
> -Charlie
>
> On 11/6/2018 12:08 PM, Chris Davis wrote:
> > Not really, I can issue the query once and I get C(10) and again and I
> > get
> M(10) with the whole value in it.
> >
> > It seems to be an issue with the Filemaker ODBC driver, they suggested
> > VFP
> does ODBC v1? And their driver only supports ODBC v2?
> >
> > Whatever the issue is, Remote Views seem to get around it.  I would
> > just
> like to be able to get around it using SPT.
> >
> > -Original Message-
> > From: ProfoxTech  On Behalf Of Ted Roche
> > Sent: Tuesday, 06 November 2018 16:53
> > To: profoxt...@leafe.com
> > Subject: Re: SPT and Remote Views
> >
> > Remote views, as you've indicated, let you specify the target
> > structure of
> the query.
> >
> > When you execute direct SPT Fox attempts to get the first record
> > matching
> the query, and uses the structure of that result as the (fixed column)
> structure of the result set. So, if you have a varying-length string
> > (varchar) and the first result is 3 characters, VFP might create a
> > C(3)
> field, which could truncate everything else. Does that describe what you
> are seeing?
> >
> >
> >
> > On Tue, Nov 6, 2018 at 10:54 AM Chris Davis 
> wrote:
> >
> >> Hi All
> >>
> >> What extra happens when using Remove Views over SPT?
> >>
> >> Using the same ODBC conneciton to a Filemaker database if I do
> >> "select
> >> * from " I get mixed results for the text strings.
> >>
> >> If I perform the same query via a remote view I get the same mixed
> result.
> >>
> >> But if I go one step further with the Remote View and specifc
> >> properties of the fields it manages to pull complete information out
> >> of
> filemaker.
> >>
> >> So what extra is Remote View managing to ask of the Filemaker ODBC
> >> driver to make it behave?
> >>
> >> Any ideas?
> >>
> >> Regards
> >>
> >> Chris.
> >>
> >>
> >>
> >> --- 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/CAJidMYJkyLdkCeWo2sRxeyKb38ycnmTut7U=7md+vM=+p1+...@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: SPT and Remote Views

2018-11-07 Thread Paul H. Tarver

Haven't run into a problem with CAST(), but I'll add CONVERT() to my notes
for further review. 

Thanks!

Paul H. Tarver
Tarver Program Consultants, Inc.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kevin J
Cully
Sent: Wednesday, November 07, 2018 2:24 PM
To: profoxt...@leafe.com
Subject: RE: SPT and Remote Views

I was looking for an old blog post but I couldn't find it.  At times there
may be a problem with the ODBC connection and using CAST(), especially with
VARCHAR(max).  If you ever experience problem using CAST() and accessing a
field of type VARCHAR(max), take a look at CONVERT().  This will work with
VFP ( and Xojo! ) to access these fields where CAST() fails.

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Paul H. Tarver
Sent: Wednesday, November 07, 2018 3:14 PM
To: profox@leafe.com
Subject: RE: SPT and Remote Views

+1

Paul H. Tarver
Tarver Program Consultants, Inc.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
Charlie-gm
Sent: Tuesday, November 06, 2018 2:46 PM
To: profoxt...@leafe.com
Subject: Re: SPT and Remote Views

Just a quick FYI.

If using SQL Pass-through, don't forget you have the "CAST()" syntax
available (you can convert dates to strings, set a size of the character
length, etc). I've used it frequently to ensure a "proper" (expected) VFP
data type output result.

-Charlie

On 11/6/2018 12:08 PM, Chris Davis wrote:
> Not really, I can issue the query once and I get C(10) and again and I 
> get
M(10) with the whole value in it.
>
> It seems to be an issue with the Filemaker ODBC driver, they suggested 
> VFP
does ODBC v1? And their driver only supports ODBC v2?
>
> Whatever the issue is, Remote Views seem to get around it.  I would 
> just
like to be able to get around it using SPT.
>
> -Original Message-
> From: ProfoxTech  On Behalf Of Ted Roche
> Sent: Tuesday, 06 November 2018 16:53
> To: profoxt...@leafe.com
> Subject: Re: SPT and Remote Views
>
> Remote views, as you've indicated, let you specify the target 
> structure of
the query.
>
> When you execute direct SPT Fox attempts to get the first record 
> matching
the query, and uses the structure of that result as the (fixed column)
structure of the result set. So, if you have a varying-length string
> (varchar) and the first result is 3 characters, VFP might create a 
> C(3)
field, which could truncate everything else. Does that describe what you are
seeing?
>
>
>
> On Tue, Nov 6, 2018 at 10:54 AM Chris Davis 
wrote:
>
>> Hi All
>>
>> What extra happens when using Remove Views over SPT?
>>
>> Using the same ODBC conneciton to a Filemaker database if I do 
>> "select
>> * from " I get mixed results for the text strings.
>>
>> If I perform the same query via a remote view I get the same mixed
result.
>>
>> But if I go one step further with the Remote View and specifc 
>> properties of the fields it manages to pull complete information out 
>> of
filemaker.
>>
>> So what extra is Remote View managing to ask of the Filemaker ODBC 
>> driver to make it behave?
>>
>> Any ideas?
>>
>> Regards
>>
>> Chris.
>>
>>
>>
>> --- 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/00aa01d476d9$35532810$9ff97830$@tpcqpc.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: SPT and Remote Views

2018-11-07 Thread Paul H. Tarver

+1

Paul H. Tarver
Tarver Program Consultants, Inc.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
Charlie-gm
Sent: Tuesday, November 06, 2018 2:46 PM
To: profoxt...@leafe.com
Subject: Re: SPT and Remote Views


Just a quick FYI.

If using SQL Pass-through, don't forget you have the "CAST()" syntax 
available (you can convert dates to strings, set a size of the character 
length, etc). I've used it frequently to ensure a "proper" (expected) 
VFP data type output result.

-Charlie

On 11/6/2018 12:08 PM, Chris Davis wrote:
> Not really, I can issue the query once and I get C(10) and again and I get
M(10) with the whole value in it.
>
> It seems to be an issue with the Filemaker ODBC driver, they suggested VFP
does ODBC v1? And their driver only supports ODBC v2?
>
> Whatever the issue is, Remote Views seem to get around it.  I would just
like to be able to get around it using SPT.
>
> -Original Message-
> From: ProfoxTech  On Behalf Of Ted Roche
> Sent: Tuesday, 06 November 2018 16:53
> To: profoxt...@leafe.com
> Subject: Re: SPT and Remote Views
>
> Remote views, as you've indicated, let you specify the target structure of
the query.
>
> When you execute direct SPT Fox attempts to get the first record matching
the query, and uses the structure of that result as the (fixed column)
structure of the result set. So, if you have a varying-length string
> (varchar) and the first result is 3 characters, VFP might create a C(3)
field, which could truncate everything else. Does that describe what you are
seeing?
>
>
>
> On Tue, Nov 6, 2018 at 10:54 AM Chris Davis 
wrote:
>
>> Hi All
>>
>> What extra happens when using Remove Views over SPT?
>>
>> Using the same ODBC conneciton to a Filemaker database if I do "select
>> * from " I get mixed results for the text strings.
>>
>> If I perform the same query via a remote view I get the same mixed
result.
>>
>> But if I go one step further with the Remote View and specifc
>> properties of the fields it manages to pull complete information out of
filemaker.
>>
>> So what extra is Remote View managing to ask of the Filemaker ODBC
>> driver to make it behave?
>>
>> Any ideas?
>>
>> Regards
>>
>> Chris.
>>
>>
>>
>> --- 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/009d01d476d6$5d910110$18b30330$@tpcqpc.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: SPT and Remote Views

2018-11-07 Thread Kevin J Cully

I was looking for an old blog post but I couldn't find it.  At times there may 
be a problem with the ODBC connection and using CAST(), especially with 
VARCHAR(max).  If you ever experience problem using CAST() and accessing a 
field of type VARCHAR(max), take a look at CONVERT().  This will work with VFP 
( and Xojo! ) to access these fields where CAST() fails.

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Paul H. Tarver
Sent: Wednesday, November 07, 2018 3:14 PM
To: profox@leafe.com
Subject: RE: SPT and Remote Views

+1

Paul H. Tarver
Tarver Program Consultants, Inc.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Charlie-gm
Sent: Tuesday, November 06, 2018 2:46 PM
To: profoxt...@leafe.com
Subject: Re: SPT and Remote Views

Just a quick FYI.

If using SQL Pass-through, don't forget you have the "CAST()" syntax available 
(you can convert dates to strings, set a size of the character length, etc). 
I've used it frequently to ensure a "proper" (expected) VFP data type output 
result.

-Charlie

On 11/6/2018 12:08 PM, Chris Davis wrote:
> Not really, I can issue the query once and I get C(10) and again and I 
> get
M(10) with the whole value in it.
>
> It seems to be an issue with the Filemaker ODBC driver, they suggested 
> VFP
does ODBC v1? And their driver only supports ODBC v2?
>
> Whatever the issue is, Remote Views seem to get around it.  I would 
> just
like to be able to get around it using SPT.
>
> -Original Message-
> From: ProfoxTech  On Behalf Of Ted Roche
> Sent: Tuesday, 06 November 2018 16:53
> To: profoxt...@leafe.com
> Subject: Re: SPT and Remote Views
>
> Remote views, as you've indicated, let you specify the target 
> structure of
the query.
>
> When you execute direct SPT Fox attempts to get the first record 
> matching
the query, and uses the structure of that result as the (fixed column) 
structure of the result set. So, if you have a varying-length string
> (varchar) and the first result is 3 characters, VFP might create a 
> C(3)
field, which could truncate everything else. Does that describe what you are 
seeing?
>
>
>
> On Tue, Nov 6, 2018 at 10:54 AM Chris Davis 
wrote:
>
>> Hi All
>>
>> What extra happens when using Remove Views over SPT?
>>
>> Using the same ODBC conneciton to a Filemaker database if I do 
>> "select
>> * from " I get mixed results for the text strings.
>>
>> If I perform the same query via a remote view I get the same mixed
result.
>>
>> But if I go one step further with the Remote View and specifc 
>> properties of the fields it manages to pull complete information out 
>> of
filemaker.
>>
>> So what extra is Remote View managing to ask of the Filemaker ODBC 
>> driver to make it behave?
>>
>> Any ideas?
>>
>> Regards
>>
>> Chris.
>>
>>
>>
>> --- 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/sn6pr0901mb2526a483670d499f1b50aa1fc5...@sn6pr0901mb2526.namprd09.prod.outlook.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: IBM to buy RedHat

2018-11-07 Thread Ted Roche

On Wed, Nov 7, 2018 at 2:14 PM Gene Wirchenko  wrote:

>   OTOH, there is that line about insanity.
>

Oh, you mean: https://twitter.com/tedroche/status/701896005332168705

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

--- 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/cacw6n4uy2whzvpaqxuoxwzmocgjbhouotzku7kmtcawkh62...@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: GetFile() issue

2018-11-07 Thread Ted Roche

On Wed, Nov 7, 2018 at 2:13 PM Gene Wirchenko  wrote:

>
>   That URL was wrong in your post as it included the closing
> paren.  Oddly, Eudora excluded it in this reply.
>

Mayhaps your email reader parsed it wrong, as I sent plain text and it
works fine on my end.

> >SETs often have global effects which make their local use frustrating.
>
>   I have not found it so, but one must be careful.
>

Well, OP had a classic case, where the SET is saved, changed, and reset in
a very small snippet of code, but if other code runs in the meantime
(timers, in that case, or menu code or LostFocus events) that depend on the
global setting, confusion results.

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

--- 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/CACW6n4sAKsN3nVowksxP-Xk3zY6scN2=QvBkEmecyr=6mz7...@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: IBM to buy RedHat

2018-11-07 Thread Gene Wirchenko


At 08:49 2018-11-07, Ted Roche  wrote:

On Thu, Nov 1, 2018 at 11:18 AM Ed Leafe  wrote:

> Hey, I guess it could happen. ;-)

Past history is no guarantee of future performance.


 OTOH, there is that line about insanity.

Sincerely,

Gene Wirchenko


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

2018-11-07 Thread Gene Wirchenko

At 07:08 2018-11-07, Ted Roche  wrote:

On Wed, Nov 7, 2018 at 5:57 AM Dave Crozier  wrote:

> Unknown to me after all these years, the set default to command has an
> effect on the whole of the VFP thread not just the DataSession you are in.

To quote my co-author, "Computer language purists object to SET commands
for a pretty straightforward reason: the formation of the infinite-state
machine. Although that sounds cool,..." (
https://www.tedroche.com/hackfox7/s4g126.html)

 That URL was wrong in your post as it included the closing 
paren.  Oddly, Eudora excluded it in this reply.

SETs often have global effects which make their local use frustrating.

 I have not found it so, but one must be careful.

 If I change a global setting SET (as opposed, say, to a SET 
ORDER), I either set the setting back as soon as I can or I have a 
procedure for doing the modified function requiring the different SET 
value.  One must be careful about this stuff.

Three things:

1. If you were rewriting the app, you'd store a "Data Directory" in your
global settings table and precede all your file open commands with that.
That makes it INCREDIBLY easy to have a test mode that just switches that
setting. But you're not re-writing your app, so...

 I did that for a few programs where I needed to get to a 
different set of data.  I am glad that it was only a few.

[snip]

Sincerely,

Gene Wirchenko

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

Re: CAN You Hear the Silence???

2018-11-07 Thread Kurt @ Gmail

Thanks for the follow-up Ted. I did notice that you use GMail, although 
I didn't notice till after I wrote the below reply.


Thanks again for the reply - and I'm glad to finally be back here again!

-K-


On 11/7/2018 10:14 AM, Ted Roche wrote:

I've been GMail only for a couple of years now and it seems to work fine.
Some people's emails don't come through (like Yahoo!) because they don't
follow the proper rules, but mostly, it works okay.


On Wed, Nov 7, 2018 at 1:02 PM Kurt @ Gmail  wrote:


Hey there Ted,

Turns out - it wasn't my email reader. It seems that Optonline.net was
being Black listed, which I found out - since I reached out directly to
Ed about the problem. However, I got busy with looking for work and
failed to followup and switch to another email address of mine. Well -
this has now been rectified - as I'm now using my GMail account.
Hopefully it now works (as I think I remember people reporting problems
in the past with GMail access to ProFox. Will See...

-K-


On 6/26/2018 11:24 AM, Ted Roche wrote:

ProTip: visit the Leafe forum archives to see if there are email
messages you're not getting in your defective email reader.



On Tue, Jun 26, 2018 at 1:55 PM, Kurt at VR-FX 

wrote:

Wow - was surprised not to receive ANY Forum postings since 6/16! Has it
really been that silent - or have I been unsubscribed for some reason?
Hmmm...


-K-



[excessive quoting removed by server]

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

Big Changes & Fox Work in SF Bay Area?

2018-11-07 Thread Kurt @ Gmail


Hey there folks,

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


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


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


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


TIA!
-K-

___
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/0b25c384-7c96-3d25-bba7-c7d3b8917...@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: CAN You Hear the Silence???

2018-11-07 Thread Ted Roche

I've been GMail only for a couple of years now and it seems to work fine.
Some people's emails don't come through (like Yahoo!) because they don't
follow the proper rules, but mostly, it works okay.

On Wed, Nov 7, 2018 at 1:02 PM Kurt @ Gmail  wrote:

> Hey there Ted,
>
> Turns out - it wasn't my email reader. It seems that Optonline.net was
> being Black listed, which I found out - since I reached out directly to
> Ed about the problem. However, I got busy with looking for work and
> failed to followup and switch to another email address of mine. Well -
> this has now been rectified - as I'm now using my GMail account.
> Hopefully it now works (as I think I remember people reporting problems
> in the past with GMail access to ProFox. Will See...
>
> -K-
>
>
> On 6/26/2018 11:24 AM, Ted Roche wrote:
> > ProTip: visit the Leafe forum archives to see if there are email
> > messages you're not getting in your defective email reader.
> >
> >
> >
> > On Tue, Jun 26, 2018 at 1:55 PM, Kurt at VR-FX 
> wrote:
> >> Wow - was surprised not to receive ANY Forum postings since 6/16! Has it
> >> really been that silent - or have I been unsubscribed for some reason?
> >> Hmmm...
> >>
> >>
> >> -K-
> >>
> >>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cacw6n4vv+cms8a1qwa_vllq10xy7aso4fgvv103xa6pxkzk...@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: CAN You Hear the Silence???

2018-11-07 Thread Kurt @ Gmail


Hey there Ted,

Turns out - it wasn't my email reader. It seems that Optonline.net was 
being Black listed, which I found out - since I reached out directly to 
Ed about the problem. However, I got busy with looking for work and 
failed to followup and switch to another email address of mine. Well - 
this has now been rectified - as I'm now using my GMail account. 
Hopefully it now works (as I think I remember people reporting problems 
in the past with GMail access to ProFox. Will See...


-K-


On 6/26/2018 11:24 AM, Ted Roche wrote:

ProTip: visit the Leafe forum archives to see if there are email
messages you're not getting in your defective email reader.



On Tue, Jun 26, 2018 at 1:55 PM, Kurt at VR-FX  wrote:

Wow - was surprised not to receive ANY Forum postings since 6/16! Has it
really been that silent - or have I been unsubscribed for some reason?
Hmmm...


-K-



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/b055ac66-0b4f-0950-0ec7-5e799f40c...@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: IBM to buy RedHat

2018-11-07 Thread Ted Roche

On Thu, Nov 1, 2018 at 11:18 AM Ed Leafe  wrote:

>
> Hey, I guess it could happen. ;-)
>
>
Past history is no guarantee of future performance.

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

--- 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/cacw6n4uf99cnp2m2cctjo3vfwgf3fek-3on2okywoo584tp...@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: IBM to buy RedHat

2018-11-07 Thread Jerry Wolper

> He’s basically updating the “Apple buys NeXT” story from the mid-90s.
Apple was
> much bigger and better known, but was having some financial woes after
some
> management mis-steps. Within a couple of years, nearly every Apple exec
was
> gone, replaced by people from NeXT. The Mac OS was replaced by NeXTSTEP,
> which was re-christened as OS X.

Wasn't one of those people at NeXT Steve Jobs? It's much easier to
transform the culture when you were instrumental in originally establishing
it.

> Hey, I guess it could happen. ;-)

It could, but it seems unlikely that a culture as entrenched as the one at
IBM will suddenly flip, for better or worse. I would imagine that mainframe
salespeople will still be in their blue suits when pushing big iron to
other corporate behemoths.

-Jerry


--- 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/caksnnohplmveq5lykk7k_p_+kfoqkdhsp4vgcsuast16smn...@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: GetFile() issue

2018-11-07 Thread Ted Roche

On Wed, Nov 7, 2018 at 5:57 AM Dave Crozier  wrote:

> Unknown to me after all these years, the set default to command has an
> effect on the whole of the VFP thread not just the DataSession you are in.

To quote my co-author, "Computer language purists object to SET commands
for a pretty straightforward reason: the formation of the infinite-state
machine. Although that sounds cool,..." (
https://www.tedroche.com/hackfox7/s4g126.html)

SETs often have global effects which make their local use frustrating.

Three things:

1. If you were rewriting the app, you'd store a "Data Directory" in your
global settings table and precede all your file open commands with that.
That makes it INCREDIBLY easy to have a test mode that just switches that
setting. But you're not re-writing your app, so...

2. Adding another GLOBAL to solve this issue is putting out fire with fire,
but if you had your data directory in your SET PATH, would that solve
the problem?

3. I think you can replace the GetFile() command locally with one from the
Common Dialog set, which gives you finer control. I believe Doug Hennig
wrote a white paper on this one. (
http://doughennig.com/Papers/Pub/ModernUI.pdf)

--- 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/CACW6n4ty+M1k+pAT90g6QToL+zWAkyrnPG43d=o-03y97q2...@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: GetFile() issue

2018-11-07 Thread Frank Cazabon

Does the _commonfolder class in _system.vcx help you out?

I use it like this:

LOCAL loCommonFolder AS _commonfolder OF _system.vcx

m.loCommonFolder = CREATEOBJECT("_commonfolder")
#DEFINE CSIDL_PERSONAL 0x0005 && My Documents
#DEFINE CSIDL_APPDATA 0x001a && name>\Application Data

m.lcFolder = ADDBS(m.loCommonFolder.getfolder(CSIDL_PERSONAL))

Frank.

Frank Cazabon

On 07/11/2018 06:56 AM, Dave Crozier wrote:

Hi folks,
Just had an issue that has been bugging me for a while and I now why but I
haven’t got a solution to hand… so maybe you can help.

In lots of places we allow users to export their reports and spreadsheet
results onto their own personal “C” drives. And to do this I implement

… default folder set in prior coding

cOld_Folder = SYS(5) + SYS(2003)
set default to
cFile = Getfile(……..)
set default to (cOld_Folder)

This code allows the user to be programmatically placed in the suggested folder
to save/open files.

Unknown to me after all these years, the set default to command has an effect
on the whole of the VFP thread not just the DataSession you are in.
Unfortunately for me I have a number of regular timers running that check
whether any particular file or process is locked, or the system is available
for use i.e. it can sometimes auto log out the user to allow system
maintenance for example. The timers open tables and expect to be in the base
folder of the application but issuing the above coding changes the base folder
for ALL the application, hence throwing errors as the tables (all held relative
to the application folder) cannot be found in the new location.

So, if you action the Getfile() command and stay in the dialogue for a period
of time during which the timers fire, then the timer coding cannot open it’s
tables as you are no longer where it expects you to be.

Looking at the help file ( OK, I should have looked at it years ago!!) it
states:
“The SET DEFAULT command is not supported in either single or multithreaded DLL
servers. This command changes the default directory of the entire process, so
all threads which are part of the process are affected. Use the
mk:@MSITStore:c:\program%20files%20(x86)\microsoft%20visual%20foxpro%209\dv_foxhelp.chm::/html/047f2e74-3552-43b7-a18d-ee2c7dd2db6e.htm
in DLL servers, in place of CD and CHDIR.”
The pertinent fact being: This command changes the default directory of the
entire process, so all threads which are part of the process are affected. The
same thing goes for CD and Chdir so using those as replacements is not an
option unfortunately.

Has anyone any ideas as to how to produce a dialogue for saving/opening a file
which doesn’t require the “set default to ” instruction?

I can modify all the timers to open tables based upon absolute paths but this
would be a mega change which I am trying to avoid. Of course I could roll my
own Getfile() unless anyone has one available!!!

All suggestions accepted, thanks in anticipation.

Dave Crozier
Software Development Manager
Flexipol Packaging Ltd.

﴾⚆ᨎ⚆﴿

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

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

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

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

Terms & Conditions:
Notwithstanding delivery and the passing of risk in the goods, the property in the
goods shall not pass to the buyer until the seller Flexipol Packaging Ltd. ("The
Company") has received in cash or cleared funds payment in full of the price of the
goods and all other goods agreed to be sold by the seller to the buyer for which payment
is then due. Until such time as the property

Re: GetFile() issue

2018-11-07 Thread Alan Bourke

maybe check out the GetSaveFileName() function in the Vfp2c32 library (Github) 

"Creates a Save dialog box that lets the user specify the drive, directory, and 
name of a file to save.

GetSaveFileName([nFlags [, cFileFilters [, cFileName [, cInitialDirectory [, 
cDialogTitle [, nFlagsEx [, cCallbackFunc]]])"


Or maybe this which I got from the ApiViewer project on GitHub, which is a nice 
database of the old news2news site:

oShell = CREATEOBJECT("Shell.Application")
oFolder = oShell.Application.BrowseForFolder(_screen.HWnd,;
 "Select Folder", 1, "c:\Program Files")

That would open the dialog with the 'c:\program files' folder selected.




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

On Wed, 7 Nov 2018, at 10:56 AM, Dave Crozier wrote:
> Hi folks,
> Just had an issue that has been bugging me for a while and I now why but 
> I haven’t got a solution to hand… so maybe you can help.
> 
> In lots of places we allow users to export their reports and spreadsheet 
> results onto their own personal “C” drives. And to do this I implement 
> 
> … default folder set in prior coding
> 
> cOld_Folder = SYS(5) + SYS(2003)
> set default to 
> cFile = Getfile(……..)
> set default to (cOld_Folder)
> 
> This code allows the user to be programmatically placed in the suggested 
> folder to save/open files.
> 
> Unknown to me after all these years, the set default to command has an 
> effect on the whole of the VFP thread not just the DataSession you are 
> in. Unfortunately for me I have a number of regular timers running that 
> check whether any particular file or process is locked, or the system is 
> available for use i.e. it can sometimes auto log out the user  to allow 
> system maintenance for example. The timers open tables and expect to be 
> in the base folder of the application but issuing the above coding 
> changes the base folder for ALL the application, hence throwing errors 
> as the tables (all held relative to the application folder) cannot be 
> found in the new location.
> 
> So, if you action the Getfile() command and stay in the dialogue for a 
> period of time during which the timers fire, then the timer coding 
> cannot open it’s tables as you are no longer where it expects you to be.
> 
> Looking at the help file ( OK, I should have looked at it years ago!!) 
> it states:
> “The SET DEFAULT command is not supported in either single or 
> multithreaded DLL servers. This command changes the default directory of 
> the entire process, so all threads which are part of the process are 
> affected. Use the mk:@MSITStore:c:\program%20files%20(x86)\microsoft
> %20visual%20foxpro
> %209\dv_foxhelp.chm::/html/047f2e74-3552-43b7-a18d-ee2c7dd2db6e.htm in 
> DLL servers, in place of CD and CHDIR.”
> The pertinent fact being: This command changes the default directory of 
> the entire process, so all threads which are part of the process are 
> affected. The same thing goes for CD and Chdir so using those as 
> replacements is not an option unfortunately.
> 
> Has anyone any ideas as to how to produce a dialogue for saving/opening 
> a file which doesn’t require the “set default to ” instruction?
> 
> I can modify all the timers to open tables based upon absolute paths but 
> this would be a mega change which I am trying to avoid. Of course I 
> could roll my own Getfile() unless anyone has one available!!!
> 
> All suggestions accepted, thanks in anticipation.
> 
> Dave Crozier
> Software Development Manager
> Flexipol Packaging Ltd.
> 
> ﴾⚆ᨎ⚆﴿
> 
> 
> 
> Flexipol® Packaging Ltd
> T 01706 222 792
> E dcroz...@flexipol.co.uk
> W https://www.flexipol.co.uk/
> Follow us: 
> Unit 14 Bentwood Road, Carrs Industrial Estate, Haslingden, Lancashire, BB4 
> 5HH
> 
> This communication and the information it contains is intended for the 
> person or organisation to whom it is addressed. Its contents are 
> confidential and may be protected in law. If you have received this e-
> mail in error you must not copy, distribute or take any action in 
> reliance on it. Unauthorised use, copying or disclosure of any of it may 
> be unlawful. If you have received this message in error, please notify 
> us immediately by telephone or email.
>   
> Flexipol Packaging Ltd. has taken every reasonable precaution to 
> minimise the risk of virus transmission through email and therefore any 
> files sent via e-mail will have been checked for known viruses. However, 
> you are advised to run your own virus check before opening any 
> attachments received as Flexipol Packaging Ltd will not in any event 
> accept any liability whatsoever once an e-mail and/or any attachment is 
> received.
>   
>  It is the responsibility of the recipient to ensure that they have 
> adequate virus protection.
> 
>

Re: GetFile() issue

2018-11-07 Thread Thierry Nivelet

use locfile() instead?

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

VisitFoxInCloud Blog
WatchFoxInCloud Marketing Videos

WatchFoxInCloud Technical Videos

Stay tuned onFoxInCloud Roadmap
Learnhow to use FoxInCloud
DownloadFoxInCloud Adaptation Assistant
for free

Le 07/11/2018 à 11:56, Dave Crozier a écrit :

Hi folks,
Just had an issue that has been bugging me for a while and I now why but I
haven’t got a solution to hand… so maybe you can help.

In lots of places we allow users to export their reports and spreadsheet
results onto their own personal “C” drives. And to do this I implement

… default folder set in prior coding

cOld_Folder = SYS(5) + SYS(2003)
set default to
cFile = Getfile(……..)
set default to (cOld_Folder)

This code allows the user to be programmatically placed in the suggested folder
to save/open files.

Has anyone any ideas as to how to produce a dialogue for saving/opening a file
which doesn’t require the “set default to ” instruction?

All suggestions accepted, thanks in anticipation.

Dave Crozier
Software Development Manager
Flexipol Packaging Ltd.

﴾⚆ᨎ⚆﴿

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

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

GetFile() issue

2018-11-07 Thread Dave Crozier

Hi folks,
Just had an issue that has been bugging me for a while and I now why but I 
haven’t got a solution to hand… so maybe you can help.

In lots of places we allow users to export their reports and spreadsheet 
results onto their own personal “C” drives. And to do this I implement 

… default folder set in prior coding

cOld_Folder = SYS(5) + SYS(2003)
set default to 
cFile = Getfile(……..)
set default to (cOld_Folder)

This code allows the user to be programmatically placed in the suggested folder 
to save/open files.

Unknown to me after all these years, the set default to command has an effect 
on the whole of the VFP thread not just the DataSession you are in. 
Unfortunately for me I have a number of regular timers running that check 
whether any particular file or process is locked, or the system is available 
for use i.e. it can sometimes auto log out the user  to allow system 
maintenance for example. The timers open tables and expect to be in the base 
folder of the application but issuing the above coding changes the base folder 
for ALL the application, hence throwing errors as the tables (all held relative 
to the application folder) cannot be found in the new location.

So, if you action the Getfile() command and stay in the dialogue for a period 
of time during which the timers fire, then the timer coding cannot open it’s 
tables as you are no longer where it expects you to be.

Looking at the help file ( OK, I should have looked at it years ago!!) it 
states:
“The SET DEFAULT command is not supported in either single or multithreaded DLL 
servers. This command changes the default directory of the entire process, so 
all threads which are part of the process are affected. Use the 
mk:@MSITStore:c:\program%20files%20(x86)\microsoft%20visual%20foxpro%209\dv_foxhelp.chm::/html/047f2e74-3552-43b7-a18d-ee2c7dd2db6e.htm
 in DLL servers, in place of CD and CHDIR.”
The pertinent fact being: This command changes the default directory of the 
entire process, so all threads which are part of the process are affected. The 
same thing goes for CD and Chdir so using those as replacements is not an 
option unfortunately.

Has anyone any ideas as to how to produce a dialogue for saving/opening a file 
which doesn’t require the “set default to ” instruction?

I can modify all the timers to open tables based upon absolute paths but this 
would be a mega change which I am trying to avoid. Of course I could roll my 
own Getfile() unless anyone has one available!!!

All suggestions accepted, thanks in anticipation.

Dave Crozier
Software Development Manager
Flexipol Packaging Ltd.

﴾⚆ᨎ⚆﴿



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

This communication and the information it contains is intended for the person 
or organisation to whom it is addressed. Its contents are confidential and may 
be protected in law. If you have received this e-mail in error you must not 
copy, distribute or take any action in reliance on it. Unauthorised use, 
copying or disclosure of any of it may be unlawful. If you have received this 
message in error, please notify us immediately by telephone or email.
  
Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the 
risk of virus transmission through email and therefore any files sent via 
e-mail will have been checked for known viruses. However, you are advised to 
run your own virus check before opening any attachments received as Flexipol 
Packaging Ltd will not in any event accept any liability whatsoever once an 
e-mail and/or any attachment is received.
  
 It is the responsibility of the recipient to ensure that they have adequate 
virus protection.

-

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


---

RE: SPT and Remote Views

2018-11-07 Thread Dave Crozier

Chris,
Not dealt with FM for a couple of years but I did have similar inconsistency 
issues with the SPT and ended up using remote views when I wrote a small add-on 
system for a friend who specialises in FM Pro.

One thing is sure it isn't going to be fixed if it is an ODBC issue!!!

Dave Crozier
Software Development Manager
Flexipol Packaging Ltd.

﴾⚆ᨎ⚆﴿

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

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

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

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

-

Terms & Conditions:
 Notwithstanding delivery and the passing of risk in the goods, the property in 
the goods shall not pass to the buyer until the seller Flexipol Packaging Ltd. 
("The Company") has received in cash or cleared funds payment in full of the 
price of the goods and all other goods agreed to be sold by the seller to the 
buyer for which payment is then due. Until such time as the property in the 
goods passes to the buyer, the buyer shall hold the goods as the seller's 
fiduciary agent and bailee and keep the goods separate from those of the buyer 
and third parties and properly stored protected and insured and identified as 
the seller's property but shall be entitled to resell or use the goods in the 
ordinary course of its business. Until such time as the property in the goods 
passes to the buyer the seller shall be entitled at any time
-Original Message-
From: ProFox  On Behalf Of Chris Davis
Sent: 06 November 2018 17:09
To: profox@leafe.com
Subject: RE: SPT and Remote Views

Not really, I can issue the query once and I get C(10) and again and I get 
M(10) with the whole value in it.

It seems to be an issue with the Filemaker ODBC driver, they suggested VFP does 
ODBC v1? And their driver only supports ODBC v2?

Whatever the issue is, Remote Views seem to get around it.  I would just like 
to be able to get around it using SPT.

-Original Message-
From: ProfoxTech  On Behalf Of Ted Roche
Sent: Tuesday, 06 November 2018 16:53
To: profoxt...@leafe.com
Subject: Re: SPT and Remote Views

Remote views, as you've indicated, let you specify the target structure of the 
query.

When you execute direct SPT Fox attempts to get the first record matching the 
query, and uses the structure of that result as the (fixed column) structure of 
the result set. So, if you have a varying-length string
(varchar) and the first result is 3 characters, VFP might create a C(3) field, 
which could truncate everything else. Does that describe what you are seeing?

On Tue, Nov 6, 2018 at 10:54 AM Chris Davis  wrote:

> Hi All
>
> What extra happens when using Remove Views over SPT?
>
> Using the same ODBC conneciton to a Filemaker database if I do "select
> * from " I get mixed results for the text strings.
>
> If I perform the same query via a remote view I get the same mixed result.
>
> But if I go one step further with the Remote View and specifc 
> properties of the fields it manages to pull complete information out of 
> filemaker.
>
> So what extra is Remote View managing to ask of the Filemaker ODBC 
> driver to make it behave?
>
> Any ideas?
>
> Regards
>
> Chris.
>
>
>
> --- 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:

Re: SPT and Remote Views

RE: SPT and Remote Views

RE: SPT and Remote Views

RE: SPT and Remote Views

Re: IBM to buy RedHat

Re: GetFile() issue

Re: IBM to buy RedHat

Re: GetFile() issue

Re: CAN You Hear the Silence???

Big Changes & Fox Work in SF Bay Area?

Re: CAN You Hear the Silence???

Re: CAN You Hear the Silence???

Re: IBM to buy RedHat

Re: IBM to buy RedHat

Re: GetFile() issue

Re: GetFile() issue

Re: GetFile() issue

Re: GetFile() issue

GetFile() issue

RE: SPT and Remote Views

20 matches

Site Navigation

Mail list logo

Footer information