var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: storing the value of a query
I have the following query which finds the max record number (I want to increment it by 1 using custom logic):
How can I assign the return value of this query to a string variable in code?
ie. MaxRecordNumber = "SELECT max([OrderID]) FROM Orders;"
A perfect use for the DMax domain aggregate function
Or use this, so it doesn't crash on an empty table (assuming MaxRecordNumber is a long integer)
MaxRecordNumber = DMax("OrderId", "Orders")
MaxRecordNumber = Nz(DMax("OrderId", "Orders"), 0)