G'day Dave,
I set col names to var in a form same as you are trying to do and
it saves OK, so your logic is valid re the method.
Have you tried running the form with TRACE and see if it throws
an error message?
Is the form called single instance, one row of data (if so, an UPDATE
after the form closes will save the value) or can the user scroll
through rows?
Is it possible to put a SAVEROW entry eep in the field after the
var is set to see if it then updates?
At 18:34 25/07/01 -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.
Warmest regards,
Tom Grimshaw
coy: Just For You Software
tel: 612 9552 3311
fax: 612 9566 2164
mobile: 0414 675 903
post: PO Box 470 Glebe NSW 2037 Australia
street: 3/66 Wentworth Park Rd Glebe NSW 2037
email: [EMAIL PROTECTED]
web: www.just4usoftware.com.au
This email and any files transmitted with it are confidential to the
intended recipient and may be privileged. If you have received this email
inadvertently or you are not the intended recipient, you may not
disseminate, distribute, copy or in any way rely on it. Further, you should
notify the sender immediately and delete the email from your computer.
Whilst we have taken precautions to alert us to the presence of computer
viruses, we cannot guarantee that this email and any files transmitted with
it are free from such viruses.
