Thanks, I'll give this a try!
John
On 8/25/06, Martin Jenkins <[EMAIL PROTECTED]> wrote:
John Salerno wrote:
> Well, I figured out the sqlite commands, but how would I make these
> settings the default each time I use the sqlite command line program?
> (i.e. .he on and .mo col)
If you're on
rockdawg <[EMAIL PROTECTED]> wrote:
Here are some entries:
smb://MSHOME;kevin:@Movie-server/D/Gladiator/VIDEO_TS
smb://MSHOME;kevin:@Movie-server/D/Rocky/VIDEO_TS
smb://MSHOME;kevin:@Movie-server/E/Saw/VIDEO_TS
smb://MSHOME;kevin:@Movie-server/F/Analyze This/VIDEO_TS
Therefore, I need to
Dear Lister,
I use SAS, a statistical computing language, to link to a sqlite
database through ODBC.
When I tried to delete rows from a table, it says the delete function
is not supported. Does ODBC support delete function?
Thanks.
I have a program I run on my Xbox (Xbox Media Center) that creates and uses a
SQLite db that I would like to edit. What I have is a table called paths
and within that table is a column/field called strPaths. It lists the paths
to movies located on various drives on a server. Here are some
Hi all.
I am sure this is asked fairly frequently but I couldn't find anything
(recent) in the archives.
Is there an updated version of the PSUTILS script to work with SQLite 3?
If not, is there a "convert from 2.8 to 3" guide that can be understood
by a VB developer with a little C
Looks like you're not alone...
http://www.gatago.com/comp/databases/20027474.html
/m
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Try something like this:
CREATE INDEX ix_polys ON polys (xmin, ymin, xmax, ymax);
SELECT name
FROM polys
WHERE EXISTS
(SELECT x FROM points WHERE point_id = 1 AND xmin < x AND ymin < y AND xmax
x AND ymax > y);
In your query you do 4 select from points table. Here, you do only one. I
think
Roberto <[EMAIL PROTECTED]> wrote:
> int sqlite3_user_data_find(...)
Usually the user data is some information you can use to refer to your
context. How are you using the userData ?
I'm keeping a reference to a Java object in it that contains the
actual function being called.
Woudn't
On 8/26/06, Joe Wilson <[EMAIL PROTECTED]> wrote:
> --- P Kishor <[EMAIL PROTECTED]> wrote:
..
> Actually, I have tried many other approaches, and SQL seems to be a
> fairly efficient one. Here is why -- in the worst case, I have to test
> each point against each poly (a geometry algorithm
Hi
Is there any way to handle the different error messages from sqlite
without doing strcmp? For example SQLITE_CONSTRAINT?
What I'm doing now is:
id = SELECT id FROM Table WHERE parent=0;
if id = NULL:
handle parent does not exist
code = INSERT INTO Table(NULL,'a',id);
if (code ==
--- P Kishor <[EMAIL PROTECTED]> wrote:
> On 8/26/06, Joe Wilson <[EMAIL PROTECTED]> wrote:
> > The sample poly.name's you've provided in your example seem to be integers.
> > Is that always the case? Are the poly_id's unique? If both of these
> > are true, you might consider making poly_id your
On 8/26/06, P Kishor <[EMAIL PROTECTED]> wrote:
On 8/26/06, Cory Nelson <[EMAIL PROTECTED]> wrote:
> Instead of indexing each column on its own, try making them one big index.
>
Thanks. Actually making a composite index really helped. The match
rate went from 2.5/sec to more than 82/sec. Very
On 8/26/06, Cory Nelson <[EMAIL PROTECTED]> wrote:
Instead of indexing each column on its own, try making them one big index.
Thanks. Actually making a composite index really helped. The match
rate went from 2.5/sec to more than 82/sec. Very nice. I did the
following --
sqlite> CREATE INDEX
The sample poly.name's you've provided in your example seem to be integers.
Is that always the case? Are the poly_id's unique? If both of these
are true, you might consider making poly_id your primary key in the
polys table in order to eliminate a column.
This problem is very difficult to do in
Instead of indexing each column on its own, try making them one big index.
On 8/26/06, P Kishor <[EMAIL PROTECTED]> wrote:
As a follow-up to my own email below, I ran the following query
SELECT COUNT(py.poly_id)
FROM polys py JOIN points pt ON
(py.xmin < pt.x AND py.ymin < pt.y AND py.xmax >
As a follow-up to my own email below, I ran the following query
SELECT COUNT(py.poly_id)
FROM polys py JOIN points pt ON
(py.xmin < pt.x AND py.ymin < pt.y AND py.xmax > pt.x AND py.ymax > pt.y);
to determine how many exact points-in-poly matches I could find. The
query has now been running
Greets,
Using SQLite for Windows 3.3.7. I have the following two tables
-- bounding box of each poly
CREATE TABLE polys (
poly_id INTEGER PRIMARY KEY,
xminREAL,
yminREAL,
xmaxREAL,
ymaxREAL,
nameTEXT
)
data look like so
If they offer PHP then they offer Sqlite, since it is embedded.
Clark Christensen wrote:
I've been thinking about that myself. Then I started to wonder if the more
common MySQL or PostgreSQL wouldn't be just as good (or better) for websites -
particularly remote-hosted ones.
I see there are
18 matches
Mail list logo