Re: [sqlite] Is this legal SQL?

"Mike McGonagle" wrote in message news:370dda580901121949u3d2bf52ai87bfd7102cd7...@mail.gmail.com > Thanks for the advice, everyone was a help in this... > > On Mon, Jan 12, 2009 at 6:41 PM, Igor Tandetnik > Why do you want to > create a bunch of identical tables in the first >> place? What are yo

Re: [sqlite] Is this legal SQL?

Thanks for the advice, everyone was a help in this... On Mon, Jan 12, 2009 at 6:41 PM, Igor Tandetnik > Why do you want to create a bunch of identical tables in the first > place? What are you trying to achieve? I am working with Multimedia stuff, and each table, while holding the same fields, ar

Re: [sqlite] Is this legal SQL?

Mike McGonagle wrote: > I want to be able to create some tables dynamically (same structure, > different name), and I thought this might work... > > CREATE TABLE ?1 (x double, y double); Parameters can only appear where a literal could legally appear. Why do you want to create a bunch of identic

Re: [sqlite] Is this legal SQL?

2009 3:43 AM Subject: [sqlite] Is this legal SQL? Hello all, I am working on connecting SQLite up to another programming language, and had a question about how SQLite (or SQL in general) would handle this... I want to be able to create some tables dynamically (same structure, different name),

Re: [sqlite] Is this legal SQL?

You can only bind data elemeents. If you want to chjange table names you have to recompile the SQL (think about it). Mike McGonagle wrote: > Hello all, > > I am working on connecting SQLite up to another programming language, > and had a question about how SQLite (or SQL in general) would handle

[sqlite] Is this legal SQL?

Hello all, I am working on connecting SQLite up to another programming language, and had a question about how SQLite (or SQL in general) would handle this... I want to be able to create some tables dynamically (same structure, different name), and I thought this might work... CREATE TABLE ?1 (x