Re: [sqlite] SQLite syntax diagrams

On Oct 3, 2008, at 8:48 AM, D. Richard Hipp wrote: > http://www.sqlite.org/draft/syntaxdiagrams.html > http://www.sqlite.org/draft/syntax.html > > Comments, criticism, and error reports are welcomed - particularly if > they are received in time to be addressed prior to the release of > 3.6.4, curre

Re: [sqlite] Visual Basic Programming to SQlite

Depends on what version of VB and what type of data access underpinnings you're using. If it's ADO.NET, you'll want to use the free open-source SQLite ADO.NET provider from http://sqlite.phxsoftware.com Robert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf

Re: [sqlite] Visual Basic Programming to SQlite

Steven Charest <[EMAIL PROTECTED]> writes: > > I am a Visual Basic programmer who would like to port the Access Database > over to SQlite. Is there any documentation on how to use this database with > Visual Basic? I am difficulty finding any documentation on it. You can use my ADO-like wrappe

Re: [sqlite] Visual Basic Programming to SQlite

Dim Records Dim Database dim Recs AddObject "newObjects.sqlite3.dbutf8", "Db" set Database = Db 'Open the database On Error resume next If DataBase.Open(Get_Database_Name) Then DataBase.AutoType = True DataBase.TypeInfoLevel = 4 Else MsgBox "ERROR ON OPEN OF DATABASE: " & DataBase.last

[sqlite] Visual Basic Programming to SQlite

I am a Visual Basic programmer who would like to port the Access Database over to SQlite. Is there any documentation on how to use this database with Visual Basic? I am difficulty finding any documentation on it. Thanks ___ sqlite-users ma

Re: [sqlite] SQLite syntax diagrams

On Oct 3, 2008, at 4:59 PM, Alexey Pechnikov wrote: > Hello! > > Which do "exec xv $name.gif &"? XV is an image viewer for X11. http://en.wikipedia.org/wiki/xv has more information. The command above displays the GIF after it has been generated from the canvas image. You can substitute "d

Re: [sqlite] SQLite syntax diagrams

Hello! Which do "exec xv $name.gif &"? For my debian lenny host there is no xv utility but with # if {$do_xv} { #exec xv $name.gif & # } all work fine. Best regards, Alexey. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org

Re: [sqlite] SQLite syntax diagrams

Hello! В сообщении от Friday 03 October 2008 23:10:40 D. Richard Hipp написал(а): > On Oct 3, 2008, at 1:55 PM, Petite Abeille wrote: > > Out of curiosity, how did you generate those diagrams? > > A Tcl/Tk script generates the diagrams into a canvas widget. The > script is at: > > http://ww

Re: [sqlite] SQLite syntax diagrams

On Oct 3, 2008, at 1:55 PM, Petite Abeille wrote: > > Out of curiosity, how did you generate those diagrams? A Tcl/Tk script generates the diagrams into a canvas widget. The script is at: http://www.sqlite.org/docsrc/artifact/894 After each diagram is rendered on screen, the script use

Re: [sqlite] SQLite syntax diagrams

On Oct 3, 2008, at 4:48 PM, D. Richard Hipp wrote: > http://www.sqlite.org/draft/syntaxdiagrams.html > http://www.sqlite.org/draft/lang.html > > Comments, criticism, and error reports are welcomed - particularly if > they are received in time to be addressed prior to the release of > 3.6.4, curre

Re: [sqlite] SQLite syntax diagrams

Page http://www.sqlite.org/draft/lang_droptable.html add "and triggers" after "All indices". Add a "caution note" => Note: It is possible to drop a table while there are views that reference that table. Regards, Noah -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTEC

Re: [sqlite] SQLite syntax diagrams

I quickly read through the pages and have the following comments: page http://www.sqlite.org/draft/lang_explain.html, last sentence of the second paragraph after the diagram is missing "sqlite would have used to execute the command had the EXPLAIN QUERY PLAN keyword not been present". page http

Re: [sqlite] SQLite syntax diagrams

On Oct 3, 2008, at 10:48 AM, D. Richard Hipp wrote: > http://www.sqlite.org/draft/syntaxdiagrams.html > http://www.sqlite.org/draft/syntax.html Bad link. Should have been: http://www.sqlite.org/draft/lang.html > > > Comments, criticism, and error reports are welcomed - particularly > if the

[sqlite] SQLite syntax diagrams

http://www.sqlite.org/draft/syntaxdiagrams.html http://www.sqlite.org/draft/syntax.html Comments, criticism, and error reports are welcomed - particularly if they are received in time to be addressed prior to the release of 3.6.4, currently scheduled for Oct 15. D. Richard Hipp [EMAIL PROTECT

Re: [sqlite] sqlite on flash devices

I was thinking of setting up similar experiments; nice idea hooking the MTD layer to count erase cycles.. I'm going to keep 1st implementation simple and just use sqlite direct to flash, no memory cache. Then I can measure the performance.. We should be using a flash controller that does wear le

Re: [sqlite] sqlite on flash devices

I thikn you mean supplying a sqlite3_vfs to the sqlite3_open_v2 call; will look into it. Anyone know where there are examples of this? - -Paul On Fri, 2008-10-03 at 01:03 +0400, Alexey Pechnikov wrote: > Hello! > > I'm using SQLIte on a few dozens winmobile devices a few years. It's work >

Re: [sqlite] sqlite on flash devices

-- -Paul ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users