Search results for query: *

I'm trying to send the file path c:\documents and settings\<username>\my documents\<filename> to an old COTS application that will not accept blanks in the path. Does anybody have any ideas on how this could be done? The DOCUMENTS AND SETTINGS portion can be changed to DOCUME~1 but what can I...

How do I change the color of a static text control in a dialog box? Thanks

I'm looking for a way to save milliseconds in a SQL Server database datetime field. CTime doesn't handle milliseconds as far as I know and I haven't been able to find a way to do it with COleDateTime either. Can I add the milliseconds in a SYSTEMTIME to COleDateTime? Do I need to change...

I've got 2 date/time fields I want to combine/add and put in another date/time field in another table. Here's an example of the 2 fields: [arrivetime] [WaitingPeriod] 9/16/2002 11:49:49 PM 1:29:00 AM Logically if you add them you would get: 9/17/2002 1:18:49 AM But I'm getting...

I got an insert statement that works fine in the QA but when I put it in a Stored Procedure it doesn't work. I don't use Transact-SQL very much so I figure I'm missing something. Any tips would be appreciated. Here's the code: CREATE PROCEDURE [dbo].[migrate_data] AS declare @days int declare...

With a wizard I put a CStringArray within the application class &quot;theApp&quot;. When I start the debugger I get the assertion failure before my code touches the CStringArray (as far as I know). Here's the assertion failure: Debug Assertion Failed! Program:...\GapPlus.exe File: afxcoll.inl...

When using the T-SQL debugger the sp appears to be working, returning the new record number from a SELECT statement. However 98% of the time the Enterprise Manager shows no new records in the table. It's the fact that it works occasionally that has me stumped. The Profiler says the sp is...

I'm new to Transact-SQL. I've got a number in a varchar field that I need to get the numeric value of. How do I go about this? Thanks

If I use CEdit::Create() to create and edit box at run time I don't get the 3D effect. How can this be done?

Get the full path of the application at run time. I know I did it once before but it's been so long I can't remember how! Can anybody remind me?

How do you get the ProductVersion, FileVersion, etc. from the string table?

Using MSVC++ 6.0 and SQL Server 2000. I let the wizard create the CRecordset for a table. When I do a CRecordset::Open() it throws an exception. I stepped through it with the debugger and found I was getting warnings when calling the RFX_* functions. The first 9 are RFX_Text() calls and...