Pam Greene wrote:
I use sqlite3_create_function() to attach C++ functions to SQLite
triggers. For example, I create the SQL function INSERT_HANDLER(),
bound to the C++ function InsertTriggerHandler(). Then I create a
trigger:
CREATE TRIGGER trig AFTER INSERT ON TableName
FOR EACH ROW
WHE
Eric Bohlman <[EMAIL PROTECTED]> wrote:
> Dennis Cote wrote:
> > You could also do this:
> > SELECT x from y WHERE y.x LIKE '%' || ? || '%' ;
> >
> > The || operator concatenates the % characters with your string. Now you
> > don't need to massage the string in the calling code. Six of one, hal
Dennis Cote wrote:
You could also do this:
SELECT x from y WHERE y.x LIKE '%' || ? || '%' ;
The || operator concatenates the % characters with your string. Now you
don't need to massage the string in the calling code. Six of one, half
dozen of the other.
Note, though, that as currently imp
On 4/7/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> "Miguel Bazdresch" <[EMAIL PROTECTED]> wrote:
> > I must be missing something obvious, but I can't figure out how to
> > compile/install the tcl bindings. I've been trying to install
> > sqlite-3.3.5 for the last few hours.
>
> The TEA (Tcl
On Friday 07 April 2006 22:39, Pam Greene wrote:
> Is there any way to create a more broadly available, persistent custom
> function, short of building it into sqlite? Or does anyone have
> another suggestion to solve the implicit problem?
Layering. Wrap sqlite3_* into your own set of functions.
On 4/7/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote:
> On 4/7/06, Pam Greene <[EMAIL PROTECTED]> wrote:
> > I use sqlite3_create_function() to attach C++ functions to SQLite
> > triggers. For example, I create the SQL function INSERT_HANDLER(),
> > bound to the C++ function InsertTriggerHandler().
On 4/7/06, Pam Greene <[EMAIL PROTECTED]> wrote:
> I use sqlite3_create_function() to attach C++ functions to SQLite
> triggers. For example, I create the SQL function INSERT_HANDLER(),
> bound to the C++ function InsertTriggerHandler(). Then I create a
> trigger:
>
> CREATE TRIGGER trig AFTER
I use sqlite3_create_function() to attach C++ functions to SQLite
triggers. For example, I create the SQL function INSERT_HANDLER(),
bound to the C++ function InsertTriggerHandler(). Then I create a
trigger:
CREATE TRIGGER trig AFTER INSERT ON TableName
FOR EACH ROW
WHEN (INSERT_HANDLER(ne
Hi Dennis,
I followed your path and managed to rebuild my table. All is well in the land
of Roman now. Thanks again,
Roman
On Friday 07 April 2006 11:57 am, Dennis Cote wrote:
> Roman wrote:
> >http://sqlzoo.net/howto/source/z.dir/tip557646/i02create.xml
> >
> >says that such is not possible
> >
Roman wrote:
http://sqlzoo.net/howto/source/z.dir/tip557646/i02create.xml
says that such is not possible
On Friday 07 April 2006 11:39 am, Roman wrote:
I know that ALTER TABLE -> ALTER COLUMN is not supported by sqlite3.
I misspelled a column name, and I am curious if there is a command t
Here's what I might do, I'd be curious of the other's answers.
You could use the .dump command, redirect it into a flat file
Use sed to fix the field name in the file.
Delete the old table.
Then load it back in using the corrected dump file.
-alex
On Apr 7, 2006, at 10:39 AM, Roman wrote:
I k
Roman <[EMAIL PROTECTED]> writes:
> I know that ALTER TABLE -> ALTER COLUMN is not supported by sqlite3.
>
> I misspelled a column name, and I am curious if there is a command to change
> the name from sqlite3 interface.
A bit simplistic, but:
echo ".dump" | \
sqlite3 database.db | \
sed 's
http://sqlzoo.net/howto/source/z.dir/tip557646/i02create.xml
says that such is not possible
On Friday 07 April 2006 11:39 am, Roman wrote:
> I know that ALTER TABLE -> ALTER COLUMN is not supported by sqlite3.
>
> I misspelled a column name, and I am curious if there is a command to
> change the
I know that ALTER TABLE -> ALTER COLUMN is not supported by sqlite3.
I misspelled a column name, and I am curious if there is a command to change
the name from sqlite3 interface.
Thanks,
RK
Marian Olteanu wrote:
But why don't you use
SELECT x from y WHERE y.x LIKE ? ;
and bind the first parameter to "%SomeText%" instead of "SomeText" like
before?
Chad,
You could also do this:
SELECT x from y WHERE y.x LIKE '%' || ? || '%' ;
The || operator concatenates the % characters wi
> >http://3dcanvas.tcl.tk :)
>
oops, html problem I think:
A 3-D Canvas Widget For Tcl/Tk
don't believe is valid there.
On Fri, 7 Apr 2006, Dan Kennedy wrote:
>
>> The same virtual server hosts multiple websites. Besides
>> SQLite it hosts:
>>
>>http://www.cvstrac.org/
>>http://canvas3d.tcl.tk/
>>http://tkhtml.tcl.tk/
>
>http://3dcanvas.tcl.tk :)
Mmmm, triangles:)
>
>
>_
> The same virtual server hosts multiple websites. Besides
> SQLite it hosts:
>
>http://www.cvstrac.org/
>http://canvas3d.tcl.tk/
>http://tkhtml.tcl.tk/
http://3dcanvas.tcl.tk :)
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the
In general, a journal is created when executing a DELETE statement.
Guarantees of atomicity etc. (ACID) are the same as for an INSERT.
Dan.
--- chetana bhargav <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I just want to know how rows are deleted, its same like insertion where we
> create journal
"Miguel Bazdresch" <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I must be missing something obvious, but I can't figure out how to
> compile/install the tcl bindings. I've been trying to install
> sqlite-3.3.5 for the last few hours.
>
The TEA (Tcl Extension Architecture) package from the download
pa
Hi,
I just want to know how rows are deleted, its same like insertion where we
create journal?
-x-
-
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+
countries) for 2ยข/min or less.
21 matches
Mail list logo
