C / C++ / MFC

Re: Retrieving Dates from Access Database using ODBC

18-Mar-04 12:32

Hi, pavneet!

I'm trying to go the other way: getting system time from a client PC and sending it to an SQL Server database.

Here's a code snippet. The table column OPENDATE is type datetime and I'm binding it to a variable in my app:

time_t now;<br />
struct tm *localNow;<br />
TIMESTAMP_STRUCT tsOpenDate;<br />
char* szStmt = "INSERT INTO ORDERS (ORDERID, CUSTID, OPENDATE, SALESPERSON, STATUS) VALUES (?, ?, ?, ?, ?)";<br />
<br />
SQLDescribeParam(hstmt, 3, &DataType, &ParamSize, &DecimalDigits, &Nullable);<br />
SQLBindParameter(hstmt, 3, SQL_PARAM_INPUT, SQL_C_TYPE_TIMESTAMP, SQL_TYPE_TIMESTAMP, ParamSize, DecimalDigits, &tsOpenDate, 0, &cbOpenDate); <br />
<br />
time (&now);<br />
localNow = localtime (&now);<br />
<br />
tsOpenDate.year = localNow->tm_year;<br />
tsOpenDate.month = localNow->tm_mon;<br />
tsOpenDate.day = localNow->tm_mday;<br />
tsOpenDate.hour = localNow->tm_hour;<br />
tsOpenDate.minute = localNow->tm_min;<br />
tsOpenDate.second = localNow->tm_sec;<br />
tsOpenDate.fraction = 0;

