Code: Select all
SELECT COUNT(*) FROM zzzzsys_debugThat would suggest that I induced the problem somewhere. In order to troubleshoot further, I need to know the difference between how nuBuilder draws an Edit Form upon selecting a record on a Browse Form and how it redraws the same Edit Form after saving changes made on the modal Arrange Objects window?toms wrote:It works just fine for me on an Edit Form.
Code: Select all
SELECT sum(total) AS total_due FROM (SELECT
IF(
Transactions.duration_type = 0,
Transactions.duration / 60 * IF(Matters.billing_type = 0, Matters.billing_amount, 0),
Transactions.duration * IF(Matters.billing_type = 0, Matters.billing_amount, 0)
) AS total
FROM
Transactions
LEFT JOIN Matters ON Transactions.Matters_id = Matters.Matters_id
WHERE
(
(
Transactions.Matters_id = '#record_id#'
) AND(Transactions.is_billable = TRUE)
)
UNION
SELECT
Expenses.expense_qty * Expenses.expense_amount AS total
FROM
Expenses
WHERE
(
(
Expenses.matterid = '#record_id#'
)
)
UNION
SELECT
Payments.Payments_amount * -1 AS total
FROM
Payments
WHERE
(
(
Payments.Payments_matters_id = '#record_id#'
)
)) AS tmp_tblCode: Select all
SELECT count(Matters.Matters_id) FROM Matters WHERE 1Hurray! That fixed it! Thanks Steven. Turns out there is a #record_id# Hash Cookie, but its value is not always updated like #RECORD_ID#.admin wrote:TonyD,
Try using #RECORD_ID# instead of #record_id#.
Steven