It sounds like you are trying to get your data the way we used to do in the old FoxPro days. When using a server based db (like Oracle or SQL Server), just put the "condidion" in the where clause of your sql. Then the db will give you back only the data you need.
Ex, your sample should look like this.
cnn.ConnectionString = "Provider=MSDAORA;Password=tiger;User ID=scott;Data Source=Pshop"
cnn.Open
rs.CursorLocation = adUseClient
string sql = "select * from DataTable where srno = '" + Left(Trim(inputdata), 14) + "'"
rs.Open sql, cnn, adOpenDynamic, adLockBatchOptimistic
HTH.
On 1/10/06, Sam Hansh <[EMAIL PROTECTED]> wrote:
>
> Hi All,
>
> Any one can help me nw i m using oralce on my application. i wan to use
> index & seek on my applicaiton but i m getting error the current provider
> not support index...
>
> this is my code
>
> cnn.ConnectionString =
> "Provider=MSDAORA;Password=tiger;User ID=scott;Data
> Source=Pshop"
> cnn.Open
> rs.CursorLocation = adUseClient
> rs.Open "select * from DataTable", cnn, adOpenDynamic,
> adLockBatchOptimistic
>
> rs.Index = "srno"'
>
> rs.Seek "srno = " & Left(Trim(inputdata), 14), adSeekAfter
>
>
> plz help me..
>
>
>
> ________________________________
> Yahoo! Photos
> Ring in the New Year with Photo Calendars. Add photos, events, holidays,
> whatever.
>
> ________________________________
> YAHOO! GROUPS LINKS
>
>
> Visit your group "AspNet2" on the web.
>
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
> ________________________________
>
>
>
--
______________________________
- David Lanouette
- [EMAIL PROTECTED]
SPONSORED LINKS
| Object oriented programming language | Object oriented | Programming languages |
YAHOO! GROUPS LINKS
- Visit your group "AspNet2" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
