Re: [sqlite] Check if file exists in SQL syntax?

lite> select getfileattributes('D:\source\sqlite'); > 16 > sqlite> > > You do similar on Unices just substitute the appropriate call to get the file > attributes ... > >>-Original Message- >>From: sqlite-users-boun...@sqlite.org [mailto:sqlite-

Re: [sqlite] Check if file exists in SQL syntax?

om: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] On Behalf Of Krzysztof >Sent: Friday, 10 October, 2014 12:21 >To: General Discussion of SQLite Database >Subject: [sqlite] Check if file exists in SQL syntax? > >Hi, > >I'm collecting file nam

Re: [sqlite] Check if file exists in SQL syntax?

On 10/10/2014 2:20 PM, Krzysztof wrote: I'm collecting file names (full paths) in sqlite table. Each day I need to remove non existing files from this table (thousands records). I'm wondering if SQLite has such function (could not find it in core functions). SQLite doesn't have such a function

[sqlite] Check if file exists in SQL syntax?

Hi, I'm collecting file names (full paths) in sqlite table. Each day I need to remove non existing files from this table (thousands records). For now I'm selecting all records and then checking if file exists using C++ routine and if not then deleting it. I'm wondering if SQLite has such function