Results 1 to 6 of 6

Thread: problem with ado control find method !!!

Threaded View

  1. Aug 17th, 2003, 06:26 AM #1
    eranfox
    eranfox is offline

    Thread Starter
    Hyperactive Member eranfox's Avatar
    Join Date
    May 2001
    Posts
    492

    Unhappy problem with ado control find method !!!

    Hello Everybody,
    I'm using a ado data control and my problem is with the find method:
    VB Code:
    1. Adodc1.Recordset.Find sFieldName & " like '*" & Trim(txtSearchFor.Text) & "*'", , adSearchForward, 0

    txtSearchFor.Text is a text box

    when i'm searching on a string field i have no problem
    but...
    when i'm searching on a numeric field i get the following error:
    Run-time error '-2147217881(80040e27)':

    Find cannot be performed over the specified column,or compare
    operator is invalid.

    how can i use find on a numeric field ?


    please H-E-L-P!!!

    Thank you all in advance,
    ERAN
    Last edited by eranfox; Aug 17th, 2003 at 06:34 AM.
    Eran Fox
    ASSEMBLER,C,C++,VB6,SQL...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width