Results 1 to 3 of 3

Thread: Databases

  1. #1
    Stanislaus Fernandes Guest

    Default Databases

    How do I insert records into a database table (MS-Access) using a variable e.g I have stored a string "computers" into a variable named "category". When I use the INSERT INTO statement, how do I substitute the variable name for the appropriate table.

  2. #2
    Join Date
    Dec 1969

    Default RE: Databases

    INSERT INTO SampleTab ( Name )<BR>SELECT "&#039" + Temp + "&#039";<BR><BR>When this statement is executed, u r prompted to enter a value for the variable that u have given.<BR>

  3. #3
    iyyappan n iyer Guest

    Default insert

    insert into table (field1,field2) values (&#039" & strvar1 & "&#039," & numvar1 & ")"<BR><BR>remember for strvariable u need surrounding single quotes

Posting Permissions

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