Format a field from a querry SQLServer

predal · March 3rd, 2004, 09:37 AM

Hi guys

How can I format a field containing numbers(double) directly from a querry. The database is SQLServer. I need it so I can link the result as the datasource for a MSHFlexGrid control.

Is there an event MSHFelxGrid whet it fills up. Something like OnFill or smth.

Many thanks

Lucian Preda
[email protected]

pgtips · March 3rd, 2004, 10:49 AM

Maybe change your query to use SQL Server's STR() function to do the formatting?

Quote:

quote:
Syntax
STR ( float_expression [ , length [ , decimal ] ] )

Arguments
float_expression

Is an expression of approximate numeric (float) data type with a decimal point. Do not use a function or subquery as the float_expression in the STR function.

length

Is the total length, including decimal point, sign, digits, and spaces. The default is 10.

decimal

Is the number of places to the right of the decimal point.

predal · March 5th, 2004, 10:35 AM

Thanks
But the str function converts the value to a string of a fixed length and it returns it containing spaces.
Anyway I managed to work around my problem.

Lucian Preda
[email protected]

Yehuda · March 5th, 2004, 10:43 AM

You could of course format it in the SQL Query. SQL has many string functions. Doing formatting in your SQL query can be more efficient than doing it in VB. Here is an example of converting a double to string:

SELECT CONVERT(varchar(20), [mynumber]) as mynumber FROM mytable

If you gave us more of an idea of how you are trying to format the double, I could give you a better example.