topic native SQL in Application Development and Automation Discussions

native SQL

Former Member — Wed, 21 Nov 2007 15:49:04 GMT

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 — Wed, 21 Nov 2007 15:58:49 GMT

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 — Wed, 21 Nov 2007 16:09:35 GMT

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 — Wed, 21 Nov 2007 16:16:54 GMT

Hi,

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

Regards,

Ferry Lianto