[sqlite] ISO 8859

Hello, I had this guy email me about a problem about using ISO8859 character . He has this in the DB Handhilfsbetätigungssatz but when queried using my wrapper it returns Handhilfsbet..tigungssatz When using SQLITE.EXE the results are displayed fine. When I debug the code the char *

RE: [sqlite] Sqlite Secure backup

Hi David, I have been thinking about developing a backup/restore as part of my wrapper. It would be great to have all of these features compatible. I really wanted to backup the database and then have the ability to restore just one table or the entire DB. What do you think? Maybe we should

RE: [sqlite] sqlite with Visual Basic

and XML. You can pragmatically send it a array and bind to that. With the ODBC driver, I'm not a big fan of installing drivers (ODBC) during setup or supplying them with the application. That's why the wrapper I wrote doesn't use them. A & G Software Quality software with Style

RE: [sqlite] sqlite with Visual Basic

Hi Carlos, Sorry mate I didn't point out the wrappers on Sqlite.Org http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers Greg > -Original Message- > From: Jalil Vaidya [mailto:[EMAIL PROTECTED] > Sent: Friday, 14 May 2004 11:13 AM > To: Carlos Garces; [EMAIL PROTECTED] > Subject: Re:

Re: [sqlite] row size limit

don't. Greg - Original Message - From: Puneet Kishor To: SQLite Sent: Monday, April 19, 2004 10:41 AM Subject: Re: [sqlite] row size limit On Apr 18, 2004, at 7:31 PM, Greg Obleshchuk wrote: > Hi Richard, > You know that is the first clear and concise

Re: [sqlite] row size limit

Hi Richard, You know that is the first clear and concise explanation of why not to store large blobs in a database that I have heard anywhere. Greg - Original Message - From: D. Richard Hipp Cc: [EMAIL PROTECTED] Sent: Monday, April 19, 2004 9:50 AM Subject: Re: [sqlite]

Re: [sqlite] Adding SQL commands

Hi Basil, The first use of IF is same syntax as the case statement so I don't think it is required and as IF isn't SQL92 I doubt it will be included so your command is replaced by case when (select count(*) from foo) = 100 then 'good' else 'bad' end I like the idea of exist but then again you

Re: [sqlite] New Web site

: Greg Obleshchuk To: [EMAIL PROTECTED] Sent: Monday, April 12, 2004 8:53 AM Subject: [sqlite] New Web site Hi Everyone, (I know this is off subject) I have finished a new web site dedicated to SQL Scripts for database system. I am looking for people to lodge there useful

[sqlite] New Web site

Hi Everyone, (I know this is off subject) I have finished a new web site dedicated to SQL Scripts for database system. I am looking for people to lodge there useful (and not) scripts onto the system . If you are looking for scripts try here first. There some useful stuff like the SQL-99

Re: [sqlite] A proposal for SQLite version 3.0

I think the collate feature will solve this. have a pre-defined collate TEXT_CI is the solution. One thing Microsoft allows you to do is create a database with a defined collation. Maybe this is the idea around the parameters in the open API . You could open a DB with COLLATION TEXT_CI and

Re: [sqlite] A proposal for SQLite version 3.0

Hi Will, Thanks for clearing that up for me, it make more sense now. Greg - Original Message - From: Will Leshner To: Forum SQLite Sent: Monday, April 12, 2004 8:06 AM Subject: Re: [sqlite] A proposal for SQLite version 3.0 On Apr 11, 2004, at 3:01 PM, Greg Obleshchuk

Re: [sqlite] A proposal for SQLite version 3.0

Hello, I just read the proposed changes and they seem fine. A couple of thing. The data types I think are great but can we have a large and small integer? I noticed some people (embedded systems people) complain about this. I quite happy with the large type but as integers will now be

Re: [sqlite] Group by only returning one row when source table is sub-query or view

table, which is slow. Greg. - Original Message - From: D. Richard Hipp Cc: [EMAIL PROTECTED] Sent: Friday, April 02, 2004 8:28 AM Subject: Re: [sqlite] Group by only returning one row when source table is sub-query or view Greg Obleshchuk wrote: > > I posted

