Re: [sqlite] Dynamically generate SQL statements for SQLite

2013-09-14 Thread danap
> Subject: Re: [sqlite] Dynamically generate SQL statements for SQLite > Message-ID: <1379089163135-71243.p...@n5.nabble.com> > Content-Type: text/plain; charset=us-ascii > > I agree with the other poster. You can just use any string manipluation > routines you like to

Re: [sqlite] Dynamically generate SQL statements for SQLite

2013-09-14 Thread Jay A. Kreibich
On Fri, Sep 13, 2013 at 09:19:23AM -0700, dochsm scratched on the wall: > I agree with the other poster. You can just use any string manipluation > routines you like to assemble the SQL into a string and then execute it. > Take care with literals, eg where name = 'fred' might have to become where >

Re: [sqlite] Dynamically generate SQL statements for SQLite

2013-09-14 Thread Stephen Chrzanowski
+100 on SQLite Expert. I used the free version for about a month, but found it to be so useful, and with the life time upgrades feature, had to purchase to get the whole thing. The developer also spies on all of us in here, and is usually quick to reply to emails from registered users. (Unless I

Re: [sqlite] Dynamically generate SQL statements for SQLite

2013-09-14 Thread dochsm
I agree with the other poster. You can just use any string manipluation routines you like to assemble the SQL into a string and then execute it. Take care with literals, eg where name = 'fred' might have to become where name = ''fred'' in Delphi (thats two single quotes at each end). If it's any

Re: [sqlite] Dynamically generate SQL statements for SQLite

2013-09-13 Thread Simon Slavin
On 13 Sep 2013, at 3:26am, Mun Wai Chan wrote: > I was wondering if there are any software that would dynamically generate SQL > statements for SQLite using C#. For example, I would like to be able to do > this: > > var sqlStatement = sqlGenerator.Select("Name").From("Customers").ToSQL(); >

[sqlite] Dynamically generate SQL statements for SQLite

2013-09-13 Thread Mun Wai Chan
Hi all, I was wondering if there are any software that would dynamically generate SQL statements for SQLite using C#. For example, I would like to be able to do this: var sqlStatement = sqlGenerator.Select("Name").From("Customers").ToSQL(); I only know the names of tables and fields at runtime