topic Re: Insert into database --- only in specified columns in Application Development and Automation Discussions

Insert into database --- only in specified columns

Former Member — Wed, 09 Apr 2008 02:56:48 GMT

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 — Wed, 09 Apr 2008 02:59:38 GMT

use Update or Modify query of OSQL

Former Member — Wed, 09 Apr 2008 02:59:48 GMT

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

Regards,

Atish

Former Member — Wed, 09 Apr 2008 03:14:09 GMT

update worked well

thank you