copy the data


i have two tables 1. postable 2.sostable

postable fields are Custacct, Custname,Addresss, COntactNo

Sostable fields are Accid ,Name

i want to move the all Cust acct field values to Accid ,CustName values to Name

how to do it …

Do you want to copy all records from one table to the other? In that case, I would use insert_recordset. See the following example (not tested):

insert_recordset sosTable (AccId, Name)
    select CustAccount, CustName from posTable;

its not working …