#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.
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
- Original Message -
From: "Nuno Lucas" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
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
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
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
e 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 queston, but:
As it looks it
> 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
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' operato
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
>
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
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
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 ???
>
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
> 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
e 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: <sqlite-users@sqlite.org>
Sent: Wednesday, December 20, 2006 9:23 AM
Subject: Re: [sq
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
to do it with Tcl, I just know how to do
it with c#.
Regards:
Jesús López
-Mensaje original-
De: Jeff Godfrey [mailto:[EMAIL PROTECTED]
Enviado el: martes, 19 de diciembre de 2006 21:45
Para: sqlite-users@sqlite.org
Asunto: [sqlite] Mathematical "power" operator?
Hi All,
New
Hi All,
New to SQLite, so bear with me... ;^)
I'm trying to migrate an MS-Access database over to SQLite. I have a VIEW
created from a SELECT statement that uses the mathematical "power" operator
("^") for both "square root" and "squared" operations. It seems that SQLite
doesn't support the
21 matches
Mail list logo
