Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Deleting in the Remote View.
Message
 
À
06/02/2006 04:51:31
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 6 SP3
OS:
Windows XP
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01092231
Message ID:
01094273
Vues:
23
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
Fil
Voir

Click here to load this message in the networking platform