Pointers - Working with pointers returned from <TBL>.FIELD.GET()

[SNusa]

Re: Pointers - Working with pointers returned from &lt;TBL&gt;.FIELD.GET()

When you use table.current() you are accepting the default parameter of 1 which is the top level table in a set. You refer to lower level tables with their position number.

table.current(2)
table.current(3)
table.current(4)
etc.

When the onactivate event fires there is no current field. Try this for the onactivate event code.

delete obj
delete obj_table_ptr
delete obj_field_ptr

obj_table_ptr_name = ""
obj_field_ptr_name = ""
obj = parentform.this
obj_table_ptr = obj.table_get()
obj_table_ptr_name = obj_table_ptr.name_get()

[B][COLOR="#FF0000"]obj_field_ptr = this.this[/COLOR][/B]
obj_field_ptr_name = obj_field_ptr.name()

ui_msg_box("",""+obj_table_ptr_name)
ui_msg_box("",""+obj_field_ptr_name)

You should get messages telling you the name of the table and the name of the form.

You might try the same for the onarrive event of a form.

I found this iine of code very "intriguing."

I''m wondering why this doesn't work: vp_Field = vp_Field.NAME_GET().this (when used in the context of my OP)
~I know it's "redundant", but at first I thought it just might "technically" result in working code....

Actually, my thoughts are: It doesn't work because you can't re-associate the character field result (returned from NAME_GET()) back to a pointer reference. ~ In other words, "You can't associate a pointer when a character result is returned?"

Explained in another way: Reference to the pointer vp_Field is lost when the function/method NAME_GET() is performed on the pointer itself.)

[johngtatp]

Re: Pointers - Working with pointers returned from &lt;TBL&gt;.FIELD.GET()

Code:
delete obj
delete obj_table_ptr
delete obj_field_ptr

obj_table_ptr_name = ""
obj_field_ptr_name = ""
obj = parentform.this
obj_table_ptr = obj.table_get()
obj_table_ptr_name = obj_table_ptr.name_get()

obj_field_ptr = this.this
obj_field_ptr_name = obj_field_ptr.name()

ui_msg_box("",""+obj_table_ptr_name)
ui_msg_box("",""+obj_field_ptr_name)You should get messages telling you the name of the table and the name of the form.

You might try the same for the onarrive event of a form.

Stan,
I tried the above and the correct field name is displayed in the message box(great), but the first message box contains the primary table for the set(not so great). Having the field name, I thought you could get which table it is a field of but I cannot do it. I tried using .<OBJECT>.TABLE_GET() in the above but I could not get it to display the appropriate table. Any ideas for this?

[SNusa]

Re: Pointers - Working with pointers returned from &lt;TBL&gt;.FIELD.GET()

Are you supposed to delete an object variable before re-assigning it to point to another object? ~ I don't understand the significance of the delete statements... (I thought I had read it is is a bad practice to delete variables of any type, due to speed and efficiency considerations.)

[SNusa]

Re: Pointers - Working with pointers returned from &lt;TBL&gt;.FIELD.GET()

Are you supposed to delete an object variable before re-assigning it to point to another object? ~ I don't understand the significance of the delete statements... (I thought I had read it is is a bad practice to delete variables of any type, due to speed and efficiency considerations.)

How about my earlier idea above in post #12? (Setting a session pointer to the table using the onChange record event so you know which table was updated?) ~Then have each table call the same function (after setting and passing the pointer to the table... usingvp_tbl=table(current) to grab the pointer) to write to the log file.... ?

[johngtatp]

Re: Pointers - Working with pointers returned from &lt;TBL&gt;.FIELD.GET()

Robert,
I really need it to work in the onarrive event.

Here is what I am doing using action scripting on one field[5 tables on a form with one one-to-many browse]
(I have 40 other fields I want to use this on and this is why I want to make it a function)
On Arrive:
Manually set a variable to the field name, and one to the type of field, and one to a field title appropriate for a user to see.
Also, Set variable to value of field prior to change

On Change Event:
Set second variable to new value
Request PIN number of associate (If they have not made a previous PIN entry in the last minute)
If PIN is NOT valid, restores previous value and saves record
If PIN is valid
Saves the change – saves the time of the change(for the above 1 minute autologout)
Gets employee # from the PIN Table
Compares current value with previous value, they should be different, and if they are, writes a new record to an external table which saves the reservation number, employee number, date/time, and the field title and the previous value and the new value for auditing purposes.

This works great with action scripting, but I am trying to make it as universal as I can using a function. I know may have to set some variables with each individual field, but I was trying to get some of the information automatically. I have a dozen users with one terminal making many changes at a time. Much of the time is just looking at info and I didn’t want to force a login logout for each, it would be way too much of a pain. This way anyone can look at the data and if they need to make a change, they have to enter their PIN once as long as they make a change every 60 seconds. If this stirs up any new ideas, I would love to hear them.

Another big one is can you dim a variable using a variable for the type of field?

[Stan Mathews]

Re: Pointers - Working with pointers returned from &lt;TBL&gt;.FIELD.GET()

Another big one is can you dim a variable using a variable for the type of field?

tst = "C"

evaluate_template("Dim my_variable as "+tst)
? my_variable
= ""

? typeof(my_variable)
= "C"

Which of course means you can....

tst_type = "C"
tst_vName = "some_variable_name"


evaluate_template("Dim "+tst_vName+" as "+tst_type)

? eval(tst_vname)
= ""

? typeof(tst_vName)
= "C"

or

? some_variable_name
= ""

? typeof(some_variable_name)
= "C"

[johngtatp]

Re: Pointers - Working with pointers returned from &lt;TBL&gt;.FIELD.GET()

Stan, that helps. I was using eval only, never used eval template. Thanks for that one.

[Stan Mathews]

Re: Pointers - Working with pointers returned from &lt;TBL&gt;.FIELD.GET()

Evaluate_template is very near Eval in the wiki.

•EVAL Function
•EVALUATE_STRING Function
•EVALUATE_TEMPLATE Function
•EVALUATE_TEMPLATE_PRIVATE Function

[johngtatp]

Re: Pointers - Working with pointers returned from &lt;TBL&gt;.FIELD.GET()

Stan, it works with C but not anything else

dim vartype as c
vartype = "P"
?vartype
= "P"

evaluate_template("dim shared testt as"+vartype)
?typeof(testt)
= "C"

Thats what I got...

[Stan Mathews]

Re: Pointers - Working with pointers returned from &lt;TBL&gt;.FIELD.GET()

Works with all types I think. You need a space after as.

? "dim shared testt as"+vartype
= "dim shared testt asP"

? "dim shared testt as "+vartype
= "dim shared testt as P"

[johngtatp]

Re: Pointers - Working with pointers returned from &lt;TBL&gt;.FIELD.GET()

That was it, the space. Now if I can just solve the rest... ;)

[SNusa]

Re: Pointers - Working with pointers returned from &lt;TBL&gt;.FIELD.GET()

That was it, the space. Now if I can just solve the rest... ;)

Well, one of the things I'm thinking is you are going to have to put some code on all the "can" events to cancel the save (in the event pin is not good), right? ~Thad being said, why not put all the code on the can events of each table? (Including the call the to the function.)

That way, you're either updating the field and recording the the log file, or you're issuing a cancel to the edit, add, update...

[SNusa]

Re: Pointers - Working with pointers returned from &lt;TBL&gt;.FIELD.GET()

Anyone using this thread for reference: Code in thread title should read <TBL>.FIELD_GET()
(A hyphen should have been used (instead of the period) in the <TBL>.FIELD.GET() method) ~ See red underscore (corrected) above!