where are my global variables?

[Marion Wiffen]

Using the �on-save� event, and action scripting, (set variable(s) to field values - fields on a form), I have set up some global variables. When I step through them, they all hold the correct data.

�C_one� is a logical checkbox field, and if checked should (on the first loop) enter a surname into a field called �last_name� in a second table (see below)

This is somewhat simplified, but I hope explains the basis of the problem.

my difficulty is that I cannot find or identify or use the global variables from one table to enter data in a second table.

I cannot use a �dim C_one as L� statement since although it does not generate an error, it has no value,
If I just use �C_one� in the xbasic script, it brings up the error �c_one not found�

I guess that in neither case am I actually using the global variable I set up in the previous table.

I have been through the manuals, but cannot see the obvious, would really would appreciate a pointer.


----------------------------------------------------
For n = 1 to 2
SELECT
CASE C_one=.T.
Field one = �lastname�
CASE C_one =.T. .and. n>1
Field one = �cust_id�
Next n


Marion

[JerryBrightbill]

RE: where are my global variables?

If you define a global variable in a table structure definition, the variable is only created when you open the table the first time after the database is opened. If the table has not been opened, either directly or by opening a form, the global does not exist. For this reason, globals are frequently initially defined in an autoexec script.

Jerry

[Marion Wiffen]

RE: where are my global variables?

Jerry,

Thanks for your input. Yes you are right, but I seem to have found a solution as well.

You know how you suddenly figure it out whilst driving home, or whatever. It hit me at the intersection, and on testing it works fine

The problem was that I was using action scripting to set up variables in one table, then trying to use them in another table.

I then realised that if I set up the variables from within the table that needed them. but instead of selecting current form, I used "another" form for the fields, the form holding the data. it worked fine.

I sure hope that makes sense?

Anyway I really appreciate your reply, thanks again.

Marion

[Lenny Forziati]

RE: where are my global variables?

You also have a problem with
CASE C_one=.T.
Field one = "lastname"
CASE C_one =.T. .and. n>1
Field one = "cust_id"

The second block will never get executed because if c_one = .t., the first block is true and all of the rest of your case statements get skipped. You should review how select..end select works: http://support.alphasoftware.com/xbasic_reference/Language/select_..._case.htm

-Lenny

[Marion Wiffen]

RE: where are my global variables?

Thanks Lenny, will do.

[Marion Wiffen]

RE: where are my global variables?

Lenny, just an update.

CASE C_one=.T.
Field one = "lastname"
CASE C_one =.T. .and. n>1
Field one = "cust_id"

should have read

CASE C_one=.T. .AND. n=1
Field one = "lastname"
CASE C_one =.T. .and. n>1
Field one = "cust_id"

Works fine now, but I have one remaining hair puller which I am about to post, if you have any 'idle' time

Thanks MW