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

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

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

Message

19/12/2006 10:46:57

Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia

19/12/2006 01:57:15

Bhavbhuti Nathwani
Venus Software Operations
Rajkot, Inde

Information générale

Forum:

Visual FoxPro

Catégorie:

Gestionnaire d'écran & Écrans

Titre:

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

Versions des environnements

Visual FoxPro:

VFP 9 SP1

Database:

MS SQL Server

Divers

Thread ID:

01178491

Message ID:

01178874

Vues:

>>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.

Répondre

Fil

Voir

Click here to load this message in the networking platform