Answer Posted / 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 boundary test?

1150

---

Name the two modes of recording?

1111

---

Define parameterizing?

1090

---

How to get the resolution settings?

1045

---

How do you clear a gui map files?

1189

---

How to do text matching?

1132

---

I want to do smoke test in my application but i have learnt the application before recording but im getting an error class name not found while running the script.I want to check each links and each text in my application. Can anybody answer my quesion plz.If it is possible i want test script for Yahoo login form with "New User" Login.

2179

---

Explain the purpose of loading winrunner add-ins?

1143

---

Explain the winrunner testing process?

1118

---

plz give me code or steps for pop up exception. or can u tell me how to pause test run for defining handler function?

2675

---

What is the use of gui map?

1132

---

What are the reasons that winrunner fails to identify gui object?

1034

---

what is the difference between toggle checkpoint and checkpoint?

5167

---

Hiiiiiiiii This is lavanya.....At present i m working as a MATLAB developer at CMC(A tata enterprise)from about1 year .now i want to move to testing field as a fresher?Is this possible...can anyone give me a suggestion regarding d testing field.....

2354

---

What are the platforms that WinRunner can be used?

2126

---