Hi Karen
I tried your way but couldn't make the DBEDIT fields to be filled in after the click in the ListBox.
Are there special commands, perhaps an On Click EEP in the ListBox?
Do you have constrains?
 
Regards
Armin
 
 
 
 
----- Original Message -----
Sent: Tuesday, November 30, 2004 1:18 AM
Subject: [RBG7-L] - Re: property RBASE_FORM rebuild 'true'

Armin:

I did something similar.  I created a 2-table form.  The first table is actually a single-table view of my customer table that concatenates the first/lastnames and has the CustID.  The second table is the customer table.

The first table (view) has a list box in last name order.  The second table has all the DBEdit fields.  You click on a name in the view's list box and you get the edit fields all filled in.  The only problem is that there's no "searching" -- you have to navigate to the customer in that list box.

Karen



Hi all   
(Have a look to Doug Hamilton's mail from 11/3/04, too)

I know the upper PROPERTY-Command doesn't exist. But it would be nice if ...

Reason:
I have one form with a     
--> Variable Lookup ListBox (in order to choose the CustId --> vCustId)  and some
--> DbEdit - Fields (in order to edit CustName... that belong to the CustId).
I'm looking for a possibility to choose the CustId out of the  ListBox and directly (without any other form)  edit the record that belongs to that chosen CustId.
I don't want to use a CHOOSE-Command before, I dont want to use temp. table.

Solution (not the best one, but it works)

--Call the Form
SET VAR vCustId INTEGER = 1  (first record is to see)
WHILE vCustId > -1 THEN
 EDIT USI FCustEdit WHE CustId = .vCustId
ENDWHILE
RETURN

--OnClick-EEP in VarListBox
CLOSEWINDOW
RETURN

-- BitButton to CLose the form
SET VAR vCustId = -1
CLOSEWINDOW
RETURN

-- BitButton to add a new row
property table Customers 'append'
saverow
property CustIdList refreshlist 'true'
RETURN

Well, it works, but I'm looking for an elegant solution. With an property-command like
                  property RBase_Form rebuild 'true'
one could reach that goal elegant.
Regards
Armin



Reply via email to