DATEDIFF function - C / C++ / MFC Discussion Boards

David Crow2-Jul-07 4:32

2-Jul-07 4:32

A DSN does not know/care about the underlying DBMS. The third argument is where you specify the type, and the fourth argument contains the details of that type.

"A good athlete is the result of a good and worthy opponent." - David Crow

"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne

Re: create DSN at runtime

meenakhisjoshi2-Jul-07 19:29

meenakhisjoshi

2-Jul-07 19:29

The third argument is "Microsoft Access Driver (*.mdb)" then what should changes are required?

Re: create DSN at runtime

meenakhisjoshi2-Jul-07 21:47

meenakhisjoshi

2-Jul-07 21:47

I wrote :

SQLConfigDataSource(NULL,ODBC_ADD_SYS_DSN,"Microsoft SQL Driver (*.sql)\0",(LPCSTR)szDesc))

sprintf(szDesc,"DSN=%s: DESCRIPTION=TOC support source: DBQ=%s: FIL=MicrosoftSQL: DEFAULTDIR=D:\\Database:: ","TestDB","root@localhost\\dtest.sql")

but it gives error so plzzzzzzzzz help me what should i changes?

Re: create DSN at runtime

David Crow3-Jul-07 2:08

David Crow

3-Jul-07 2:08

meenakhisjoshi wrote:
SQLConfigDataSource(NULL,ODBC_ADD_SYS_DSN,"Microsoft SQL Driver (*.sql)\0",(LPCSTR)szDesc))

Why the extra \0 character? This statement is missing a semicolon.

meenakhisjoshi wrote:
sprintf(szDesc,"DSN=%s: DESCRIPTION=TOC support source: DBQ=%s: FIL=MicrosoftSQL: DEFAULTDIR=D:\\Database:: ","TestDB","root@localhost\\dtest.sql")

If you are using MFC, why not use a CString object rather than mess with sprintf()? This statement is also missing a semicolon.

meenakhisjoshi wrote:
but it gives error...

And that error would be?

"A good athlete is the result of a good and worthy opponent." - David Crow

"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne

Re: create DSN at runtime

meenakhisjoshi3-Jul-07 23:33

meenakhisjoshi

3-Jul-07 23:33

In this '\0' just for termination of string
the error is
SQLConfigDataSource is return False.

Is any problem in that syntax

Re: create DSN at runtime

David Crow4-Jul-07 11:42

David Crow

4-Jul-07 11:42

meenakhisjoshi wrote:
In this '\0' just for termination of string

Which string literals already have one of.

meenakhisjoshi wrote:
SQLConfigDataSource is return False.

So have you bothered to call SQLInstallerError() to find out why?

"A good athlete is the result of a good and worthy opponent." - David Crow

"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne

Re: create DSN at runtime

MANISH RASTOGI2-Jul-07 19:03

MANISH RASTOGI

2-Jul-07 19:03

Use ODBC_ADD_SYS_DSN

Manish Rastogi

DATEDIFF function

El'Cachubrey2-Jul-07 1:08

El'Cachubrey

2-Jul-07 1:08

Hi Is exists in c++ a function similar to DATEDIFF in SQL or VB
THANK

Re: DATEDIFF function

CPallini2-Jul-07 1:44

CPallini

2-Jul-07 1:44

If you're using MFC, have a look at CTimeSpan class http://msdn2.microsoft.com/en-us/library/ay6ws8h3(VS.80).aspx[^].
Smile | :)

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.

Re: DATEDIFF function

benjymous2-Jul-07 1:59

benjymous

2-Jul-07 1:59

CompareFileTime is a win32 function that'll compare two FILETIME structs

Re: DATEDIFF function

vladfein2-Jul-07 9:20

vladfein

2-Jul-07 9:20

Unfortunately, none of the two suggestion above will do what DATEDIFF does...
You need to separate the DATE part of your time value. You didn't say what data type you use for your date/time variables.
The easiest way, I think, is to convert both dates to COleDateTime (which wraps double representation of date/time), truncate the fractional part and simply subtract one value from another.

-----------------------------
Get trial copy of FeinViewer - an integrated GDI objects viewer for Microsoft Visual Studio .NET 2005 (8.0) Visual C++ Debugger, and other convenience and productivity tools for Microsoft Visual Studio .NET at at www.FeinSoftware.com

Dynamic Structures

Programm3r2-Jul-07 0:32

Programm3r

2-Jul-07 0:32

Hi all,

