Insert into database --- only in specified columns

[Former Member]

I want to insert certain values in certain columns of database tables.

Native SQL query works like

insert into table < column1, col2........> values (1,2,.....)

How would i do it using Open SQL

[Former Member]

I want to insert certain values in certain columns of database tables.

Native SQL query works like

insert into table < column1, col2........> values (1,2,.....)

How would i do it using Open SQL

[Former Member]

use Update or Modify query of OSQL

[Former Member]

Use keyword UPDATE. Just do F1 on the same you will get how to use it.

Regards,

Atish

[Former Member]

update worked well

thank you