Hi All,

How can I get only one row using SPT? I could think of MaxRecords property but that if use it will be something like

=CURSORSETPROP("MaxRecords", 1, "MyCursor")

In this case, I guess the remote server would have already fetched the entire result into cursor "mycursor" resultset even though I am interested in the 1st record of the result set and causing network delay. Am I missing something here?

Thanks in advance

Regards
Vijay