[sqlite] Uriel Carrasquilla/BOCA/NCCI is out biking and hiking.

I will be out of the office starting 08/12/2005 and will not return until 08/22/2005. If you need to send me a message, e-mail [EMAIL PROTECTED] I will check on a best effort basis. If it is urgent to call me, check my cell number with Judy. The information contained in this e-mail message

Re: [sqlite] determining all tables and fieldnames in a db

Try "select * from sqlite-master"; Regards, [EMAIL PROTECTED] NCCI Boca Raton, Florida 561.893.2415 greetings / avec mes meilleures salutations / Cordialmente mit freundlichen Grüßen / Med vänlig hälsning

Re: [sqlite] Multiple Tables on one Flat File

Got it. Thank you. Eric did point it out as well. In summary, do all my creates, then do all my prepares, then do all my executes with the dummy @bind (? ?) fields. Finally, I proceed to do my true executes and commits. Regards, [EMAIL PROTECTED] NCCI Boca Raton, Florida 561.893.2415

Re: [sqlite] Multiple Tables on one Flat File

Eric: thank you for your reply. I ended up creating a %dbh hash with $table as the index along with one Operating System file for each table. I was hoping there was a way not to create so many Operating System files because of the extra Administration they require. can you think of any way

Re: [sqlite] Multiple Tables on one Flat File

Follow up: If I create multiple $dbh as in $dbh{$tables}, and point each to a different Operating System (O.S.) flat file, then I am OK. LOOP-for-tables: $dbh{$tables} = DBI->connect('dbi:SQLite:' . $dbms_file . $table , "", "", { RaiseError => 1,AutoCommit => 0 });

[sqlite] Multiple Tables on one Flat File

I am running into a situation that does not make sense. I have allocated a flat file under the Operating System as follows (notice that autocommit is off): $dbh = DBI->connect('dbi:SQLite:' . $dbms_file , "", "", { RaiseError => 1,AutoCommit => 0 }); Then, I create

Re: [sqlite] HEllo All

If you need protection at the Operating System level for the file where the database resides, then, depending on whether is Linux/Unix or Windows you protect it the same way you protect any other file. Regards, [EMAIL PROTECTED] NCCI Boca Raton, Florida 561.893.2415 greetings / avec mes

Re: [sqlite] sqlitebrowser alternative

Andrea: thank you very much for your terrific contribution. Why don't you and Noel take this off-line. It seems to be something very specific to Noel's environment and may be the list is not the vehicle for such details. Regards, [EMAIL PROTECTED] NCCI Boca Raton, Florida 561.893.2415

Re: [sqlite] Contrib uploads

I use your product. I would be interested in getting the new version. Regards, [EMAIL PROTECTED] NCCI Boca Raton, Florida 561.893.2415 greetings / avec mes meilleures salutations / Cordialmente mit freundlichen Grüßen / Med vänlig hälsning

Re: [sqlite] database replication

sign me up please. Regards, [EMAIL PROTECTED] NCCI Boca Raton, Florida 561.893.2415 greetings / avec mes meilleures salutations / Cordialmente mit freundlichen Grüßen / Med vänlig hälsning Jay

Re: [sqlite] Re: [unclassified] Re: [sqlite] getting rid of dirty SQLITE_BUSY workaround

Keep It Simple, Keep It Small Foot Print. If the multi-access, multi writter can be implemented without compromising these two tenets, then great. Otherwise, let's use a different RDBMS. Regards, Uriel_Carrasquilla

Re: [sqlite] Remote apps reading and writing data to the same DB

John: Check out SQL Relay at http://sqlrelay.sourceforge.net/ It will do locks but you can lock/unlock really fast. Regards, [EMAIL PROTECTED] NCCI Boca Raton, Florida 561.893.2415 greetings / avec mes meilleures salutations / Cordialmente mit freundlichen Grüßen / Med vänlig hälsning

Re: [sqlite] Thanks!

can a similar argument be made for assembler? Regards, [EMAIL PROTECTED] NCCI Boca Raton, Florida 561.893.2415 greetings / avec mes meilleures salutations / Cordialmente mit freundlichen Grüßen / Med vänlig hälsning

RE: [sqlite] Good Graphical Tool for 3.x

