Solved

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

Posted on 2009-05-05
4
679 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

0
Comment
Question by:todgor
  • 2
  • 2
4 Comments
 
LVL 2

Expert Comment

by:Morris_Szyslak
ID: 24313935
What kind of exception do you get?

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

Author Comment

by:todgor
ID: 24317782
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?
0
 
LVL 2

Accepted Solution

by:
Morris_Szyslak earned 500 total points
ID: 24323352
Apparently not, sorry. I was wrong about how the SetFields() method works. I thought it would run a command on the sql server but it only changes the data set and runs a command when you Post() the dataset. It seems the dataset locally stores the values in the format that is specified in the FieldDefs.

You could try to set the FieldDef to ftString and after that call SetFields();
dataset->FieldDefs->Items[insert index of the datetime field]->DataType = ftString;
I'm not sure if this will work, but it may be worth a try

You could also build a SQL command and give the parameters as you like. But you might have to change the structure of your app for this.
0
 

Author Closing Comment

by:todgor
ID: 31578271
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
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Programmer's Notepad is, one of the best free text editing tools available, simply because the developers appear to have second-guessed every weird problem or issue a programmer is likely to run into. One of these problems is selecting and deleti…
Update (December 2011): Since this article was published, the things have changed for good for Android native developers. The Sequoyah Project (http://www.eclipse.org/sequoyah/) automates most of the tasks discussed in this article. You can even fin…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
The viewer will learn how to synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question