I have a problem to update the underlying table(Ms Access) for my remote view when the field of underlying table is reserve word eg. date, or the field name cannot accept by VFP eg. "pur order no".


I using following command to create my remote view:

CREATE SQL VIEW mex_transaction CONNECTION cmex ;
AS SELECT counter,;
action,;
[date],;
[purchase order no],;
FROM [Stores transactions] Stores_transaction

DBSETPROP('mex_transaction','VIEW','Tables','"Stores transactions"')

DBSETPROP('mex_transaction.counter','FIELD','KEYFIELD',.T.)
DBSETPROP('mex_transaction.counter','FIELD','UpdateName','"stores transactions".counter')

DBSETPROP('mex_transaction.date','FIELD','UpdateName','"stores transactions"."date"')
DBSETPROP('mex_transaction.date','FIELD','Updatable',.T.)

DBSETPROP('mex_transaction.action','FIELD','UpdateName','"stores transactions".action')
DBSETPROP('mex_transaction.action','FIELD','Updatable',.T.)

DBSETPROP('mex_transaction.purchase_order_no','FIELD','UpdateName','"stores transactions.purchase order no')
DBSETPROP('mex_transaction.purchase_order_no','FIELD','Updatable',.T.)

DBSETPROP('mexStores','VIEW','SendUpdates',.T.)


The view are working fine except I cannot update the date,purchase order no.

Please help me to solve the problem.


TIA.