[sqlite] Re: Logo usage

2006-12-17 Thread Muhammad Hassan
I just want to know if it is legal to use Sqlite logo on my companies website technology page http://badrit.com/page/technology, i want to refer to the technologies we used? Please reply. Thanks. On 12/13/06, Muhammad Hassan [EMAIL PROTECTED] wrote: Can i use Sqlite logo on my companies

RE: [sqlite] Is sqlite the right db for me?

2006-12-17 Thread Steve Davis
Roger, I genuinely appreciate your comments. My consideration has been that although setting up a server and mySQL is trivial for me, it might not be for someone else who isn't a geek. But that will have to be resolved in the installation process. Thanks again. All the best Steve Davis

Re: [sqlite] Re: Logo usage

2006-12-17 Thread Martin Jenkins
Muhammad Hassan wrote: I just want to know if it is legal to use Sqlite logo on my companies website technology page http://badrit.com/page/technology, i want to refer to the technologies we used? As I understand it, Dr Hipp has disclaimed all rights to the SQLite software, his intention

Re: [sqlite] Re: Logo usage

2006-12-17 Thread Muhammad Hassan
Thanks On 12/17/06, Martin Jenkins [EMAIL PROTECTED] wrote: Muhammad Hassan wrote: I just want to know if it is legal to use Sqlite logo on my companies website technology page http://badrit.com/page/technology, i want to refer to the technologies we used? As I understand it, Dr Hipp

Re: [sqlite] Is sqlite the right db for me?

2006-12-17 Thread Derrell . Lipman
Steve Davis [EMAIL PROTECTED] writes: It is not a web-based app, rather browser based. Many brigades do not have net access at their stations, they might only have someone there once a fortnight, so it isn't viable. Also this app might also be used on a notebook at a remote location...where

Re: [sqlite] Is sqlite the right db for me?

2006-12-17 Thread John Stanton
I can imagine that before long all firefighters will have internet connected equipment. A handheld device with broadband access and GPS is an obvious move forward, both for safety, for rapid deployment of resources and for access to maps and logistics. To design what you are doing now for

Re: [sqlite] Is sqlite the right db for me?

2006-12-17 Thread jose simas
I have a reasonably large application written in VB6 that uses SQLite. It is possibly the simplest solution for you as you already know VBScript. It is also very easy to install on most computers (with Windows, I mean). Another option would be VB.NET or C# if you distribute the app usind CDs. A

Re: [sqlite] Calculate years and months difference with Julian Date?

2006-12-17 Thread John Stanton
Have a look at Sqlite date code. I just lifted its data structures and used its functions to build user functions to give month etc. The algorithms are accurate and they are easy to use. I found setting up user functions to do those calculations made the SQL simpler. The functions are in a

Re: [sqlite] Is sqlite the right db for me?

2006-12-17 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Steve Davis wrote: | My consideration has been that although setting up a server and mySQL is | trivial for me, it might not be for someone else who isn't a geek. But that | will have to be resolved in the installation process. There are pre-built

RE: [sqlite] Calculate years and months difference with Julian Date?

2006-12-17 Thread RB Smissaert
I am not into C and I want to stay clear from compiling SQLite. Or do I misunderstand this? RBS -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: 17 December 2006 20:38 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Calculate years and months difference with

RE: [sqlite] building sqlite on windows in Unicode

2006-12-17 Thread Robert Simpson
I wrote the original patch to loadext.c with the intent of making it as minimally obtrusive as possible to the existing code structure. I know firsthand how much DRH hates changing his codebase :) As Brodie stated, FreeLibrary() takes a type HANDLE, which is returned from a call to LoadLibrary()

Re: [sqlite] building sqlite on windows in Unicode

2006-12-17 Thread Brodie Thiesfield
Robert Simpson wrote: I wrote the original patch to loadext.c with the intent of making it as minimally obtrusive as possible to the existing code structure. I know firsthand how much DRH hates changing his codebase :) [snip] FWIW, that patch I wrote is currently in production code in the

Re: [sqlite] Calculate years and months difference with Julian Date?

2006-12-17 Thread John Stanton
I answered your question. It is possible and showed you how to do it. The rest is up to you. RB Smissaert wrote: I am not into C and I want to stay clear from compiling SQLite. Or do I misunderstand this? RBS -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: 17

RE: [sqlite] Calculate years and months difference with Julian Date?

2006-12-17 Thread RB Smissaert
Yes, and it is nice to know that this is an option. I am using a VB wrapper though and not using the SQLite dll. Will figure something out. RBS -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: 17 December 2006 23:05 To: sqlite-users@sqlite.org Subject: Re: [sqlite]

Re: [sqlite] Calculate years and months difference with Julian Date?

2006-12-17 Thread claudio benghi
On 12/18/06, RB Smissaert [EMAIL PROTECTED] wrote: Yes, and it is nice to know that this is an option. I am using a VB wrapper though and not using the SQLite dll. Will figure something out. RBS In VB.net I once solved this implementing an user function using the ADO.net provider. You can

RE: [sqlite] Calculate years and months difference with Julian Date?

2006-12-17 Thread RB Smissaert
Interesting and thanks for the tip, but I don't think you can do that in VBA. Maybe it is possible in VB6. Will have a look at it. RBS -Original Message- From: claudio benghi [mailto:[EMAIL PROTECTED] Sent: 18 December 2006 00:40 To: sqlite-users@sqlite.org Subject: Re: [sqlite]

Re: [sqlite] Calculate years and months difference with Julian Date?

2006-12-17 Thread drh
RB Smissaert [EMAIL PROTECTED] wrote: Is it possible with Julian dates in 2 fields to calculate the months and/or years difference between those 2 dates? I know I can subtract the 2 dates and divide by 30 (or 30.42) or 365 and take it from there, but I would like it a bit more precise, so

Re: [sqlite] building sqlite on windows in Unicode

2006-12-17 Thread Joe Wilson
Many large open source projects have committers for specific platforms, or particular sections of the code. I would think that Windows support and autoconfigury would be good candidates for delegation. One guy can't do it all. --- Brodie Thiesfield [EMAIL PROTECTED] wrote: [EMAIL PROTECTED]

[sqlite] SQL error: near READ_ONLY: syntax error

2006-12-17 Thread LuYanJun
Hi guy: what does the follow meaning? sqlite BEGIN READ_ONLY; SQL error: near READ_ONLY: syntax error

Re: [sqlite] SQL error: near READ_ONLY: syntax error

2006-12-17 Thread Marten Feldtmann
LuYanJun schrieb: Hi guy: what does the follow meaning? sqlite BEGIN READ_ONLY; SQL error: near READ_ONLY: syntax error READ_ONLY is not a valid option for this command. BEGIN [DEFERRED | EXCLUSIVE | IMMEDIATE] Marten

RE: [sqlite] Calculate years and months difference with Julian Date?

2006-12-17 Thread RB Smissaert
If you have two dates A and B, you can ask the question: Is A more than one month after B like this: SELECT julianday(A,'+1 month')B ... Thanks; that looks exactly what I need. RBS -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 18 December 2006