Re: [sqlite] Incompatible versions of SQLite on same system

2012-01-24 Thread epankoke
1. Could we please stay on topic 
2. Could we please not go down this road again? 

If you guys really want to argue about proper posting etiquette and / or using 
something besides an email list, they've both been done to death. Just search 
the archives or start a new thread that's appropriately titled. Just leave it 
out of this one. 

Eric 

On 2012-01-24 16:09, Tim Streater wrote: 
> On 24 Jan 2012 at 20:02, Joe Winograd wrote: 
> 
>> Thanks for the idea, but it will not install. The way this group operates 
>> with excessive trimming/snipping ... 
> No it doesn't. It doesn't do *enough* trimming and snipping, and as a result 
> our inboxes grow exponentially. If I want to read a thread I can sort by 
> subject and then read it through. But this is made harder by the excessive 
> repetition due to inadequate trimming (particularly of .sigs). 
> 
> -- 
> Cheers -- Tim 
> 
> 
> 

Did you guys ever consider Google Groups or something of the like? Email 
lists are soo clumsy. 

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


Re: [sqlite] insert error

2011-12-20 Thread epankoke
Besides that, shouldn't it be 

cursor.execute "insert into ""default"" (rowname) values('1');" 

I would expect that the execute command is expecting a string containing the 
SQL to execute. 




- Original Message -
From: "Petite Abeille"  
To: "General Discussion of SQLite Database"  
Sent: Tuesday, December 20, 2011 2:40:50 PM 
Subject: Re: [sqlite] insert error 


On Dec 20, 2011, at 8:34 PM, jim-on-linux wrote: 

> cursor.execute insert into default (rowname) values ( '1' ) ; 

'default' is a keyword: 

http://www.sqlite.org/lang_keywords.html 

If you insist on that name, double quote it. 

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


Re: [sqlite] How about a proper forum rather than an e-mail list

2011-10-18 Thread epankoke
I'll say one thing - a forum would have saved me the wasted time of having to 
download and then delete all of this discussion about forums :) 




- Original Message -
From: "Danny Staten"  
To: "General Discussion of SQLite Database"  
Sent: Tuesday, October 18, 2011 9:59:09 AM 
Subject: Re: [sqlite] How about a proper forum rather than an e-mail list 

I for one would love a forum, and disagree about it being the same as an 
email list. I would love to not see 40+ emails in my inbox every day from 
this mailing list, but I do find the available resource handy to have when I 
need it. A forum would allow us to be more active because we can quickly 
and easily ask questions and follow the conversation rather than having to 
scan through a myriad of other emails, or try and follow the reply chain 
when a flood comes in. It would also allow us to keep our inboxes a lot 
cleaner and clutter free which would be very very nice. 

-Original Message- 
From: Frank Missel 
Sent: Tuesday, October 18, 2011 6:35 AM 
To: 'Teg' ; 'General Discussion of SQLite Database' 
Subject: Re: [sqlite] How about a proper forum rather than an e-mail list 

Hi Teg, 

> I love forums and consider them far superior to email if only because it's 
> easier to follow a topic with less quoting needed. The downside is that 
> someone has to manage the forum. I've managed a forum for the past 10 
> years and there's a daily spam cleanup process and constant attacks and 
> required upgrades. You have to set the tone and be pretty ruthless about 
> flaming too. 
> 
> I'd like to see a forum. I just wouldn't want to manage it. 

Okay, but if the posting is by members only would it not be the same as the 
e-mail-lists. 
I don't see a lot of spam in the e-mail-list, so either it also monitored by 
someone or the fact that it can only be accessed by members makes for a well 
behaved list which would be the same for the forum. 

/Frank 

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

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


Re: [sqlite] Max Value In Group By Scenario

2009-05-05 Thread epankoke
Thanks. 



- Original Message - 
From: "Igor Tandetnik"  
To: sqlite-users@sqlite.org 
Sent: Tuesday, May 5, 2009 8:05:42 AM GMT -05:00 US/Canada Eastern 
Subject: Re: [sqlite] Max Value In Group By Scenario 

"Eric Pankoke"  wrote 
in message news:6a90e70a6f404948991a0380e6793...@gamesmachine 
The following query: 
> 
> SELECT MfgProductID, ProductID, SUM(Weight) As MaxWeight FROM 
> dominantmaterials GROUP BY MfgProductID, ProductID 
> 
> Gets me most of the way to what I need. What I'm really after, 
> however, is the ProductID for each MfgProductID that has the greatest 
> combined weight from all MfgProductID / ProductID rows. 

select m, p, 
(select sum(Weight) from dominantmaterials 
where MfgProductId=m and ProductID=p) w 
from 
(select m, 
(select ProductID from dominantmaterials 
where MfgProductId = m 
group by ProductID 
order by sum(Weight) desc limit 1) p 
from 
(select distinct MfgProductId m from dominantmaterials)); 

Igor Tandetnik 



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


[sqlite] SQLite and Liberty Basic

2008-10-15 Thread epankoke
I searched all the archives to no avail, so I'm probably just making this up, 
but I was positive that someone posted an SQLite interface written in Liberty 
Basic in the last month or two.  If you are the person who posted such a 
program, if you know who did, or if you are neither but have done work with 
SQLite in Liberty Basic, maybe you can help me out.  I'm looking for a couple 
of good, practical examples of how to use SQLite with LB.  Any URLs, tips or 
code would be greatly appreciated.

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Populating and scrolling the Listbox using query

2008-04-21 Thread epankoke
Is it possible to store all of the needed data in memory?  If so, why not read 
the required information into an array and just update an index variable to 
keep track of where you are at in the array when the user clicks the up and 
down buttons?  That should be quite fast.

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

 -- Original message --
From: Farzana <[EMAIL PROTECTED]>
> 
> Thanks for your reply Igor.
> 
> We tried populating the listbox as mentioned in the URL.We are successful in
> populating the listbox but when we go for scrolling the data, it takes more
> time to move forward and backward since it has to execute the query
> everytime. We are using a PocketPc so it is much slower. Is there any other
> way to do this or can some one provide us a sample code for the same.
> We are using a Table say Employees where we have to dsiplay their Job
> Description in ascending order in a user defined listbox with scroll up and
> scroll down buttons. Can anyone provide us a suggestion.
> Thanks in Advance.
> 
> Regards,
> Farzana
> 
> 
> 
> Igor Tandetnik wrote:
> > 
> > "Farzana" <[EMAIL PROTECTED]>
> > wrote in message news:[EMAIL PROTECTED]
> >> We are working in eVC++ environment with SQLite database.We need to
> >> populate the listbox with the values obtained by executing the query.
> >> We were able to get the values of the query by using the API's
> >> sqlite3_prepare and sqlite3_step.
> >> But we were able to populate and move the listbox in the downward
> >> direction only
> > 
> > http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor
> > 
> > Igor Tandetnik 
> > 
> > 
> > 
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> > 
> > 
> 
> -- 
> View this message in context: 
> http://www.nabble.com/Populating-and-scrolling-the-Listbox-using-query-tp1667617
> 8p16806114.html
> Sent from the SQLite mailing list archive at Nabble.com.
> 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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


