|
Fixed!
|
|
|
|
|
I need to get the count of the distinct dates from the DB which has both date and time . I use the following query . it is working in MS Access , but is failing while executing through MFC . Please let me know if anything needs to be modified.
SELECT COUNT(*) AS Field1 FROM (SELECT DISTINCT Format(Date,"dd/mm/yy") FROM Table)
|
|
|
|
|
And your code is?
Let's think the unthinkable, let's do the undoable, let's prepare to grapple with the ineffable itself, and see if we may not eff it after all. Douglas Adams, "Dirk Gently's Holistic Detective Agency"
|
|
|
|
|
opening recordset with the sql is throwing exception
cRec.Open (AFX_DB_USE_DEFAULT_TYPE, szSql);
|
|
|
|
|
The error is " Too Few parametrs . Please specify 1 parameter
|
|
|
|
|
krishnan.s wrote: sql is throwing exception
And the exception does contain what?
A few unsorted tips from MSDN[^]
"Finally, you must not insert whitespace before the curly brace in a CALL statement or before the SELECT keyword in a SELECT statment."
"You can examine the constructed string by calling GetSQL after calling Open. For additional details about how the recordset constructs a SQL statement and selects records, see the article Recordset: How Recordsets Select Records (ODBC)."
Let's think the unthinkable, let's do the undoable, let's prepare to grapple with the ineffable itself, and see if we may not eff it after all. Douglas Adams, "Dirk Gently's Holistic Detective Agency"
|
|
|
|
|
krishnan.s wrote: I use the following query . it is working in MS Access
krishnan.s wrote: SELECT COUNT(*) AS Field1 FROM (SELECT DISTINCT Format(Date,"dd/mm/yy") FROM Table)
I don't see any "Format" listed in the SQL Reserved words for MS Access?
led mike
|
|
|
|
|
It is used in formattting the date time values in accesss like date_trunc() in postgres
|
|
|
|
|
SELECT COUNT(*) AS Field1 FROM (SELECT DISTINCT Format(Date,"dd/mm/yy") FROM Table)
So if that is supported in Access it becomes:
SELECT COUNT(*) AS Field1 FROM (SELECT DISTINCT 12/02/08 FROM Table)
And that runs in Access?
led mike
|
|
|
|
|
can any one help...how to add separator line in list box just like menu items separator.
|
|
|
|
|
How about:
InsertString(x, "--------------");
"Normal is getting dressed in clothes that you buy for work and driving through traffic in a car that you are still paying for, in order to get to the job you need to pay for the clothes and the car and the house you leave vacant all day so you can afford to live in it." - Ellen Goodman
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne
|
|
|
|
|
If david's answer is good so AddString is good for you.
|
|
|
|
|
I thought it's already seperated
OK,. what country just started work for the day ? The ASP.NET forum is flooded with retarded questions. -Christian Graus
Best wishes to Rexx[^]
|
|
|
|
|
i can add string using m_listBox.AddString("------");
but now user is able to select ----- option.
what i want is:
i have list of items to display in list box, i want a separator in between some,and
user is not allowed to select separator line.( ----- ).
|
|
|
|
|
How do I convert INT32 to int?
For instance, INT32 nID = 10;
Thanks!
|
|
|
|
|
from MSDN.
INT32 32-bit signed integer.
This type is declared in BaseTsd.h as follows:
typedef signed int INT32;
Hence you don't even need the conversion.
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.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke
|
|
|
|
|
From MSDN only,
The size of a signed or unsigned int item is the standard size of an integer on a particular machine. For example, in 16-bit operating systems, the int type is usually 16 bits, or 2 bytes. In 32-bit operating systems, the int type is usually 32 bits, or 4 bytes.
for 64-bit OS, ..., he didn't specify which machine he is using
|
|
|
|
|
Provided he is using MS C++ compiler a int is a 32 bit type, see http://msdn2.microsoft.com/en-us/library/cc953fe1.aspx[^].
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.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke
|
|
|
|
|
quote from your link
Type int is an integral type that is larger than or equal to the size of type short int, and shorter than or equal to the size of type long.
link to size of int http://msdn2.microsoft.com/en-us/library/ed98zksd.aspx[^]
CPallini wrote: using MS C++ compiler
not mentioned
|
|
|
|
|
Rajkumar R wrote: using MS C++ compiler
not mentioned
Have you seen forum title, haven't you?
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.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke
|
|
|
|
|
Have n't u seen the links i provide (size of int )
|
|
|
|
|
Yes but if he needs to convert a INT32 that is, by definition (unless he isn't using the BaseTsd.h header), a signed int then the assignment
INT32 i32 = 10;
int i = i32;
it is valid.
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.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke
|
|
|
|
|
when int is 16bit it truncates . ok just started as joke
modified on Monday, February 11, 2008 11:27 AM
|
|
|
|
|
On a 32 bit machine, int is just 32. On a 64 bit machine, int becomes 64 but INT32 would still be 32. Or I'm wrong ?
OK,. what country just started work for the day ? The ASP.NET forum is flooded with retarded questions. -Christian Graus
Best wishes to Rexx[^]
|
|
|
|
|
I was thinking that the size of int depended on the machine, too, but on the website mentioned above by CPallini, it says that the size of int (and unsigned int) is 4 bytes, and that __intn (where n is 32, 64, etc) specifies that a specific number of bytes is used. So it sounds like maybe int is always the same as INT32?
Now I'm confused about whether INT is the same as int or __intn. That is, do the capitalized versions of data types (INT, UINT, LONG, DOUBLE, etc.) depend on the machine, unless specified as INT32, INT64, etc?
Thanks!
|
|
|
|