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" operator? Jes�s, Thanks for the response. As I mentioned in my original message, it seems that I can create my own replacement functions and register them with SQLite via the provided "function" method. While I assume that'll solve the issue when running my code, how does one go about using views containing custom functions in 3rd party tools (in my case "SQLite Expert Personal")? I assume the answer is " you don't, unless the 3rd part tool somehow allows for the inclusion of user-defined functions". I want to have my cake and eat it too... ;^) Now, I guess that brings me back to my initial thought, which was... With all the fancy functionality that's apparently supported by SQLite expressions, isn't the absence of a basic mathematical "power" operator a glaring omission? It seems to me that it is, though I admittedly have very little experience in this domain. Again, thanks for your input. Jeff ----- Original Message ----- From: "Jes�s L�pez" <[EMAIL PROTECTED] > To: <sqlite-users@sqlite.org > Sent: Tuesday, December 19, 2006 3:08 PM Subject: RE: [sqlite] Mathematical "power" operator? 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 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 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 "^" operator, so I'm trying to find the best way around that. I'm using SQLite from Tcl. I know that I can create my own Tcl-based replacements for these functions and register them with SQLite via the "function" method, though that still seems to leave an issue. I am using a 3rd part tool (SQLite Expert Personal) to create, manipulate, and generally experiment with my SQLite database. Obviously, if I create a Tcl-based function replacement, I can use it from within my code, but it won't be recognized when I open up the VIEW query that uses it via the 3rd part tool. Also, I can fairly easily change the query to get by without the need for the "squared" function, though the "square root" function would seem to be a bit more tricky to "code around". So, a few questions: 1. Thoughts on my specific issue with the missing mathematical operator? 2. More generally, do people who "add" functions to SQLite just not use 3rd party tools to work with their data? Thanks for any insight... Jeff Godfrey ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
