Changes to Display values w/o changing database values 
Author Message
 Changes to Display values w/o changing database values

Does anyone know of a way I can perform a operation on a a display value in
a Datagrid without having it change the underlying database.  Using the
Datagrid, I am displaying data in English units (feet) and need the ability
to convert the display values to Metric (meters) without changing the
database.
  Could this be done with some kind format command or am I looking at a lot
more coding than that?

Thanks in advance.



Sat, 02 Mar 2002 03:00:00 GMT  
 Changes to Display values w/o changing database values

Quote:

> Does anyone know of a way I can perform a operation on a a display value in
> a Datagrid without having it change the underlying database.  Using the
> Datagrid, I am displaying data in English units (feet) and need the ability
> to convert the display values to Metric (meters) without changing the
> database.
>   Could this be done with some kind format command or am I looking at a lot
> more coding than that?

Couldn't you do this in the SQL that retrieves the recordset:

SELECT SomeField, AnotherField, (Length * 0.3048) AS MetricLength
FROM...

--
Jim in Cleveland
If you're writing to me, in my address
change "REAL_Address.see.below" to "worldnet.att.net"

"What's so funny 'bout peace, love & understanding?"
     - Nick Lowe



Sat, 02 Mar 2002 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. combobox value: can not change value

2. Calulated fields changes control values back to original values

3. COMBOBOX.BOUNDTEXT VALUE CHANGES TO DIFFERENT FIELD VALUE

4. changing numeric format displayed based on value

5. Change font formatting changes value of other cell

6. change value in database

7. Combobox or Listbox: separting key values from display values

8. ComboBox Display value and Data Value?

9. changing databases in odbc doesnt change database in report

10. How to set default value of combo box to value of record in database

11. To displaying NULL database values on an HTML page

12. Swithing Display from Parameters to Database Value.

 

 
Powered by phpBB® Forum Software