Results 1 to 2 of 2

Thread: plz clarify this doubt

  1. #1
    Junior Member
    Join Date
    Jul 12
    Posts
    22

    Exclamation plz clarify this doubt

    i have one doubt , if i have to insert the values into the column such as "leavebalance" and that value will be come after subtract calculation of two different column from same table such as "maxleaveallowed " and "leavetaken".
    my question is - i have to insert as
    insert into Tablename (leavebalance) values (' "maxleaveallowed - leavetaken" ' ) where employeeID = 'something'
    this query doesnt work as i generate this query by my own logic , plz correct or give a perfect code query

  2. #2
    Junior Member
    Join Date
    Jul 12
    Posts
    22

    Re: plz clarify this doubt

    Quote Originally Posted by addycoolindia1 View Post
    i have one doubt , if i have to insert the values into the column such as "leavebalance" and that value will be come after subtract calculation of two different column from same table such as "maxleaveallowed " and "leavetaken".
    my question is - i have to insert as
    insert into Tablename (leavebalance) values (' "maxleaveallowed - leavetaken" ' ) where employeeID = 'something'
    this query doesnt work as i generate this query by my own logic , plz correct or give a perfect code query

    resolved

Posting Permissions

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