Adapter Wizard Part 2

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi ther

SELECT TOP 10 House, LivingRoom, DiningRomm, Den, [Date], FamilyRoom, BedRoom1, BedRoom2, Notes, [Number], Kitchen, Deck FROM MyRecords ORDER BY Number DES

I have a data adapter I am trying to configure and when I enter the aboue query in the Adapter Wizard Dia box it says there is an erro
The aim is to fill a dataset with only the last ten rows of data in decending order. Ironicaly, when I enter the same statement into OleDbCommand, it works
Please hel
 
Hi Sam,

What is ironicly with that, that is what I messaged you in your original
thread.

Please stay in the original thread.

Cor
SELECT TOP 10 House, LivingRoom, DiningRomm, Den, [Date], FamilyRoom,
Click to expand...
BedRoom1, BedRoom2, Notes, [Number], Kitchen, Deck FROM MyRecords ORDER BY
Number DESC
I have a data adapter I am trying to configure and when I enter the aboue
Click to expand...
query in the Adapter Wizard Dia box it says there is an error
The aim is to fill a dataset with only the last ten rows of data in
Click to expand...
decending order. Ironicaly, when I enter the same statement into
OleDbCommand, it works.
 
Back
Top