Variable

[forskare]

The form is based on the set with table2 linked to mama 1:1. Table2 contains the Lastname, Firstname and SSN fields as well as the corresponding. I'm trying to get the following code to work but keep getting the error message that Lastname is not found. I added the table2 name (Clients) so:

CASE find_by.value = "Clients->Lastname"

The variables Find_By and What_Value are also defined as Global variables on the form.

I also tried:

parentform.index_set("Last_Name")

Here's the code:

SELECT

CASE find_by.value = "Lastname"
Data_Entry.index_set("Last_Name")

CASE find_by.value = "Firstname"
Data_Entry.index_set("First_Name")

CASE find_by.value = "Ssnumber"
Data_Entry.index_set("Ssn")

end SELECT
Data_Entry.commit()
Data_Entry.find(what_value)

Thanks, kenn

[jkletrovets]

Re: Variable

Kenn

I see a couple things.

CASE find_by.value = "Clients->Lastname"

Putting quotes around this is telling the the equation to look for the literal character string of "Clients->Lastname" and not the field. That being said I think the order of the equation is reversed.

Try

CASE clients->Lastname = find_by.value

Although I never write it that way. I would use:

CASE Clients->Lastname=find_by or CASE Clients->Lastname=var->find_by

Regards,

Jeff

[G Gabriel]

Re: Variable

Either one of these should work:

clients->Lastname = var->find_by

Or:

find_by= clients->Lastname

Or:

clients->Lastname =find_by.value 'if find_by is an object in the form.

Or:

lastname.value=find_by 'if lastname is an object

Or:

lastname.value=find_by.value 'if both are objects

Or:

clients ->lastname=var->find_by

Or:

find_by= clients ->lastname

Or:

find_by=lastname.value 'if lastname is an object

Or:

find_by.value=lastname.value 'if both are objects

linked to mama

I thought they don't allow this kind of language on the board!

[forskare]

Re: Variable

Kenn

I see a couple things.


Putting quotes around this is telling the the equation to look for the literal character string of "Clients->Lastname" and not the field. That being said I think the order of the equation is reversed.

Try

CASE clients->Lastname = find_by.value

Although I never write it that way. I would use:

CASE Clients->Lastname=find_by or CASE Clients->Lastname=var->find_by

Regards,

Jeff

Hi Jeff,

The use of the " is straight out of A5 Help. I tried both suggestions; find_by.value was not found

and

var->find_by ended up with No such field.

Thanks for your response; I'm off to Gab's suggestions.

kenn

[jkletrovets]

Re: Variable

Thanks for your response; I'm off to Gab's suggestions.

G's suggestions are what I suggested (with a lot of variations).

BTW, thanks for the all the examples there G. I learned some stuff from them.

Regards,

Jeff

[Tim Kiebert]

Re: Variable

The form is based on the set with table2 linked to mama 1:1. Table2 contains the Lastname, Firstname and SSN fields as well as the corresponding. I'm trying to get the following code to work but keep getting the error message that Lastname is not found. I added the table2 name (Clients) so:
.....
.....
Thanks, kenn

I interpret from this that table2 is the child. If so it seems that you are trying to set an index for a child table using .Index_set(). I am reasonably sure that .Index_set only works on the primary table of the set. ie the parent. You could try topparent.QuickSortExplicit("Lastname")

[forskare]

Re: Variable

I interpret from this that table2 is the child. If so it seems that you are trying to set an index for a child table using .Index_set(). I am reasonably sure that .Index_set only works on the primary table of the set. ie the parent. You could try topparent.QuickSortExplicit("Lastname")

Hi Tim,

You are correct. I went through every suggestion Gabe suggested. None worked, not because what Gabe suggested was wrong but brcause you are correct.

I did a work around by:
1. Adding the Lastname and Firstname field to Table1.
2. Creating a set for entering data to include Table2 as the parent and Table1 as the child (son or daughter, Gabe's choice :D)
3. I then linked the 1:Many using a unique number, Lastname and Firstname. The unique # is really all that is needed but I included the others just to populate the fields in the new Table2.

Now, I can go back to the previous set and us the progressive lookups and variables as needed.

Thanks for your input. A special Thank You to Gabe for the numerous ways to get the job done.

kenn