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

Ïðèâåò 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 name=''; I need

Re: Re: [sqlite] Multibyte

I am confused what are you trying to acheive by building a Unicode DLL? I'm really confused to... ;-) OK. The Facts: I create SQLite-Release-DLL's, one Unicode, one MCBS I create SQLite-Debug-Libs with symbolic informations, also Unicode and MCBS. For all this I use the Source-Version

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

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 where type='table' and name=''; I need column definition. Sqlite does not require that columns be typed so they

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

Ïðèâåò 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 where type='table' and name=''; I need

Re: [sqlite] real time gui updates

On 6/28/06, Rob Menegon [EMAIL PROTECTED] wrote: I have an application that displays data retrieved from various SQLite tables. As the data within the tables changes I want these changes reflected in the application real time. Can someone advise on the best way of doing this? Try

Re: [sqlite] Which is most appropriate encoding ?

FWIW, if Windows is your only target, UTF-16 is the best choice for you, because wchar_t is in UTF-16 on Windows and you can avoid some string conversion in this case, while still be able to enable the stuff for other OSes as soon as there is a need for it. Alexei Alexandrov I think

Re: [sqlite] Preferred way to copy/flush new memory db to disk db ?

My requirements are database file must be removed from disk if any error while creating/copying tables, records or indices other application or other instance of same app must not be able to access the database, till database is not ready with necessary minimum tables and records. So

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

blins [EMAIL PROTECTED] wrote: How to get column description from table using SQL pragma table_info() http://sqlite.org/pragma.html Regards

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

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

Re: [sqlite] real time gui updates

Rob Menegon wrote: I have an application that displays data retrieved from various SQLite tables. As the data within the tables changes I want these changes reflected in the application real time. Can someone advise on the best way of doing this? Rob Menegon Do you have multiple

Re: [sqlite] Preferred way to copy/flush new memory db to disk db ?

On 6/28/06, RohitPatel [EMAIL PROTECTED] wrote: My requirements are database file must be removed from disk if any error while creating/copying tables, records or indices other application or other instance of same app must not be able to access the database, till database is not

[sqlite] hard copy docs

Hi, I am pretty much a hard copy guy too. But about a month ago I purchased a dual output video card and a second monitor (LCD). Total price $270. Now I have the docs on one screen while a work on the other. I like it much better than I thought I would. Bill

Re: [sqlite] hard copy docs

On 6/28/06, Dennis Jenkins [EMAIL PROTECTED] wrote: The developers at my company have dual-headed displays. Very nice. I highly recommend that others try it if they can. It makes debugging much easier when you can have your app open on one monitor and the debugger on the other. Or when you

Re: [sqlite] sqlite3_free()

Hello, --- Dennis Cote [EMAIL PROTECTED] wrote: This really has nothing to do with the Windows DLL system. It is simply Thanks for the explanation. Wondered what that bug reporter was talking about :) There's a lot Windows does wrong, we don't have to go around making up stuff :) SQLite

[sqlite] sqlite3_free_table question

Hi all, Firstly, forgive me for a slightly naïve question; I don’t normally code in C and I’m having problems freeing up memory. Basically I have a structure I use to hold data results: //= typedef struct { char *sqlStatement; // Either the sqlstatement to be executed or

Re: [sqlite] sqlite3_free_table question

Richard Boyd wrote: Basically I have a structure I use to hold data results: //= typedef struct { char *sqlStatement; // Either the sqlstatement to be executed or the last statement that was executed char **results; // the result stored in an array char

RE: [sqlite] sqlite3_free_table question

Dennis, Ok thanks for the quick response. I'll persevere with that then and get back if I still have problems. Thanks, Richard.

RE: [sqlite] real time gui updates

No a single user/instance of the application reading from the database. Rob Menegon MenMac Services Pty Ltd ABN: 54 088 928 321 Mobile: +61 416 271 348 Fax: +61 2 8569 2063 Phone: +61 2 9482 7193 Email: [EMAIL PROTECTED] Skype: rmenegon -Original Message- From: John

Re: [sqlite] real time gui updates

In that case your application knows whenever the database is changed and can call a refresh routine. Rob Menegon wrote: No a single user/instance of the application reading from the database. Rob Menegon MenMac Services Pty Ltd ABN: 54 088 928 321 Mobile: +61 416 271 348 Fax: