Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Insert into database --- only in specified columns

Former Member
0 Likes
448

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
419

use Update or Modify query of OSQL

3 REPLIES 3
Read only

Former Member
0 Likes
420

use Update or Modify query of OSQL

Read only

Former Member
0 Likes
419

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

Regards,

Atish

Read only

Former Member
0 Likes
419

update worked well

thank you