Re: [sqlite] Re: hello... little short SQLite Question

Thomas Buerdel wrote: Hello? thanks that i wnow bu i need in the SQL-Ouptut a new line (Carriage Return) between "\backup_path\artist.sql" and ".dump artist". SELECT '.output \backup_path\' || name || '.sql .dump' || name FROM sqlite_master WHERE type='table'; -- D. Richard Hipp -- [EMAIL PR

[sqlite] Re: hello... little short SQLite Question

Thomas Buerdel wrote: Does SQLite Support Carriage-Returns in select-Statements?? I try to made this a little dynamic with a select from the Sqlite-Data-Dictionary... sounds like: .output test.sql SELECT '.output \backup_path\'|| name || '.sql .dump ' || name FROM sqlite_master WHERE type='table