Friends, I decided to simplify the use of a system in Delphi , using banco de dados and the executable available in a file in pen drive .
With this, I have my tables in Access , and arranged in a DataModule with...
I have a routine where I update the local database with data from another database.
I simply run a DELETE and then INSERT INTO tblX (SELECT * FROM tblY (tblY is a linked table)) , as below.
The problem is that there is a time between DE...
In MS Access I have two tables: tbCourses and tbPeople
tbPeople contain: ID , Nome , CursoID , CursoNome ;
tbCourses contains: ID , Nome ;
Is it possible to make the field CursoNome of the tabl...
I need to make a simple update where I update the column "DiasPendentes" with the value of the current date minus the date of the column "DataAbertura".
"UPDATE tblPendencia SET DiasPendentes = (DATEDIFF(day, DATAABERTURA, DATE())) WHERE Pende...
I am using% co.de% of .Net to create a project as a learning base for BD with C #. I chose an easier way that would be to work most of the time in design mode through dataAdapters . The battle I face is to insert the current date into a DB...
We're migrating signatures from an Access database to Mysql, but before migrating I need to treat some parts of the data. I need:
Remove duplicate id's
Return the highest value of the date field for these id's
In the librecalc itself it...
I have a C # solution with access database that accepts SELECT, but does not accept INSERT or UPDATE, Follow insert button code:
OleDbConnection con = new OleDbConnection();
con.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;DataSourc...
I have a project that adds and deletes dates, to add I have the following code:
Set dbs = CurrentDb
dbs.Execute " INSERT INTO TMP " _
& "(diaMes) VALUES( " _
& "'" & tmp7 & "') "
where tmp7 is the date in dd-mm-...
Hello, I would like a command in SQL for a query in an Access database.
The structure of the table is: tbList
Id | Nome | Genero | Endereco | Estado | ...
The result you would like to group by state and count the number of gender (sex)...
I have a method to compress my base Access , however when I run the program I get the following error:
Error:
The exception to catch is this message: {"Retrieving the COM class factory for component with CLSID {DE88C160-FF2C-11...