Select Expert produce incorrect result

[lndoan]

When i use the Select Expert to show only records that has the field LINE_DELETED='N', it removes this line as well as all lines that follows which are not marked with a 'N'. The field is a checkbox which is a YES or NO and I want to display all records that has no lines deleted. I'm thinking the issue may be with the joins because it seems like you cannot issue a select on a table that is join left.

 

[synapsevampire]

The field probably isn't a checkbox, that isn't a field type I've ever heard of.

It's probably stored as a boolean, but the best way to know is to right click the field and select browse data.

Now you'll know what's stored in there. It might be 0/1, or N/Y, or False/True, etc.

Rather than using the brain dead Select Expert, try using the Report->Edit Selection Formulas->Record and hand coding, you get more control.

Then check the Database->Show SQL Query to see what is being passed to the database.

Please include your software version in future posts.

And selects on LEFT OUTER joined tables are ceretainly allowed by every dataqbase that has a Left Outer, otherwise why would you have it as an option?

Sounds like you might want to read up on databases and SQL in general, it proves very useful when writing reports.

-k

 

[OrionStar]

Vampire, I must say that I've been having big problems with LEFT OUTER JOINS using INTERSYSTEMS CACHE SQL databases. Left outer join doesn't work, or doesn't work the way it should. It IS offered as an option, but when you choose it, you get an error saying that LOJ is not allowed or the SQL is incorrect.

Have you ever dealt with INTERSYSTEMS CACHE SQL DATABASES??

Anyway I was just reading and wanted to chime in.

Mike (aka CBMCLEANING)

Thanks:

MV

"What would you attempt to do... if you knew ... you could not fail?