I have a table named Teste de aluno and a call Parametros
I need to create a Query that compares if the test conforms to the Parameters
The problem is that the tables are not 100% similar
Test Table:
IDTESTE
PARAMETRO1
PARA...
I am creating a program that uses a database on file. I was told that SQLite is for this, I can create database with it and access per file. In the case then would I use the SQL or JDBC library to connect to this database? Does SQL already com...
I have 3 selects in my code where:
If the user enters the start date and end date, they will display the data between them.
If the user enters the invoice it will show the data with that note.
If the user selects the peripheral it will s...
I tried to do a left join in LINQ as follows:
(from opr in db.Operacao
join vol in db.Volume on new { VOL_CODBAR = opr.OPR_CODBAR } equals new { VOL_CODBAR = vol.VOL_CODBAR } into vol_join
from vol in vol_join.DefaultIfEmpty()
select new {...
I'm doing a loyalty system, and wanted to use two forms for clients , form1 with datagridview and a button to sign up and the other form2 with the data fields to be filled , this form2 would be triggered by pressing the form1 button, w...
Well, due to the exhaustion of my attempts to find the error, I will try to get a light here with you. Of course I apologize if the error is too generic and does not have the necessary infos.
But here goes a part of the scenario and the situa...
How do I get all rows using IN (), and inside the IN () have duplicate values
SELECT NOME FROM PESSOA WHERE ID IN (1,1,1,2,3,3,4)
I want to return 3 times the name of ID 1, and 2 times the name of ID 3.
Well, does anyone know how to get the sql executed in the POST of a query in insert mode?
For example, I have the student table with id and name:
begin
tblAluno.Insert;
tblAlunoID.asInteger := 1;
tblAlunoNome.asString := 'Carlos';...
I have a certain problem in "logic", where I should insert the records of two arrays into a table of the DB. Here I have the following situation:
At first if I check that tabela_p does not contain data. If it does not contai...