Interested to Buy Any Domain ? << Click Here >> for more details...
Hi guys pls any one help me , I am facing this problem since
last one week ,
my question is
in there 1000 rows and 1000 coloums , i want to pick the one
record , how ?
- 1 Answers
- 4693 Views
- I also Faced
- E-Mail Answers
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
| Is This Answer Correct ? | 2 Yes | 2 No |
What are the advantages and disadvantages of Context sensitive and Analog Recording?
what is virtual object?
What in contained in the GUI map?
Hi,please help me out with my ques:in winrunner the object will be reconzined in the form of label or class.
where does WR records the information about objects in AUT?
What is the purpose of different record methods 1) record 2) pass up 3) as object 4) ignore.
can any one provide some testing material?
How do you view the contents of the GUI map?
In the system of coordinates used by WinRunner,the origin(0,0 coordinate)is located in the --- screen?
Whole application is taking as single html frame while recording and learning but i want to learn each textbox,text,links whatever the page have.If we click any link in one page that will show another page so i want to learn that pages objects also.I want navigation steps or guidence plz
When do you feel you need to modify the logical name?
How do you add a property to the checkpoint from the script?
WinRunner 
