This is what i did till now.. CTime currentTime=CTime::GetCurrentTime(); int nDay = currentTime.GetDay(); int nMonth = currentTime.GetMonth(); int nYear = currentTime.GetYear(); int nHour = currentTime.GetHour(); int nMin = currentTime.GetMinute(); int nSec = currentTime.GetSecond(); currentTime -= 2592000; ///30*24*60*60 (Seconds) nDay = currentTime.GetDay(); nMonth = currentTime.GetMonth(); nYear = currentTime.GetYear(); nHour = currentTime.GetHour(); nMin = currentTime.GetMinute(); nSec = currentTime.GetSecond(); But i dont want to calculate it like this. Can anybody suggest me soem other method?

Dear Friends, I need to display a date exact month before from current date. For Ex: todays date is 14-OCt-08.. then i should display 14-Sep-08. Can anybody please help me out with this? Thank u so much in advance Megha

Dear Friends, I m working on VC++ application using Oracle with ODatabase. I m able to execute the query "SELECT SYSDATE FROM DUAL"... but how to take this data in a Date variable in my application... Can anybody help me out??? Megha

Hi Arsene, Actually using one application i m putting data in a table and another application is accessing that data to display on the screen. Can this lead to deadlock situation??/ When i m reading tht data from another appplication i m trying to do some operation as Distinct, SUM and Count... Can this lead to deadlock situation??/ It will be very helpful if u can provide with some information... Thanks in Advance

Dear Friends, i m working on an VC++ application and using oracle as a backend. Through my application i m writing some data to Oracle database. After certain number of iterations i m getting Commit error (8197). Can anybody help me with this? What might be the reason for the same.

I have tried on Google it is mentioned as it commit error and nothing in detail.. I have asked this question on VC++ forum because i wanted to know if somebody who have worked on VC++ and Oracle in combination may know the reason........ Thank u so much

Dear Friends, i m working on an VC++ application and using oracle as a backend. Through my application i m writing some data to Oracle database. After certain number of iterations i m getting Commit error (8197). Can anybody help me with this? What might be the reason for the same.

Thank you so much James. Could u plz tell me how can we set system time?

Dear Friends, I m working on an aplication which is using Oracle as a backend. I need to sync the time between Oracle server and my machine using some oracle defined function. Actualy i m not very familiar with how Oracle supports for this time sync. Can anybody help me out with this? Thanks in Advance.. If u need any more input to answer please let me know Megha

Dear Friends, I need a progress bar which should have two values. Target and Actual. both values should be drawn on the same ctrl. Like below ........Actual......[Target] I already have used CMacProgressCtrl to display one value. Now i have to change it. can anybody help me out.

Thank u so much.. it worked...

Thanks Naveen for such quick response. actually i have tried these two things but i dont need the number of days i directly want the date. For example from now if 24 hrs are there then i need date as 16 Apr. i dont want as 1 day. could you please help me out for this?

Dear Friends, I need to calculate the future date from number of seconds available from now. Can anybody help me out? Which all classes i can use for this calculation?

Dear Friends, I am getting problem in Creating class for Table in Oracle DB. Following steps i have follwed.. 1) Created A DSN name in Control pannel- Adminstrative Tool-Data Sources 2) new class, Name it as AA and Base class as CRecordSet - OK 3)In DB Options, ODBC-- DSN Name, Snapshot -- OK 4) Put the password -- ok 5) Here list of tables should be displayed but i cant see any table.. some names are coming but they do not contain the tables which i m searching for.. Can u plz help me out to solve this problem?? Plz ask me if u want any more info.. Megha

Hi alok, I have created DSN Name. On class view when i clicked on new class and selected CRecordset (as baseclass) -> selected ODBC -> and in List box DSN which i have created -> after entering pasword clicked on OK -> then it should display list of tables for which i need to make a class but it not showing that table at all...

I have one table in an Oracle Db.. I want to access that DB in my application so for that i want to create one class. When i m trying to creat enew class using CDaorecordset as base class. I m not getting Table name to select under "SELECT DATABASE TABLE" dialogue. Did u get me?? Could you please help me now? megha

Megha

Hello friends, If i m using VC++ and i want to rotate soem text on GUI like a Marquee in HTML.. how can i do it?? Could you plz help me out? Megha

in character map this value corresponds to downarrow.. so i thought by doing s1 = _T(2193); i m ay get tht value as CString in s1...

Dear Friends, I m working VC++ where UNICODE is not defined for tht particular application. I want to display "Name (DownArrow)" as a caption on a control. here Downarrow means the picture of downarrow. I tried in a following way. CString s1, s2; s1 = _T(2193); s2 = "PickUp" + s1; But for S1 it is giving me the character with value as 255. Can anybody help me out?/ I can use painting tht control but i don't want to do that.. Thanks in advance Megha