Marc, How are you trying to update the current row? I'm assuming you're doing this within a form?
If that's the case and if I'm understanding correctly, you could do a couple of things. You could use the PROPERTY componentid TEXTVALUE .varname command. In an on entry/exit eep on a field, or on entry into the row. Make sure you assign a component id to the field(s) in question. If it's a situation where you want the value of the column to equal a variable no matter what, you can just create a variable with the same name as the column. For example, in my quote system, the user may enter a customer number to do a quote for an existing customer, but they may be doing a misc. quote for someone new. I have a variable vcustno = custno, and variables for the customer name (vcustname), address (vaddress), etc. In an on exit eep from the customer number field, I have PROPERTY custnamefield TEXTVALUE .vcustname, PROPERTY addressfield TEXTVALUE .vaddress. If the customer number is null, there is nothing put in those fields, and the user can type whatever they want. If I actually had a variable with the same name as the field (like custname = custname in custlist whe custno = custno), the field would ALWAYS equal the variable and the user wouldn't be able to change it. If I have completely misunderstood what you're trying to do - I'm having one of those weeks - post back Dawn -----Original Message----- From: Marc [mailto:[EMAIL PROTECTED] Sent: Thursday, November 10, 2005 10:23 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Fw: Update current row Sorry I hit send instead of Spell Check and I didn't finish the post. Hi I thought there was a way to update the current row without having to list specific columns. I want to be able to update the current row without using columns in the where clause and I would like to be able to set a var = to a column on the current row. Thanks, sorry for the 1/2 post Marc
