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