RE: recordset.sort Problems with data types
From: Kevin Yu [MSFT] (v-kevy_at_online.microsoft.com)
Date: 07/28/04
- Next message: barani: "VB & MS Access"
- Previous message: Piglet: "VBA + MS SQL"
- In reply to: Rasmus: "recordset.sort Problems with data types"
- Next in thread: Rasmus: "RE: recordset.sort Problems with data types"
- Reply: Rasmus: "RE: recordset.sort Problems with data types"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 28 Jul 2004 09:07:44 GMT
Hi Ramus,
First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you are receiving a error which says
"Relate, Compute By, and Sort operations cannot be performed on column(s)
whose defined size is unknown or to large" when doing a sort on RecordSet.
If there is any misunderstanding, please feel free to let me know.
Based on my research, the size of a column, which was set as a sort column,
cannot be larger than 32766. So could you change the size to 32766, so that
the code will run properly?
HTH.
Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
- Next message: barani: "VB & MS Access"
- Previous message: Piglet: "VBA + MS SQL"
- In reply to: Rasmus: "recordset.sort Problems with data types"
- Next in thread: Rasmus: "RE: recordset.sort Problems with data types"
- Reply: Rasmus: "RE: recordset.sort Problems with data types"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
