Search results for query: *

Is there a function or procedure to round to the nearest hour. For example, if I had 1-Jan-2002 23:23:59 it would return 1-Jan-2002 23:00:00. Any help would be appreciated.

I have the below code: Do Until rsSQL2.EOF cmdCorrective.ActiveConnection = Plant_SQL cmdCorrective.CommandType = adCmdStoredProc cmdCorrective.CommandText = "AT_Corrective_Action" cmdCorrective.Parameters("@EndDate") = dtEnd...

What are the symptoms? You are using the File --> Make programname.exe... Correct?

Currently I have the below line using the sa password with no password. Const MAL_Driver = "Provider=sqloledb;Data Source=usmbcusmwpweb01;Initial Catalog=MAL;User Id=sa;Password=; " Does any one know if I can use NT authetication for this connection?

I would be interested to see bpoth teqniques. I am currently using the preset list of reports I think. I have a deadlline in the morning so I hacked some code. It might have the same logic though. Thanks a ton.

For simplicity sake I would like just one form in which I open up my crystal reports. Currently I am trying to use the crystal viewer. Well I can hard code one report name into the form_load procedure but when I try to manipulate with a variable to try and pass a differant report name it errors...

Alright I figured out how to access the recordset properties properly. Everything works great when I add or update the recordset. When I delete a record is when I have problems. The problem now is that I do an .update then a .requery and the record I deleted re-populates in the grid. Any ideas?

Thanks for the thought Mike. I looked into it but I am using a commandtype of adcmdtext and not a specific recordset. So I can not use the .update or the .CommitTransaction. Any other thoughts?

The issue is when I enter data into a data grid and then call up a report which references the data it is not being updated properly. Well when I close down the program and then re-run the application it works fine. So I thought instead of just using the adodc1.refresh method I will close &...