|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
March 12th, 2004, 09:23 PM
|
|||
|
|||
|
DateAdd question
I have a four fields
Field 1:Ship Field 2: Date Field 3: Ship2 Field 4: Date2 All our bound to textboxes via ADODC I have a DateAdd function that is not working. When the field1:date reaches today's date, i am trying to get the Ship2 value and date2 to move over to Ship and Date fields, kind of resync. EndTime = DateAdd("s", "30", Adodc1.Recordset.Fields(29)) If Now = EndTime Then Adodc1.Recordset.Fields(28).Value = Adodc1.Recordset.Fields(17).Value Thank you for any advice.
|
|
#2
March 20th, 2004, 04:16 PM
|
|||
|
|||
|
try to work with a Store Procedure not ADODC directly(if you can )...I have no any idea what your trying to do here...but if you want me to help you..try to refomula your problem in SQL
|
|
#4
March 21st, 2004, 03:06 AM
|
|||
|
|||
|
make stored procedure
Make a stored procedure and let it run by the sql service manager every x time.
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > DateAdd question |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
