Hey there folks--
I've been away from foxpro for awhile.. too long, I guess.. I'm trying to pull some data into a listbox, but the 255-char limit on the SQL statement is getting in the way. I've tried basing the listbox on a query, but can't figure out how to add a WHERE clause programmatically. I've tried SET FILTER on the cursor, then requery on the listbox, but that just pulls the full dataset. I've tried a local view, but that's the same thing/result as the query. Can someone lend a hand? Here's the SQL...
Thanks
-- frank~
I've been away from foxpro for awhile.. too long, I guess.. I'm trying to pull some data into a listbox, but the 255-char limit on the SQL statement is getting in the way. I've tried basing the listbox on a query, but can't figure out how to add a WHERE clause programmatically. I've tried SET FILTER on the cursor, then requery on the listbox, but that just pulls the full dataset. I've tried a local view, but that's the same thing/result as the query. Can someone lend a hand? Here's the SQL...
Code:
SELECT Invoices.pkey, Invoices.dstartdate, Invoices.cinvoiceno, Clients.cname, TRANSFORM(NTOM(SUM(Items.rtotal)),"$9999.99") AS totalcost FROM clients INNER JOIN invoices INNER JOIN items ON Invoices.pkey = Items.ninvoicekey ON Clients.pkey = Invoices.nclientkey
GROUP BY Invoices.pkey, Invoices.dstartdate, Invoices.cinvoiceno, Clients.cname ORDER BY Invoices.cinvoiceno INTO CURSOR curlst
Thanks
-- frank~