General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2000 Server
Mobeen,
What are:
?set("dele")
?set("multi")
?CURSORgetPROP("Buffering")
?CURSORgetPROP("Prepared")
Are you sure that when calling tableupdate(.t.,.t.) you are sitting on the proper view? Try tableupdate(1,.t.,cursor_alias).
Also, there are a lot of keyfields. Are you sure that before deleting one of them was not changed (and table was not updated before deleting)?
>Hi Yuri,
>
>
>
>?CURSORgetPROP( "KeyFieldList")==>
>company_id,user_branch,voucher_date,voucher_no,serial_number,voucher_type
>
>?CURSORgetPROP( "UpdatableFieldList")==>
>company_id,branch_id,user_branch,voucher_date,voucher_no,serial_number,voucher_type,account_code,acct_effect_st_dt,debit_amount,credit_amount,transaction_desc,updt_userid,updt_time,cheque_no,cheque_dt,updt_user_ip
>
>
>?CURSORgetPROP( "SendUpdates")==> .T.
>?CURSORgetPROP( "FetchSize")==> -1
>
>
>Thanks,
>Mobeen.
>
>
>
>
>
>
>>Mobeen,
>>
>>Let me start with this: are you sure that you set properly the view properties?
>>
>> ?CURSORgetPROP( "KeyFieldList")
>> ?CURSORgetPROP( "UpdatableFieldList")
>> ?CURSORgetPROP( "SendUpdates")
>> ?CURSORgetPROP( "FetchSize")
>>
>>
>>
>>>Hi all,
>>>
>>>i want to delete the records in the remote view but it doesnot.
>>>when i focefully delete the record by =Tableupdate(.t.,.t.) it return
>>>the Ture but did not delete the record.
>>>sometime following error comes
>>>
>>>Table buffer for alias "name" contains uncommitted changes
>>>
>>>
>>>
>>>
>>>Best Regards,
>>>Mobeen.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only