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 different actions are performed by find and show button?

1110

---

Explain the difference between gui map and gui map files?

1038

---

hi this is uday iam trying for testing job with 3+ yrs of exp if u have qtp faqs materil plz send me thanks in advance

2027

---

how can you explain your Real Estate Project in front of interviewer..? please step by step......

1614

---

How to force wr to learn the sub-items on a menu?

965

---

How do you execute your tests from windows run command?

1958

---

What is the extension of gui map file?

1329

---

How to have winrunner insert yesterdays date into a field in the application?

1011

---

two file is there how will compate it by useing qtp.

2228

---

what is the difference between toggle checkpoint and checkpoint?

5032

---

How do you find an object in an gui map.

1194

---

Explain the purpose of different record methods?

1096

---

Define parameterizing?

1022

---

How to get the resolution settings?

987

---

Name the two modes of recording?

1054

---