What I am trying to do is capture any records that happened that day. Where it is a datetime field there are 24 records during that time period. I can always put in qualifers for midnight to midnight however I thought the LIKE would work. I will have to try the other way I guess...

Dim dsFred = New DataSet
conn = New OleDbConnection("Provider=OraOLEDB.Oracle;User ID=test;Password=testPass;Data Source=ARC")
sql = "select level from testTable where dTime LIKE to_date('3/27/2013','MM/DD/YYYY') and station = '019654' order by dTime"
myCommand = New OleDbDataAdapter(sql, conn)
myCommand.Fill(dsFred, "fred")
Dim fred As Integer = dsFred.Tables("fred").Rows.Count

yes and it works perfectly. I am using VS2010 if that makes a difference.

I have SQL that is returning 24 rows in SQLPlus however when I run the same query in VS2010 using Provider=OraOLEDB.Oracle its doesn't return any rows. I am using a LIKE operator with to_date. Any suggestions? Is it the provider I am using the problem? See example

select level from testTable where dTime LIKE to_date('3/27/2013','MM/DD/YYYY') and station = '019654' order by dTime

I did try it with '%3/27/2013%'

I don't know if there is a way to do this or not but I would like to monitors any changes to a specific database table. The database in question would be Oracle. I have done numerous searched on the net but either my search text sucks or there is no solution... What I want is to have is an app that would do a check to see if the table has changed and if so it sends an email to a user. The only thing I need to figured out is how to capture the edits/changes to the database table logic... Any suggestions?

I have a problem I have added a command to my crystal report that calls a stored procedure and should turn a number. I have also added a parameter to that procedure to make it dynamic. The problem I am experiencing is that when I bind this result to an unbound field the parameter doesn't change. It is static. And results in an error of having to Verify the Database to update the report. Is there another way I can do this. Is this a glitch with Crystal.... select test.pkg_s_e.get_cnt_ws('{?P_WS}') from dual

Congrads....

I am sorry, I guess I will upgrade my fridge.... :-D

Sorry to hear about you loss...

Sorry to hear about your kitty. It is never easy. We suffered the loss of my family (parents) cat that I had since I was 8. She only left us in May she lived a good life of 22 years.

LMFAO that is definatly a typo.. Hitting my head against the table. Obviously my spelling is not that great lol... Must fix before anyone else notices.... Thanks :-O

I was at work, Then a call came out for help in regards to the international planes being diverted to Newfoundland (where I live). You can read about it here http://www.snopes.com/rumors/gander.htm[^] I don't live in Gander but in St. John's Newfoundland where we also have housed many flights and showed them hospitality.

no kidding...

Yep that is a good bonus. But when you have to go through two PMS's in one month that is not too good :laugh:

not too funny for me. But this is why I am careful where i have to fly.

This is an excellent story... A happy ending... http://www.cnn.com/video/#/video/living/2007/08/21/wsaz.dog.dug.out.affl[^]

Happy Birthday... Enjoy....

Is this all they do in the prison. I actually find it a little cool. Found this on CNN. http://www.cnn.com/video/#/video/offbeat/2007/08/01/vo.philippines.prison.dance.reut[^]

leckey wrote:

Sunday: Natinal Tapioca Pudding Day and Respect Canada Day! I personally am not a fan of any pudding and I have no clue what tapioca tastes like. And what has Canada ever done for the US? One day I would like to go up there with a bunch of US quarters and screw up all YOUR pop machines.

LOL on the quarters and no they don't screw up our pop machines... As for what we have done for you.... of which i know you weren't really serious :) but where I am from Newfoundland Canada you can read one of our biggest things here http://www.snopes.com/rumors/gander.htm[^]

Thanks