Stephan, >Thanks a lot for your help. It seems we have a problem with our qdbc >command. Its terminateing a sql command when a ; is detected. With sqlite >console your syntax is working:
Sorry for misleading you with a phantom missing closing parenthesis, I was doing (or rather trying to do) too many things at the same time but with one core only ;-) Indeed, if your wrapper terminates SQL input at the first SQL-level semicolumn, then it's badly broken and I don't see how you can work around that overlook in this case, since a semicolumn is required here in the middle of the statement block. BTW v3.6.14 is quite old now and maybe a fixed version is available. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

