Re: recordset.sort Problems with data types
From: Val Mazur (group51a_at_hotmail.com)
Date: 07/29/04
- Next message: Jim Rodgers: "RE: Reading Access DB: get someteimes Data - sometimes not"
- Previous message: Val Mazur: "Re: Problem determining new autonum value after UPDATE before UPDATEBATCH"
- In reply to: Rasmus: "RE: recordset.sort Problems with data types"
- Messages sorted by: [ date ] [ thread ]
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
- Next message: Jim Rodgers: "RE: Reading Access DB: get someteimes Data - sometimes not"
- Previous message: Val Mazur: "Re: Problem determining new autonum value after UPDATE before UPDATEBATCH"
- In reply to: Rasmus: "RE: recordset.sort Problems with data types"
- Messages sorted by: [ date ] [ thread ]