>Hi Cetin,
>
>Thanks for your reply. I am uncertain how to implement your suggestion. Could you post a sample?
>
>Thanks
>Vince

Sample is for SQL server, but main idea is same.

csql = "SELECT EmployeeID, LastName, FirstName," + ;
		"BirthDate," + ;
		"Hiredate FROM dbo.Employees"

lnHandle=Sqlstringconnect('DRIVER=SQL Server;'+;
  'SERVER=(local);DATABASE=Northwind;Trusted_Connection=Yes')
SQLExec(lnHandle,cSQL,'v_emp')

CursorSetProp('KeyFieldList','Employeeid','v_emp')
CursorSetProp('WhereType',1,'v_emp')
CursorSetProp('Tables','employees','v_emp')

CursorSetProp("UpdateNameList", ;
  "employeeID    employees.employeeid,"+;
  "Firstname employees.FirstName,"+;
  "Lastname employees.Lastname,"+;
  "BirthDate employees.birthdate",'V_emp')

CursorSetProp('UpdatableFieldList',"Firstname,Lastname,BirthDate",'v_emp')
CursorSetProp('SendUpdates',.T.,'v_emp')
CursorSetProp('Buffering',5,'v_emp')
Browse title 'Editable fields are : Firstname,Lastname,BirthDate'
If !Tableupdate(2,.T.,'v_emp')
  AError(arrWhy)
  Display memo like arrWhy
endif
SQLExec(lnHandle,'select * from dbo.employees','afterupdate')
SQLDisconnect(lnHandle)
Select afterupdate
Browse

Cetin