Try: http://sqlite.org/contrib/download/sqlite3Explorer.zip?get=5 Regards, Uriel Carrasquilla "Tim McDaniel"

[sqlite] accessing Tables on a different Server

SQLiters: does anybody have a need to access SQLite Tables on a different server over the same LAN? how do you access such Tables? Regards, Uriel_Carrasquilla

[sqlite] Remote Access of SQLite Tables

elay.sourceforge.net/). Regards, Uriel_Carrasquilla

Re: [sqlite] tricky date time problem

Lloyd: Let me call a variable $seconds and perform your mod 60 and assign the results to $newSeconds: "$newSeconds = $seconds % 60". If you were to look at $newSeconds in the HH:MM;SS, you will find all your SS values were set to zero for each record. I am assuming that your SQLite Table

Re: [sqlite] What is the best way to store date value in sqlite

You can use SQLite for this purpose (instead of C) as described in http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions. I don't use C under Microsoft so I can't help you there (I only use C under Linux). I do know that making Jan 1, 1970 00:00:00 the same as 0 seconds, you could write

[sqlite] datetime column type, how-to

SQLiters: What would be the best method for creating a Table with one column in the format 03-Mar-2005 16:05:30? i.e. dd-mmm-yy hh:mm:ss I will need to retrieve by date/time in proper order. i.e. "select * from 'table' ORDER BY datetime-field". Thank you. Regards, Uriel_Carrasquilla

RE: [sqlite] Best way to check for existence of a table?

did you try: SELECT NULL FROM sqlite_master WHERE tbl_name = 'table'; Regards, [EMAIL PROTECTED] NCCI Boca Raton, Florida 561.893.2415 greetings / avec mes meilleures salutations / Cordialmente mit freundlichen GrÃÃen / Med vÃnlig hÃlsning

Re: [sqlite] Best way to check for existence of a table?

I got this from Witold Czarnecki: SELECT NULL FROM sqlite_master WHERE tbl_name = 'your-table'; Regards, Uriel_Carrasquilla "Richard Boyd" <[EMAIL PROTECTED]To: <sqlite-users@sqlite.org> .com>

Re: [sqlite] Best way to check for existence of a table?

I got this from Witold Czarnecki: SELECT NULL FROM sqlite_master WHERE tbl_name = 'your-table'; Regards, Uriel_Carrasquilla "Ri

RE: [sqlite] VACUUM question

A! very helpful indeed. thank you so much. Regards, Uriel_Carrasquilla Rani Pinchuk

RE: [sqlite] VACUUM question

My understanding is that a stupid question is the one not asked. Excuse my ignorance, but what is VACUUM? I've seen a couple of e-mails go back and forth and I feel silly not to know what you guys are talking about. Regards, Uriel_Carrasquilla

[sqlite] exact copy of an existing Table

SQLiters: what would be the most efficient method for creating an exact copy of an existing table with all the columns and data of the existing table? Regards, Uriel_Carrasquilla

Re: [sqlite] Adding a new field in sqlite

ALTER table-name ADD COLUMN column-name TYPE ... is not supported under SQLite. The best approach is to create a new table with the extra column and copy the existing table into it. Regards, Uriel_Carrasquilla

Re: [sqlite] CREATE TABLE $table_name (\%HASH)

iptname ERROR during EVAL=$cleanenv_sql: [EMAIL PROTECTED]" if ($@); # END #### Regards, Uriel_Carrasquilla

Re: [sqlite] Cursors

row->{oscode}, osname => $row->{osname}, availtm=> $row->{availtm}, sartm => $row->{sartm} }, { id => $row->{id} }) } ##

[sqlite] CREATE TABLE $table_name (\%HASH)

Question: I have a perl %HASH that contains the column names and type for the TABLE I am trying to create. HOW can I achieve such a task? I have looked into SQL::Abastract DBIx::Simple and DBI without any success. Regards, Uriel_Carrasquilla

[sqlite] Cursors

Hello list! I have run into problems trying to use SQLite via perl DBA. According to the SQLite.org web site, DECLARE CURSOR should be supported (actually, it is not in the list of the only SQL not supported). I get a error saying "error near DECLARE". I have tried to declare cursor in many