Re: recordset.sort Problems with data types

From: Val Mazur (group51a_at_hotmail.com)
Date: 07/29/04


Date: Wed, 28 Jul 2004 21:36:53 -0400

Hi,

adLongVarWChar is a BLOB type and as I know you cannot perform any sorts on
a BLOB fields at all. This is just a limitation.

-- 
Val Mazur
Microsoft MVP
"Rasmus" <Rasmus@nospam.nospam> wrote in message 
news:DF50252A-F24B-4F27-B50A-BB143F97A49F@microsoft.com...
> Thanks for the reply. You are correct - that was just what i needed for it 
> to work.
>
> But now another issue has come up:
>
> When sorting on the "LongText" column the following error comes:
>
> Failede to execute the script. The following was returned by the error 
> object (runtime)
> Number:-2147024882
> Source:Microsoft Cursor Engine
> Description:Out of memory.
>
> Thats eventhough the recordset contains only 3 rows!
>
> Regards
>
> Rasmus