Re: Using if clause with SQLQuery

null@example.com (DriveSoft) — Fri, 31 Aug 2018 10:23:58 +0000

Hello.

Please provide more info about your question.

Using if clause with SQLQuery

null@example.com (thezimguy) — Thu, 30 Aug 2018 22:53:01 +0000

Hello Dmitry and MVD users,
Please what will be the right way to achieve this

if SQLQuery('SELECT sellprice,buyprice,quantity FROM stock WHERE id=' + frmProPur.cbProduct.sqlvalue, Results) then//No error from database or query
   begin
   frmProPur.edSellPrice.text := Results.FieldByName('sellprice').AsString;
   frmProPur.edBuyPrice.text := Results.FieldByName('buyprice').AsString;
   frmProPur.edQtyAvail.text := Results.FieldByName('quantity').AsString;
   frmProPur.edTotal.Value :=    Results.FieldByName('buyprice').AsFloat * frmProPur.edQty.Value;
   end
   else//if there is error with connection, query etc
    ShowMessage(sellPrice);

Regards

My Visual Database — Using if clause with SQLQuery

Re: Using if clause with SQLQuery

Using if clause with SQLQuery