The problem is that the values in the localNow structure are offsets from a '0' date (I think it's 1.1.1900), whereas the data table wants a real calendar date. Thus, the SQLExecute() call fails.

I know I can use the ASCII time conversion functions to get strings for all the datetime parts (strftime), and then convert those to integers (atoi), but there must be an easier way!!!

'til next we type...
HAVE FUN!! -- Jesse

pavneet19-Mar-04 9:34

pavneet

19-Mar-04 9:34

hi jesse,
Actually its easier to add the date as CString's rather then the hard way out.

	Ctime time;<br />
        CString m_appdate;<br />
	time = time.GetCurrentTime();<br />
	m_appdate = time.Format("%d-%m-%y");<br />
	const char *appdate = (LPCTSTR)m_appdate;<br />
	SQLINTEGER cappdate = SQL_NTS;<br />
<br />
<br />
	sr = SQLBindParameter(hstmt,6,SQL_PARAM_INPUT,<br />
		SQL_C_TCHAR,SQL_C_TCHAR,10,0,<br />
		(void *)appdate,sizeof(appdate),&cappdate);<br />
	if(sr != SQL_SUCCESS && sr != SQL_SUCCESS_WITH_INFO)<br />
	{<br />
		displayError(sr,"Error in Binding 6");<br />
	}

I think that will help u out......
Pavneet

Re: Retrieving Dates from Access Database using ODBC

Jesse Evans22-Mar-04 6:07

Re: Retrieving Dates from Access Database using ODBC

22-Mar-04 6:07

Pavneet,

Thanks for your response. In my case, this will not work, as the datatype of the date column is datetime and the Bind call fails unless you use SQL_C_TYPE_TIMESTAMP to describe it.

After reviewing the documentation on localtime, I found I can fix up the date in the following manner:

time (&now);<br />
localNow = localtime (&now);<br />
printf ("%s", asctime (localNow));<br />
<br />
memset (&tsOpenDate, 0, sizeof(tsOpenDate));<br />
tsOpenDate.year = localNow->tm_year + 1900;<br />
tsOpenDate.month = localNow->tm_mon + 1;<br />
tsOpenDate.day = localNow->tm_mday;<br />
tsOpenDate.hour = localNow->tm_hour;<br />
tsOpenDate.minute = localNow->tm_min;<br />
tsOpenDate.second = localNow->tm_sec;

'til next we type...
HAVE FUN!! -- Jesse

Jesse Evans22-Mar-04 7:16

Multi Column Combo Box class

22-Mar-04 7:16

Pavneet,

Found another way to get the timestamp without the fixup that locatime needs: An SDK function called GetLocalTime

Here's another code snippet showing its use:

SYSTEMTIME systemTime;<br />
GetLocalTime (&systemTime);<br />
<br />
memset (&tsOpenDate, 0, sizeof(tsOpenDate));<br />
tsOpenDate.year = systemTime.wYear;<br />
tsOpenDate.month = systemTime.wMonth;<br />
tsOpenDate.day = systemTime.wDay;<br />
tsOpenDate.hour = systemTime.wHour;<br />
tsOpenDate.minute = systemTime.wMinute;<br />
tsOpenDate.second = systemTime.wSecond;<br />

'til next we type...
HAVE FUN!! -- Jesse

DougW483-Mar-04 8:25

Re: Multi Column Combo Box class

3-Mar-04 8:25

Has anybody here used the CMultiColumnComboBox class written by Xiao Wu Guang? The link is http://www.codeproject.com/combobox/mccombobox.asp#xx737862xx. In the posts at the end of the artice, there are some problems with using this class in Windows 2000/XP. Unfortunately, the link to the fix doesn't work anymore. Does anybody know how to make this class work correctly in Windows 2000/XP? It would be nice if one of the better programmers on here (definitely not me) would update this class and repost it with all the fixes! Thanks Smile | :)

BrutalDeath04-Mar-04 23:41

BrutalDeath0

4-Mar-04 23:41

Hi, I use the MultiColumnComboBox class, I made some changes (which I found in the forum), here is the additional code :

.cpp :
------
in the DrawItem() function, under :
CRect TextRectangle = lpDrawItemStruct->rcItem;
// **** Additional coding Start ****
if (DropDownWindowPointer == NULL)
{
if((GetWindowLong(m_hWnd, GWL_STYLE) & 0x3) == CBS_DROPDOWN)
{
DropDownWindowPointer = GetWindow (GW_CHILD);
}
if((GetWindowLong(m_hWnd, GWL_STYLE) & 0x3) == CBS_DROPDOWNLIST)
{
DropDownWindowPointer = GetWindow (GW_HWNDFIRST);
}
}
// **** Additional coding End ****

under // if vertical scrool bar is visible : replace :
if ((ColumnIndex == m_TotalColumn - 1 || (ColumnIndex == m_TotalColumn - 2 && m_ColumnWidth[m_TotalColumn - 1] == 0)) && (DropDownWindowPointer->GetStyle() & WS_VSCROLL))
TextRectangle.right -= GetSystemMetrics(SM_CXVSCROLL);

BY :
DeviceContextPointer->DrawText(m_ColumnItemList[ColumnIndex].GetAt(m_ColumnItemList[ColumnIndex].FindIndex(lpDrawItemStruct->itemID)), -1, TextRectangle, m_ColumnAlignStyle[ColumnIndex] | DT_SINGLELINE | DT_NOPREFIX | DT_VCENTER);

I think it's all;
if you still have a problem, just answer and I'll send you the complete file.

BrutalDeath0

Modeless Dialog

ERKs3-Mar-04 8:16

ERKs

3-Mar-04 8:16

I have an MFC application that displays a modeless dialog during a file transfer with the status information. That all works fine, I can update the info in the dialog box with the current file transfer status info. The problem is the user can still try to interact with the main window while this modeless dialog is displayed. What I would like is to have the modeless dialog behave similar to a modal dialog where the user can only interact with that dialog and not access the main view. I do not want to use a modal dialog because the main program needs to continue processing the file transfer. Any ideas on what is the best way to do this?

DougW483-Mar-04 8:19

3-Mar-04 8:19

Have the main program process your file transfer in a thread, then you'll be able to use a modal dialog box. That's probably not exactly what you were looking for, but it's what I'd try first. Good luck

Maximilien3-Mar-04 8:50

Maximilien

3-Mar-04 8:50

maybe by using CWnd::EnableWindow on the main window can do the trick.

Maximilien Lincourt
Your Head A Splode - Strong Bad

James R. Twine3-Mar-04 9:16

James R. Twine

3-Mar-04 9:16

Note that you may have to call CWnd::EnableWindow( TRUE ) on the modeless dialog after calling CWnd::EnableWindow( FALSE ) on the parent...

Disabling the parent tends to take child windows with it.

Peace!

-=- James (Sonork:100.21837)
[Tip for SUV winter driving survival: "Professional Driver on Closed Course" does not mean "your Dumb Ass on a Public Road"!]
[Get Delete FXP Files Now!]

sps-itsec463-Mar-04 8:54

sps-itsec46

3-Mar-04 8:54

I guess the following articles will solve your problem:

http://www.codeproject.com/threads/TemplatedLengthyOperation.asp[^]
http://www.codeproject.com/datetime/tasktimer.asp[^]

Regards, mYkel

Looking for Windows Debugging Tools for Win 98

ERKs3-Mar-04 13:10

ERKs

3-Mar-04 13:10

The AfxGetMainWnd()->EnableWindow(false) did the trick. Always seems so obvious when you know the answer.

The article in http://www.codeproject.com/threads/TemplatedLengthyOperation.asp answered some other questions I had about function pointers.

Thanks for everyones help. Eric

Jesse Evans3-Mar-04 7:41

3-Mar-04 7:41

Searched MS site but only found WDT for NT/2K/XP.

'til next we type...
HAVE FUN!! -- Jesse

Rename a locked file

Paul Riley3-Mar-04 7:13

Paul Riley

3-Mar-04 7:13

This seems like a really simple question, but I can't find the answer anywhere else and I know someone in here has to have faced it before.

At the commandline (at least on NT/2k/XP, which is all that matters in this question), you can rename a file which is currently locked using ren and the program holding the file will adjust, allowing you to put a new file in its place ready for later.

If I try to do this using MoveFileEx then (not entirely surprisingly) it complains that the file is locked.

I could open a new process and use the commandline, and I will if I have to, but if there's some way of convincing MoveFileEx or call something else to rename the file then I'd prefer not to have a DOS box flash up.

Does anyone know if this is possible?

Paul

Re: Rename a locked file

David Crow3-Mar-04 7:20

David Crow

3-Mar-04 7:20

Does SHFileOperation() work any better?

"The pointy end goes in the other man." - Antonio Banderas (Zorro, 1998)

Re: Rename a locked file

Maximilien3-Mar-04 7:21

Maximilien

3-Mar-04 7:21

have a look at ShFileOperation I think it works for locked files.

Maximilien Lincourt
Your Head A Splode - Strong Bad

Re: Rename a locked file

Paul Riley3-Mar-04 7:46

Paul Riley

3-Mar-04 7:46

You guys rock, thanks. Serious brain freeze on my part.

Paul

Link Error

DougW483-Mar-04 6:36

3-Mar-04 6:36

I am having a problem compiling a class I downloaded from CodeProject. The class compiles until I try to create a variable of that type, and then I get a linker for each function that I try to call with that variable (to begin with, just the constructor and destructor.) Here are the compiling errors that I am receiving:

error LNK2019: unresolved external symbol "public: __thiscall CMultiColumnComboBox::CMultiColumnComboBox(void)" (??0CMultiColumnComboBox@@QAE@XZ) referenced in function "public: __thiscall NewInvoice::NewInvoice(void)" (??0NewInvoice@@QAE@XZ)

error LNK2001: unresolved external symbol "public: virtual __thiscall CMultiColumnComboBox::~CMultiColumnComboBox(void)" (??1CMultiColumnComboBox@@UAE@XZ)

The class is the CMultiColumnComboBox class from http://www.codeproject.com/combobox/mccombobox.asp#xx169761xx[^] The directions say to include the file in the .cpp file, but then I cannot declare variables in my .h file, so I had to include the class in my .h file. Now I'm getting these linker errors. Can somebody please give me some suggestions? Thanks a bunch!!

jmkhael3-Mar-04 6:42

jmkhael

3-Mar-04 6:42

Did u add the file in the project?

Papa

while (TRUE)
Papa.WillLove ( Bebe ) ;

DougW483-Mar-04 6:57

3-Mar-04 6:57

yes, the files are included in the project. Sigh | :sigh:

David Crow3-Mar-04 7:18

David Crow

3-Mar-04 7:18

DougW48 wrote:
The directions say to include the file in the .cpp file, but then I cannot declare variables in my .h file...

Probably because the two .h files are in the wrong order. The #include <MultiColumnComboBox.h> statement should precede the inclusion of your dialog's .h file. Or, if your dialog declaration is going to be used in places other than by its definition, you'll need the #include <MultiColumnComboBox.h> statement in the dialog's .h file instead, before any reference to the CMultiColumnComboBox class.

"The pointy end goes in the other man." - Antonio Banderas (Zorro, 1998)

DougW483-Mar-04 7:44