Skip to content
TheChatArchiveThe Chat Archive
Claudeclaude-3-5-sonnet-20241022· AnthropicHugging Face LMArena Human Preference 140K

mi lahko iz klica iz delphi komponente spišeš execute procedure v sqlu {:RETURNVALUE =…

  1. 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

  2. Claude 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.