AW: [sqlite] [ANN] SQLite ODBC driver version 0.67

[michael.hanssen]

Hi,

I just would like to point out that:

  - a zip-archive for the drivers (no-install) is not provided

  - the documentation for sqliteodbc.c / sqliteodbc.h is missing


Regards,
Michael


-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Christian Werner
Gesendet: Montag, 3. April 2006 18:19
An: sqlite-users@sqlite.org
Betreff: [sqlite] [ANN] SQLite ODBC driver version 0.67

Version 0.67 of the SQLite ODBC driver is ready for download
from http://www.ch-werner.de/sqliteodbc
It fixes some Unicode length issues with the SQLite 2.8.17
version of the driver and now fully supports binary data.
The Win32 version is now made with a MinGW cross compiler
and NSIS.

Enjoy,
Christian

AW: [sqlite] time zone?

[michael.hanssen]

Try select time('now', 'localtime');
Michael

-Ursprüngliche Nachricht-
Von: Stephen Leaf [mailto:[EMAIL PROTECTED] 
Gesendet: Freitag, 1. Juli 2005 15:47
An: sqlite-users@sqlite.org
Betreff: [sqlite] time zone?

sqlite select time('now');
13:45:20

$ date
Fri Jul  1 08:45:37 CDT 2005

anyone know what's wrong?

thanks,
Stephen

AW: [sqlite] SQLite 2.8.13. Issues found with SQLite.exe

[michael.hanssen]

Hi all, 

my tests found: 

Using a file test.sql and decommenting the .commands as required 
  -- + .databases 
  -- + .dump 
  -- + .echo ON 
  -- + .exit 
  -- + .explain 
  -- + .header ON 
  -- + .help 
  -- + .indices table 
  -- + .mode list 
  -- + .mode insert table 
  -- / .nullvalue 'nil' 
  -- + .output filename 
  -- + .output stdout 
  -- / .prompt '1' '2' 
  -- + .quit 
  -- + .read filename 
  -- + .schema 
  -- / .separator '-' 
  -- + .show 
  -- + .tables 
  -- + .timeout 1 
  -- + .width 10 10 

  select 'Hello, this is SQLite!', 123; 
with the command line 
  sqlite.exe test.db .read test.sql 
under WinNT shows, that the commands 
  .nullvalue, .prompt and .separator 
are not working a expected but providing an output like 
  unknown command or invalid arguments:  .command. Enter .help for help 
All other commands obviously are working allright. 


Michael Hanssen 


-Ursprüngliche Nachricht- 
Von: D. Richard Hipp 
Gesendet am: Dienstag, 9. März 2004 04:21 
An: rayB 
Cc: [EMAIL PROTECTED] 
Betreff: Re: [sqlite] SQLite 2.8.13. Issues found with SQLite.exe 

rayB wrote: 
 Seems that dot-commands (.output, .separator, .nullvalue, etc) are now being 
 rejected by SQLite.exe 2.8.13 when contained in files executed via the .read 
 command. 
  
 Error message text is: 'unknown command or invalid arguments:  output. 
 Enter .help for help' 
  

I tired it and everything appears to be working fine.  Please provide 
more details about the problem and I will look into it further. 


-- 
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565 


- 
To unsubscribe, e-mail: [EMAIL PROTECTED] 
For additional commands, e-mail: [EMAIL PROTECTED]