[sqlite] drop, create and copy a table

2015-11-27 Thread Héctor Fiandor
Dear Mr. Smith and Dr. Hipp> Finally, I have an application that works, using your suggestions. Something is not working as I want, but finally, it works. Thanks very mucho for your help. Regards, Ing. H?ctor Fiandor hfiandor at ceniai.inf.cu -Mensaje original- De: sqlite-users-bounc

[sqlite] drop, create and copy a table

2015-11-26 Thread Héctor Fiandor
Dear Mr. Smith and Dr. Hipp: Thanks very much for your answers. I have learned a lot from your messages. Reviewing old message I found one from Mr. Smith that confirm this routines, that I have found previously but I miss something, and need to do all this in three "phases", I need to close the a

[sqlite] drop, create and copy a table

2015-11-25 Thread Héctor Fiandor
Dear Mr. Hipp and other members: I have a table where I have introduced a lot of information during 2015. In December 31, I have to select the records to be continue in 2016. Previously, I have obtained a copy of the 2015 table for any consult. In 2016, the year start with a table "cleaned" of t

[sqlite] drop, create and copy a table

2015-11-25 Thread Héctor Fiandor
Dear members: I have asked previously about this matter but nobody answer me. I have a table to be copied in another one with other name as a temp. Then I drop the first one. Then I create another one with same as the dropped table. Then I copy from the temp to the new created. I do all t

[sqlite] how to empty a table with sqliteEstudio-2.0.26

2015-11-02 Thread Héctor Fiandor
Dear fellows, I have obtained the sqliteEstudio-2.0.26 and I need to empty a table. Is possible with this program? If not, how to do? Thanks in advance, Yours, Ing. H?ctor Fiandor hfiandor at ceniai.inf.cu

[sqlite] from hfiandor about a unit in spanish

2015-10-26 Thread Héctor Fiandor
Dear Mr. Chrzanowski: I have found the solution in an easier way. Thanks to you, I will study your solution for others problems. Saludos, Ing. H?ctor Fiandor hfiandor at ceniai.inf.cu

[sqlite] from hfiandor about a unit in spanish

2015-10-25 Thread Héctor Fiandor
Dear Members: I have found the solution of my problem about "do the routines up to the error message appear. Then I close the table, and do an application.terminate. Then I start again but go to a phase2 routines, following the logical plan, generally up to the end of process." It was simple, "cli

[sqlite] from hfiandor about a unit in spanish

2015-10-22 Thread Héctor Fiandor
Dear Mr. Simon: First, thanks for learn to me that the list don?t admits attachments. Second, I am not sure that my problem if only with lazarus, the error messages appears when I try to copy a table to a transistory one, drop, and recreate the same table, and after that copy from the transistory

[sqlite] from hfiandor about a unit in spanish

2015-10-22 Thread Héctor Fiandor
Dear members: I use Lazarus for applications and SQLite for BD?motors, in spanish language. I have the attached unit to re-build a BD table that fulfill some conditions. I have found the way of a 2-phase to avoid an error message. Please, if you have a solution to do this task in a 1 phas

[sqlite] Copy, drop, create tables

2015-10-14 Thread Héctor Fiandor
I am using a SQLite tables and Lazarus with the information of the current year. I december 31, after finish all the current operations, we have to copy the information in others folders for savings, and empty the former ones for the new year. I have tried some routines (copy, drop, create, etc)

[sqlite] obtain a copy of a table

2015-10-06 Thread Héctor Fiandor
Dear fellows: I handle my applictions with Lazarus and use BD as sqlite. Sometimes I have to obtain a copy of an sqlite table and now I use the method of read and write, but I want to know if exists and SQL command that do the same with less efforts. Thanks for your suggestions Ing. H?ctor

[sqlite] sql query

2015-09-10 Thread Héctor Fiandor
Dear members: I am trying to use a SQL statement like this: fdm.tNegSerAct.SQL:='SELECT * FROM NegSerAct WHERE codNegSerAct >=desde AND codNegSerAct <=hasta ORDER BY codNegSerAct'; but the trouble is that the variables ?desde? and ?hasta? are strings and fixed previously. I

[sqlite] sqlite.dll

2015-09-03 Thread Héctor Fiandor
Dear members: Thanks very much. I have decided to start again other application from cero, and it is working well up to now. I expect to finish the copy of the app and hope it will work fine. Thanks again. Ing. H?ctor Fiandor hfiandor at ceniai.inf.cu

[sqlite] sqlite.dll

2015-09-03 Thread Héctor Fiandor
This is my first request to the list. I am using Lazarus and tables sqlite in an Application. It works fine. I don?t know what happens (sure I have clicked something) and now, when I clicked over the .lpi file, don?t charge Lazarus and a message appears asking for a file sqlite.dll. I don?t r