What is the best way 2 take 24 hr data frm database avoiding duplicate times

[user_1]

Hi All,

I have a table containing data for 24 hrs for many stations.

So when i display this using labview application i have to display all the stations along with its 24 hr data in the following format...

stationame stnno  12    01   02  03.........................................................................23(0...23 are the time from 12 am to 11pm)

stna               s1     24   -       23   22     .....................................................................-

stnb                s2     22   22    -      21........................................................................20

(i am using a multi column list box to display this)

.....

......

If the station dont have record at a particular time i have to represent it by" -" and if a station contains 2 records at a particular hour i have to

take only one and represent.

How do i design sql query for this.

What i did now is i have selected all the records from 12am 11 pm of the day the user selected and then in a for loop i have taken the 24 hour data of each station.

Then checked for each hour.

But its not functioning properly.

Any help?

[Jason_Whaylen]

Hi!

The functionality it looks like you are trying to achieve here is contained within our Database Connectivity Toolkit.  It would be a good start for you to take a look at this and verify this is the case. 

If this is the case, using this tool would be by far the easiest way to go about obtaining this functionality.  The primary work around I can think of at this point would be to use a DLL to try to programmatically access these resources, and call it within LabVIEW.  I hope this is at least helpful it getting you on the right track.  It might be worth trying some of your own inquires from within ni.com/support, as there seems to be a lot of helpful information.  Let us know if you have more questions.

Regards,

Jason W.

Message Edited by jason_w on 10-08-2007 06:21 PM