It is possible to transform a javax.persistence.Query into ArrayList .
I need to return an object of type Query but can not have all result values.
I want to delete some results based on some tests, the code is below.
I...
Have the query below.
SELECT
'A. ABERTOS' QUANTIDADE,
(SELECT SUM(S)
FROM
(SELECT COUNT(*) S
FROM VW_SOLICITACAO_DETALHE VW
INNER JOIN SOLICITACAO SOL ON SOL.ID_SOLICITACAO = VW.ID_SOLICITACAO
WHERE (VW.COD_TIPO_SERVICO IN (...
I have the following problem:
I need to analyze the differences between two databases, based on the existing tables and columns within these tables. My idea is to get the name of the columns inside the INFORMATION_SCHEMA of each bank and base...
Assuming I have two tables:
Car containing: plate, year, ect .. Event containing: car, lat, long, date, time, etc.
How could I return only the last entry of each car in the event table?
Hello,
I had some problems with a code in SELECT ...
example:
SELECT dados FROM banco WHERE CPF='$CPF' // com o código assim estava dando alguns erros pois o bd era em SQL e o Servidor windows.
The solution was:
SELECT CAST(C...
I have a table, which shows all data in the SQLite database. I wanted to sort by name all the data and present them. I have a hyperlink that calls a function to sort. The problem is that it does not work. How can I make it to the table, on the s...
I have the following Trigger generated in my database:
SET TERM ^ ;
CREATE OR ALTER TRIGGER ATUALIZA_CODNCM FOR EST_ADICIONAIS
ACTIVE BEFORE INSERT OR UPDATE POSITION 0
AS
begin
UPDATE est_adicionais
set id_ncm = (select ncm.id from est_ad...
I have a report in Crystal Reports where I should pass parameters to the search, however one of these parameters must be filled with a default value that is nothing more than a field of type memo of a view of the database. This field sh...
I have a dynamic map (at least I would like it to be), I wanted it to depend on the user, it introduced the coordinates (based on a form) I wanted and they were entered into the database ... so far so good. But then how did you introduce these c...
I have had some problems recently in making modifications to the approval environment and for bureaucratic reasons these modifications could not be inspected in the production environment and were done wrongly, causing a delay in identifying the...