Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error when using "COUNT(DISTINCT Field1)" through ODBC

Status
Not open for further replies.
StevenK

StevenK

Programmer
Jan 5, 2001
1,294
GB
I'm getting errors when I try and perform a COUNT of DISTINCT records from a Paradox table through means of an ODBC connection (through C#.NET code application).
The application will happily let me perform a standard issue 'SELECT COUNT(Field1) FROM Table1' against Paradox tables through this mean.
When I try and extend this to something like 'SELECT COUNT(DISTINCT Field1) FROM Table1' I get an error :
"ERROR [42000] [Microsoft][ODBC Paradox Driver] Syntax error (missing operator) in query expression 'COUNT (DISTINCT Field1)'." ...

Can anyone explain why I would be getting this ?

And furthermore can I work around this to obtain my COUNT of DISTINCT entries ?

Thanks in advance
Steve
 
Status
Not open for further replies.

Similar threads

caitlind
  • Locked
  • Question
50, 60 years old women, summer or wear "skirt + flat shoes" the most beautiful
Replies
0
Views
254
caitlind
caitlind
caitlind
  • Locked
  • Question
There are several kinds of dogs that the poor "can't accept", try not to consider them whe
Replies
0
Views
204
caitlind
caitlind
Geoff Collins
  • Locked
  • Question
Edit method error.
Replies
1
Views
69
simd01
simd01
PDX79
  • Locked
  • Question
Finding File Types Using Filesystem's Findfirst & FindNext Methods
Replies
0
Views
64
PDX79
PDX79
PDXBob
  • Locked
  • Question
Losing the "Save As" command
Replies
0
Views
58
PDXBob
PDXBob

Part and Inventory Search

Sponsor

Back
Top