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

Dear all i am new to testing my company using vb.net and we are developing web based application. How i can test those application with winrunner if any one have some good tutorial or link kindly provide thanks u.

2139

---

Have you ever created a start-up script?

1182

---

How should we write and execute a user define function using WinRunner.

2142

---

How do you call windows APIs, explain with an example?

2067

---

Name the two modes of recording?

1107

---

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.....

2349

---

How do you load GUI map?

1177

---

Without the gui map, use the phy desc directly?

1046

---

What is tsl? What 4gl is it similar too?

1258

---

What happens when the gui map file get loaded?

1219

---

Name the different types of checkpoints?

1104

---

Which function to use to compare the application date with system date?

1994

---

How do you handle unexpected events and errors?

1123

---

How do you copy and move objects between different gui map files?

1202

---

How to read the third party controls in the application

2004

---