mi lahko iz klica iz delphi komponente spišeš execute procedure v sqlu {:RETURNVALUE =…
- User
mi lahko iz klica iz delphi komponente spišeš execute procedure v sqlu {:RETURN_VALUE = CALL pHE_MoveItemUpdate (:cIsInsertItem, :cIsEmbal, :cAvtor, :chKey, :nhUserId, :chDocType, :dhDate, :dhDateInv, :dhDateVAT, :dhDateDue, :nhDaysForPayment, :chIssuer, :chIssuerStock, :chReceiver, :chReceiverStock, :chPrsn3, :chCurrency, :chDept, :chDeptOut, :chCostDrvOut, :chVerifiedPrices, :chWayOfSale, :nhFXRate, :nhRoundItem, :nhRoundValue, :chPriceRate, :nhValue, :nhCurrValue, :nhRebate, :nhDiscount, :nhTransport, :nhDuty, :nhDirectCost, :nhVAT, :nhVATIn, :nhForPay, :nNo, :cIdent, :cName, :cUM, :cOrigin, :cDeclarForOrigin, :cDeclarForOriginType, :cDept, :cCostDrv, :cLnkKey, :nLnkNo, :nWarrenty, :nDimWeight, :nDimWeightBrutto, :nDimVolume, :cAcctCR, :nQty, :nQtyTemp, :nPackQty, :nPriceCurrency, :nPrice, :nRebate, :nRebate1, :nRebate2, :nRebate3, :cVATCode, :nVAT, :cVATCodeTR, :nVATIn, :nBeatShare, :nTransport, :nDuty, :nDirectCost, :nFixPriceDiff, :nStockPrice, :nWSPrice2P, :nWSPrice2, :nWSPriceP, :nWSPrice, :nRTPriceP, :nRTPrice, :nSalePrice, :nRetailPrice, :nExciseP, :nExcise, :nInWSPrice2P, :nInWSPrice2, :nInWSPriceP, :nInWSPrice, :nInRTPriceP, :nInRTPrice, :nInSalePrice, :nIncTax, :nPVValue, :nPVDiscount, :nPVExcise, :nPVVATBase, :nPVVAT, :nPVForPay, :nPVOCValue, :nPVOCDiscount, :nPVOCExcise, :nPVOCVATBase, :nPVOCVAT, :nPVOCForPay, :nPVOCTransport, :nPVOCDuty, :nPVOCIncVAT, :nPVOCDirectCost, :nPVOCBeatShare, :nPVOCNonBeatShare, :nPVOCFixPriceDiff, :nPVOCStockValue, :nPVOCSuppExcise, :nPVOCSuppExciseIncSV, :nPVOCSuppExciseIncVB, :nPVOCSuppExciseNonIncVB, :nPVOCIncVATWoExc, :nPVOCVATBaseWoExc, :nPVOCForPayWoExc, :nPVOCBeatShareWoExc, :nPVOCNonBeatShareWoExc, :nUMToUM3, :cUM3, :cNote, :cSerialNo, :cError, :cStatus, :cIsMSUpdate, :nQtyConverted, :cUMConverted, :cUM2, :cAbortStockUpdate, :cAbortInsFromProdSt, :cTransfer, :cTransferKey, :nTransferNo, :cVATAllowChange, :nExciseInc, :nExciseNotInc, :nExciseIncP, :nExciseNotIncP, :cAcctClaim, :cUpdateOrderDispQty, :nStockValue, :nStockChange, :nStockIndex, :nStockQty, :nStockNewValue, :nVATAfterDeduction, :nValueAfterDeduction, :nVatValueAfterDeduction, :p_HasNoAuthorisation, :p_EntityType, :p_UniqueId, :p_PermissionName, :cDistributeCosts, :p_nOldNo, :p_nUMDecPlaces, :nRound, :p_cIsPOSX, :cWeighed, :nPOSXStock, :cErrorKos, :cStatusKos, :p_cStartInTransaction, :p_AllowAddOnDoc, :p_cCreatFromWO, :nRTPriceConverted, :cExemptFromVATSType, :nPayRebate, :nQId, :cContract, :nIdentQId, :nDeptQId, :nCostDrvQId)} :RETURN_VALUE(Integer,RESULT)= :cIsInsertItem(String[1],IN)='T' :cIsEmbal(String[1],IN)='T' :cAvtor(WideString[9],IN)='PrometPre' :chKey(WideString[13],IN)='2510000000001' :nhUserId(Integer,IN)=1 :chDocType(WideString[4],IN/OUT)='1000' :dhDate(DateTime,IN)=20.6.2025 :dhDateInv(DateTime,IN)=20.6.2025 :dhDateVAT(DateTime,IN)=20.6.2025 :dhDateDue(DateTime,IN/OUT)=20.6.2025 :nhDaysForPayment(Integer,IN/OUT)=1 :chIssuer(WideString[0],IN/OUT)='' :chIssuerStock(String[1],IN/OUT)='N' :chReceiver(WideString[22],IN/OUT)='Veleprodajno skladisce' :chReceiverStock(String[1],IN/OUT)='Y' :chPrsn3(WideString[0],IN)='' :chCurrency(WideString[3],IN)='EUR' :chDept(WideString[0],IN)='' :chDeptOut(WideString[0],IN)='' :chCostDrvOut(WideString[0],IN)='' :chVerifiedPrices(String[1],IN)='F' :chWayOfSale(String[1],IN)='K' :nhFXRate(Float,IN)=1 :nhRoundItem(Float,IN)=0,01 :nhRoundValue(Float,IN)=0,01 :chPriceRate(String[1],IN)='1' :nhValue(Float,IN/OUT)=0 :nhCurrValue(Float,IN/OUT)=0 :nhRebate(Float,IN/OUT)=0 :nhDiscount(Float,IN/OUT)=0 :nhTransport(Float,IN/OUT)=0 :nhDuty(Float,IN/OUT)=0 :nhDirectCost(Float,IN/OUT)=0 :nhVAT(Float,IN/OUT)=0 :nhVATIn(Float,IN/OUT)=0 :nhForPay(Float,IN/OUT)=0 :nNo(Integer,IN/OUT)=1 :cIdent(WideString[10],IN/OUT)='MATERIAL01' :cName(WideString[11],IN/OUT)='Material 01' :cUM(WideString[3],IN/OUT)='KOS' :cOrigin(WideString[3],IN/OUT)='124' :cDeclarForOrigin(WideString[0],IN/OUT)='' :cDeclarForOriginType(WideString[0],IN/OUT)='' :cDept(WideString[0],IN/OUT)='' :cCostDrv(WideString[0],IN/OUT)='' :cLnkKey(WideString[0],IN/OUT)='' :nLnkNo(Integer,IN/OUT)=0 :nWarrenty(Integer,IN/OUT)=12 :nDimWeight(Float,IN/OUT)=1,23 :nDimWeightBrutto(Float,IN/OUT)=3,215 :nDimVolume(Float,IN/OUT)=2,7 :cAcctCR(WideString[0],IN/OUT)='' :nQty(Float,IN/OUT)=0 :nQtyTemp(Float,IN/OUT)=0 :nPackQty(Float,IN/OUT)=0 :nPriceCurrency(Float,IN/OUT)=100 :nPrice(Float,IN/OUT)=100 :nRebate(Float,IN/OUT)=0 :nRebate1(Float,IN/OUT)=0 :nRebate2(Float,IN/OUT)=0 :nRebate3(Float,IN/OUT)=0 :cVATCode(WideString[2],IN/OUT)='B2' :nVAT(Float,IN/OUT)=20 :cVATCodeTR(WideString[2],IN/OUT)='NN' :nVATIn(Float,IN/OUT)=0 :nBeatShare(Float,IN/OUT)=1 :nTransport(Float,IN/OUT)=10,9605911330049 :nDuty(Float,IN/OUT)=11,0960591133005 :nDirectCost(Float,IN/OUT)=4,25701970443348 :nFixPriceDiff(Float,IN/OUT)=0 :nStockPrice(Float,IN/OUT)=0 :nWSPrice2P(Float,IN/OUT)=251,980906083554 :nWSPrice2(Float,IN/OUT)=444,6 :nWSPriceP(Float,IN/OUT)=254,672617915951 :nWSPrice(Float,IN/OUT)=448 :nRTPriceP(Float,IN/OUT)=262,853284350574 :nRTPrice(Float,IN/OUT)=458,3333 :nSalePrice(Float,IN/OUT)=550 :nRetailPrice(Float,IN/OUT)=550 :nExciseP(Float,IN/OUT)=0 :nExcise(Float,IN/OUT)=0 :nInWSPrice2P(Float,IN/OUT)=251,980906083554 :nInWSPrice2(Float,IN/OUT)=444,6 :nInWSPriceP(Float,IN/OUT)=254,672617915951 :nInWSPrice(Float,IN/OUT)=448 :nInRTPriceP(Float,IN/OUT)=262,853284350574 :nInRTPrice(Float,IN/OUT)=458,3333 :nInSalePrice(Float,IN/OUT)=550 :nIncTax(Float,IN/OUT)=0 :nPVValue(Currency,IN/OUT)=0 :nPVDiscount(Currency,IN/OUT)= :nPVExcise(Currency,IN/OUT)= :nPVVATBase(Currency,IN/OUT)= :nPVVAT(Currency,IN/OUT)= :nPVForPay(Currency,IN/OUT)= :nPVOCValue(Currency,IN/OUT)=0 :nPVOCDiscount(Currency,IN/OUT)=0 :nPVOCExcise(Currency,IN/OUT)= :nPVOCVATBase(Currency,IN/OUT)=0 :nPVOCVAT(Currency,IN/OUT)= :nPVOCForPay(Currency,IN/OUT)=0 :nPVOCTransport(Currency,IN/OUT)=0 :nPVOCDuty(Currency,IN/OUT)=0 :nPVOCIncVAT(Currency,IN/OUT)=0 :nPVOCDirectCost(Currency,IN/OUT)=0 :nPVOCBeatShare(Currency,IN/OUT)=0 :nPVOCNonBeatShare(Currency,IN/OUT)=0 :nPVOCFixPriceDiff(Currency,IN/OUT)=0 :nPVOCStockValue(Currency,IN/OUT)=0 :nPVOCSuppExcise(Currency,IN/OUT)=0 :nPVOCSuppExciseIncSV(Currency,IN/OUT)=0 :nPVOCSuppExciseIncVB(Currency,IN/OUT)=0 :nPVOCSuppExciseNonIncVB(Currency,IN/OUT)=0 :nPVOCIncVATWoExc(Currency,IN/OUT)=0 :nPVOCVATBaseWoExc(Currency,IN/OUT)=0 :nPVOCForPayWoExc(Currency,IN/OUT)=0 :nPVOCBeatShareWoExc(Currency,IN/OUT)=0 :nPVOCNonBeatShareWoExc(Currency,IN/OUT)=0 :nUMToUM3(Float,IN/OUT)=1 :cUM3(WideString[3],IN/OUT)='KOS' :cNote(WideString[0],IN/OUT)='' :cSerialNo(WideString[0],IN/OUT)='' :cError(WideString[0],IN/OUT)='' :cStatus(WideString[1],IN/OUT)='T' :cIsMSUpdate(String[0],IN/OUT)= :nQtyConverted(Float,IN/OUT)=0 :cUMConverted(WideString[3],IN/OUT)='KOS' :cUM2(WideString[3],IN/OUT)='KOS' :cAbortStockUpdate(String[0],IN)= :cAbortInsFromProdSt(String[0],IN)= :cTransfer(String[0],IN)='' :cTransferKey(WideString[0],IN)='' :nTransferNo(Integer,IN)=0 :cVATAllowChange(String[1],IN)='F' :nExciseInc(Float,IN)= :nExciseNotInc(Float,IN)= :nExciseIncP(Float,IN)=0 :nExciseNotIncP(Float,IN)=0 :cAcctClaim(WideString[0],IN)= :cUpdateOrderDispQty(String[1],IN)='T' :nStockValue(Currency,IN/OUT)= :nStockChange(Currency,IN/OUT)= :nStockIndex(Float,IN/OUT)= :nStockQty(Float,IN/OUT)= :nStockNewValue(Currency,IN/OUT)= :nVATAfterDeduction(Float,IN/OUT)=0 :nValueAfterDeduction(Float,IN/OUT)=0 :nVatValueAfterDeduction(Float,IN/OUT)=0 :p_HasNoAuthorisation(String[0],IN/OUT)= :p_EntityType(WideString[0],IN/OUT)= :p_UniqueId(WideString[0],IN/OUT)= :p_PermissionName(WideString[0],IN/OUT)= :cDistributeCosts(String[1],IN)='T' :p_nOldNo(Integer,IN)= :p_nUMDecPlaces(Float,IN)=0 :nRound(Integer,IN/OUT)= :p_cIsPOSX(String[1],IN)='F' :cWeighed(String[0],IN/OUT)= :nPOSXStock(Float,IN/OUT)= :cErrorKos(WideString[0],IN/OUT)= :cStatusKos(WideString[0],IN/OUT)= :p_cStartInTransaction(String[0],IN)= :p_AllowAddOnDoc(String[0],IN)= :p_cCreatFromWO(String[1],IN)='F' :nRTPriceConverted(Float,IN/OUT)=0 :cExemptFromVATSType(WideString[0],IN)= :nPayRebate(Float,IN)= :nQId(Integer,IN/OUT)= :cContract(WideString[0],IN/OUT)='' :nIdentQId(Integer,IN/OUT)=0 :nDeptQId(Integer,IN/OUT)=1 :nCostDrvQId(Integer,IN/OUT)=1
Assistant
Based on the provided Delphi component call, I'll help you create the corresponding SQL EXECUTE procedure statement. Here's the SQL version:
EXECUTE PROCEDURE pHE_MoveItemUpdate ( 'T', -- cIsInsertItem 'T', -- cIsEmbal 'PrometPre', -- cAvtor '2510000000001', -- chKey 1, -- nhUserId '1000', -- chDocType '2025-06-20', -- dhDate '2025-06-20', -- dhDateInv '2025-06-20', -- dhDateVAT '2025-06-20', -- dhDateDue 1, -- nhDaysForPayment '', -- chIssuer 'N', -- chIssuerStock 'Veleprodajno skladisce', -- chReceiver 'Y', -- chReceiverStock '', -- chPrsn3 'EUR', -- chCurrency '', -- chDept '', -- chDeptOut '', -- chCostDrvOut 'F', -- chVerifiedPrices 'K', -- chWayOfSale 1, -- nhFXRate 0.01, -- nhRoundItem 0.01, -- nhRoundValue '1', -- chPriceRate 0, -- nhValue 0, -- nhCurrValue 0, -- nhRebate 0, -- nhDiscount 0, -- nhTransport 0, -- nhDuty 0, -- nhDirectCost 0, -- nhVAT 0, -- nhVATIn 0, -- nhForPay 1, -- nNo 'MATERIAL01', -- cIdent 'Material 01', -- cName 'KOS', -- cUM '124', -- cOrigin '', -- cDeclarForOrigin '', -- cDeclarForOriginType '', -- cDept '', -- cCostDrv '', -- cLnkKey 0, -- nLnkNo 12, -- nWarrenty 1.23, -- nDimWeight 3.215, -- nDimWeightBrutto 2.7, -- nDimVolume '', -- cAcctCR 0, -- nQty 0, -- nQtyTemp 0, -- nPackQty 100, -- nPriceCurrency 100, -- nPrice 0, -- nRebate 0, -- nRebate1 0, -- nRebate2 0, -- nRebate3 'B2', -- cVATCode 20, -- nVAT 'NN', -- cVATCodeTR 0, -- nVATIn 1, -- nBeatShare 10.9605911330049, -- nTransport 11.0960591133005, -- nDuty 4.25701970443348, -- nDirectCost 0, -- nFixPriceDiff 0, -- nStockPrice 251.980906083554, -- nWSPrice2P 444.6, -- nWSPrice2 254.672617915951, -- nWSPriceP 448, -- nWSPrice 262.853284350574, -- nRTPriceP 458.3333, -- nRTPrice 550, -- nSalePrice 550, -- nRetailPrice 0, -- nExciseP 0, -- nExcise 251.980906083554, -- nInWSPrice2P 444.6, -- nInWSPrice2 254.672617915951, -- nInWSPriceP 448, -- nInWSPrice 262.853284350574, -- nInRTPriceP 458.3333, -- nInRTPrice 550, -- nInSalePrice 0, -- nIncTax 0, -- nPVValue NULL, -- nPVDiscount NULL, -- nPVExcise NULL, -- nPVVATBase NULL, -- nPVVAT NULL, -- nPVForPay 0, -- nPVOCValue 0, -- nPVOCDiscount NULL, -- nPVOCExcise 0, -- nPVOCVATBase NULL, -- nPVOCVAT 0, -- nPVOCForPay 0, -- nPVOCTransport 0, -- nPVOCDuty 0, -- nPVOCIncVAT 0, -- nPVOCDirectCost 0, -- nPVOCBeatShare 0, -- nPVOCNonBeatShare 0, -- nPVOCFixPriceDiff 0, -- nPVOCStockValue 0, -- nPVOCSuppExcise 0, -- nPVOCSuppExciseIncSV 0, -- nPVOCSuppExciseIncVB 0, -- nPVOCSuppExciseNonIncVB 0, -- nPVOCIncVATWoExc 0, -- nPVOCVATBaseWoExc 0, -- nPVOCForPayWoExc 0, -- nPVOCBeatShareWoExc 0, -- nPVOCNonBeatShareWoExc 1, -- nUMToUM3 'KOS', -- cUM3 '', -- cNote '', -- cSerialNo '', -- cError 'T', -- cStatus NULL, -- cIsMSUpdate 0, -- nQtyConverted 'KOS', -- cUMConverted 'KOS', -- cUM2 NULL, -- cAbortStockUpdate NULL, -- cAbortInsFromProdSt '', -- cTransfer '', -- cTransferKey 0, -- nTransferNo 'F', -- cVATAllowChange NULL, -- nExciseInc NULL, -- nExciseNotInc 0, -- nExciseIncP 0, -- nExciseNotIncP NULL, -- cAcctClaim 'T', -- cUpdateOrderDispQty NULL, -- nStockValue NULL, -- nStockChange NULL, -- nStockIndex NULL, -- nStockQty NULL, -- nStockNewValue 0, -- nVATAfterDeduction 0, -- nValueAfterDeduction 0, -- nVatValueAfterDeduction NULL, -- p_HasNoAuthorisation NULL, -- p_EntityType NULL, -- p_UniqueId NULL, -- p_PermissionName 'T', -- cDistributeCosts NULL, -- p_nOldNo 0, -- p_nUMDecPlaces NULL, -- nRound 'F', -- p_cIsPOSX NULL, -- cWeighed NULL, -- nPOSXStock NULL, -- cErrorKos NULL, -- cStatusKos NULL, -- p_cStartInTransaction NULL, -- p_AllowAddOnDoc 'F', -- p_cCreatFromWO 0, -- nRTPriceConverted NULL, -- cExemptFromVATSType NULL, -- nPayRebate NULL, -- nQId '', -- cContract 0, -- nIdentQId 1, -- nDeptQId 1 -- nCostDrvQId );This SQL statement maintains all the parameter values from your Delphi component call, converting them to the appropriate SQL format. I've added comments to make it easier to track which parameter is which.