I recommend to just define your own color palette and use it in both the chart and the custom table legend. Check this blog article for an example and explanations: http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx
-- Robert
|||Thanks, Robert. It helpsI recommend to just define your own color palette and use it in both the chart and the custom table legend. Check this blog article for an example and explanations: http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx
-- Robert
|||Thanks, Robert. It helpsI am trying to achieve a similar query in ORACLE but donno how to do it in Ms SQL Server and MS Access (I have to do it for both these databases)
SELECT * FROM someTable
WHERE someField = &EnterValue
When this query is executed in ORACLE, it will ask user to enter value for &EnterValue and then execute the query using the user entered value.
Can this be done in MS SQL Server and MS ACCESS?
Please help...
ThanksHi-
Found the answer for MsAccess, I need to enter =[EnterValue] in Criteria for a given column.
Still looking for answer for MS SQL Server. Is Stored Proc the only answer?
Please help...
Best Wishes,|||SQL Server will not prompt the user for a parameter value. It needs to be supplied.
It is normally done like this:
SELECT * FROM someTable
WHERE someField = @.someValue
Check out the ASP.NET tutorialServer-Side Data Access, especially the "Performing a Parameterized Select" section, to see how to use Parameters with ADO.NET.
Terri
Hi,
I can't get ntext field value from my database (or nvarchar).
If I write in my database in english, I get only the 2 first letters.
If I write in my database in hebrew, I get gibbrish letters.
please I need some help
I'm using sql serser 2000, CRecordset, CDatabase, ODBC
Code Snippet
CDBVariant val;
rs.GetFieldValue("activity",val);
CString activity = (*activityVal.m_pstring).GetBuffer(0);
I'm sorry but I've not used MFC very much, but I've used ODBC, and this looks to me like you're fetching Unicode characters into ANSI buffers. The first thing I would try is defining your application as a Unicode app by adding the following add the beginning of your code:
#define UNICODE
#define _UNICODE
Here's a link to using ODBC via MFC: http://msdn2.microsoft.com/en-us/library/s9ds2ktb(VS.80).aspx
Hopefully someone else on this alias is more familiar with MFC to help you out.
Good luck!
~Warren
|||Thank's,
Do you know how can I define these in my project? how to use this?
#define UNICODE
#define _UNICODE
what is the value when running sql script?
select cast(cast(.0000006 as numeric(38,10)) * cast(1.0 as numeric(38,10)) as numeric(38,10))
the result is .0000010000.
why the result is not .0000006000?
The reason the scale of the result has been reduced to 6 is interesting. You have asked SQL Server to multiply two numerics, each with 38 precision and 10 scale.
Conceptually, the result should be a numeric(77, 20). However, this is above SQL Server's maximum precision, so the result would need to be truncated.
An implementation decision was made to sacrifice some scale to gain more digits on the left side of the decimal point, up to a minimum of scale 6. So the numeric(77,20) is actually converted to numeric(38, 6). The same behavior happens for division.
That decision is based off the assumption that digits on the left side of the decimal point are usually more important than the ones on the right side. It can pay off in a different situation:
select cast(1234567890123456789012345678.0 as numeric(38,10)) * cast(10.0 as numeric(38,10))
Here, the extra scale was not actually important, so sacrificing it to get more digits on the left side of the decimal point paid off.
To keep SQL Server from guessing if the scale is needed or not, you need to type your numerics appropriately if possible. In your example:
select cast(cast(.0000006 as numeric(10,10)) * cast(1.0 as numeric(2,1)) as numeric(38,10))
Yields the appropriate results. The result of the multiplication is conceptually numeric(13,11) which is well within our limits.
I hope this helps, and let me know if this work around does not work for you.
-Mat
|||In addition to Matt's comments, please take a look at the "Precision, Scale, and Length" topic in Books Online. The url is mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\tsqlref.chm::/ts_da-db_8rc5.htm. This topic explains the formula used to arrive at the resulting precision of arithmetic operations involving two numeric values.|||thanks for your help~|||Thank you for your reply.
I can find 'tsqlref.chm' but not know how to go '/ts_da-db_8rc5.htm' .Can you tell me how to do.Thanks.
I know how to find.^_^
use the tool bar,GO-->URL.... to open 'Jump to URL'
|||If you have SQL Server 2000 Books Online installed then go to Go\Url menu option and paste the url. You can also search for this topic in MSDN.Anyone knows is it possible to use an expression in alias or get the value for alias from another table?
No. Field aliases are constants.|||if you want to conditionally refer to a field, you could use the Items() collection syntax. For example, let's say you wanted to display one of two fields based on a parameter:Fields.Items(Parameters!SelectedField.Value).Value
