l and msquery and all the data appears without issue.
I have decided not to pursue using fox to get the data out.
-Original Message-
From: ProfoxTech On Behalf Of Stephen Russell
Sent: Thursday, 08 November 2018 02:39
To: profoxt...@leafe.com
Subject: Re: SPT and Remote Views
You could
se 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
&g
ovember 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()
+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
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
T
asses 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 wh
ver 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
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 stru
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 strin
9 matches
Mail list logo
