hi every one:
I have binded some data which I have connected through DATA BASE wizard of OLeDB in a comboBOX AND now i want to add queries to select distict values . i have entered the query
select DISTINCT[name of my field] from table_name
but I get the following error while clicking the OK botton
"theschema returned by the new query differs from the base query"
any idea to help me.?
Jump to Postselect DISTINCT[[B]name of my field[/B]] from table_name
the reason is this query differ from the orginal one . The name of my field must be the same in all queries
select DISTINCT[[B]name of my field[/B]] from table_name
the reason is this query differ from the orginal one . The name of my field must be the same in all queries
Hello apchidara...
if u could put the QUERY CODES dat u use in ur program maybe i could determine what problem u have.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.