INSERTING data into specific fields of a table

Question

what abt if i wanna insert data to only fldLength and fldSize (fields) of the table Table1 how do i choose to insert into the specific fields? Table1: fldID fldName fldLength fldSize fldExt ps: do i need to .update() or acceptchanges() for the above codes? my current codes are: cn = New OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:	est.mdb;) cn.Open() For each filename In filelist str = insert into table1 values(' & filename.name & '' & 99 & ') cmd = New OleDbCommand(str cn) cmd.ExecuteNonQuery() Next For each filename In filelist str = insert into table2 values(' & filename.Extension & '' & filename.Length & ') cmd = New OleDbCommand(str cn) cmd.ExecuteNonQuery() Next cn.Close()

pioneerpauls · Answer

Dear Friend If we use an INSERT commandEach time a new row is inserted into the table.... If the table has 4 fields and we insert a row with 2 values....the other two fields are automatically given NULL values ..Provided those fields are not identity columns. And We cannot Use WHERE clause in a direct insert command.. SO it is better to use UPDATE command incase of partial input where we can specify the particular row with some identity.. EXAMPLE update table2 set fldLength=10 and fldSize=25 where fldName=filename.Name Al d best wit prayers Satisa....