Re: [sqlite] what platforms does SQLite run on?

2008-02-19 Thread epankoke
Honestly, the last time I did a WinCE compile was before the amalgamation, so I 
did not realize it had become so easy to compile for WinCE.  Guess I'll be 
needing to make a new build when I get home tonight :)

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

 -- Original message --
From: "Fin Springs" <[EMAIL PROTECTED]>
> > Here's a link to an WinCE port: http://sqlite-wince.sourceforge.net/
> Is there a reason to use this port any more? The straight 3.5.6
> amalgamation compiles and runs fine for me on Windows CE 5.0 and
> includes specific '#if OS_WINCE' sections for CE (to define localtime,
> etc).
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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


Re: [sqlite] Re[sqlite] trieving only one record in the database

2008-01-25 Thread epankoke
You could do

SELECT whatever FROM table WHERE criteria LIMIT 1

or

SELECT COUNT(*) AS RowCount FROM table WHERE criteria

Then just check that the value of RowCount > 0.  The nice thing about the 
latter is that now you are set up if you ever want to know how many rows meet 
the criteria that you've chosen.

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

 -- Original message --
From: arbalest06 <[EMAIL PROTECTED]>
> 
> Good day!
> 
> I want to retrieve only one record in the database with a condition that may
> cause a retrieval of many records. The purpose of this is for me to check
> only if there is at least 1 record in the database. So if given my
> condition, the query would now search for one record in the database that
> satisfies the condition the returns that record. After one record is found,
> it should now stop finding and retrieving other records that satisfies the
> condition. How can i do this? What query can i issue?
> 
> Thank you and God bless!
> -- 
> View this message in context: 
> http://www.nabble.com/Retrieving-only-one-record-in-the-database-tp15087994p1508
> 7994.html
> Sent from the SQLite mailing list archive at Nabble.com.
> 
> 
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
> 


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



RE: [sqlite] Improving performance of SQLite. Anyone heard of Devic eSQL?

2007-12-17 Thread epankoke
Wow, I know this isn't really the point of your comment, but I always have to 
jump in when I see VB programmers "attacked".  So as a Delphi / C++ / VB 
programmer, where do I fit into your analogy?  Do I end up replacing myself :)

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

 -- Original message --
From: "Fred Williams" <[EMAIL PROTECTED]>
> A hundred or so Visual Basic programmers are cheaper to replace and
> "maintain" than one good Delphi/C++ programmer. ;-)  That is the reason
> management likes "Visual ."  Been there, learned that.  Hire the
> staff from the largest pool, not the most effective.  Besides it's damn
> hard to be a prima donna, when your replacement is ready to jump off
> that forklift and learn a cushy job.
> 
> Fred
> 
> > -Original Message-
> > From: John Elrick [mailto:[EMAIL PROTECTED]
> > Sent: Sunday, December 16, 2007 7:36 PM
> > To: sqlite-users@sqlite.org
> > Subject: Re: [sqlite] Improving performance of SQLite. Anyone heard of
> > Devic eSQL?
> >
> >
> > John Stanton wrote:
> > > This also is an anecdote from some time back.  As we were signing a
> > > fairly significant software contract with a large
> > organization their
> > > manager told us "You guys know nothing about marketing.  Your
> > > presentation was unprofessional, no glossy brochures, no
> > audio visuals
> > > and we would not have bought except that you were the only ones who
> > > convinced us you could do the job".  We just smiled and watched the
> > > ink dry while we pondered "where did we go right?".
> > >
> > > The simple truth is that if you hype a product and sell it into an
> > > area where it is inadequate your triumph is short lived and
> > the scorn
> > > and litigation enduring.  On the other hand if you deliver
> > a solution
> > > which works as well, or preferably better, than proposed you have
> > > generated raving fans who will buy again and endorse your
> > product to
> > > all and sundry.  Which is the better model?
> >
> > To quote a former programs manager for Bank of America "the first
> > solution which meets my business needs and performs the job
> > adequately".  In this case, adequately can be defined as loosely as
> > "doesn't crash too often" or as stringently as "positively no
> > errors",
> > depending on the business use.
> >
> > Keeping the discussion academic, "hype a product..." is a
> > business model
> > that apparently has been used to at least some degree by a company
> > called Microsoft.  It tends to work because the model permits
> > them such
> > an early lead that even better products have difficulty catching up.
> >
> > I do most of my programming in Delphi, a Borland product
> > which remains
> > in my opinion, even in its shadow of former glory state, a far more
> > straightforward and powerful product than Visual Studio.  Borland has
> > always been a technical company, not a market driven one and its
> > flagship product is surviving only because it remains a more well
> > rounded Windows solution than its competition.  However, it is only
> > surviving and is unlikely to actually thrive ever again.
> >
> > So my suggested answer is, the proven model is "dominate the market
> > early with an adequate product".  If your product is very
> > good and even
> > better than proposed, all the better.  But if you are "Johnny come
> > lately", you will likely lose unless your product is very,
> > very good.
> > And, whether we like it or not, a big part of market domination is to
> > convince all the decision makers (management) and decision breakers
> > (engineers with influence) that yours is the safest choice to make.
> >
> > FWIW
> >
> >
> > John Elrick
> >
> > --
> > ---
> > To unsubscribe, send email to [EMAIL PROTECTED]
> > --
> > ---
> >
> 
> 
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
> 


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Precompiled 2.x for Windows?

2007-09-20 Thread epankoke
Actually, it compiled, but it appears that I was not successful.  The compile I 
made did not work for what I wanted.  However, the DLL at the link you provided 
for me did work, so thanks for pointing that out.

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

 -- Original message --
From: Kees Nuyt <[EMAIL PROTECTED]>
> On Thu, 20 Sep 2007 20:42:30 +, you wrote:
> 
> > Where?  sqlite-2_8_17.zip is just an executable,
> > and the other zip for Windows is just the source. 
> > As it stands, however, I was able to recompile
> > the DLL after all and it didn't make a difference.
> 
> Oh, sorry, I should have checked.
> The link isn't on the page anymore, but (as with many old
> versions) the download is still available: 
> 
> http://www.sqlite.org/sqlitedll-2_8_17.zip 
> 
> I'm glad you managed to compile it by yourself.
> -- 
>   (  Kees Nuyt
>   )
> c[_]
> 
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
> 


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] Precompiled 2.x for Windows?

2007-09-20 Thread epankoke
Would anyone happen to have a precompiled DLL for Windows of the latest 2.x 
version of SQLite?  I don't have the facilities to make one myself where I'm at 
right now, but I need one to test out a problem with an application I'm trying 
to support.  Thank you to anyone who might be able to provide this for me.

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Re: Case Insensitive Equality Searches

