|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
October 4th, 2004, 05:15 PM
|
|||
|
|||
In MSAccess, Memo Field being trunicated!
Hey guys. I have a SQL query I'm trying to create. It's nice and dandy, but I have a memo field that's being trunicated to 256 characters.
SQL is something like this: Code:
Select distinct `group`,sortorder,HideLabel,category,img,Description,Null as num,Null as subcat from catalogimages where Inact=0 and subcateg is NULL group by `group`,sortorder,HideLabel,category,img,Description order by `group`,sortorder,category Description would be the memo field. Is the 'GROUP BY' clause even necessary here? I'm also willing to bet that the 'DISTINCT' clause might not be necessary. Any help would be greatly appreciated.
|
|
#2
October 4th, 2004, 06:07 PM
|
||||
|
||||
|
GROUP BY and DISTINCT are both not necessary, as you guessed (unless the table has rows with duplicate sets of values for the selected columns)
this might also eliminate the truncation problem
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > In MSAccess, Memo Field being trunicated! |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
