Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
One to many updatable form
Message
From
30/11/1997 13:57:04
 
 
To
28/11/1997 23:10:39
George Alexander
Qatar Armed Forces
Doha, Qatar
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00062681
Message ID:
00062926
Views:
53
>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.

For the APPEND BLANK:
SELECT MyChildTable
APPEND BLANK

New records in grid: implementing your functionality for adding new records in grid is ratter hard to program. You need to add code in the GotFocus() and the AfterRowColChange() of the grid. A better approach will be to put a Add button beside your grid.

>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

TableUpdate() won't trigger the ON ERROR when it fail if record or table buffering is enabled. TableUpdate() will return .F. in that case, so you could check:

IF NOT TableUpdate()
WAIT WINDOW "Save not commited"
ENDIF
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform