UPDATE STATEMENT TIME INSERTION 
Author Message
 UPDATE STATEMENT TIME INSERTION

What am I doing wrong here?

SQLQuery="UPDATE tasks SET tk_date='" & txt2 & "', tk_time= #" &
format(txt3, "##:##:##") & "#, tk_offerte="&ch1&", tk_support="&ch2&",
tk_development="&ch3&", tk_invoiced="&ch4&" WHERE tk_id = "&NR&";"

DB.Execute(SQLQuery)

the red part is where it goes wrong. I want to insert the txt3(the name of
an input field in a form which i have extracted with the request.form
statement) variable in the tk_time column(which is a short time defined
column).

ANY solutions?



Tue, 28 Aug 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. UPDATE STATEMENT TIME INSERTION

2. UPDATE STATEMENT TIME INSERTION

3. AVI Insertion Declaration and Command Statement?

4. Update statement creates Error, when statement is fine

5. Report Field Data Insertion & Update

6. Report Fields Data Insertion and Update

7. Generic insertion combo box (was :Insert text at Insertion point of a field)

8. RTF insertion of text at a specific insertion point

9. using stopeatch form functions to time an event procedure and update elapsed time control

10. web service and updating web reference with vb.net design time vs run time

11. web service and updating web reference with vb.net design time vs run time

12. DoCmd and Update statement

 

 
Powered by phpBB® Forum Software