Hi everybody,

Can you please tell me what's wrong with Select-SQL and why it gives me 86 pages of Styles, while the supposedly same procedural code gives only 1 page of Styles?

The idea is to print all Styles with Reserved (customer's order) <= House Order + In_Stock (e.g items already in stock or ordered to be bring in stock with special type of order (ACC field) "HOUSE"). I added lSelectWay variable to switch between select way and old procedural way and I'm getting completely different results.

Thanks in advance.

UPDATE. For some reason I can not post code inside PRE tags using word Style. I'm not sure why and what should I do to fix it. I'll replace Style with cStyle and see, if it makes a difference for UT parser.

***********

Superficially it sounds like your SELECT is missing a JOIN or WHERE clause, and you're getting a partial Cartesian join.

As for the word "Style" that is a PITA here. You can't include it between any start or end tags. Also you need to be careful when using "greater than" and "less than" in expressions because text in between may be treated/parsed as a tag. Also if you have auto-quote set on you get the prior text prepended with "greater than" which can also lead to "tags" being parsed when added to any "less than" in your expressions.