Results 1 to 3 of 3

Thread: How to insert values without knowing field names

  1. Nov 6th, 2002, 11:19 AM #1
    VBOB
    VBOB is offline

    Thread Starter
    Member
    Join Date
    Mar 2000
    Posts
    57

    How to insert values without knowing field names

    I want to Insert Values into an existing record of an SQL table, without knowing the field names.
    Normally I do the following :
    "INSERT INTO tblA ([User],[Date]) VALUES ('A','B') WHERE <condition>"

    ....but in this instance I don't know the field names ([User],[Date]), I merely want to insert the values into the 2nd and 3rd fields.
    Reply With Quote Reply With Quote
  2. Nov 6th, 2002, 11:24 AM #2
    Justy
    Justy is offline
    Addicted Member
    Join Date
    Aug 2002
    Location
    Belfast, N. Ireland
    Posts
    167
    You could use the fields collection of the recordset:

    VB Code:
    1. rs.Fields(0) = "Hello World"
    www.digitalfront.co.uk
    Reply With Quote Reply With Quote
  3. Nov 6th, 2002, 11:25 AM #3
    seoptimizer2001
    seoptimizer2001 is offline
    Frenzied Member seoptimizer2001's Avatar
    Join Date
    Apr 2001
    Location
    Toledo, Ohio USA GMT -5
    Posts
    1,075
    Why wouldn't you know where you are putting the data? Can you just create a stored procedure then you have...
    VB Code:
    1. strSQL = "usp_ProcedureName 'A','B'"
    seoptimizer2001
    VB 6.0, VC++, VI, ASP, JavaScript, HTML,
    Perl, XML, SQL Server 2000

    If God had intended us to drink beer, He would have given us stomachs.


    Please use the [code] and [vbcode] tags in your posts!
    If you don't know how to use them please go HERE!

    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