I've tried this over and over corrupting forms and decided to try it on
another pc. It worked first time. I noticed some strange anomolies in
RBDos a few weeks ago (things crashing that shouldn't, things not working
that should) and hadn't thought more of it.
For whatever reason my problem seemed to be hardware related.
Thanks you for the assurance that I hadn't lost my mind believing that ought
to work.
Dave
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Tom Grimshaw
> Sent: Wednesday, July 25, 2001 8:12 PM
> To: [EMAIL PROTECTED]
> Subject: Re: From form variable to column value
>
>
> 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.
>
