Answer / themba tjnas ngobeni

Hi, If you already know what record to pick then before
recommend what you need to do:

1. do you know how your table structure looks like? I guess
u know but do you have indexes build on your major select
columns?

2. irrespective of how many columns are there if you know
how to describe your table you will know which columns are
of importance to you.

With that I will recommend this:

Write your sql statement similar to:
1. Select *
From My_table
where major_column = :my_value --Primary key view all
columns

2. Select *
From My_table
limit 1 -- without primary key but view all columns

3. Select my_column1,my_column2,my_column3, etc
From My_table
where my_column1 like '%:my_value%' -- without using
primary key
limit 1

you can still write more sql statements to achieve the same
results if you want to be vendor specific like Oracle you
can use limit 1 or rownum =1 etc.

I hope this answers you questions.
Regards

what is the purpose of verify,update and debug modes in wr?

3 Answers   Accenture,

---

winrunner supports .NET technology or not?

4 Answers  

---

How we conduct Regression Testing through WinRunner

5 Answers   QA,

---

what is the difference between synchronization pt and wait statement. what are the advanatages and disadv..of context sensitive and analog recording

4 Answers   FCG,

---

Is it possible to place a Logical name in a data table and can use that logical name in the script? Tell me with mentioning function names..?

1 Answers   Accenture,

---

Name the three modes of running the scripts?

0 Answers  

---

Where to use the public or private functions in your script?

2 Answers  

---

What is the XML test cases creation?

0 Answers   IBM,

---

Name the different types of checkpoints?

0 Answers  

---

Explain the purpose of loading winrunner add-ins?

0 Answers  

---

what is the function key to toggle a breakpoint

1 Answers  

---

what is data driven framework?

6 Answers   EDS,

---