[sqlite] va_list

Hi , Can anyone tell me if you can manually create a va_list object. I have in my wrapper now the sqlite_vmprintf function but as .NET doesn't support the ... as a parameter I had to use a [ParamArray] . Currently I am testing the number of parameters passed and calling sqlite_vmprintf

Re: [sqlite] Re: SQLite Logos?

a darker image part does, it highlight the mean (in terms of mySQL the freedom ) In terms of the SQLite the feature is obviously the Lite indicating light footprint ) Anyway I think it's a great. Greg - Original Message - From: Allan Edwards To: 'Greg Obleshchuk' ; 'D. Richard Hipp

Re: [sqlite] Re: SQLite Logos?

I love that logo! - Original Message - From: D. Richard Hipp To: Karl Timmermann ; [EMAIL PROTECTED] Sent: Sunday, March 28, 2004 9:36 AM Subject: [sqlite] Re: SQLite Logos? Karl Timmermann wrote: > > Do you know of any "Powered By SQLite" type logos that might exist,

[sqlite] Search results

Hi Everyone, This is a tiny bit off subject, so sorry. I have a search page on my web site which when used will search the database for results. I want to be able to rank the results in best match first order. In the database I will have three columns where I will be searching for matches , my

[sqlite] Information Schema Views

Hello All, I have created a new wiki page off the main wiki page called Information Schema. Here is the link http://www.sqlite.org/cvstrac/wiki?p=InformationSchema The SQL standard INFORMATION_SCHEMA views are a standard way of retrieving schema information from any SQL standardised database.

Re: [sqlite] which files to compile...

Hi Peter, Which OS are you using? I have the latest compiled LIB for Windows on my system I could send you. regards Greg - Original Message - From: "Peter Lau" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 12, 2004 8:16 AM Subject: [sqlite] which files to compile...

[sqlite] Bad Database file

Hi, I just checked a database which was giving me problems using PRAGMA integrity_check; and discovered it was corrupt. sqlite> PRAGMA integrity_check; *** in database main *** List of tree roots: invalid page number 24 List of tree roots: invalid page number 23 What would be the reasons for a

Re: [sqlite] Re: [inbox] Re: [sqlite] Primary key and index

Thanks for clearing that up Greg - Original Message - From: D. Richard Hipp To: [EMAIL PROTECTED] Sent: Tuesday, February 10, 2004 11:52 AM Subject: Re: [sqlite] Re: [inbox] Re: [sqlite] Primary key and index Greg Obleshchuk wrote: > > So in these

Re: [sqlite] Re: [inbox] Re: [sqlite] Primary key and index

- Original Message - From: D. Richard Hipp To: Greg Obleshchuk Sent: Tuesday, February 10, 2004 9:29 AM Subject: Re: [sqlite] Re: [inbox] Re: [sqlite] Primary key and index Greg Obleshchuk wrote: > > Select * , Product_Description.ProductName from

[sqlite] Re: [inbox] Re: [sqlite] Primary key and index

an index on the a column if it is an autonumber(identity ) column if I was using this column in joins or where clauses. regards Greg - Original Message - From: Michael Hunley To: Greg Obleshchuk Sent: Tuesday, February 10, 2004 6:49 AM Subject: Re: [inbox] Re: [sqlite

Re: [sqlite] OK to drop support for legacy file formats?

Hello, Why not remove the feature but create a seperate utility project that converts any version of SQLITE DB to the latest version. In this way SQLite can be just what it is small and fast. There would be a tool from the orginal source which you would know would work and simple to use. The

Re: [sqlite] Query optimization help

Hi Richard, try this SELECT DISTINCT p.poster_id AS has_posted, t.id, t.subject, t.poster, t.posted, t.last_post, t.last_post_id, t.last_poster, t.num_views, t.num_replies, t.closed, t.sticky, t.moved_to FROM topics AS t ,

Re: [sqlite] Best method to create a database with a tree structure?

Hi Martin, You are talking about standard Parent/Child relationships here but because you have unlimited number of entries you fold it into one table and have a Parent_ID column. So if you have your required details as being these columns Name SomethingElse Then a standard table might be

Re: [sqlite] How to link under Windows

Erik, You will need to use one of the .Net Wrappers or the .NET data providers. http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers regards Greg O Erik Jälevik wrote: I'm just about to write some code using SQLite from Visual Studio .NET under Win XP. I am however, not sure how I go about linking

[sqlite] New wiki page for Performance Tuning

Hi All, I just created a new wiki page off the wiki home called PerformanceTuning. I have started to place clipets from emails in the group which relate to making queries or DB operations run quicker. Please add your bits and pieces http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuning

RE: [sqlite] web-based admin utilities

Hi, I've done one in VB.NET and it's here http://sourceforge.net/projects/dotnetsqliteadm/ Regards Greg -Original Message- From: Wade Preston Shearer [mailto:[EMAIL PROTECTED] Sent: Thursday, 15 January 2004 6:01 AM To: [EMAIL PROTECTED] Subject: [sqlite] web-based admin utilities

RE: [sqlite] AGS_SQLite_Wrapper VB

Hi, The returned result is a variant array. You move through a array as you normally do, by increasing a index counter. You can write a class around any array to emulate an ADO recordset if you want. Regards Greg -Original Message- From: ISA Programmi [mailto:[EMAIL PROTECTED] Sent:

[sqlite] .NET Assembly and VB Wrapper

Hello, I have updated my .NET Assembly and VB Wrapper for SQLite to support version 2.8.9. Both can be downloaded from http://www.ag-software.com/SQLite.aspx .NET Assembly Changes None VB Wrapper changes Introduced a new function called ags_number_of_rows_from_last_call, which as the name

RE: [sqlite] need faster count(*)

Hi, No the process must count all the rows. The ROWID value is generated when a new row is inserted but if you delete rows the last rowid will not be the same as the count of rows. If you have an index on the primary key and count that then it will run as quickly as possible. Regards Greg

RE: [sqlite] Field name

Hi, Des that mater? If it does then just un=quote them by removing the first char and lasts Kind regards Greg O -Original Message- From: Bronislav Klucka [mailto:[EMAIL PROTECTED] Sent: Thursday, 27 November 2003 8:42 PM To: SqLite Konference; Greg Obleshchuk Subject: RE: [sqlite

re: [sqlite] Network Performance

Hi Brian, I few things. The problem is your network speed compared to local disk speed (also distance is an issue as well) Disk transfer is in Mega bytes where as network IO is in mega bits. SO while IDE standard 33.3MB looks slower than 100mb for your network (even switched) it is in fact

[sqlite] Is there a problem with this list?

Hello, Just wondering if there is a problem with this list. regards Greg

Fw: [sqlite] Performance problem

Sorry Richard I meant to send this to the group Hello, Last week I raised an issue about case sensitivity in where clauses. In doing a little research I happened to talk to an Oracle DBA here where I work and asked him the question of how Oracle handled case sensitivity . He explained it is

Re: [sqlite] Where statements are they case sensitive?

I checked a few systems and there doesn't seem to be a standard. As was said Oracle is case sensitive but all the Microsoft products I check SQL, Access , MS Query where all case insensitive. I think a PRAGMA would be a great idea for this. What do other people think? Using a like

RE: [sqlite] Web Database Manager for SQLite

- From: Darren Duncan [mailto:[EMAIL PROTECTED] Sent: Wednesday, 22 October 2003 4:06 AM To: Greg Obleshchuk Cc: SQLite Subject: Re: [sqlite] Web Database Manager for SQLite At 3:54 PM +1000 10/21/03, Greg Obleshchuk wrote: >Hi Everyone, >Does anyone have a web based database manager for

Re: [sqlite] AUTO INCREMENT

Hi Kevin, You could also query the table or view but don't return any rows. If you set the option to get the column types in the resultset this should do what you want . AN example of what I am trying to say would help :) PRAGMA show_datatypes = ON; select COl3 from tablename where 0 = 1