Qsqlquery problem [Solved]



  • @
    void company_db::delete_item(int itmn)
    {
    QSqlQuery dlt_itm("delete from item where item_no= ?? ");
    }
    @
    how should i compare itemn(int) to item_no(int ) attribute of item table ? Because i have to pass itmn as a string within QsqulQuery constructor ??



  • that was very simple Ques. i got the ans
    @
    void company_db::delete_item(int itm_no)
    {
    QSqlQuery del_item;
    del_item.prepare("delete from item where item_no=(:tag)");
    del_item.bindValue(":tag",itm_no);
    del_item.exec();
    }
    @
    sry for disturbance ...



  • hi,
    pls set the thread to solved.
    edit the topic header and write [Solved] in front of it!
    br


Log in to reply
 

Looks like your connection to Qt Forum was lost, please wait while we try to reconnect.