On Wed, Sep 09, 2009 at 07:33:31AM -0700, Sebastian Bermudez scratched on the
wall:
> ok. i'm develop... an PHP-WEB Sqlite TUNNEL....
Because apparently the world doesn't have enough wheels?
> <originalQuery> select * from tableA </OriginalQuery>
> <rows> <new> <id value='3'> <descri value='description'></new></rows>
> how can i to know the "base table name" of a column for make the
> insert statement in PHP without parsing the SQL QUERY.
You can't. There is no reason to assume a result column even
has a base table.
> I assume:
> 1) Every query with only one table in Where clause is updatable.
Hardly. You need a lot more restrictions than that. Consider
a query like:
SELECT count(*), descri FROM tableA GROUP BY descri;
> I have Sqlite 2x.
SQLite 2.x is five years old. You're not likely to get a lot of
help, as nearly everyone on the mailing list moved to 3.x a long long
time ago. They're different enough to be considered two different
products.
-j
--
Jay A. Kreibich < J A Y @ K R E I B I.C H >
"Our opponent is an alien starship packed with atomic bombs. We have
a protractor." "I'll go home and see if I can scrounge up a ruler
and a piece of string." --from Anathem by Neal Stephenson
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
