Dave -
In 16 years of working with RBase forms I have yet to see a form
fail to place the variable value in the column and then properly insert a
new row or update an existing row.
I have had problems getting them to display properly. Better look for
something else being wrong.
Bernie
=======================================
At 06:34 PM 7/25/2001 -0400, you wrote:
>Somewhere I'd read about having variable values returned as column values
>and I've found a case where I am not getting it to work.
>
>The form collects multiple rows on living situations for one month. The
>particular situation is based on a lookup table, and each situation has a
>numeric score attached.
>
>At the top of the form I use a combo box to collect the row ID
>(nonintelligent primary key) of the lookup record. That value is returned
>to a column (this works ok).
>
>However, I cannot get the score to write to the table when the record is
>saved.
>
>Two lookups based on one lookup action (the combo box): how should this
>work?
>
>The variables I'm using are:
>
>Table: EvLR
> 1. INTEGER ypid = .gvhhn (a earlier lookup: a client id from a CHOOSE in
>code)
> 2. INTEGER eid = .gveid (the admission id for the above client id, same
>method)
> 3. TEXT vfypname = (lname + ', ' + fname) from yp where ypid = .gvhhn
>(concatenation of the name, works)
> 4. INTEGER vflrid = lrid (set a variable equal to the lookup record
>number)
> 5. NUMERIC vfLRes = LRScore in DLres where val = .vflrid (looks up the
>score, this works in that the correct value is captured as shown by a SHOW
>VAR command after exiting the form).
> 6. NUMERIC Lres = .vfLres (sets the column = to the variable -- this does
>not work)
>
>The score field -- Lres -- is placed on the form. I tried placing the
>variable, got it to display, but could not get the value written to the
>table.
>
>Where do I go from here?
>
>tia
>
>Dave Ebert
>[EMAIL PROTECTED]
>
>
>
