native SQL

[Former Member]

Hi,

I want to execute the following code and get an exception.

ErrorCode: =>

dsf = 've_country, ve_vendor_no, ve_name' .

dsv = ' :DE, :18005, :jwr'.

EXEC SQL.

insert into Dummytab

(

dsf

)

VALUES

(

dsv

)

ENDEXEC.

<=

Goodcode, which does work.

EXEC SQL.

insert into Dummytab

(

ve_country, ve_vendor_no, ve_name

)

VALUES

(

:'DE', :'18005', :'jwr'

)

ENDEXEC.

Does anybody have an idea, how I can solve?

Thx

Joachim

[ferry_lianto]

Hi,

Please try this.

EXEC SQL.
  INSERT INTO Dummytab
        (ve_country, ve_vendor_no, ve_name)
  VALUES 
        ('DE', '18005', 'jwr')      "Change here
ENDEXEC.

Regards,

Ferry Lianto

[Former Member]

Hi,

but I want to use a String for the Values, because I want to create the fields, which should be insert Dynamically.

Joachim

[ferry_lianto]

Hi,

I don't think you can do that with native SQL.

Regards,

Ferry Lianto