Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement