SQL PT returns a CAST AS CHAR(100) as memo, need char fl

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

SQL PT returns a CAST AS CHAR(100) as memo, need char fl

Message

From

19/12/2006 10:46:57

Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia

19/12/2006 01:57:15

Bhavbhuti Nathwani
Venus Software Operations
Rajkot, India

General information

Forum:

Visual FoxPro

Category:

Forms & Form designer

Title:

Re: SQL PT returns a CAST AS CHAR(100) as memo, need char fl

Environment versions

Visual FoxPro:

VFP 9 SP1

Database:

MS SQL Server

Miscellaneous

Thread ID:

01178491

Message ID:

01178874

Views:

>>SELECT ..., SUBSTRING(Remarks,1,100) AS cRemarks ...
>>

>
>Yes, I did try this out too, but somehow something is wrong on my side and it does not seem to convert to a character field.

Did you try this on another machine? Maybe there's something in your ODBC settings?

back to same old
the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.

Map

View

Click here to load this message in the networking platform