Re[2]: [sqlite] Help me in SQL

2006-07-23 Thread blins
age on a mistake "no such column: t1.field1(1)" JS> On 7/20/06, blins <[EMAIL PROTECTED]> wrote: >> Hi sqlite-users@sqlite.org, >> >> I use sqliteODBC 0.68 + ADO and SQLite 3.3.6. >> I try executing sql: >> select t1.field1 as field1, t2.field2 as field2 f

[sqlite] Help me in SQL

2006-07-20 Thread blins
ы помогают быстро и эффективно решать проблемы, появившиеся с изобретением компьютеров С наилучшими пожеланиями, blins mailto:[EMAIL PROTECTED]

Re[2]: [sqlite] How to get column description from table using SQL

2006-06-29 Thread blins
Привет Kurt, Wednesday, June 28, 2006, 6:19:37 PM, you wrote: KW> blins <[EMAIL PROTECTED]> wrote: >> How to get column description from table using SQL KW> pragma table_info() KW> <http://sqlite.org/pragma.html> KW> Regards Thanks for help, but

Re[4]: [sqlite] How to get column description from table using SQL

2006-06-28 Thread blins
Ïðèâåò C.Peachment, Wednesday, June 28, 2006, 12:55:46 PM, you wrote: CP> On Wed, 28 Jun 2006 12:40:52 +0600, blins wrote: >>>> How to get column description from table using SQL >>CP> To get table definition for '': >>CP> select sql from sqlite_master

Re[2]: [sqlite] How to get column description from table using SQL

2006-06-28 Thread blins
Ïðèâåò C.Peachment, Wednesday, June 28, 2006, 11:47:09 AM, you wrote: CP> On Wed, 28 Jun 2006 10:29:47 +0600, blins wrote: >> How to get column description from table using SQL CP> To get table definition for '': CP> select sql from sqlite_master where type='table' and

[sqlite] How to get column description from table using SQL

2006-06-27 Thread blins
Hi sqlite-users@sqlite.org, How to get column description from table using SQL -- А у нас как не было порядка, так и есть! С наилучшими пожеланиями, blins mailto:[EMAIL PROTECTED]