I'm developing an application for a smart device, when I add "Distinct" to my query, I got the following message "The command contains one or more error", when I remove "Distinct" to the query it will work.
here's the query:
AdoceDataAdapter da = new AdoceDataAdapter("Select Distinct Name From Students",cn);
DataSet ds = new DataSet();
da.Fill(ds);
Any suggestions
Error using Distinct !!
Hot Topic
- smart device project creation failed\VS 2005 Pro\Vista RC1\Build 5600
- Multi-form, multi-thread messagebox() woes (VB, CF 1.0)
- String Split Function!!!
- Inserting Ads using the API
- Retrieving Lat & Lon from an address without a map
- Combobox Value member foreach loop
- [Windows Mobile] Windows messages
- Bluetooth signal strength
- unknown Bug
- BudgetLimitType WSDL error
Smart Devicet
- Symbol MC9062B scanner laser crashes
- Why no managed C++?
- Derive from XmlElement
- Performance - Standalone Device Emulator 1.0
- how many pixels per mile/km
- Bypass GPRS Connection in WM'05 Smarphone/Pocket PC
- A problem about StartMenu show/hide notification
- Multiple Tile Layers and zoom on double click issue
- is it possible to copy an already installed certificate?
- Can WMP 10 on WM 5.0 really do streaming?
Error using Distinct !!
ghe
That is quite expected as ADOCE does not support Distinct. Please consider upgrading to SQL Mobile. Since ADOCE is no longer supported/available, it’s a good idea anyway.