Results 1 to 4 of 4
  1. #1
    chyeeqi is offline Member
    Join Date
    Aug 2009
    Posts
    23
    Rep Power
    0

    Default java insert data into database problem

    i wan ensert data in to a database...the table contain a filed data type AutoNumber , i try with tis wat :
    Java Code:
    INSERT INTO Reception ( Patient)
    VALUES ("das");
    but fail.
    the table contain 2 field , there are
    No and Patient
    No 's data type is AutoNumber
    Patient 's data type is Text
    how can i make the sql statement??

  2. #2
    Eranga's Avatar
    Eranga is offline Moderator
    Join Date
    Jul 2007
    Location
    Colombo, Sri Lanka
    Posts
    11,371
    Blog Entries
    1
    Rep Power
    20

    Default

    Okay, what happen when you insert data? Did you get any error message, if so please post it here?

    What you've to do with semicolon at the end of your SQL query?

  3. #3
    chyeeqi is offline Member
    Join Date
    Aug 2009
    Posts
    23
    Rep Power
    0

    Default

    i d noe way to solve the problem

  4. #4
    Eranga's Avatar
    Eranga is offline Moderator
    Join Date
    Jul 2007
    Location
    Colombo, Sri Lanka
    Posts
    11,371
    Blog Entries
    1
    Rep Power
    20

Similar Threads

  1. Replies: 3
    Last Post: 03-19-2010, 01:59 AM
  2. Problem when insert Date to database(SQL)
    By hungleon88 in forum JDBC
    Replies: 6
    Last Post: 04-29-2009, 04:53 PM
  3. Replies: 3
    Last Post: 02-28-2009, 10:17 AM
  4. how to fetch 20,000 records from excel sheet & insert into access database using Java
    By santosh_tamse in forum JavaServer Pages (JSP) and JSTL
    Replies: 0
    Last Post: 02-22-2009, 11:24 AM
  5. How to insert java Object in oracle database
    By Thilkumar82 in forum Advanced Java
    Replies: 9
    Last Post: 08-13-2008, 12:33 PM

Posting Permissions

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