Contributions
Re: How do I navigate to a particular record in a table variable?
Yes, the relationship is 1 (patient) to many (address).Which is why I need them to match up. It has been hard trying to figure out how to dothis with Table Variable and inside Keyword tests. I'm not very familiar with TestComplete. I have found the same issue with Table variables as you and have to do a conversion to int in order to overcome it. I like the idea of doing two DDT instead of a DDT for the Patient and While loop for the Address. I will definetly try that out to see if it works. For now I'm not able to change the Table variable in this test suite because there is too much in changing things around. For future tests I'm not going to use the Table variable because of the limitations I've been having with it. It just doesn't work for what I need to do. Thank you very much everyone for answering my question and helping me get this figured out.1.6KViews0likes0CommentsRe: How do I navigate to a particular record in a table variable?
The table type is a TestComplete Table Variable. One table, the parent, has patient information in it and the second table, the child, has address information that is associated to the patient table. There can be 1 to many address information so I need to be able to iterate through these values or the particular MRNof the Patient. The MRN field is the PK, FK relationship between them. I have this set up in a KeyWord test. The Patient table has a data-driven loop around it. I'm doing a while loop around the Address table. I have a variable set up that has the current MRN number of the Patient table. The while loop is set up to go through the Address table while it's MRN is equal to the MRN variable that is set to the one currently in the Patient table.There is no problem with incrementingthrough the loops.Where I have the issue is that if I start the Patient table out where the MRN = 3 (which you can do with the data-driven loop, is start at any record number you want), the while loop for the Address table doesn't do anything because the current MRN is 1, not 3. I want to start the Address table at the same MRN as the Patient table.Basically like in a sql query, Select * from Address where MRN = 3 and then do a while loop around it so that it will go through till the MRN doesn't equal 3. Does that make sense? Since I'm dealing with the Table Variable I'm not sure how to get the cursor to start at a particular record in it.1.6KViews0likes3CommentsHow do I navigate to a particular record in a table variable?
I have a couple of tables that are related to one another and I need to select the particular records depending on the PK that is selected from the parent table. For example: Patient table has MRN, NameFirst, NameLast ... Address table has MRN, AddressID, Address1 ... There is a data-driven loop for the Patient table There is a while loop for the Address table where Address.MRN = Patient.MRN When I choose to start at a particular record in the Patient table, say record 3 which happens to be MRN = 3. The code for the While loop of the Address table is not recognized because the Address.MRN = 1, and not MRN = 3 that it needs to be. How do I force the Address table to start at Address.MRN = 3 record? I tried Call Object Method and looked at the Addres.Iteration, Value [Set], Address.MRN = Variable.MRN (which has the value of the current MRN working on). This didn't work.1.7KViews0likes6Comments