query insertion in vb.net

Please support our VB.NET advertiser: Intel Parallel Studio Home
Reply

Join Date: Aug 2007
Posts: 18
Reputation: apchidara is an unknown quantity at this point 
Solved Threads: 0
apchidara apchidara is offline Offline
Newbie Poster

query insertion in vb.net

 
0
  #1
Sep 10th, 2007
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.?
Reply With Quote Quick reply to this message  
Join Date: Mar 2006
Posts: 121
Reputation: manal is an unknown quantity at this point 
Solved Threads: 17
manal's Avatar
manal manal is offline Offline
Junior Poster

Re: query insertion in vb.net

 
0
  #2
Sep 11th, 2007
select DISTINCT[name of my field] 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
"give only what u willing to receive "
Reply With Quote Quick reply to this message  
Join Date: Sep 2007
Posts: 7
Reputation: YHUBZ is an unknown quantity at this point 
Solved Threads: 0
YHUBZ's Avatar
YHUBZ YHUBZ is offline Offline
Newbie Poster

Re: query insertion in vb.net

 
0
  #3
Sep 13th, 2007
Hello apchidara...

if u could put the QUERY CODES dat u use in ur program maybe i could determine what problem u have.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC