I think Joanne's example may be simplified, and the question was really more general...
On 12/12/07, Joanne Pham <[EMAIL PROTECTED]> wrote: > Basiclly there is no SQL logic in SQLite. Right, there's nothing like T-SQL. Even in other databases, most procedural logic along IF..THEN lines is done with a dedicated language used for functions or stored procedures, not part of the primary SQL interface. SQLite does have a limited form of procedural logic in its trigger statements. Keep in mind that because SQLite is an embedded database, it's considered normal to do such logic within the application as necessary. There isn't any overhead for a network protocol or similar, and you generally don't need to deal with arbitrary applications accessing your database, so there's less gain for pushing things into the database interface itself. After all, the database is inside your application already. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------