Is there any simple way ?

INSERT INTO testing (name, addr, note1, note2, note3, ......,note9, note10)

    VALUE (:sName, :sAddress, :sType1, :sType2, ........, :sType9, :sType10);

Is there any simple way for this command in embedded SQL ? Can I write a field name (note1 ...note10) as a variabel ? And if :sType are variabel with array (sType[1], sType[2] ....) how can I insert their value into a new record ? Received on Mon Apr 12 1999 - 03:19:34 CDT