Solved

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

Posted on 2009-05-05
4
668 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

In our object-oriented world the class is a minimal unit, a brick for constructing our applications. It is an abstraction and we know well how to use it. In well-designed software we are not usually interested in knowing how objects look in memory. …
Here is a helpful source code for C++ Builder programmers that allows you to manage and manipulate HTML content from C++ code, while also handling HTML events like onclick, onmouseover, ... Some objects defined and used in this source include: …
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.
The viewer will learn how to synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.

763 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now