C++ Programming
10-10-2010, 02:01 AM
COleDateTime date = COleDateTime::GetCurrentTime();
CString one_id = "A001";
CString description = "test";
sqlSP.Format("declare @data_uid as integer exec dbo.msp_Insert %s, %s, %d, @doc_uid output select @doc_uid AS doc_uid",
one_id,
description,
date
);
i need to insert a COleDateTime in MFC to a MS SQL table, with column as datetime.
Can anybody tell me what is the error???
I guess there is a CString formatting error...
Any help will be great.
Saleem
CString one_id = "A001";
CString description = "test";
sqlSP.Format("declare @data_uid as integer exec dbo.msp_Insert %s, %s, %d, @doc_uid output select @doc_uid AS doc_uid",
one_id,
description,
date
);
i need to insert a COleDateTime in MFC to a MS SQL table, with column as datetime.
Can anybody tell me what is the error???
I guess there is a CString formatting error...
Any help will be great.
Saleem