Results 1 to 3 of 3

Thread: Sql

  1. #1

    Thread Starter
    Hyperactive Member samsyl's Avatar
    Join Date
    Jun 2001
    Location
    London
    Posts
    338

    Sql

    rs.open (select * from tblname where fieldname='value')

    I want to declare above line in a variable and execute later.

    Thanks for help.

  2. #2
    PowerPoster
    Join Date
    Jan 2001
    Location
    Florida
    Posts
    3,216
    no need...just execute when you need it

  3. #3
    Junior Member
    Join Date
    Jul 2001
    Posts
    19
    dim sql as string
    sql="select * from tblname where fieldname='value'"

    cnn.execute(sql)

Posting Permissions

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



Click Here to Expand Forum to Full Width