Displaying multiple values into multiple fields from 1 trigger

Hi All,

I am creating a trigger that displays all data into a canvass with multiple fields but am unable to get it to display all the data.

SELECT CAR_STYLE, COLOUR
INTO :CAR.CAR_STYLE, :CAR.COLOUR
FROM CAR
WHERE :CAR.REG_NUM=REG_NUM; The table CAR contains all types of data regarding cars, eg colour, stereo, car type etc and have created the relevant fields within the canvass.

Is there a way where instead of putting :CAR.(ATTRIBUTE); for each attribute. Whenever I simply add a comma it doesnt like it and returns an error.

Please help..any suggestions welcome.
Many Thanks Received on Sat Feb 22 2003 - 09:39:35 CST