SELECT count (1) into :rowcount
FROM EXPENSE
WHERE EXPENSE_TYPE like 'O%' AND SUPPLIER=:supplier AND INVOICE_NO=:invoice;
如果是新增的话,那么SUPPLIER和INVOICE是不能同时存在一样的记录。
...全文
901打赏收藏
如何知道数据窗体是新增还是修改状态?
现在想用一个if判断数据窗体是新增还是修改,然后分别做不同的操作。 SELECT count (1) into :rowcount FROM EXPENSE WHERE EXPENSE_TYPE like 'O%' AND SUPPLIER=:supplier AND INVOICE_NO=:invoice; 如果是新增的话,那么SUPPLIER和INVOICE是不能同时存在一样的记录。