Greetings to all!!! Suppose there is a table Mother (ID, Name) and Child (ID, Name, Mother), Mother in the table Childis a relationship.
SQL
Last answer 26 October 2017
We are trying to convert some of our SQL Service Integration Service jobs from Visual Studio to Ensemble. If we execute a Stored Procedure within SQL Server Management Studio it is returning approx 12,000 rows.
Last answer 19 October 2017 Last comment 20 October 2017
Hi,
I have a class with around 400k lines and 60 columns. Class storage is Cache SQL storage (Mapped from a global).
I want to create multiple indices on certain fields.
Last answer 11 October 2017 Last comment 19 October 2017
The newer dynamic SQL classes (%SQL.Statement and %StatementResult) perform better than %ResultSet, but I did not adopt them for some time because I had learned how to use %ResultSet.
Last comment 18 October 2017
Hi World
I've a problem when in extract a float value from my database
the problem is that i get an interger instead of float.
Last answer 16 October 2017 Last comment 16 October 2017
HI,
I have a query like below but its syntax is not accepted by Cache.
I would like to perform a left join on two tables first and then make a inner for this result with another table.
Last answer 14 October 2017 Last comment 15 October 2017
I am pleased to announce that Release Candidates of Caché and Ensemble 2017.2 are now available.
Last comment 10 October 2017
I have a class that has a list property, which contains a list of other objects, and I want to join against it in SQL.
Last answer 4 October 2017 Last comment 4 October 2017
Hi, folks!
Is there any way to use $CASE or $SELECT functionality in SQL SELECT query?
E.g. something like this:
Last answer 30 September 2017 Last comment 30 September 2017
Hi, folks!
When you deploy DeepSee solutions you often do not want grant a User %All Role to work with a particular Dashboard.
Last answer 28 September 2017 Last comment 28 September 2017
Hi, i want to extract the timestamp values and order them low to hight , how can i do, you find here a screenchot of my batabase
Last answer 26 September 2017 Last comment 26 September 2017
hi world, i want to browse an sql table on cache, and get min ,max value from one collumn, how can i do it ?
thank's
Last answer 11 September 2017 Last comment 18 September 2017
Hi,
I'm developing an integration between Caché servers by ODBC conection, and I have the following problem.
In this call:
Last answer 6 September 2017 Last comment 7 September 2017
Is it possible to execute a sql update statement from objectscript? This code isn't working for me.
Last answer 5 September 2017 Last comment 6 September 2017
Hi everyone, I have a SQL service that is working fine, except I don't want it to run on a schedule or continuously. I'd like to only run when requested. Run once and then stop until another request.
Last answer 29 August 2017 Last comment 29 August 2017
I have a simple SQL service that does a simple select from an SQL database. After the select, I do an update to set the ProcessedFlag to "Y" for yes, so my next pass doesn't select records already processed.
Last comment 24 August 2017
I use %SQL.Statement. The original column names are not contained in the metadata.
Sample query:
Last answer 16 August 2017 Last comment 16 August 2017
I am currently working on a issue with WRC on one of my Inbound SQL Adapters not returning all the records it should be.
Last answer 20 July 2017 Last comment 14 August 2017
Hi guys.
I need validate a field string in a table. It needs have a specific mask
I want use regex + CASE expression
There is any function to this purpose in SQL?
Last answer 12 April 2017 Last comment 14 August 2017
I used Cache 2016.
I used the following statement to sort after paging, but suggested an error:
Last answer 14 August 2017 Last comment 14 August 2017
Is it possible to import a Cube from SQLServer (format .abf) in a Cache?
I have an .abf file and I want to open it in Cache. Is it possible?
Thanks
Last answer 1 August 2017 Last comment 29 July 2017
hi
I execute sql like this: select * from DHC_PatBillDetails where PBD_PBO_ParRef>='2046121'
Last answer 24 July 2017 Last comment 31 July 2017
I have a query string that I am creating programmatically, based on some user inputs. The user might search on 5 fields, or 8 fields, or no fields.
Last answer 18 July 2017 Last comment 20 July 2017
Hi,
Is it possible to use the value of a column that is populated by its own subquery, in the WHERE clause of the outer-query ?
The following fails (it does not parse syntactically):
Last answer 19 July 2017 Last comment 19 July 2017
Hello! So, my knowledge on the Cache database is extremely limited, and I was hoping I could find some assistance here. I'm connecting to the DB via ODBC.
Last answer 19 July 2017 Last comment 19 July 2017
