Dennis, To update a column of "Table A" with the column of "Table B" use the following command and also read more from R:Base help.
UPDATE NameOfTableA SET + FieldNameOfTableA=B.FieldNameOfTableB + FROM NameOfTableA A, NameOfTableB B+ WHERE A.CommonFieldName=B.CommonFieldName Regards Rehan Wyne MIT On Monday, September 22, 2014 11:27 PM, Dennis McGrath <[email protected]> wrote: You can replace this set error message 705 off drop cursor hm1 set error message 705 on Declare hm1 cursor for select eqphigh from eqphigh where dotnum=.mydotno open hm1 fetch hm1 into veqphigh indicator vind1 drop cursor hm1 with this SELECT eqphigh into veqphigh indicator vind1 from eqphigh where dotnum=.mydotno From:[email protected] [mailto:[email protected]] On Behalf Of Hodges, Dennis Sent: Monday, September 22, 2014 11:50 AM To: RBASE-L Mailing List Subject: [RBASE-L] - updating form field from another table I have a crew form that has an equipment number, beginning usage and ending usage. I want the user to be able to add a piece of equipment and when the equipment number is entered, (on exit of equipment number field), I want to look up the piece of equipment in another table and place the high usage value from that table into the beginning usage field. Here’s the code I have been using: getproperty vbegeqp text "mybegeqp" if mybegeqp is null then getproperty dotno text "mydotno" set error message 705 off drop cursor hm1 set error message 705 on Declare hm1 cursor for select eqphigh from eqphigh where dotnum=.mydotno open hm1 fetch hm1 into veqphigh indicator vind1 drop cursor hm1 SET var vbegeqp = .veqphigh endif return Dennis Hodges Maintenance Management Manager FDOT Office of Maintenance MS #52 PH: (850) 410-5635 FAX: (850) 410-5511 [email protected] As far as we know, our computer has never had an undetected error. Please note: e-mail may be subject to public disclosure.
