Re[2]: [sqlite] offset 2F

2006-02-16 Thread Sergey Startsev
ontains value 01 on 2F offset. In the rest a "bad" and "good" files are identical. What is correct value? 04? -- Best regards Sergey Startsev SQLite Analyzer - SQLite database management tool with GUI. http://www.kraslabs.com/sqlite_analyzer.html

[sqlite] offset 2F

2006-02-16 Thread Sergey Startsev
Hello, What means one byte in a database file on offset 2F? -- Best regards Sergey Startsev SQLite Analyzer - SQLite database management tool with GUI. http://www.kraslabs.com/sqlite_analyzer.html

Re: [sqlite] SQLite -- Very Slow -- ??

2006-01-13 Thread Sergey Startsev
t PRAGMA synchonius. -- Best regards Sergey Startsev SQLite Analyzer - SQLite database management tool with GUI. http://www.kraslabs.com/sqlite_analyzer.html

Re[2]: [sqlite] 3.2.7 and russian characters

2005-10-14 Thread Sergey Startsev
is depending on the old (broken) behavior. Yes. I called sqlite3_open() with non UTF8 string. Thank you. -- Best regards Sergey Startsev SQLite Analyzer - SQLite database management tool with GUI. http://www.kraslabs.com/sqlite_analyzer.html

[sqlite] 3.2.7 and russian characters

2005-10-12 Thread Sergey Startsev
Hi all! Why 3.2.7 version can not open database with path that contains russian characters? -- Best regards Sergey Startsev SQLite Analyzer - SQLite database management tool with GUI. http://www.kraslabs.com/sqlite_analyzer.html

Re[2]: [sqlite] Storing RTF text in a field

2005-09-20 Thread Sergey Startsev
Hello, Use functions sqlite3_prepare(), then sqlite3_bind_blob to assign RTF text to a blob parameter Tuesday, September 20, 2005, 5:39:59 PM, you wrote: >> Now when I try to save it to database, I get an error: unrecognized token: >> "\". What should I do? -- Best reg

Re: [sqlite] SQLite 3 + ADOdb

2005-09-11 Thread Sergey Startsev
rshegsm.lt.eu.org/bardakas/adodb_sqlite LV> I don't know if it is SQLite's problem, so sorry if this is not the LV> right place to post this. LV> Regards, -- Best regards Sergey Startsev SQLite Analyzer - SQLite database management tool with GUI. http://www.kraslabs.com/sqlite_analyzer.html

Re: [sqlite] Simple question

2005-08-31 Thread Sergey Startsev
Hello Massimo, Wednesday, August 31, 2005, 7:19:27 PM, you wrote: MG> Is there any way to check if a table (in an opened database) exists? MG> Something smarter than "SELECT * FROM TABLENAME". ? Select * from sqlite_master where name = 'TABLENAME' -- Best regards

Re: [sqlite] Dates in sqlite3 databases and GUI tools

2005-08-24 Thread Sergey Startsev
Hello Serge, But if you use CURRENT_TIMESTAMP for default value, the time represents as string with format "-MM-DD HH:MM:SS". This format is more human readable :) -- Best regards Sergey Startsev SQLite Analyzer - SQLite database management tool with GUI. http://www.kr

[sqlite] ANN: New version of SQLite Analyzer

2005-08-21 Thread Sergey Startsev
BLOB data. You can download new version from our web site: http://www.kraslabs.com/files/sqlanlz3034.exe -- Best regards Sergey Startsev

Re[2]: [sqlite] Convert / Import

2005-08-16 Thread Sergey Startsev
Hello administrator, Tuesday, August 16, 2005, 6:06:41 PM, you wrote: a> Thank you ! That did it in 17 minutes. Not at all! -- Best regards Sergey Startsev SQLite Analyzer - SQLite database management tool with GUI. http://www.kraslabs.com/sqlite_analyzer.html

Re: [sqlite] Convert / Import

2005-08-16 Thread Sergey Startsev
much time (running for a> 2h50m now and still going, a ~ 2.000.000. rows each with 32 fields ) and a> hassle. Any quick way to do this ? You can try SQLite Analyzer http://www.kraslabs.com/sqlite_analyzer.html -- Best regards Sergey Startsev

Re: [sqlite] How to insert a string using C interface that contains both single and double quotes

2005-05-25 Thread Sergey Startsev
N> quotes. This insert works currently: INSERT INTO test (str) VALUES ('single ''quotes'' and double "quotes"') -- Best regards Sergey Startsev SQLite Analyzer - GUI tool to manage SQLite databases. http://www.kraslabs.com/sqlite_analyzer.html

Re[2]: [sqlite] [ANN] SQLite Analyzer 3

2005-03-16 Thread Sergey Startsev
ort/export capabilities. -- Best regards Sergey Startsev SQLite Analyzer - GUI tool to manage SQLite databases. http://www.kraslabs.com/sqlite/

[sqlite] [ANN] SQLite Analyzer 3

2005-03-14 Thread Sergey Startsev
Hello SQLite users, I'm pleased to announce the release of SQLite Analyzer. http://www.kraslabs.com/files/sqlanlz.exe -- Best regards Sergey Startsev SQLite Analyzer - SQLite database management tool with GUI. http://www.kraslabs.com/sqlite_analyzer.html

[sqlite] Ann: SQLite Analyzer v 2.2.0 released

2004-03-14 Thread Sergey Startsev
qlite/screen.html Member of sqlite list group have 20% discount. -- Best regards Sergey Startsev SQLite Analyzer - GUI tool to manage SQLite databases. http://www.kraslabs.com/sqlite/ - To unsubscribe, e-mail: [EMAIL PROT

[sqlite] Ann: SQLite Analyzer v 2.1.0 released

2004-02-17 Thread Sergey Startsev
qlite/screen.html -- Best regards Sergey Startsev SQLite Analyzer - GUI tool to manage SQLite databases. http://www.kraslabs.com/sqlite/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Network Probs with SQLITE.exe

2003-12-22 Thread Sergey Startsev
atabase MH> "y:\batadases\john.db": unable to open database y:\batadases\john.db << MH> If the database is on Win98 , there are no problems, only the MH> combination WinXP to WinXP does not work. May be NTFS permissions? -- Best regards Sergey Startsev SQLite Analyz

[sqlite] Ann: SQLite Analyzer v 2.0.0 released

2003-11-17 Thread Sergey Startsev
tree. - Database registration in SQLite Analyzer for fast access in future. - Query execution time displaying. - Quick access to object's sql-script. Download url http://www.kraslabs.com/sqlite/files/sqlanlz.exe Screenshots http://www.kraslabs.com/sqlite/screen.html -- Best regards Serge

[sqlite] LoadLibrary, ERROR_NOACCESS

2003-11-10 Thread Sergey Startsev
lid access to memory location) Why I can't load two copies of sqlite.dll? P.S. I use Delphi 7, windows 2000 -- Best regards Sergey Startsev, KRASLabs http://www.kraslabs.com - To unsubscribe, e-mail: [EMAIL

[sqlite] sqlite grammar

2003-10-28 Thread Sergey Startsev
Hello! Where can I get a sqlite's language grammar (for example, in Backus-Naur form) ? -- Best regards Sergey Startsev, KRASLabs http://www.kraslabs.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For addit