dcsimg
Page 1 of 2 12 LastLast
Results 1 to 15 of 21

Thread: SQL-Error

  1. #1
    Join Date
    May 2007
    Posts
    3

    SQL-Error

    Hi..
    I am Inserting into a Table with sql interperter

    Create table myemployees_sp1511
    (firstname varchar(15),
    Lastname varchar(20),
    Title varchar(10),
    Age number(3),
    Salary number(8,2));


    myemployees_sp1511 created:
    firstname Lastname Title Age Salary


    insert into
    myemployees_sp1511
    (firstname, lastname,
    title, age, salary)
    values ('Jonie', 'Weber',
    'Sec', 28,
    19500);



    Error occured. Recheck your SQL statement


    could any one tell me where i am wrong..why i am not able to insert into the table.

    Rgds
    Geeta

  2. #2
    Join Date
    May 2007
    Posts
    13
    Hello are the column names case sensitive in the software you are using?

    You have created table column names using a mixture of capital and small case letters and you have been inconsistent in your insert statement.

    Maybe this helps. Please let me know.

  3. #3
    Join Date
    May 2007
    Posts
    3
    Pls can u try the sql statement and let me know.

  4. #4
    Join Date
    May 2007
    Posts
    13
    Try it yourself you lazy fool.
    You will never succeed if you don't have the most basic problem solving skills. This is nothing to do with language barriers simply about YOU as a person.

    You have the means and the time to develop your skills.

    This is not getyourassignmentdoneforfree.com

  5. #5
    Join Date
    May 2007
    Posts
    3
    this is fyi that i hv tired more than 50 times but still could not get it...and if u read my message clearly i asked just to try from ur end and let me know,moreover i didnt ask for the answer ...anyways be polite on forums and try to encourage others.

  6. #6
    Join Date
    Sep 2002
    Posts
    5,938
    Did you try this one?

    insert into
    myemployees_sp1511
    (firstname, Lastname,
    Title, Age, Salary)
    values ('Jonie', 'Weber',
    'Sec', 28,
    19500);

    That's what POS told you about case issue. Other people don't necessary have same environment like you have, so makes no sense to ask people test your code on their system.

  7. #7
    Join Date
    Jun 2007
    Posts
    1
    Well, it could be case sensitivity that was mentioned earlier by POS and he's probably right. But I think there are two other possibilities (very small ones) but it depends on your software. (Does it have a manual?)

    It could also be related to salary. I'm not familiar with the sql software that you are using but it might require you to imput data with accuracy up to two digits to the right of the decimal point (mantissa). For example, 19500.00

    Also, you included an age column that is using number data type with three digits. Does your software require three digits to be included. That would be an uncommon requirement.
    Also, I'm not sure three digits are necessary for age.

  8. #8
    Join Date
    Jun 2007
    Posts
    7
    he is right .I got same problem..I tried may be 20 times .. no way..its didnt work..

  9. #9
    Join Date
    Jun 2007
    Posts
    7
    please someone help me. please

  10. #10
    Join Date
    Sep 2002
    Posts
    5,938
    What's your statement and db collation? What was the error if got any?

  11. #11
    Join Date
    Jun 2007
    Posts
    7
    insert into
    myemployees_sp1511
    (firstname, Lastname,
    Title, Age, Salary)
    values ('Jonie', 'Weber',
    'Sec', 28,
    19500);
    this is not working..I tried many a times .no way..

  12. #12
    Join Date
    Sep 2002
    Posts
    5,938
    Got any error message?

  13. #13
    Join Date
    Jun 2007
    Posts
    7
    Error occured. Recheck your SQL statement

  14. #14
    Join Date
    Sep 2002
    Posts
    5,938
    What do you mean?

  15. #15
    Join Date
    Jun 2007
    Posts
    7
    Hi..
    I am Inserting into a Table with sql interperter

    Create table myemployees_ede
    (firstname varchar(15),
    Lastname varchar(20),
    Title varchar(10),
    Age number(3),
    Salary number(8,2));

    myemployees_ede created:
    firstname Lastname Title Age Salary


    insert into
    myemployees_ede
    (firstname, lastname,
    title, age, salary)
    values ('Jonie', 'Weber',
    'Sec', 28,
    19500);

    and I am getting this error

    Error occured. Recheck your SQL statement

Posting Permissions

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