
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