Question Aditi Goswami · Jun 14, 2017

SQL Query for Range

Hello,

I have a question related to running an SQL query for range of data.

I am running a query like:

Select A,B from table_name where A>=12345 AND A<=12390

 - Where A and B are my two of the properties under the mentioned table/class definition

- A is an integer property

 Question: The result of the above query does not return me all the values between the mentioned range of integer though I do have all the values in that range. I see that some of the values are missing in result.

Any reason why this query won't work?

Any ideas?

Thanks,
Aditi

#Caché #SQL
9
0 573
Question Aditi Goswami · Dec 28, 2016

Private Property

Hello,

I read the Cache Documentation where it describes Private Property as below:

Specifies that the property is private. Private properties can only be used by instance methods of this class (or its subclasses).
A private property is not displayed in the catalog information (accessed by using %Library.SQLCatalog) and is not returned by a SELECT * query. However, you can explicitly refer to and use a private property in an SQL query.
 
Can someone please explain how to explicitly refer or use the private property in an SQL query?
Is there any other way to access any Private properties in SQL
#Caché #SQL
7
0 760