Re: [sqlite] Best way to develop a GUI front-end

2017-11-13 Thread Bart Smissaert
As you are familiar with VBA I can see two other options: 1. Use Christian Werner's ODBC driver from Access (or Excel): http://www.ch-werner.de/sqliteodbc/ 2. Use Olaf Schmidt's COM dll with Access (or Excel): http://www.vbrichclient.com/#/en/About/ RBS On Mon, Nov 13, 2017 at 9:54 PM, Balaji

Re: [sqlite] Valid characters for indentifiers

2017-11-13 Thread Clemens Ladisch
Jens Alfke wrote: > On Nov 11, 2017, at 6:31 AM, Simon Slavin wrote: >> There is no documentation for this. Which means that even if you find >> that, say, macrons are allowed in this version, they might not be allowed >> in the next version. > > Um, really? That sounds bad

Re: [sqlite] Running sums and averages

2017-11-13 Thread David Raymond
As other folks have mentioned, doing it in an external language is going to be easiest. That being said, CTE's are almost a full language in themselves. I'm just gonna go with 1 value here for the example, but how about something like... with recursive foo (RowNumber, F1, sumF1, OverallAvgF1,

Re: [sqlite] Simple Search using LIKE or something else

2017-11-13 Thread Jens Alfke
> On Nov 11, 2017, at 3:41 PM, Stephen Chrzanowski wrote: > > Although there are pay for, and free to use, libraries that can be > linked into my applications, I've never been satisfied with the code > provided. Hm, I didn’t say anything about 3rd party libraries, so I’m

Re: [sqlite] Valid characters for indentifiers

2017-11-13 Thread Jens Alfke
> On Nov 11, 2017, at 6:31 AM, Simon Slavin wrote: > > There is no documentation for this. Which means that even if you find that, > say, macrons are allowed in this version, they might not be allowed in the > next version. Um, really? That sounds bad for

Re: [sqlite] Running sums and averages

2017-11-13 Thread Balaji Ramanathan
OK, thanks for the short and sweet answer! I just wanted to make sure I wasn't missing something. Balaji Ramanathan > -- Forwarded message -- > From: Simon Slavin > To: SQLite mailing list > Cc: > Bcc: > Date: Sun,

Re: [sqlite] Valid characters for indentifiers

2017-11-13 Thread Simon Slavin
On 13 Nov 2017, at 7:33pm, Jens Alfke wrote: > On Nov 11, 2017, at 6:31 AM, Simon Slavin wrote: > >> There is no documentation for this. Which means that even if you find that, >> say, macrons are allowed in this version, they might not be allowed

Re: [sqlite] Best way to develop a GUI front-end

2017-11-13 Thread Peter Da Silva
Since sqlite originated as a Tcl extension it’s got excellent Tcl bindings, and Tcl has an excellent platform-independent GUI in Tk, so it seems to me that would be the best and simplest way to create a GUI front end for sqlite. ___ sqlite-users

Re: [sqlite] Simple Search using LIKE or something else

2017-11-13 Thread Stephen Chrzanowski
I'm not using a C compiler. Delphi Berlin doesn't compile C, AFAIK. I'll play around with that tonight as I've got a project I need to start up tonight. Third party libraries include those like LiteDAC, or DISQLite3, or Synopse mORMot framework. On Mon, Nov 13, 2017 at 1:34 PM, Jens Alfke

[sqlite] Best way to develop a GUI front-end

2017-11-13 Thread Balaji Ramanathan
Hi, I have been using SQLite without any programming language so far. I maintain the data in SQLite and use SqliteStudio (www.sqlitestudio.pl) for inputting data into it and running queries to look at outputs. However SqliteStudio does not have a programmable back-end that allows me to take

Re: [sqlite] Best way to develop a GUI front-end

2017-11-13 Thread Richard Hipp
On 11/13/17, Peter Da Silva wrote: > Since sqlite originated as a Tcl extension it’s got excellent Tcl bindings, > and Tcl has an excellent platform-independent GUI in Tk, so it seems to me > that would be the best and simplest way to create a GUI front end for >

Re: [sqlite] Best way to develop a GUI front-end

2017-11-13 Thread Tim Streater
On 13 Nov 2017, at 21:54, Balaji Ramanathan wrote: > Is there a third party free tool like MS Access that would allow me to > connect to a SQLite db in the back-end and enable me to create a custom > front-end to it with forms and reports? All my searches for