I would liek to know if it is possible to create dynamic structures? And if it is possible, how would one go about doing it?

Many Thanks
Regards,

The Code Project...Where men are made and legends are born Green Alien | [Alien]

Programm3r
My Blog: ^_^

Re: Dynamic Structures

baerten2-Jul-07 0:45

baerten

2-Jul-07 0:45

Hi,

i think the only way is to use void* Pointer into your struct.
So you can store what-ever in your structure.
But the number of pointers must be specified in the code.

Good luck Smile | :)

Re: Dynamic Structures

CPallini2-Jul-07 1:04

CPallini

2-Jul-07 1:04

Programm3r wrote:
I would liek to know if it is possible to create dynamic structures?

What do you mean? Do you want to dynamically create statically declared structs?
If the answer is yes, then use the new operator. On the other hand, if the answer is no, please detail you request.

Smile | :)

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.

Re: Dynamic Structures

Programm3r2-Jul-07 2:29

Programm3r

2-Jul-07 2:29

CPallini wrote:
What do you mean?

Well for example, instead of creating five structures, is it possible to create one structure that can dynamically cater for each of the five structs during run time.

Makes sense ?
Thanks for the response ...

Regards,

The Code Project...Where men are made and legends are born Green Alien | [Alien]

Programm3r
My Blog: ^_^

Re: Dynamic Structures

CPallini2-Jul-07 2:47

CPallini

2-Jul-07 2:47

Programm3r wrote:
is it possible to create one structure that can dynamically cater for each of the five structs during run time

Why don't you use a container (such as std::vector) for your dynamically created structures?

(Maybe I haven't fully understood your requirements).
Smile | :)

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.

Re: Dynamic Structures

Programm3r2-Jul-07 2:59

Programm3r

2-Jul-07 2:59

Thanks for the info CPallini, never really used a std::vector before, but I'll give it a shot.

Thanks
Regards,

The Code Project...Where men are made and legends are born Green Alien | [Alien]

Programm3r
My Blog: ^_^

Re: Dynamic Structures

Eytukan2-Jul-07 6:15

Eytukan

2-Jul-07 6:15

You mean 5 different structures? Unsure | :~

, then you can't use vectors straight away. You can use vectors to grow itself dynamically but not different data struct types. May be you can cast everything to void* then push it inside the vector. I mean if you are talking about different structs.

Press: 1500 to 2,200 messages in just 6 days? How's that possible sir?
Dr.Brad :Well,I just replied to everything Graus did and then argued with Negus for a bit.

Dialog inside view?

adityarao312-Jul-07 0:22

adityarao31

2-Jul-07 0:22

I developed application using SDI CHTMLView
Is it possible to have dialog at one corner of
my view ? If yes how to acvhieve that.

|| Lust Causes Sorrow ||

HtmlHelp function problem [modified]

camalia2-Jul-07 0:16

camalia

2-Jul-07 0:16

I`ve got MFC dialog-based program and i`ve made html help support by this way:

pressing F1 in dialog calls OnHelpInfo(..) in which i call HtmlHelp(..). It works in some strange way: if before pressing F1 i press button Browse (that calls standart file open dialog CFileDialog) and point to some file, HtmlHelp() does not work after this.

What do i do wrong?

VC++ 6.0

Thx.

Re: HtmlHelp function problem

Iain Clarke, Warrior Programmer2-Jul-07 2:47

Iain Clarke, Warrior Programmer

2-Jul-07 2:47

I would guess that your current directory is being set by the FileOpen dialog, and you are not calling the help function with the correct name.

Imagine your program lives in "c:\myprog".

User runs your program:
Dir is set to c:\myprog
User asks for help
HtmlHelp ("myhelp.chm") runs c:\myprog\myhelp.chm.
User changes directory to c:\other
User asks for help
HtmlHelp ("myhelp.chm") runs c:\other\myhelp.chm, and fails.

What you need to do is to make sure you're running the correct help file.

What I do is: Use GetModuleFilename to get the full path of the exe. replace exe with chm, and then run that help file.

I hope that helped!

Iain.

Re: HtmlHelp function problem

camalia2-Jul-07 3:04

camalia

2-Jul-07 3:04

Yes, it works! Thanks very much!

Convert string^ to numeric

mikobi2-Jul-07 0:06

mikobi

2-Jul-07 0:06

I am using Visual c++ NET 2005

How to convert string^ to numeric

Re: Convert string^ to numeric

aatul2-Jul-07 0:08