2007-03-08 Thread epankoke
My first suggestion was using upper around both operands in the equation, but 
the person who needed it said that didn't work, which actually leads me to 
another question.  Is any of this stuff (upper, collate nocase, etc) available 
in 2.x, or are they 3.x innovations?

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

 -- Original message --
From: "Igor Tandetnik" <[EMAIL PROTECTED]>
> [EMAIL PROTECTED] wrote:
> > If I want to do "SELECT * FROM table WHERE field = value", how can I
> > do this matching text only and not case?
> 
> If you always need case insensitive comparison, the easiest way is to 
> assign NOCASE collation to the field when creating the table:
> 
> create table mytable (field char collate NOCASE, ...)
> 
> If you need only this comparison to be case insensitive, you can do
> 
> SELECT * FROM table WHERE upper(field) = upper(value);
> 
> Reportedly, the latest CVS code for SQLite also supports
> 
> SELECT * FROM table WHERE field=value collate NOCASE;
> 
> This will probably make it into the next release.
> 
> Note that NOCASE collation in SQLite only recognizes letters A through Z 
> as being equal to a through z. It doesn't support any other characters, 
> e.g. accented Latin characters or characters from other scripts. If you 
> need any kind of linguistically correct collation, you need to provide 
> one yourself (luckily SQLite supports custom collations).
> 
> Igor Tandetnik 
> 
> 
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
> 


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Case Insensitive Equality Searches

2007-03-08 Thread epankoke
Thank you.  I'm sure this has been addressed before, but I couldn't remember 
where the list archive was.  You'd think as long as I've been on this list I'd 
have known the answer to this anyway :)

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

 -- Original message --
From: [EMAIL PROTECTED]
> [EMAIL PROTECTED] wrote:
> > If I want to do "SELECT * FROM table WHERE field = value",
> > how can I do this matching text only and not case?
> > 
> 
>SELECT * FROM table
> WHERE field COLLATE nocase = value;
> 
> --
> D. Richard Hipp  <[EMAIL PROTECTED]>
> 
> 
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
> 


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] Case Insensitive Equality Searches

2007-03-08 Thread epankoke
If I want to do "SELECT * FROM table WHERE field = value", how can I do this 
matching text only and not case?

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] Backwards Conversion Of Databases

2007-03-06 Thread epankoke
This is actually a forwarded question.  Someone on another group I frequent 
would like to convert a database from SQLite 3 to SQLite 2.  I'm guessing 
there's nothing complex about the database, and most likely nothing SQLite 3 
specific.  What would be the easiest way to accomplish this task?

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



RE: [sqlite] x000 line queries - only for benchmarks?

2007-02-08 Thread epankoke
No, I just forgot that this all stemmed from the original problem of 
sqlite_get_table throwing errors.  After a while these threads all tend to get 
a little fuzzy to me.  Sorry about that.

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

 -- Original message --
From: "RB Smissaert" <[EMAIL PROTECTED]>
> Yes, VBA supports both, but as it is just for logging purposes my solution
> is fine, particularly as these long queries have repetitions of similar
> elements.
> 
> Also the function sqlite_get_table will produce an array and the error
> happens directly when that function is called, so how is using a collection
> or a recordset going to help me? Did you mean alter the C source code?
> 
> RBS
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
> Sent: 08 February 2007 12:50
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] x000 line queries - only for benchmarks?
> 
> Does VBA support collections?  Or you could use an ADO recordset.  Either
> one should easily let you store elements that are over 2K bytes in length.
> 
> --
> Eric Pankoke
> Founder / Lead Developer
> Point Of Light Software
> http://www.polsoftware.com/
> 
>  -- Original message --
> From: [EMAIL PROTECTED]
> > There is no problem running queries of whatever
> > length, so I could do benchmarks fine, it is just
> > that VBA has a problem with array elements holding
> > over 1823 characters.
> > 
> > RBS
> > 
> > 
> > > [EMAIL PROTECTED] wrote:
> > >> In my (commercial) app I regularly have queries with over 1000
> > >> characters.
> > >> Not over 1000 lines though.
> > >> As VBA (not sure now about VB6) has a problem with
> > >> array elements having over 1823 characters I had
> > >> to truncate my SQL logging routine.
> > >>
> > > Under 2k? That seems a bit restrictive. No benchmarking for you then,
> > > because the 25k line queries in the SQLite benchmark are nearly 2 meg. I
> > > guess they're unusual but even the (more typical?) 100 liners can get up
> > > to about 6-8k.
> > >
> > > Martin
> > >
> > >
> 
> -
> > > To unsubscribe, send email to [EMAIL PROTECTED]
> > >
> 
> -
> > >
> > >
> > >
> > 
> > 
> > 
> > 
> >
> 
> -
> > To unsubscribe, send email to [EMAIL PROTECTED]
> >
> 
> -
> > 
> 
> 
> 
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> 
> -
> 
> 
> 
> 
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
> 


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] x000 line queries - only for benchmarks?

2007-02-08 Thread epankoke
Does VBA support collections?  Or you could use an ADO recordset.  Either one 
should easily let you store elements that are over 2K bytes in length.

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

 -- Original message --
From: [EMAIL PROTECTED]
> There is no problem running queries of whatever
> length, so I could do benchmarks fine, it is just
> that VBA has a problem with array elements holding
> over 1823 characters.
> 
> RBS
> 
> 
> > [EMAIL PROTECTED] wrote:
> >> In my (commercial) app I regularly have queries with over 1000
> >> characters.
> >> Not over 1000 lines though.
> >> As VBA (not sure now about VB6) has a problem with
> >> array elements having over 1823 characters I had
> >> to truncate my SQL logging routine.
> >>
> > Under 2k? That seems a bit restrictive. No benchmarking for you then,
> > because the 25k line queries in the SQLite benchmark are nearly 2 meg. I
> > guess they're unusual but even the (more typical?) 100 liners can get up
> > to about 6-8k.
> >
> > Martin
> >
> > -
> > To unsubscribe, send email to [EMAIL PROTECTED]
> > -
> >
> >
> >
> 
> 
> 
> 
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
> 


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



RE: [sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

2007-02-07 Thread epankoke
1. When the application first starts up, click on the Servers icon in the 
middle of the window.  Alternatively, select Tools | Server | Server Manager.

2. For Server Engine, select SQLite (of course).  If you're still using 2.x, go 
to step 4.

3. Select the options tab, put 3 in the first box for Version, then switch back 
to the Parameters tab.

4. Put some sort of description in for Server Name.  This is simply for you to 
identify the database when looking through the treeview list on the left hand 
side.

5. Click the ... button next to Database Filename and browse for your database. 
 Note, if the version you specified and the version of the database that you 
selected do not match (ex: you put 3 in the options tab and are only using a 
2.x database), DBTools will "create" the connection, but you'll never see 
anything listed in the server explorer.

6. Click OK.  The server explorer should be refreshed, and under Default 
Servers | Default Group, you should see a new node with the Server Name you 
specified.  When you expand that you will see a Databases folder, and expanding 
that will reveal the a node with the name of your database, assuming all went 
correctly.
--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

 -- Original message --
From: "Rob Richardson" <[EMAIL PROTECTED]>
> For the life of me, I can't figure out how to open a database in
> DBManager.  I looked at it before, tried for an hour, and erased it.  I
> just tried again, with the same result.  If I can't figure out how to do
> such an easy thing, I can't trust the program.
> 
> RobR
> 
> 
> 
> -Original Message-
> From: COS [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, February 07, 2007 12:26 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Is there a SQLiteSpy-like thing that will let me
> change data from a grid?
> 
> Hi Rob,
> 
> You can try DBManager Standard or Enterprise Editions. The first one is
> free
> for personal use, the second is a commercial product. The complete list
> of
> features can be found at http://www.dbtools.com.br/EN/dbmanagerpro. You
> can
> edit your tables data and also manipulate images in blob fields.
> 
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
> 


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



RE: [sqlite] How do I know sqlite_get_table is finished

2007-02-02 Thread epankoke
If you want to email me a copy of the table I'd be more than happy to try 
running it here and see what happens.  You can send it to epankoke @ gmail dot 
com.

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

 -- Original message --
From: "RB Smissaert" <[EMAIL PROTECTED]>
> lReturnedRows is one of the function arguments, so that is fine.
> 
> I have made some progress though and that is that this problem only occurs
> with this particular table, called SQL. It is a table that logs all the SQL
> statements that run in my app. When I instead make this for example
> sqlite_master there is no problem ever.
> No idea though why this table would cause a problem. Could it be that
> one of the items in that table is a reserved word?
> 
> CREATE TABLE 'SQL'
> ([STATEMENT_COUNT] INTEGER,
> [DB] TEXT,
> [QUERY_TIME] TEXT,
> [QUERY_LENGTH] REAL,
> [QUERY] TEXT)
> 
> Any other ideas what could be wrong with this table?
> 
> I could mail a db with that table if that would be helpful.
> 
> RBS
> 
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
> Sent: 02 February 2007 13:51
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] How do I know sqlite_get_table is finished
> 
> I'll admit I'm not much of a C expert, so I'd say Guy has a much better
> handle on that part than I do.  As far as your code goes I only had one
> thought, and forgive me if this is just my ignorance of VBA.  I didn't see a
> declaration for lReturnedRows anywhere.  If you don't declare a variable,
> what is the value of that variable if it's used before you explicitly assign
> a value?  The reason I ask is because you only assign a value to
> lReturnedRows if the length of the error message is 0, and you only set the
> error flag if lReturnedRows = 0.  Do you need to do:
> 
> If Len(strError) = 0 then
> Else
>   lReturnedRows = 0
> End If
> 
> Don't know if this would really make a difference, and sorry if it's just a
> waste of time, but I thought I'd suggest it.
> 
> --
> Eric Pankoke
> Founder / Lead Developer
> Point Of Light Software
> http://www.polsoftware.com/
> 
>  -- Original message --
> From: [EMAIL PROTECTED]
> > Thanks for looking at that.
> > The crash can happen at the actual call to sqlite_get_table or it can
> > happen when I assign the resulting array to the wrapper function, so when
> > I do: GetFromDB = arr
> > 
> > Yes, I would be interested in making a boolean (optional) argument in
> > sqlite_get_table that can leave out the field headers. I haven't tried
> > to compile myself yet, but I do have VC6, so it should be OK.
> > 
> > Still, I don't understand why this crashes.
> > 
> > RBS
> > 
> > > At 07:44 2/2/2007 +, you wrote:
> > >>Sure, here it is:
> > >
> > > 
> > >
> > > Looking at the C code published at
> > > http://www.tannertech.net/sqlite3vb/index.htm , it seems very risky -
> > > there
> > > are a lot of places it can fail to allocate memory (for example), and
> the
> > > use of some variables looks like it could randomly crash at any time...
> > > but
> > > I didn't test it, just looked at it.
> > >
> > > As far as I can understand the problem, it happens around this line:
> > > arr = GetFromDB(strSQL, lRows, strError, lDBHandle, strDB)
> > >
> > > Are you seeing a crash on the actual call to sqlite_get_table or only
> > > after
> > > it (when you try to use the results)?
> > >
> > > If you compiled the SQLite3VB.dll on your own, I can probably make some
> > > suggestions about fixing the C code of sqlite_get_table implementation,
> > > and
> > > maybe even some improvments (for example, a boolean flag to allow you to
> > > request the results array without the column headers, which I remember
> you
> > > asking about), and returning the number of rows immediately instead of
> in
> > > another function (which is somewhat dangerous), etc.).
> > > You should also probably consider using some kind of wrapper around
> > > sqlite3_exec in addition to sqlite3_get_table so you will be able to run
> > > commands (like pragma) without going through sqlite_get_table.
> > >
> > >
> > > Guy
> > >
> > >
> > >
> > >
> --

RE: [sqlite] How do I know sqlite_get_table is finished

2007-02-02 Thread epankoke
I'll admit I'm not much of a C expert, so I'd say Guy has a much better handle 
on that part than I do.  As far as your code goes I only had one thought, and 
forgive me if this is just my ignorance of VBA.  I didn't see a declaration for 
lReturnedRows anywhere.  If you don't declare a variable, what is the value of 
that variable if it's used before you explicitly assign a value?  The reason I 
ask is because you only assign a value to lReturnedRows if the length of the 
error message is 0, and you only set the error flag if lReturnedRows = 0.  Do 
you need to do:

If Len(strError) = 0 then
Else
  lReturnedRows = 0
End If

Don't know if this would really make a difference, and sorry if it's just a 
waste of time, but I thought I'd suggest it.

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

 -- Original message --
From: [EMAIL PROTECTED]
> Thanks for looking at that.
> The crash can happen at the actual call to sqlite_get_table or it can
> happen when I assign the resulting array to the wrapper function, so when
> I do: GetFromDB = arr
> 
> Yes, I would be interested in making a boolean (optional) argument in
> sqlite_get_table that can leave out the field headers. I haven't tried
> to compile myself yet, but I do have VC6, so it should be OK.
> 
> Still, I don't understand why this crashes.
> 
> RBS
> 
> > At 07:44 2/2/2007 +, you wrote:
> >>Sure, here it is:
> >
> > 
> >
> > Looking at the C code published at
> > http://www.tannertech.net/sqlite3vb/index.htm , it seems very risky -
> > there
> > are a lot of places it can fail to allocate memory (for example), and the
> > use of some variables looks like it could randomly crash at any time...
> > but
> > I didn't test it, just looked at it.
> >
> > As far as I can understand the problem, it happens around this line:
> > arr = GetFromDB(strSQL, lRows, strError, lDBHandle, strDB)
> >
> > Are you seeing a crash on the actual call to sqlite_get_table or only
> > after
> > it (when you try to use the results)?
> >
> > If you compiled the SQLite3VB.dll on your own, I can probably make some
> > suggestions about fixing the C code of sqlite_get_table implementation,
> > and
> > maybe even some improvments (for example, a boolean flag to allow you to
> > request the results array without the column headers, which I remember you
> > asking about), and returning the number of rows immediately instead of in
> > another function (which is somewhat dangerous), etc.).
> > You should also probably consider using some kind of wrapper around
> > sqlite3_exec in addition to sqlite3_get_table so you will be able to run
> > commands (like pragma) without going through sqlite_get_table.
> >
> >
> > Guy
> >
> >
> >
> > -
> > To unsubscribe, send email to [EMAIL PROTECTED]
> > -
> >
> >
> >
> 
> 
> 
> 
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
> 


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] How do I know sqlite_get_table is finished

2007-02-01 Thread epankoke
sqlite_get_table does not terminate unless there is an error or it has 
retrieved all the records you asked for.  Something else must have been causing 
the error, or the wrapper you are using is not implementing the function call 
correctly.

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

 -- Original message --
From: "RB Smissaert" <[EMAIL PROTECTED]>
> Using the VB wrapper dll SQLite3VB.dll from Todd Tanner's site:
> http://www.tannertech.net/sqlite3vb/index.htm
> 
> In one particular procedure I had a serious problem when doing a call to
> sqlite_get_table, causing Excel to crash. It took me a long time to pinpoint
> the trouble as VBA debugging methods didn't help here. Eventually it
> appeared that the trouble was calling sqlite3_close too soon after
> sqlite_get_table.
> Not sure if this makes sense, but after moving sqlite3_close some lines down
> in that procedure the problem seems to be solved, so I take it the
> connection was closed while SQLite was still fetching data, causing the
> error and the Excel crash.
> 
> So what is the best way to determine if sqlite_get_table is finished?
> Running number_of_rows_from_last_call in a loop might be something, but
> maybe there is something better.
> 
> RBS
> 
> 
> 
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
> 


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] pragma table_info not working on empty table

2007-01-24 Thread epankoke
I'm not sure if this applies here, but you could try calling this first: PRAGMA 
empty_result_callbacks = true;

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

 -- Original message --
From: "RB Smissaert" <[EMAIL PROTECTED]>
> It just looks that this pragma won't give me the fields and data types if
> the table has no rows yet, but was just created. Is this indeed so and if so
> is there a way round it?
> I am trying to avoid parsing sqlite_master as I used to do that and using
> this pragma is a much cleaner way to do this.
> Thanks for any advice.
> 
> RBS
> 
> 
> 
> 
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
> 


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] LEMON

2006-12-29 Thread epankoke
I'm not familiar with Lemon, so I don't know if this will help: 
http://linuxgazette.net/106/chirico.html.  Also, I'd highly recommend just 
doing a Google search for either "Lemon Parser" or "Lemon Tutorial".

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

 -- Original message --
From: "Cesar Rodas" <[EMAIL PROTECTED]>
> Another URL where i can find a tutorial?
> 
> On 29/12/06, Lloyd <[EMAIL PROTECTED]> wrote:
> >
> > Ethereal make use of Lemon
> >
> > On Fri, 2006-12-29 at 11:08 -0400, Cesar Rodas wrote:
> > > Where can i find a tutorial with examples of how to use LEMON parser...
> > > because i need to build interpreted language
> > >
> > > Thanks to all
> >
> >
> > __
> > Scanned and protected by Email scanner
> >
> >
> > -
> > To unsubscribe, send email to [EMAIL PROTECTED]
> >
> > -
> >
> >
> 
> 
> -- 
> Cesar Rodas
> http://www.phpclasses.org/grank (A PHP implementation of PageRank)


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Determining Data Types

2006-12-08 Thread epankoke
This gets into my ignorance of how sqlite works internally, but if I quote an 
"integer" value, it will still be stored correctly?  I have no problems doing 
that, I just wasn't sure if that was the case.  Also, how do I need to send 
date fields to sqlite to have them stored properly?

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

 -- Original message --
From: "Will Leshner" <[EMAIL PROTECTED]>
> On 12/8/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> 
> > I can construct the update statement without much issue, but I need to know 
> whether or not I should put quotes around value, so I need to know whether or 
> not field3 is a text type field.
> 
> Why not just quote all the values?
> 
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
> 


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Determining Data Types

2006-12-08 Thread epankoke
I appreciate the insight, but I'm not sure it helps with my situation.  This is 
what I'm trying to accomplish:

1. User selects 1 or more fields from a table using basic "SELECT fields FROM 
table" syntax, and the result is retrieved using sqlite_get_table (this is 
still in v2.8x)
2. User calls a function that says "I want to update field 3 in row 10".  I 
have to construct a query that says "UPDATE table SET field3 = value WHERE 
ROWID = "

I can construct the update statement without much issue, but I need to know 
whether or not I should put quotes around value, so I need to know whether or 
not field3 is a text type field.  I hope that explains my situation a little 
better.

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

 -- Original message --
From: Seth Falcon <[EMAIL PROTECTED]>
> [EMAIL PROTECTED] writes:
> 
> > Please forgive me, because I know this has been covered before, but
> > at the moment I'm at a loss.  I am writing an SQLite wrapper for a
> > relatively new language, and one of the requirements is that the
> > user be able to add and update date as if they were using an ADO
> > recordset.  As a result, I need to be able to build an SQL statement
> > behind the scenes that is aware of each field's data type. 
> 
> I'm not sure I understand what you want.  But here are some possible
> starting points:
> 
> When using the SQLite C API, you can determine if the columns in a
> result set correspond to a database table.  In this case, it is
> possible to access the table definition and the column types can be
> parsed [*1*].
> 
> If the result columns do not directly correspond to table columns,
> then, AFAIK, the best you can do is to use sqlite3_column_type.  As
> long as you don't have NULLs, this will tell you the affinity type of
> the column in the result set.
> 
> Aside: it would be really nice to be able to determine affinity type
> from a compiled SQL statement (result of sqlite3_prepare) and not have
> to actually _step() to get this info.
> 
> [*1*] See this thread on the SQLite list:
> http://marc.theaimsgroup.com/?l=sqlite-users=116416179332110=2
> 
> HTH,
> 
> + seth
> 
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
> 


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] Determining Data Types

2006-12-08 Thread epankoke
Please forgive me, because I know this has been covered before, but at the 
moment I'm at a loss.  I am writing an SQLite wrapper for a relatively new 
language, and one of the requirements is that the user be able to add and 
update date as if they were using an ADO recordset.  As a result, I need to be 
able to build an SQL statement behind the scenes that is aware of each field's 
data type.  I vaguely recall discussions about this in the past, and I thought 
the consensus was that the SQL used to create the table needed to be parsed to 
determine data types of fields.  If this is the case, then (1) where can I find 
this SQL, and (2) does someone already have a routine to parse it that they 
could share?  If there is a better way to approach this, I'd appreciate that 
information as well, even if it's just a link to a different thread or a link 
to the SQLite web site.  Thanks for your time.

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



RE: [sqlite] Saving tables

2006-11-27 Thread epankoke
The extension doesn't actually matter.  You could call it .bob for all SQLite 
cares.  .db and .db3 are just conventions used to differentiate an SQLite 3 
database from an older database.

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

 -- Original message --
From: "RB Smissaert" <[EMAIL PROTECTED]>
> > sqlite3 mydatabase.db3
> 
> I always use the extension .db
> What is the difference between db3 and db or maybe db2 etc.?
> 
> RBS
> 
> 
> -Original Message-
> From: Kees Nuyt [mailto:[EMAIL PROTECTED] 
> Sent: 27 November 2006 22:49
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Saving tables
> 
> On Mon, 27 Nov 2006 12:43:24 -0800 (PST), you wrote:
> 
> >
> >I typed exactly what you typed there and i get 
> >SQL error: no such table: bar
> >my command window doesnt have : "sqlite3 foo.sqlite" like yours
> 
> If you don't include a database name after the sqlite3 command,
> sqlite uses the "memory" database, which ceases to exist after
> you exit the program.
> 
> So, use the following commamnd to create and open your database:
>   sqlite3 mydatabase.db3
> 
> and then issue the SQL commands at the prompt to create and
> populate the table.
> 
> Every time you want to reuse that database, you have to open it
> in the same way:
>   sqlite3 mydatabase.db3
> 
> HTH
> -- 
>   (  Kees Nuyt
>   )
> c[_]
> 
> 
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> 
> -
> 
> 
> 
> 
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
> 


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



RE: [sqlite] Saving tables

2006-11-27 Thread epankoke
It depends on how the wrapper was written.  If it is a C wrapper with the 
SQLite code compiled in (like the SQLite COM control from NewObjects), then you 
are correct that all you need is the wrapper.  However, if the wrapper makes 
calls to the DLL, then you will still need the SQLite dll along with the 
wrapper.  Different versions of the DLL should only affect you if a function 
call changes or is removed.

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

 -- Original message --
From: "RB Smissaert" <[EMAIL PROTECTED]>
> Just to clear up one thing that is not 100% clear to me.
> When you are using SQLite on your machine is it true that you don't need to
> have anything installed if you are using a VB wrapper dll. This wrapper can
> Create, update, select etc. and nil else is needed.
> 
> Now, if I am using this wrapper and there is a new version of SQLite out
> what does that mean to me? I suppose nil, unless the author of the wrapper
> brings a  new one out that uses features of the new version of SQLite?
> 
> RBS
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of P Kishor
> Sent: 27 November 2006 20:59
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Saving tables
> 
> SQLite is the C library that does all the db magic. You have to
> somehow get to that library, which you can do from a program written
> in a variety of different languages, even GUI programs, or, from
> another confusingly similar named program called sqlite or sqlite
> shell. Since the jump from version 2 to version 3 of SQLite, the C
> library, made the data incompatible between the two versions, the
> version 3 of the shell is called sqlite3 usually... it uses the SQLite
> library version 3.x
> 
> Here is what I did (my comments in-line)
> 
> > sqlite3 foo.sqlite
> 
> # called sqlite3 with a db named foo.sqlite
> # since foo.sqlite didn't exist at first, sqlite3 helpfully created it
> 
> > CREATE TABLE bar (a, b);
> > INSERT...
> 
> # CREATEd a table and inserted a row into it.
> 
> > .quit
> 
> # got out in a hurry (that was a .dot command, specific to sqlite3, the
> shell)
> # time passed
> 
> > sqlite3 foo.sqlite
> 
> # this time foo.sqlite existed, so sqlite3 just opened it up
> 
> > SELECT * FROM bar;
> 
> # the table bar was there, and had my data in it.
> 
> 
> 
> On 11/27/06, sebcity <[EMAIL PROTECTED]> wrote:
> >
> > I typed exactly what you typed there and i get
> > SQL error: no such table: bar
> > my command window doesnt have : "sqlite3 foo.sqlite" like yours
> >
> >
> >
> >
> >
> > P Kishor-2 wrote:
> > >
> > >>sqlite3 foo.sqlite
> > > SQLite version 3.3.7
> > > Enter ".help" for instructions
> > > sqlite> CREATE TABLE bar (a, b);
> > > sqlite> INSERT INTO bar (a, b) VALUES (1, 'my mp3');
> > > sqlite> .quit
> > >
> > > .. time passes..
> > >
> > >>sqlite3 foo.sqlite
> > > SQLite version 3.3.7
> > > Enter ".help" for instructions
> > > sqlite> SELECT * FROM bar;
> > > 1|my mp3
> > > sqlite>
> > >
> > >
> > >
> > > On 11/27/06, sebcity <[EMAIL PROTECTED]> wrote:
> > >>
> > >> I created a table.
> > >> I populated the table.
> > >> I exited SQLite.
> > >> Started SQLIte again.
> > >> Typed "select * from ".
> > >> ANd it tells me no such table exists??
> > >>
> > >>
> > >>
> > >> Igor Tandetnik wrote:
> > >> >
> > >> > sebcity <[EMAIL PROTECTED]> wrote:
> > >> >> Im new to SQLite, After you create your tables how do you save them
> > >> >> so they are permenently there? It might be a dumb question but i
> cant
> > >> >> find the answer anwhere?!
> > >> >
> > >> > They are "permanently there" from the very moment you create them.
> All
> > >> > changes are written to the database file when a transaction is
> > >> > committed, or at the end of every statement if you don't open any
> > >> > transactions explicitly.
> > >> >
> > >> > Igor Tandetnik
> > >> >
> > >> >
> > >> >
> > >>
> 
> -
> > >> > To unsubscribe, send email to [EMAIL PROTECTED]
> > >> >
> > >>
> 
> -
> > >> >
> > >> >
> > >> >
> > >>
> > >> --
> > >> View this message in context:
> > >> http://www.nabble.com/Saving-tables-tf2714011.html#a7567183
> > >> Sent from the SQLite mailing list archive at Nabble.com.
> > >>
> > >>
> > >>
> 
> -
> > >> To unsubscribe, send email to [EMAIL PROTECTED]
> > >>
> 
> -
> > >>
> > >>
> > >
> > >
> > > --
> > > Puneet Kishor http://punkish.eidesis.org/
> > > Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/
> > > Open Source Geospatial Foundation https://edu.osgeo.org/
> > >
> 
> 

Re: [sqlite] Saving tables

2006-11-27 Thread epankoke
Can you describe in more detail the process you're trying to use to do this?

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

 -- Original message --
From: sebcity <[EMAIL PROTECTED]>
> 
> Nope, how would i do that? 
> 
> Eric Pankoke wrote:
> > 
> > Did you open the database when you launched SQLite again?  Sorry if this
> > is a stupid question, but I've never used SQLite from a command line or
> > the shell.
> > 
> > --
> > Eric Pankoke
> > Founder / Lead Developer
> > Point Of Light Software
> > http://www.polsoftware.com/
> > 
> >  -- Original message --
> > From: sebcity <[EMAIL PROTECTED]>
> >> 
> >> I created a table.
> >> I populated the table.
> >> I exited SQLite.
> >> Started SQLIte again.
> >> Typed "select * from ".
> >> ANd it tells me no such table exists??
> >> 
> >> 
> >> 
> >> Igor Tandetnik wrote:
> >> > 
> >> > sebcity <[EMAIL PROTECTED]> wrote:
> >> >> Im new to SQLite, After you create your tables how do you save them
> >> >> so they are permenently there? It might be a dumb question but i cant
> >> >> find the answer anwhere?!
> >> > 
> >> > They are "permanently there" from the very moment you create them. All 
> >> > changes are written to the database file when a transaction is
> >> > committed, or at the end of every statement if you don't open any 
> >> > transactions explicitly.
> >> > 
> >> > Igor Tandetnik 
> >> > 
> >> > 
> >> >
> >> -
> >> > To unsubscribe, send email to [EMAIL PROTECTED]
> >> >
> >> -
> >> > 
> >> > 
> >> > 
> >> 
> >> -- 
> >> View this message in context: 
> >> http://www.nabble.com/Saving-tables-tf2714011.html#a7567183
> >> Sent from the SQLite mailing list archive at Nabble.com.
> >> 
> >> 
> >> -
> >> To unsubscribe, send email to [EMAIL PROTECTED]
> >> -
> >> 
> > 
> > 
> > -
> > To unsubscribe, send email to [EMAIL PROTECTED]
> > -
> > 
> > 
> > 
> 
> -- 
> View this message in context: 
> http://www.nabble.com/Saving-tables-tf2714011.html#a7567686
> Sent from the SQLite mailing list archive at Nabble.com.
> 
> 
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
> 


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Saving tables

2006-11-27 Thread epankoke
Did you open the database when you launched SQLite again?  Sorry if this is a 
stupid question, but I've never used SQLite from a command line or the shell.

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

 -- Original message --
From: sebcity <[EMAIL PROTECTED]>
> 
> I created a table.
> I populated the table.
> I exited SQLite.
> Started SQLIte again.
> Typed "select * from ".
> ANd it tells me no such table exists??
> 
> 
> 
> Igor Tandetnik wrote:
> > 
> > sebcity <[EMAIL PROTECTED]> wrote:
> >> Im new to SQLite, After you create your tables how do you save them
> >> so they are permenently there? It might be a dumb question but i cant
> >> find the answer anwhere?!
> > 
> > They are "permanently there" from the very moment you create them. All 
> > changes are written to the database file when a transaction is
> > committed, or at the end of every statement if you don't open any 
> > transactions explicitly.
> > 
> > Igor Tandetnik 
> > 
> > 
> > -
> > To unsubscribe, send email to [EMAIL PROTECTED]
> > -
> > 
> > 
> > 
> 
> -- 
> View this message in context: 
> http://www.nabble.com/Saving-tables-tf2714011.html#a7567183
> Sent from the SQLite mailing list archive at Nabble.com.
> 
> 
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
> 


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] whether Sqlite Db supports jar files

2006-11-24 Thread epankoke
A .jar file is a Java package.  If you can't open it, you must not have the 
Java runtime installed properly.  It doesn't have anything to do with SQLite, 
however.

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

 -- Original message --
From: "sandhya" <[EMAIL PROTECTED]>
> Hi all,
> I have loaded all my webpages into database and i am unable to open file
> have .jar extension???
> Is it something related Database where i need to look into?
> please help me
> 
> Thank u all
> Regards,
> Sandhya
> 
> 
> 
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
> 


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



RE: [sqlite] Importing text file via .bat file

2006-11-15 Thread epankoke
I've noticed that you mention both VB and VBS.  Is this something that you are 
eventually going to run from an actual VB application?  If so, you might be 
able to use a directory notification on the directory where the import is, then 
just trigger an action when the import file is deleted, which the .bat file 
could do after the import is done.  Or, if you don't want to be that drastic, 
monitor the specific file for a Rename event.  Of course, I don't know that VB 
6 supports this, but I know that VB.Net does.

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

 -- Original message --
From: "RB Smissaert" <[EMAIL PROTECTED]>
> Of course the .bat file could make a little file to notify VB.
> Still, running a loop to check for this is not ideal.
> 
> RBS
> 
> -Original Message-
> From: Griggs, Donald [mailto:[EMAIL PROTECTED] 
> Sent: 15 November 2006 19:37
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] Importing text file via .bat file
> 
>  
> Echo  .mode csv   >MyCommands.tmp
> Echo  .import ReadCode.txt ReadCode  >>MyCommands.tmp
> 
> Sqlite3 ReadCode.db ".read myCommands.tmp"
> 
> =
> -Original Message-
> From: RB Smissaert [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, November 15, 2006 1:13 PM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] Importing text file via .bat file
> 
> Hi Donald,
> 
> Thanks, but I don't quite get it yet.
> What is in this file MyCommand.tmp?
> Is there no way to put the whole thing in on .bat file or even better
> run the whole sequence from VB?
> 
> RBS
> ===
> ===
> 
> Regarding: "What is in this file MyCommand.tmp?"
> 
> The file, "MyCommand.tmp" would be a temporary file created by your
> batch file itself as it runs.
> 
> 
> 
> Regarding: "...one batch file...?"
> 
> In a sense, the entire logic *is* in one batch file, but it's true that
> a small, temporary file is created as part of the process, and you can
> delete it when done.  Unless you're doing this thousands of times an
> hour, the extra time introduced by having a temporary file will be
> minimal.
> 
> Kees Nyut showed a nicer syntax, one that I *thought* I had problems
> with for early versions of sqlite.exe under windows, but seems to work
> well now:
>  Instead of:
>   Sqlite3 ReadCode.db ".read myCommands.tmp"
>  use:
>   Sqlite3 ReadCode.db  
> 
> Re: "..or VB?" 
> I don't use Visual Basic, so I'm no expert, but the advantage of
> using the sqlite command-line utility (called sqlite3.exe) is that the
> code for parsing comma-delimited strings is built in.   If you have your
> routines for this, or want to incorporate the code from the sqlite
> command utility source, then you can certainly do everything within VB.
> 
> 
> Returning to the "single batch file" question:
> 
>  I've actually used a sneaky means of doing this, but it assumes
> you're pretty familiar with batch files.  It's more straightforward for
> unix scripts, but for windows, we start it with a line of
> /*
> Which gives a (harmless) error when the batch file starts, but it allows
> us to treat the top portion of the file as a set of inputs to sqlite
> command utility.
> 
> -beginning of file Mybatchfile.bat
> /*
> GOTO  :startit
>   This is a combination sql and batch file to ...
> */
> 
> /* Put all your sql commands and DOT commands here */
> drop table if exists ReadCode;
> create table ReadCode (
>   SUBJECT_TYPE varchar(5),
>   READ_CODEvarchar(5),
>   TERM30   varchar(30),
>   TERM60   varchar(60)
> );
> .mode csv
> .import ReadCode.txt ReadCode
> 
> -- end sqlite with .quit, but batch file continues
> .quit
> 
> == nothing runs in this space till we get to "startit"
> 
> 
> :Startit
> Rem  Beginning of batch file commands
> @echo off
> Rem clear the harmless error off the screen
> Cls
> 
> Rem [Do any other preparatory batch file commands here]
> 
> Rem Invoke sqlite3 command utility and submit the top of this batch file
> as a set of commands
> Rem we assume this entire batch file is named "Mybatchfile" and it's in
> our current directory.
> 
> Sqlite3 myData.db   
> Rem [ put here any windows batch commands we want after Sqlite3 leaves
> with the .quit command ]
> 
> end of mybatchfile.bat
> 
> 
> 
> 
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> 
> -
> 
> 
> 
> 
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
> 



-
To unsubscribe, send email to [EMAIL 

Re: [sqlite] IF EXISTS when using DROP TABLE

2006-10-23 Thread epankoke
Thank you.  My version does not.  I had used one of the archives to search for 
this issue, but the thread I found did not have an answer to the question.

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

 -- Original message --
From: "Adriano Ferreira" <[EMAIL PROTECTED]>
> On 10/23/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > If I use the syntax "DROP TABLE tablename" everything is good, except of 
> course I get a "no such table" error if the table does not exist.  However, 
> if I 
> use the syntax "DROP TABLE IF EXISTS tablename", then I get the following 
> error: 
> 'near "EXISTS": syntax error'.  Anyone have a thought as to what's going on?  
> Is 
> this a known issue?
> 
> It looks like the same issue on the thread "Trouble with ALTER
> TABLE/ADD", answered by drh. Are you sure your version of SQLite
> supports "DROP TABLE IF EXISTS"?
> 
> The URL http://www.sqlite.org/cvstrac/wiki?p=UnsupportedSql says
> 
> IF EXISTS function, e.g. "DROP TABLE IF EXISTS temp;"
> 
> Added in 3.3
> 
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
> 



-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] IF EXISTS when using DROP TABLE

2006-10-23 Thread epankoke
If I use the syntax "DROP TABLE tablename" everything is good, except of course 
I get a "no such table" error if the table does not exist.  However, if I use 
the syntax "DROP TABLE IF EXISTS tablename", then I get the following error: 
'near "EXISTS": syntax error'.  Anyone have a thought as to what's going on?  
Is this a known issue?

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] Random Row Selection

2003-12-04 Thread epankoke
In access, I use the following statement to select a random row: "SELECT TOP 1 * FROM 
Questions WHERE Not QuestionID IN (0) ORDER BY RND(QuestionID)".  How might I 
accomplish this same thing in SQLite?

--
Eric Pankoke
Programmer
Christian Family Software
http://www.christianfamilysoftware.com/

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



Re: [sqlite] sqlite with eVC++

2003-11-21 Thread epankoke
Please forgive me, but I have been away from the C++ world for a long time, and as a 
Visual Basic developer I tend to get lazy.  What do I need to do to build the .lib 
file through the ide?  Do you have a project that you might be able to send me?  I 
really appreciate all the help.

--
Eric Pankoke
Programmer
Christian Family Software
http://www.christianfamilysoftware.com/

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



Re: [sqlite] sqlite with eVC++

2003-11-21 Thread epankoke
I'm not actually sure how to compile the .lib.  I used this command initially: LIB 
/DEF:sqlite.def /MACHINE:ARM.  Is there some other way I should be building a .lib 
file?
> 
>  > I'm not sure what you mean by a WTL gui application, but the problem 
> I'm having is with compilation.  I have included sqlite.h in my project, 
> and I am calling two functions: sqlite_open and sqlite_close.  When I 
> compile, I get an "unresolved external" error on each of these 
> functions, even though I have a .lib file for sqlite and the path to 
> that .lib file is included in my project properties.  I've even listed 
> sqlite.lib explicitly as a dependancy, but that doesn't seem to make a 
> difference.
>  >
>  > Eric
>  >
>  >>Eric Pankoke wrote:
>  >>
>  >>>Is there anyone on this group that uses sqlite with Embedded Visual 
> C++ for
>  >>>the PocketPC?  If so, what do I need to do to get a project with sqlite
>  >>>commands to compile?  Any help would be greatly appreciated.  Thanks.
>  >>>
>  >>>
>  >>>
>  >>>Eric Pankoke
>  >>>
>  >>>Founder
>  >>>
>  >>>Point Of Light Software
>  >>>
>  >>>http://www.polsoftware.com
>  >>>
>  >>>"Lighting The Path To Glory"
>  >>>
>  >>>
>  >>>
>  >>>
>  >>
>  >>I do,
>  >>
>  >>But not from a command line, from WTL gui application.
>  >>How can I help you ?
>  >>Noël
>  >>
>  >>
>  >>-
>  >>To unsubscribe, e-mail: [EMAIL PROTECTED]
>  >>For additional commands, e-mail: [EMAIL PROTECTED]
>  >>
>  >
>  >
>  > -
>  > To unsubscribe, e-mail: [EMAIL PROTECTED]
>  > For additional commands, e-mail: [EMAIL PROTECTED]
>  >
> 
> Is your lib compiled for the right target (mips, arm, sh3) ?
> 
> 
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 

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



Re: [sqlite] sqlite with eVC++

2003-11-21 Thread epankoke
I'm not sure what you mean by a WTL gui application, but the problem I'm having is 
with compilation.  I have included sqlite.h in my project, and I am calling two 
functions: sqlite_open and sqlite_close.  When I compile, I get an "unresolved 
external" error on each of these functions, even though I have a .lib file for sqlite 
and the path to that .lib file is included in my project properties.  I've even listed 
sqlite.lib explicitly as a dependancy, but that doesn't seem to make a difference.

Eric
> Eric Pankoke wrote:
> > Is there anyone on this group that uses sqlite with Embedded Visual C++ for
> > the PocketPC?  If so, what do I need to do to get a project with sqlite
> > commands to compile?  Any help would be greatly appreciated.  Thanks.
> > 
> >  
> > 
> > Eric Pankoke
> > 
> > Founder
> > 
> > Point Of Light Software
> > 
> > http://www.polsoftware.com
> > 
> > "Lighting The Path To Glory"
> > 
> >  
> > 
> > 
> I do,
> 
> But not from a command line, from WTL gui application.
> How can I help you ?
> Noël
> 
> 
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 

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