|
Home > Archive > FoxPro Help and Support > May 2005 > upsizing errors
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| When I use the upsizing wizard, I get errors with a few views that I am
upsizing:
Error 170- TOP n not allowed (or something like that)
Also I get:
Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Argument
data type text is invalid for argument 1 of left function.
The field that fails is ... LEFT(mymemofield,100
) as mytextfield .
Is there away around these problems or do I need to create the remote views
differently.
| |
| Craig Berntson 2005-05-27, 11:24 am |
| Yes, you need to create the views differently. Keep in mind that VFP will
not process the SELECT statement in anyway and simply passes it on to SQL
Server. You'll need to use SQL Server compliant statements.
--
Craig Berntson
MCSD, Visual FoxPro MVP
www.craigberntson.com
Salt Lake City Fox User Group
www.slcfox.org
www.foxcentral.net
"ghj" <ghj@ghj.com> wrote in message news:vzple.3106$zb.763@trndny01...
> When I use the upsizing wizard, I get errors with a few views that I am
> upsizing:
>
> Error 170- TOP n not allowed (or something like that)
>
> Also I get:
>
> Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL
> Server]Argument data type text is invalid for argument 1 of left function.
>
> The field that fails is ... LEFT(mymemofield,100
) as mytextfield .
>
> Is there away around these problems or do I need to create the remote
> views differently.
>
>
>
|
|
|
|
|