We help IT Professionals succeed at work.

C++ Builder ODBC How to set the CURRENT_TIMESTAMP in SetFields method?

todgor
todgor asked
on
801 Views
Last Modified: 2013-11-17
I am using an ADODataSet object in C++ Builder 6, and using the SetFields and Post methods to set the values of the fields in the table, and insert the record into it. The last field in the table is a DateTime field. The current version of the code (below) works, but its putting the local PC time into the table records. I want to use CURRENT_TIMESTAMP instead, to store the database server time. I tried just using the constant (like SQL_FN_TD_CURRENT_TIMESTAMP), I tried it as an AnsiString, both return an exception in the SetFields call. How do I do this?

Thanks,
Tod
TADODataSet *dataset = frmADO->ADODataSet11;
         AnsiString dt;
         DateTimeToString(dt, "mm/dd/yyy hh:mm:ss", Now());
         try
            {
            dataset->SetFields(ARRAYOFCONST((crData.Conn_ID_C, crData.CSC_Site_C,
                                             crData.Operator_ID_C, crData.Term_ID_C,
                                             crData.WU_DNIS_No_C, crData.WU_Call_Reason_CD_N,
                                             crData.WU_Additional_Info_C, crData.Caller_Lang_CD_N,
                                             crData.Caller_Type_C, crData.WU_Product_ID_C,
                                             crData.Cap_Type_C, crData.Comments_C,
                                             crData.Skill_CD_C, t, TVarRec(dt))));

Open in new window

Comment
Watch Question

What kind of exception do you get?

You could try "Now()", this should put the current date and time of the server.

Author

Commented:
I tried "Now()" and "fn Now()" as ANSIString variables like this:

   AnsiString dt = "Now()";  

   dataset->SetFields(ARRAYOFCONST((crData.Conn_ID_C, crData.CSC_Site_C,
                                  crData.Operator_ID_C, crData.Term_ID_C,
                                  crData.WU_DNIS_No_C, crData.WU_Call_Reason_CD_N,
                                  crData.WU_Additional_Info_C, crData.Caller_Lang_CD_N,
                                  crData.Caller_Type_C, crData.WU_Product_ID_C,
                                  crData.Cap_Type_C, crData.Comments_C,
                                  crData.Skill_CD_C, t, TVarRec(dt))));

But I got the same type of exception, which is "Program xxxx raised exception EConvertError with message "Now() is not a valid date and time". Process stopped." Is it used as some other data type? Am I able to run functions from the database server like this?
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
I tried working with the ADOQuery object to build a SQL command, but I found it cumbersome. I ended up issuing a select to retrieve the server date-time to use in  the Post
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.