Recent content by schizek

Not a problem. Thank you for all your help! And thank you too, Casper!

This is ABL. The buffer solution did work for me. However, perhaps there is a better way to do it. I am writing a report in Webspeed to display a list of all orders with skus that are allocated at a particular warehouse. To get the actual allocated quantity for each sku I need to muliply the...

I need to pull the same column (ex: table1.field1) from a table based on different criteria in nested queries. I am having a problem because when I run the second query I can't access the value of table1.field1 because there is already a table1.field1 in the first query.

Is there a way to assign a field as a different variable name inside the query? I need to pull the same column based on different parameters from the same table. In SQL I would use an alias like "SELECT alias1.field1 FROM table1 AS alias1". Is there any way to do that or something similar in...

Excellent... that did it. Thank you!

I am passing user selected variables through a multi-select listbox. I need to get these variables into an array to then use in my dynamic query. Currently it appears they are concatenating each selected option together in a comma separated string. Any ideas on how to get them into an array...