Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Invalid Cursor sate Error... :argh:

 
H Melua
Ranch Hand
Posts: 172
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

Now that i solved one of the problems i had, i got into another one

Can some one please debug this code for me , i dont have a clue why its doing that! All my coding is the same, the only difference in this code is the UNION...



Dont worry about "why would you want drivers and cars combined!"

MS Access Database i'm using

Thanks
HannaH
[ April 03, 2006: Message edited by: H Melua ]
 
stu derby
Ranch Hand
Posts: 333
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
While it's not your problem with cursor state, you should learn the difference between UNION and UNION ALL.

UNION ALL is what you want here, not UNION, not least because it's more efficient.
 
H Melua
Ranch Hand
Posts: 172
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you stu

As far as i know, the difference is that Union removes duplicate values! and thats what i want!

HannaH
 
stu derby
Ranch Hand
Posts: 333
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by H Melua:
Thank you stu

As far as i know, the difference is that Union removes duplicate values! and thats what i want!

HannaH


OK.. If you can actually have a car and a driver that are the same, then you've got a very weird data model, but whatever...
 
H Melua
Ranch Hand
Posts: 172
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You see Stu, i knew i will be asked similar questions to this, thats why i stated in my first post...

Originally posted by H Melua:
Dont worry about "why would you want drivers and cars combined!"


Thanks
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic