Re: [sqlite] How to update wiki? date/time page misprint
> strftime ... for the %j format ... should specify > 001-366 instead of 000-366 You're correct. You should be able to edit the page by clicking on Edit just below the main heading. Regards
Re: [sqlite] I need one or two testers for my SQLITE3 DBMS tool i wrote.
Hmm, my previous post got not posted because the correct address wasn't set. Can't get a grip on this board yet :) A duplicate is not created if there was an error. And if the name already exists but that would generate an error as well. You might have been mistaken since there is a sort in the tablenames (?) I know the gui is not 100%, the technical part is more important for me now. Writting a better gui can always be done in the future. There are enough parts in the code i wouldn't publish. The bottlenecks are the table rebuilds and duplicates+data. In both cases the table is copied to a new one. All data *must* be equal as before of course. pbsdbms transfers data in the X' HEX ' format and should be safe. But still, databases are very important and if a mistake is made you might never find out until...? Therefore the warnings and this extra testing. Don't forget to check the help, import is a nice feature, all OLEDB/ADO stuff can be read in (i hope :) ) Give the QBE part a try, it's clean and simple. Looks like access QBE. The result query can be copied onto the clipboard and placed in a view or whatever. The querydef's are maintained in an 'hidden' table. (It's made hidden in pbsdbms only of course) Version 2 is rather obsolete, are there more people interested in v2.8 support? And why? Afaik only the blob part might be troublesome for me. Maybe no NUL char support. Not my favourite, i like sqlite3 as it is now very. - Original Message - From: "Andrew Brampton" <[EMAIL PROTECTED]> To: "Edwin Knoppert" <[EMAIL PROTECTED]> Sent: Tuesday, August 16, 2005 10:12 PM Subject: Re: [sqlite] I need one or two testers for my SQLITE3 DBMS tool i wrote. Hi again, ok I just tested Duplicate again and it did work, but I swear 10minutes ago it didn't. Maybe there is some odd situation that caused that :/ Mail me back and I'll write you out the list. What does that mean, you're no longer testing? Sorry I meant, if you want me to give you feedback on the GUI mail me back and I'll write out a list. I didn't want to write out the list if you didn't want it (because in your orginal email you said "not what to change like gui changes". Oh as for the open sourcing I'm not going to convince you to, but I'm curious as to why you want to stay closed? So far I've not found any "critical" bugs, only the little things I already mentioned. It seems pretty good, and with a few minor tweaks I'm sure it be ready to release. oh another idea!. Any chance for SQLite 2 and 3 support? Thanks Andrew - Original Message - From: "Edwin Knoppert" <[EMAIL PROTECTED]> To: "Andrew Brampton" <[EMAIL PROTECTED]> Sent: Tuesday, August 16, 2005 9:00 PM Subject: Re: [sqlite] I need one or two testers for my SQLITE3 DBMS tool i wrote. All those things you mention might change in the future. Main idea about this test to find serious issues. The table create and a few others is not preferred by me either. But has no serious impact on it's use at this time. Duplicate does duplicate a table with or without it's contents, should work. Ok name is a random one but it should be identical, if not... ? I'm considering to rewrite the listview 'engine' to make use of sqlitre_prepare() instead of .. gettable() This will have impact on the virtual grid and in the future i might rewrite that part completely + including a way to edit the contents. And yes with an optional binary edittor for BLOB data as well. That's far from now (if ever). That combo.. well i wanted that myself but at this time that grid is not able to handle both edit and combo. Otherwise it would be in right-away. Mail me back and I'll write you out the list. What does that mean, you're no longer testing? Source will not be public no. - Original Message - From: "Andrew Brampton" <[EMAIL PROTECTED]> To: "Edwin Knoppert" <[EMAIL PROTECTED]> Sent: Tuesday, August 16, 2005 9:52 PM Subject: Re: [sqlite] I need one or two testers for my SQLITE3 DBMS tool i wrote. Hi, I've received it now... I had a quick play with it and I couldn't find any way to crash it. A few comments: 1) When I add a table why does a default table get made? Can't I select some options before its created? 2) When I duplicate structure why can't I chose its name before its created? 3) Duplicate doesn't seem to do anything. No message, no error, no change. 4) Is there a way for me to edit the records in the database? I haven't played with the Views, Triggers, Indexes or Query Builder yet, but I will soon I had some comments about the GUI, but you say you dont' want to hear about them. They were general HCI comment ie ("I would like drop down box for the types in the table editor), as opposed to "I don't like the look of blah, etc", so you may find them useful. Mail me back and I'll write you out the list. Ok hope these comments are useful. Andrew P.S I see the warning saying its freeware, have you considered open
Re: [sqlite] make test fails at tcl-10.5
Works now. Thanks much! -Hari On Tue, 2005-08-16 at 07:11 -0400, D. Richard Hipp wrote: > On Mon, 2005-08-15 at 19:40 -0700, Hari Kodungallur wrote: > > Hi, > > > > I am using the latest from the CVS. While doing "make test", it fails at > > tcl-10.5 with a segmentation fault. > > > > Can you please guide me on how I can debug the issue? > > http://www.sqlite.org/cvstrac/chngview?cn=2596. > > Do "cvs update" and try again. > > -- Hari Kodungallur SpikeSource Inc.
[sqlite] How to update wiki? date/time page misprint
I'm not sure if it is possible for myself to update the SQLite wiki, but on the Date and Time Functions page, http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions, the text for the format of strftime is incorrect for the %j format. I believe this should specify 001-366 instead of 000-366. A minor change, but may cause confusion for some. Thanks, Bob Envision Information Technologies Associate [EMAIL PROTECTED] v. 608.256.5680 f. 608.256.3780
Re: [sqlite] Linking libsqlite statically
D. Kettler said: > When I add the -static flag to my g++ command it gives me 'undefined > reference to' errors for every instance where I attempt to use a sqlite > function. > > This is on a Debian (testing) system and yes I have both libsqlite3 and > libsqlite3-dev installed. There are libsqlite3.a, libsqlite3.la, and > libsqlite3.so files in /usr/lib/ > > I also tried giving the path to the libsqlite3.a file explicitly, but it > works no better. David, Static linking is a major pain in the tail. Everything is dependent upon the order that libraries are listed on the linker command line. If something in a module that appears after -lsqlite3 references sqlite3, you won't get the symbol resolved by the linker. What's your link command line (the one that contains -lsqlite3)? That may help us out quite a bit. The earlier bits about #define are malarkey and only relevant to win32 programmers. They have a notion of private and public members for shared libraries that doesn't apply in the UNIX world. Clay Dowling -- Lazarus Notes from Lazarus Internet Development http://www.lazarusid.com/notes/ Articles, Reviews and Commentary on web development
RE: [sqlite] Convert / Import
-Original Message- From: administrator [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 16, 2005 5:01 AM To: sqlite-users@sqlite.org Subject: [sqlite] Convert / Import Does anybody know a good/quick way to convert from V.Fox 8 .dbf to sqlite format ? I tried to export to .csv from Visual Fox , then to import into .db using SQLite Database Browser but it just takes to much time (running for 2h50m now and still going, a ~ 2.000.000. rows each with 32 fields ) and hassle. Any quick way to do this ? Thank you. Dumitru Florin. = If you end up continuing to use .CSV and importing, you may want to create your indices after the import, and turn the synchronous parameter OFF (until after the conversion). These should reduce the total conversion time. Donald Griggs Opinions are not necessarily those of Misys Healthcare Systems nor its board of directors.
Re: [sqlite] Have ever anybody port SQLite to WinCE
Noel Frankinet napisał(a): > jason zhang wrote: > >> Hi, >> Thank you. >> How about the performance of this library? - Original Message >> > > very good, I even use it for graphic display (GIS). > I use sqlite on Windows CE too and as Noel I use it for GIS applications. I can say it is the best SQL based database for Windows CE: - simple - very fast - typless - supports UNICODE - SQL92 implementation - very simple to use, - portable (the same db file on all platforms, just make a copy) - many wrappers for programming langs - open source on LGPL I've tested to query about 6500 records and displayed in Windows CE listview control (virtual mode) and it really ROCKS! Cheers -- Mateusz Łoskot, mateusz (at) loskot (dot) net Registered Linux User #220771
[sqlite] The total when using LIMIT clause
Hi, How do we know the total number of results, when we are using LIMIT? is there any parameter that returns the real number of matches? Thanks in advance. -- :: Ligesh
Re: [sqlite] make test fails at tcl-10.5
On Mon, 2005-08-15 at 19:40 -0700, Hari Kodungallur wrote: > Hi, > > I am using the latest from the CVS. While doing "make test", it fails at > tcl-10.5 with a segmentation fault. > > Can you please guide me on how I can debug the issue? http://www.sqlite.org/cvstrac/chngview?cn=2596. Do "cvs update" and try again. -- D. Richard Hipp <[EMAIL PROTECTED]>
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
Thank you ! That did it in 17 minutes. - Original Message - From: "Sergey Startsev" <[EMAIL PROTECTED]> To: "administrator"Sent: Tuesday, August 16, 2005 12:08 PM Subject: 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: [sqlite] I need one or two testers for my SQLITE3 DBMS tool i wrote.
Sent.. - Original Message - From: "Andrew Brampton" <[EMAIL PROTECTED]> To:Sent: Tuesday, August 16, 2005 10:38 AM Subject: Re: [sqlite] I need one or two testers for my SQLITE3 DBMS tool i wrote. Sure I'll help out. Andrew - Original Message - From: "Edwin Knoppert" <[EMAIL PROTECTED]> To: Sent: Tuesday, August 16, 2005 8:29 AM Subject: [sqlite] I need one or two testers for my SQLITE3 DBMS tool i wrote. I only need a list what i need to correct like critical errors, not what to change like gui changes or similar. It's a freeware tool and not being released before it had a better test than i did. Mail me if you want to help. App consists from exe, hlp and sqlite3 dll. hope you'll look into the help as well. Here is an image: http://www.hellobasic.com/images/pbsdbms.jpg Thanks!
Re: [sqlite] I need one or two testers for my SQLITE3 DBMS tool i wrote.
Only Windows i'm affraid. (Virtual PC?) - Original Message - From: "Dr Gerard Hammond" <[EMAIL PROTECTED]> To:Cc: "Edwin Knoppert" <[EMAIL PROTECTED]> Sent: Tuesday, August 16, 2005 10:51 AM Subject: Re: [sqlite] I need one or two testers for my SQLITE3 DBMS tool i wrote. At 9:29 AM +0200 16/8/05, Edwin Knoppert wrote: I only need a list what i need to correct like critical errors, not what to change like gui changes or similar. It's a freeware tool and not being released before it had a better test than i did. Mail me if you want to help. App consists from exe, hlp and sqlite3 dll. hope you'll look into the help as well. Here is an image: http://www.hellobasic.com/images/pbsdbms.jpg Thanks! Does it run under MacOS X. If so, then I'd be happy to test. -- Cheers, Dr Gerard Hammond Bioinformatic Analyst Garvan Institute of Medical Research, Sydney, Australia. Bioinformatics is the science of managing, mining, and interpreting information from biological and clinical data, including sequences, structures, gene expression profiles, mass spectra and medical records.
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
[sqlite] Convert / Import
Does anybody know a good/quick way to convert from V.Fox 8 .dbf to sqlite format ? I tried to export to .csv from Visual Fox , then to import into .db using SQLite Database Browser but it just takes to much time (running for 2h50m now and still going, a ~ 2.000.000. rows each with 32 fields ) and hassle. Any quick way to do this ? Thank you. Dumitru Florin.
Re: [sqlite] I need one or two testers for my SQLITE3 DBMS tool i wrote.
At 9:29 AM +0200 16/8/05, Edwin Knoppert wrote: I only need a list what i need to correct like critical errors, not what to change like gui changes or similar. It's a freeware tool and not being released before it had a better test than i did. Mail me if you want to help. App consists from exe, hlp and sqlite3 dll. hope you'll look into the help as well. Here is an image: http://www.hellobasic.com/images/pbsdbms.jpg Thanks! Does it run under MacOS X. If so, then I'd be happy to test. -- Cheers, Dr Gerard Hammond Bioinformatic Analyst Garvan Institute of Medical Research, Sydney, Australia. Bioinformatics is the science of managing, mining, and interpreting information from biological and clinical data, including sequences, structures, gene expression profiles, mass spectra and medical records.
Re: [sqlite] I need one or two testers for my SQLITE3 DBMS tool i wrote.
Sure I'll help out. Andrew - Original Message - From: "Edwin Knoppert" <[EMAIL PROTECTED]> To:Sent: Tuesday, August 16, 2005 8:29 AM Subject: [sqlite] I need one or two testers for my SQLITE3 DBMS tool i wrote. I only need a list what i need to correct like critical errors, not what to change like gui changes or similar. It's a freeware tool and not being released before it had a better test than i did. Mail me if you want to help. App consists from exe, hlp and sqlite3 dll. hope you'll look into the help as well. Here is an image: http://www.hellobasic.com/images/pbsdbms.jpg Thanks!
[sqlite] I need one or two testers for my SQLITE3 DBMS tool i wrote.
I only need a list what i need to correct like critical errors, not what to change like gui changes or similar. It's a freeware tool and not being released before it had a better test than i did. Mail me if you want to help. App consists from exe, hlp and sqlite3 dll. hope you'll look into the help as well. Here is an image: http://www.hellobasic.com/images/pbsdbms.jpg Thanks!
Re: [sqlite] Have ever anybody port SQLite to WinCE
Thank you! you are so kind. - Original Message - From: "Noel Frankinet" <[EMAIL PROTECTED]> To:Sent: Tuesday, August 16, 2005 3:17 PM Subject: Re: [sqlite] Have ever anybody port SQLite to WinCE > jason zhang wrote: > >>Hi, >> Thank you. >> How about the performance of this library? >> >>- Original Message - >>From: "Noel Frankinet" <[EMAIL PROTECTED]> >>To: >>Sent: Tuesday, August 16, 2005 2:57 PM >>Subject: Re: [sqlite] Have ever anybody port SQLite to WinCE >> >> >> >> >>>jason zhang wrote: >>> >>> >>> Hi, Thank you.I just found that there is a project named "SQLite for wince" in sourceforge.net, Do you use that version? - Original Message - From: "Noel Frankinet" <[EMAIL PROTECTED]> To: Sent: Tuesday, August 16, 2005 2:49 PM Subject: Re: [sqlite] Have ever anybody port SQLite to WinCE >jason zhang wrote: > > > > > >>Hi all, >> I am going to use SQLite on WinCE platform.Have ever anybody has >> experience with it? >>I encounter some problem when I port SQLite to WinCE. >> >> >> >> >>No virus found in this incoming message. >>Checked by AVG Anti-Virus. >>Version: 7.0.338 / Virus Database: 267.10.9/72 - Release Date: 14/08/2005 >> >> >> >> >> >> >Hello, >yes, I use sqlite on winCE for two years now. >Regards > >-- >Noël Frankinet >Gistek Software SA >http://www.gistek.net > > > > > > >>>yes, I had made the first crude port to ce than I switched to that much >>>better port. >>> >>>-- >>>Noël Frankinet >>>Gistek Software SA >>>http://www.gistek.net >>> >>> >>> >>> >> >> >> >> > very good, I even use it for graphic display (GIS). > > -- > Noël Frankinet > Gistek Software SA > http://www.gistek.net > >
Re: [sqlite] Have ever anybody port SQLite to WinCE
jason zhang wrote: Hi, Thank you. How about the performance of this library? - Original Message - From: "Noel Frankinet" <[EMAIL PROTECTED]> To:Sent: Tuesday, August 16, 2005 2:57 PM Subject: Re: [sqlite] Have ever anybody port SQLite to WinCE jason zhang wrote: Hi, Thank you.I just found that there is a project named "SQLite for wince" in sourceforge.net, Do you use that version? - Original Message - From: "Noel Frankinet" <[EMAIL PROTECTED]> To: Sent: Tuesday, August 16, 2005 2:49 PM Subject: Re: [sqlite] Have ever anybody port SQLite to WinCE jason zhang wrote: Hi all, I am going to use SQLite on WinCE platform.Have ever anybody has experience with it? I encounter some problem when I port SQLite to WinCE. No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.9/72 - Release Date: 14/08/2005 Hello, yes, I use sqlite on winCE for two years now. Regards -- Noël Frankinet Gistek Software SA http://www.gistek.net yes, I had made the first crude port to ce than I switched to that much better port. -- Noël Frankinet Gistek Software SA http://www.gistek.net very good, I even use it for graphic display (GIS). -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] Have ever anybody port SQLite to WinCE
Hi, Thank you. How about the performance of this library? - Original Message - From: "Noel Frankinet" <[EMAIL PROTECTED]> To:Sent: Tuesday, August 16, 2005 2:57 PM Subject: Re: [sqlite] Have ever anybody port SQLite to WinCE > jason zhang wrote: > >>Hi, >> Thank you.I just found that there is a project named "SQLite for wince" in >> sourceforge.net, >>Do you use that version? >> >> >>- Original Message - >>From: "Noel Frankinet" <[EMAIL PROTECTED]> >>To: >>Sent: Tuesday, August 16, 2005 2:49 PM >>Subject: Re: [sqlite] Have ever anybody port SQLite to WinCE >> >> >> >> >>>jason zhang wrote: >>> >>> >>> Hi all, I am going to use SQLite on WinCE platform.Have ever anybody has experience with it? I encounter some problem when I port SQLite to WinCE. No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.9/72 - Release Date: 14/08/2005 >>>Hello, >>>yes, I use sqlite on winCE for two years now. >>>Regards >>> >>>-- >>>Noël Frankinet >>>Gistek Software SA >>>http://www.gistek.net >>> >>> >>> >>> >> >> >> >> > yes, I had made the first crude port to ce than I switched to that much > better port. > > -- > Noël Frankinet > Gistek Software SA > http://www.gistek.net > >
Re: [sqlite] Have ever anybody port SQLite to WinCE
jason zhang wrote: Hi, Thank you.I just found that there is a project named "SQLite for wince" in sourceforge.net, Do you use that version? - Original Message - From: "Noel Frankinet" <[EMAIL PROTECTED]> To:Sent: Tuesday, August 16, 2005 2:49 PM Subject: Re: [sqlite] Have ever anybody port SQLite to WinCE jason zhang wrote: Hi all, I am going to use SQLite on WinCE platform.Have ever anybody has experience with it? I encounter some problem when I port SQLite to WinCE. No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.9/72 - Release Date: 14/08/2005 Hello, yes, I use sqlite on winCE for two years now. Regards -- Noël Frankinet Gistek Software SA http://www.gistek.net yes, I had made the first crude port to ce than I switched to that much better port. -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] Have ever anybody port SQLite to WinCE
Hi, Thank you.I just found that there is a project named "SQLite for wince" in sourceforge.net, Do you use that version? - Original Message - From: "Noel Frankinet" <[EMAIL PROTECTED]> To:Sent: Tuesday, August 16, 2005 2:49 PM Subject: Re: [sqlite] Have ever anybody port SQLite to WinCE > jason zhang wrote: > >>Hi all, >> I am going to use SQLite on WinCE platform.Have ever anybody has >> experience with it? >>I encounter some problem when I port SQLite to WinCE. >> >> >> >> >>No virus found in this incoming message. >>Checked by AVG Anti-Virus. >>Version: 7.0.338 / Virus Database: 267.10.9/72 - Release Date: 14/08/2005 >> >> > Hello, > yes, I use sqlite on winCE for two years now. > Regards > > -- > Noël Frankinet > Gistek Software SA > http://www.gistek.net > >
Re: [sqlite] Have ever anybody port SQLite to WinCE
jason zhang wrote: Hi all, I am going to use SQLite on WinCE platform.Have ever anybody has experience with it? I encounter some problem when I port SQLite to WinCE. No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.9/72 - Release Date: 14/08/2005 Hello, yes, I use sqlite on winCE for two years now. Regards -- Noël Frankinet Gistek Software SA http://www.gistek.net
[sqlite] Have ever anybody port SQLite to WinCE
Hi all, I am going to use SQLite on WinCE platform.Have ever anybody has experience with it? I encounter some problem when I port SQLite to WinCE.