Charlie
The details are a little fuzzy right now, but I remember some distinction between refreshing forms based on a table vs refreshing variable forms. Just for ha has copy your form and base it on a dummy table and see what happens with the exact same code.
DAwn
-------------- Original message from Charles Parks <[EMAIL PROTECTED]>: --------------
The browse command shows the change.The form is variable. I'm wondering if there needs to be some sort of form refresh issued. This form also has a menu bar and if I go to click one of those options the variable is updated upon that click. It is just when I leave the form untouched and wait on the timer that I don't get the desired value. The clearing of the variable and setting it to null before running the select statement but getting the previous result before the null seems to be the most interesting part.
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Lustig
Posted At: Tuesday, October 28, 2008 1:49 PM
Posted To: RB7-L
Conversation: [RBASE-L] - RE: [BULK] [RBASE-L] - Re: Lookup Variables in Timer
Subject: [RBASE-L] - RE: [BULK] [RBASE-L] - Re: Lookup Variables in TimerInsert a BROWSE of KeepStaffOutBGU right before that SELECT statement and make sure the table contains what you think it contains. -- Larry
From: Charles Parks <[EMAIL PROTECTED]>
To: RBASE-L Mailing List <[email protected]>
Sent: Tuesday, October 28, 2008 2:36:52 PM
Subject: [RBASE-L] - RE: [BULK] [RBASE-L] - Re: Lookup Variables in Timer
I have changed the variable name but seem to be getting the same result.SELECT AllowIn, OkayToBeInBGU, KeepStaffOutBGURecNo +
INTO fAllowIn INDICATOR fiAllowIn, +
fOkayToBeInBGU INDICATOR fiOkayToBeInBGU, +
fKpStfOutBGURecNo INDICATOR fiKpStfOutBGURecNo +
FROM KeepStaffOutBGU +
WHERE ForceOut = .fForceOutI'm using V-8.
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Lustig
Posted At: Tuesday, October 28, 2008 11:40 AM
Posted To: RB7-L
Conversation: [BULK] [RBASE-L] - Re: Lookup Variables in Timer
Subject: [BULK] [RBASE-L] - Re: Lookup Variables in Timer
Importance: Low<<SELECT AllowIn, OkayToBeInBGU, KeepStaffOutBGURecNo +INTO fAllowIn INDICATOR fiAllowIn, +
fOkayToBeInBGU INDICATOR fiOkayToBeInBGU, +
fKeepStaffOutBGURecNo INDICATOR fiKeepStaffOutBGURecNo +
FROM KeepStaffOutBGU +
WHERE ForceOut = .fForceOut>>Charles:The variable name "fKeepStaffOutBGURecNo" exceeds the R:Base limitation of eighteen characters, and is probably causing the SELECT statement to fail. Presumabely your're seeing the value in the other variables that you initialized elsewhere.--Larry
