Re[2]: [sqlite] offset 2F
Hello, Thursday, February 16, 2006, 7:52:12 PM, you wrote: dhc> That would be the least significant byte of the 4-byte dhc> schema-layer file format version number. Why is that dhc> important for you to know? My user writes, that cannot open a database. His "bad" file contains 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
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[2]: [sqlite] 3.2.7 and russian characters
Hello, Thursday, October 13, 2005, 7:15:46 PM, you wrote: dhc> The sqlite3_open() routine is suppose to accept the filename dhc> as UTF-8. There was a bug in earlier versions of SQLite that dhc> allowed ISO-8859-? names to be used. That bug was fixed. Probably dhc> your program 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
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
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 regards Sergey Startsev SQLite Analyzer - SQLite database management tool with GUI. http://www.kraslabs.com/sqlite_analyzer.html
Re: [sqlite] SQLite 3 + ADOdb
Hello Linas, It is not SQLite's problem. It is problem of ADOdb. Sunday, September 11, 2005, 8:14:44 PM, you wrote: LV> Hello, LV> I have a problem using SQLite 3 with ADOdb - SELECT query returns 0 results. LV> Everything you might want to know is here: LV> http://shirshegsm.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
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 Sergey Startsev SQLite Analyzer - SQLite database management tool with GUI. http://www.kraslabs.com/sqlite_analyzer.html
[sqlite] ANN: New version of SQLite Analyzer
Hello, I'm pleased to announce the new beta of SQLite Analyzer - New "Data Editor" allow to use "WHERE..., LIMIT.. OFFSET" clause. - Ability to view BLOB column as picture and as text. - Ability to load BLOB data from file or save to file and edit 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
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
Hello administrator, Tuesday, August 16, 2005, 5:01:23 PM, you wrote: a> Does anybody know a good/quick way to convert from V.Fox 8 .dbf to sqlite a> format ? I tried to export to .csv from Visual Fox , then to import into .db a> using SQLite Database Browser but it just takes to 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[2]: [sqlite] [ANN] SQLite Analyzer 3
Hello, Thursday, March 17, 2005, 7:48:09 AM, you wrote: >>From a quick look at sqlite analyzer, I would say the following : CM> 2. it has better looks than sqlite3Explorer In next SQLite Analyzer will have ER-model editor (such as ErWin, PowerBuilder). CM> 3. it cannot update tables using an editable grid approach SQLite Analyzer can it. May be it is a bug. I check it. CM> 4. it does not have a visual query builder On how many this feature seems to you important? CM> 5. I am not sure it has ADO import/export capabilities Now SQLite Analyzer hasn't import/export capabilities. -- Best regards Sergey Startsev SQLite Analyzer - GUI tool to manage SQLite databases. http://www.kraslabs.com/sqlite/
[sqlite] [ANN] SQLite Analyzer 3
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
Hello! SQLite Analyzer v 2.2.0 released. What's new in the version 2.2.0: - Index management. - Trigger management. - Database creating. - Database integrity checking. Download url http://www.kraslabs.com/sqlite/files/sqlanlz.exe Screenshots http://www.kraslabs.com/sqlite/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 PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] Ann: SQLite Analyzer v 2.1.0 released
Hello! SQLite Analyzer v 2.1.0 released. What's new in the version 2.1.0: - Table editing of the any size. - Fast scripts generation for commands INSERT, UPDATE, DELETE. Download url http://www.kraslabs.com/sqlite/files/sqlanlz.exe Screenshots http://www.kraslabs.com/sqlite/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]
[sqlite] Ann: SQLite Analyzer v 2.0.0 released
Hello! SQLite Analyzer v 2.0.0 released What's new in the version 2.0.0 - Visual table creating and modifying (add/change/delete columns, constraints etc) without data loss. - Query interrupting. - Database structure (tables, views, columns, types, indexes) displays in a 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 Sergey Startsev, KRASLabs http://www.kraslabs.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] LoadLibrary, ERROR_NOACCESS
Hello!
I am trying to load two copies of sqlite.dll at one time.
One - version 2.8.4, two - version 2.8.6
handle1:= loadlibrary('c:\2.8.4\sqlite.dll');
// this loaded OK
handle2:= loadlibrary('c:\custom\sqlite.dll');
// this return error
ERROR_NOACCESS (Invalid 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 PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
