Hi,
I have recently implemented SQlite into my Application which is an
Engineering Analysis Software.I have implemented the DB in such a way that,
I use the row_id as a primary integer key using this as an identifier for
different fields in the table.Most of the fields in the table are
2009/7/17 Atul_Vaidya atul.vai...@prototechsolutions.com:
Hi,
.
.
.
My question is, is it possible in
SQlite to retrieve the data stored in the database in the format in which it
is stored when the data was inserted in it ? for eg: if I store the data as
an Int, will I get it back as an Int,
Hi.
Im hoping someone might be able to help me with the problems im having, or
suggest a better method of doing what im trying to achieve. Currently im
using sqlite3 3.6.10. I don't mind updating or downgrading it if needed.
I have a program that I run multiple instances of. When they start,
I'm trying to get my head around doing hierarchies in SQL. I've been
Googling and it appears Oracle and MS SQL have some extensions to help, but
I'm trying to figure out what can be done with 'plain' SQL.
Imagine a directory table:
CREATE TABLE IF NOT EXISTS Directory
(
DirID
Maybe this:
select childs.Path, count(*)
from Directory childs, Directory hierarchy
where childs.ParentDirID = ?
and hierarchy.Path like childs.Path || '%'
group by childs.Path
You should have indexes on ParentDirID and on Path to make this query
somewhat effective. And you shouldn't have '%'
Wow Pavel, that's a cool approach.
I understand the issue about having % in the path (which is a problem I need
to work around), but what is special about '_' ?
Thanks
Doug
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
boun...@sqlite.org] On Behalf
Look here http://www.sqlite.org/lang_expr.html in section The LIKE
and GLOB operators.
---
The operand to the right contains the pattern, the left hand operand
contains the string to match against the pattern. A percent symbol
(%) in the pattern matches any sequence of zero or more
I'm trying to use the asynchronous I/O extension with the latest
SQLite version for the first time in my project.
This project is using database files attached into one database
connection.
I start a transaction which involves two different database files but,
the commit operation is failing
Hello
D I'm trying to get my head around doing hierarchies in SQL. I've been
D Googling and it appears Oracle and MS SQL have some extensions to help, but
D I'm trying to figure out what can be done with 'plain' SQL.
With tree structures in table, I like to use a pair of coordinates (x and
y),
Swithun Crowe
swit...@swithun.servebeer.com wrote:
Traverse the tree in depth-first order, giving each node the first
coordinate when going down, and the second when going back up.
This is known as a nested-set model:
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
Igor
Hi Gilles,
SELECT id AS Identification FROM foobar
Thanks. This is what I already use for displaying the results, but
then I'm stuck when I need to perform INSERT/UPDATES because I need to
get the actual columns names :-/
It'd be cool if each column in a table could have an internal name
I have this simple schema:
create table words
(
_id integer primary key autoincrement,
wordText text not null unique
);
I have triggers that work, which I got from
http://www.sqlite.org/cvstrac/wiki?p=ForeignKeyTriggers.
Now I'm trying to modify the update trigger to prevent saving a
12 matches
Mail list logo