Insert one value into a dataset

Fernb2000 · May 22nd, 2005, 09:30 AM

hello;

I have a dataset with many records, i would lilke to insert one specific number to all records in one specific field, how would a do that without having to traverse through all records..

Thanks

Fernb2000

BrianWren · May 25th, 2005, 10:30 AM

I would use SQL to change the data in the database first, and then fill the dataset.

Alternatively, when you fill the dataset, set up your SQL to concatenate that specific number to the database's information as it is being retrieved. To append a 1 to all FNames from an Oracle DB you might use something like:

Code:

SELECT FNAME||'1' NEWNAME, LNAME
FROM EMPLOYEES
ORDER BY LNAME

(â||â is the concatenation operator for Oracle.)