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

Привет 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> KW> Regards Thanks for help, but I use sqlite through ODBC+ADO and this stat

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: +6

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 S

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] 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 *err_m

[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()

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 :) SQLit

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 yo

Re: [sqlite] hard copy docs

[EMAIL PROTECTED] wrote: > 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

[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] 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 n

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 independ

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] 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() Regards

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.

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 th

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 sqlite3_u

[sqlite] real time gui updates

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  

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='';