>I using the following command to get minimum and Maximum Value
>
>SELECT MIN(pos) FROM Dummy where Pageno=3
>SELECT MAX(pos) FROM Dummy where Pageno=3
>
>When I use the above command It gives me Minimum & Maximum of the page but the result is shown as Query, I don't need the result to be shwn on screen as Query, I need the result to be stored in a Variable say MinResult and Maxresuklt, so that I can use it further in My code.
>
>How to do This ?
>
>Harsh
Since your conditions are the same, I suggest to use just one select statement, e.g.
select Min(pos) as MinPos, max(Pos) as MaxPos from Dummy where PageNo = 3 into array laMaxMin
lnMin = laMaxMin[1,1]
lnMax = laMaxMin[1,2]
If it's not broken, fix it until it is.
My Blog