Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
One to many updatable form
Message
From
28/11/1997 23:10:39
George Alexander
Qatar Armed Forces
Doha, Qatar
 
 
To
28/11/1997 15:00:58
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00062681
Message ID:
00062833
Views:
49
>>First). I am using table buffering. I use child cursor so that the user will be able to add records without affecting
>>the table.
>
>With table buffering, you could do an APPEND BLANK directly in the child table. The changes won't be send to the tables until you issue a TABLEUPDATE(). VFP do directly what you are doing by code.
>
>>2. I copy the records of the child cursor into array and use insert(SQL) into the child table and then give the
>>tableupdate.
>
>Do you verify the result of TABLEUPDATE()? It return .F. if the change were unsuccessful.


1. I dont know where to put the append blank. What I want is when the user clicks the grid for the first time
a blank record should be added and then when he presses down arrow more records should be added. He
will also have the freedom to click on the deleted mark to delete one or all of the child records. All this facility
is only in add mode which I keep track by setting a flag as soon as he clicks add button.

2. I have included a On Error errflag = .t. statement as Mr. Eric has suggested in one of a previous thread. But
it is not going to the roll back as far as the master table is concerned. So I end up with a master record without
a child record

thanks for the reply

alex
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform