Re: [sqlite] Is it possible to use substrings of Windows DOS batch fiile parameters in sqlite3.exe -line db sql?

2012-04-11 Thread Kees Nuyt
On Tue, 10 Apr 2012 19:14:59 -0400, Frank Chang frank_chan...@hotmail.com wrote: Good evening, We are trying to generate automated SQLITE SQL scripts based on the names of SQLite tables derived by substring manipulation of Windows DOS batch file and/or Windows environment variables. For

Re: [sqlite] Is it possible to use substrings of Windows DOS batch fiile parameters in sqlite3.exe -line db sql?

2012-04-11 Thread Gabor Grothendieck
On Tue, Apr 10, 2012 at 7:14 PM, Frank Chang frank_chan...@hotmail.com wrote: Good evening, We are trying to generate automated SQLITE  SQL scripts based on the names of SQLite tables derived by substring manipulation of Windows DOS batch file and/or Windows environment variables. For

Re: [sqlite] Is it possible to use substrings of Windows DOS batch fiile parameters in sqlite3.exe -line db sql?

2012-04-11 Thread inq1ltd
On Tuesday, April 10, 2012 07:14:59 PM Frank Chang wrote: Good evening, We are trying to generate automated SQLITE SQL scripts based on the names of SQLite tables derived by substring manipulation of Windows DOS batch file and/or Windows environment variables. For example: /* mary.bat */

Re: [sqlite] Is it possible to use substrings of Windows DOS batch fiile parameters in sqlite3.exe -line db sql?

2012-04-11 Thread Frank Chang
inq1ltd, Thank you for your reply. Here is an excerpt of the most recent Windows CMD file: set var=%1 @echo %var:~0,-4% set abc= %var:~0,-4% cameron.cmd %abc% From: inq1...@inqvista.com To: sqlite-users@sqlite.org CC: frank_chan...@hotmail.com Subject: Re: [sqlite] Is it

Re: [sqlite] Is it possible to use substrings of Windows DOS batch fiile parameters in sqlite3.exe -line db sql?

2012-04-11 Thread Frank Chang
Message: 19 Date: Wed, 11 Apr 2012 08:31:49 -0400 From: Gabor Grothendieck ggrothendi...@gmail.com To: General Discussion of SQLite Database sqlite-users@sqlite.org Subject: Re: [sqlite] Is it possible to use substrings of Windows DOS batch fiile parameters in sqlite3.exe -line db sql?

[sqlite] Is it possible to use substrings of Windows DOS batch fiile parameters in sqlite3.exe -line db sql?

2012-04-10 Thread Frank Chang
Good evening, We are trying to generate automated SQLITE SQL scripts based on the names of SQLite tables derived by substring manipulation of Windows DOS batch file and/or Windows environment variables. For example: /* mary.bat */ FOR /f %%a IN ('dir /b *.zip') DO CALL sub %%a /*