oObj.Dummy = 1 oObj.cust_id = "NEWID" oObj.Company = "New Company" oObj.TableName = "Customer" insert into Customer from name oObjwould insert a new record where only there is a matching between fieldname and property name (here it would create new customer record with cust_id and comapny field only - identical to:
insert into customer (cust_id,company) values ("NEWID","New Company")That's what makes it great for your case, you need to know your fieldnames and use them instead (remember I directly used field001,field002 etc).
oObj.PatientIn = "20071203102000" *and you could directly convert it there: oObj.PatientIn = CTOT(TRANSFORM(oObj.PatientIn,"@R ^9999/99/99 99:99:99"))Cetin