M
Min
Hi,I have a query named LastInvoiceID: "Select top 1 InvoiceID From Invoice
Order by InvoiceDate Desc" which will return a single value.
Normally, I get this value using recordset. Is it possible to use just
something like DBEngine(0)(0).Execute to return the value,such as:
strInvoiceID = DBEngine(0)(0).Execute "LastInvoiceID"
I just want to make the code easy to read, is there anything like that?
Thanks!
Order by InvoiceDate Desc" which will return a single value.
Normally, I get this value using recordset. Is it possible to use just
something like DBEngine(0)(0).Execute to return the value,such as:
strInvoiceID = DBEngine(0)(0).Execute "LastInvoiceID"
I just want to make the code easy to read, is there anything like that?
Thanks!