A very simple SQL
SELECT field1 F1, count(field2) CntF2
FROM GCT.PA_Data
where field1 is not null
group by field1
gives an error back:
SQL
Last answer 6 days ago Last comment 5 days ago
Dear all,
In our application made in Caché object script, when we deploy some classes modified we have the option of calling "Purge queries" feature of Caché.
Last answer 6 days ago Last comment 7 days ago
I have a persistent class that represents cities across the United States. It is below, but basically has a City Id, Name, Lat, Lon and a few other unimportant fields for this issue. Anytime I attempt to query o
Last answer 10 days ago Last comment 10 days ago
I am trying to use %INLIST in SQL query using a cursor and the query fails to return results. It appears that the variable I use against %INLIST returns an empty string.
Last answer 3 December 2018
Hello everyone,
I try excuting a SQL Query like this SELECT ID, CompanyName FROM Company WHERE CompanyName LIKE 'condition'
Last answer 29 November 2018 Last comment 29 November 2018
When using the JSON_OBJECT() function in Caché SQL on a %String property that contains JSON syntax, it converts the %String into a JSON object instead of escaping it as a string literal. How can I prevent this?
Last answer 20 November 2018 Last comment 28 November 2018
Hi
Is this a bug? We came across it on an older version of Cache but I've also just tried it in version "Cache for Windows (x86-64) 2017.2.2 (Build 865U)" and got the same result.
Last answer 22 November 2018 Last comment 22 November 2018
Hi,
Most of my classes are mapped from Globals. I want to access Cache classes from a BI software through ODBC connection.
Last answer 10 November 2018 Last comment 12 November 2018
Hello,
I have been trying to pull data through a linked server in SSMS from an InterSystem Cache Database for a while, this is to enable us to join the data to other source systems in our Data Warehouse.
Last comment 1 November 2018
What is the difference between %ID and ID in a database table? Both seem to reference the same column labelled ID.
For context, I am trying to create a viewer class for an existing persistent class.
Last answer 30 October 2018
Hello everyone,
I want to fill data into my select component with sql request and parameter.
Last answer 19 October 2018 Last comment 19 October 2018
I have a ZEN page with nine tablepanes. Each tablepane queries a table in the same SQLServer db.
Last answer 18 October 2018
I have created a view to stage some data in a different format and then want to reference that view in a SQL query from a table that filters the data from the view using a property of the table.
Last answer 17 October 2018
Hi,
I am trying to have the output of a field in sql have double quotes around them. The script is in Studio and I am accessing It through a task.
I have tried """"tect"""" and others...Please help
Last answer 11 October 2018 Last comment 12 October 2018
I'm running this code in our application, and in the terminal:
>set query="SELECT * FROM PMG_Data_Private.RemitInstance WHERE (VoucherNumber %INLIST ? SIZE ((10)))"
Last comment 9 October 2018
Hello,
I have a question about creating properties with curl.
I already did create properties in Java with the following command.
Last answer 4 October 2018 Last comment 4 October 2018
I would like to know , if its safe to use %NOLOCK in insert query while doing some parallel processing in Ensemble. We will have pool size of more than 1 for a business process.
Last answer 3 October 2018
SQL gateway.
It is not "compiling" correct the properties(get; set;) in the class, and generating 2 methods of :
GetuProperty and SetuProperty.
Last comment 12 September 2018
Hi Community!
We are pleased to invite you to the upcoming webinar "Taking Control of Your SQL Performance" on 12th of September at 11:00 a.m. EDT!
Last comment 10 September 2018
SQL gateway.
There is a basic problem with sql gateway,
while building the proxy methods, with:
Last answer 5 September 2018 Last comment 5 September 2018
Hi all,
We have a big problem because we have the following message when I try to open the messages in a production.
ERROR <Ens>ErrException: <DATABASE>zfindStatement+29^%SQL.DynamicStatement.1 ^%sqlcq("MYNAMESPACE","Query",8,"Gns8AZO5dJclytqv13l9gUuLUyo=",""),c:\intersystems\healthshare\mgr\cache\ -- logged as '-' number - @''
SOURCE ELEMENT: %ZEN.Component.tablePane (resultsTable)
Last answer 5 September 2018 Last comment 5 September 2018
Is there a way to lock at the record level? I know that you can lock at the table level:
Last answer 27 August 2018
Hi I've got a service setup to query a sql server via ODBC.
I've got all the parameters etc setup and everything is ok
My Query is
Last comment 20 August 2018