#ifndef SQLITE_OMIT_STORED_PROC_LANGUAGE
--- John Stanton <[EMAIL PROTECTED]> wrote:
> Well put. If Sqlite were turned into a junior Oracle, DB2 or PostgreSQL
> then someone else would have to create a new Sqlite to handle the
> lightweight embedded RDBMS role!
#endif
How is it different
Yes, any standard SQLite stored proc language is better than no
standard language, but Tcl is a hard sell because of [its {syntax}].
I used Tcl on a project several years ago and I still find
myself going back to the reference book every time I'm working with
arrays, loops and expressions. Also
On 12/22/06, Jeff Godfrey <[EMAIL PROTECTED]> wrote:
Thanks for the nudge. I never thought to check for the external DLL,
but checking my SQLite Expert installation folder I see...
sqlite3.dll
Interestingly, the DLL has the same size and date/time stamp as the
one that's available for download
- Original Message -
From: "Nuno Lucas" <[EMAIL PROTECTED]>
To:
Sent: Thursday, December 21, 2006 5:45 PM
Subject: Re: [sqlite] Mathematical "power" operator?
Just wanted to add that if one of the sqlite GUI's out there uses an
external sqlite dll (
Tom Briggs wrote:
If you want the Super SQLite GUI Tool and Swiss Army Knife 3000 to
have a POWER function, contact the maintainer of said tool - it's an
application problem. If you want your application to have the POWER
function, roll your own build of SQLite. Those are application
proble
Just wanted to add that if one of the sqlite GUI's out there uses an
external sqlite dll (instead of static linking) it's quite easy to
make your own dll with your own functions and replace the one that
comes with the GUI application.
This was discussed before, but don't know if any one of them a
x27;t generalize things according
to language anyway.
-Tom
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Thursday, December 21, 2006 12:56 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Mathematical 'power' operator?
Maybe a dumb ques
> This is quick simple and portable to your application only.
> You can not
> use a 3rd party GUI database browser that is statically linked to a
> different SQLite library (such as the standard distribution)
> to view or
> modify your database. You must add specific support for any desired
wouldn't generalize things according
to language anyway.
-Tom
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 21, 2006 12:56 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Mathematical 'power&#x
Maybe a dumb queston, but:
As it looks it is easiest to work with SQLite from Tcl, is it possible
to code in Tcl and call that from VB/VBA?
RBS
> Well put. If Sqlite were turned into a junior Oracle, DB2 or PostgreSQL
> then someone else would have to create a new Sqlite to handle the
> lightwei
Well put. If Sqlite were turned into a junior Oracle, DB2 or PostgreSQL
then someone else would have to create a new Sqlite to handle the
lightweight embedded RDBMS role!
It is very simple to add functions to Sqlite, and since it is a library
you link into your application there is no reason
All,
Thanks for the interesting responses. I think I now have a clear
understanding of my options, and while not exactly what I was looking
for, I can work within the prescribed limitations. As I mentioned, I
am working from Tcl, where it's quite easy to write and register a new
function wi
Joe Wilson wrote:
One of the strengths of SQLite is having the flexability to
hook it up to any language you like. But it would make life easier
for everyone if there was some sort of standard built-in simple
scripting language to create stored procedures and custom functions
within the standar
Tom Briggs wrote:
Now, as for a "power" function: we had exactly the same need when we
first started using SQLite. Our solution: we added it. The source code
is freely available, after all. Adding a new function to the code is
shockingly straightforward; from there you simply compile your
mail_ma wrote:
> I set the maillist is every one to send me ,so many mail is not good,
> I want get a archive,what URL i can cancel it ?
> please help me ???
>
>
>
See the mailing list instructions at the top of
http://www.sqlite.org/support.html
HTH
Dennis Cote
---
mail_ma wrote:
> I set the maillist is every one to send me ,so many mail is not good,
> I want get a archive,what URL i can cancel it ?
> please help me ???
>
Not sure what you're asking here.
If you want to remove yourself from the list send an email to
mailto:[EMAIL PROTECTED]
If you want
I set the maillist is every one to send me ,so many mail is not good,
I want get a archive,what URL i can cancel it ?
please help me ???
mail_ma
2006-12-21
发件人： Jeff Godfrey
发送时间： 2006-12-20 05:47:20
收件人： sqlite-users@sqlite.org
抄送：
主题： Re: [sqlite] Mathematical "power" operat
> In the case of SQLite, I (arguably) have to use a 3rd party
> management
> tool, for which my custom functions are no longer available. I'm
> curious how others handle this.
>
> A. You don't need or use any custom SQL functionality
> B. You don't use a 3rd party SQLite management tool
>
One of the strengths of SQLite is having the flexability to
hook it up to any language you like. But it would make life easier
for everyone if there was some sort of standard built-in simple
scripting language to create stored procedures and custom functions
within the standard SQLite distro to
Jeff Godfrey wrote:
I'm curious how others handle this.
A. You don't need or use any custom SQL functionality
B. You don't use a 3rd party SQLite management tool
C. Something else I haven't thought of?
Jeff,
I think it is mostly A, or B, or at least it alternates between A and B
depending
ustom SQL functionality
B. You don't use a 3rd party SQLite management tool
C. Something else I haven't thought of?
Thanks for any additional guidance.
Jeff Godfrey
- Original Message -
From: "jt" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, December 20, 200
Hi,
Look at the new "loadable extension" feature:
http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions
It also describe an example that could be really easy to convert to
your sqrt problem.
--
Julien
-
To unsubscribe
mittedly have very little experience in this domain.
Again, thanks for your input.
Jeff
- Original Message -
From: "Jesús López" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, December 19, 2006 3:08 PM
Subject: RE: [sqlite] Mathematical "power" operator?
Hi Jeff,
I
Hi Jeff,
I'm not a Tcl user. I use C# and Robert Simpson's SQLite ADO.NET 2.0
provider to access SQLite databases.
SQLite allows you to define both scalar and aggregate user defined
functions. I think the way to approach your issue is to define a scalar user
defined function. I don't know how to
24 matches
Mail list logo
