Re: [sqlite] SQLite Input with validation and lookup

Stephen, you might want to look at http://dabodev.com/ Among other DBs it does support Sqlite and is fully cross-platform Cheers, Kai On Thu, 15 Aug 2013 17:39 +0100 (BST), Stephen Hughes wrote: > Sorry if the following is a duplicate but I've just updated to the latest > version of my

[sqlite] Multiple autoinc columns?

Is it possible to have two (or more) autoincrement columns per table? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] More noobie questions

On Tue, 05 Mar 2013 00:26:04 -0500, Igor Tandetnik wrote: > > select ID, PostDate, Amount, > (case when Amount < 0 then -Amount else null end) Withdrawal,(case when > Amount >= 0 then > Amount else null end) Deposit,(select sum(Amount) from MyTable t2 where > t2.ID <= t.ID) > Balance

[sqlite] More noobie questions

Hi all, given a table ID integer primary key, PostDate date, Amount int with data ID PostDateAmount --- 100 2013-01-01 -500 101 2013-01-02 1000 1022013-01-03

Re: [sqlite] Can these 2 queries be combined into one?

On Fri, 18 Jan 2013 23:18:31 -0500, Igor Tandetnik wrote: > On 1/18/2013 11:10 PM, Kai Peters wrote: >> these 2 queries >> >> SELECT lm.ID, lm.Key1, lm.Key2, tr.ISOCode, lm.MaxChars, tr.Description as >> Translation, >> lm.Description FROM LanguageMas

Re: [sqlite] Need help with query

On Tue, 15 Jan 2013 14:57:42 +0900, Yongil Jang wrote: > SELECT t1.key1, t1.key2, t2.description FROM MASTERLANGUAGES as t1, > MASTERLANGUAGES as t2 WHERE > t1.ISOCode = 'DEU' and t2.ISOCode = 'ENG' and t1.key1 = t2.key1 and t1.key2 = > t2.key2; that is very close - just needed to add

[sqlite] Need help with query

Hi all, given CREATE TABLE masterlanguages ( ID integer primary key autoincrement, Key1varchar not null, Key2varchar not null, ISOCode varchar not null, Description varchar not null, MaxCharsinteger default 0 ); insert into masterlanguages values

[sqlite] Can this be done in one query?

Hi all, I do have an audit table with this structure: AuditID ChangeDate RowID (foreign/primary key in TableName) ActionType TableName and I want to query for records pertaining to a certain table name within a given changedate range. I do, however, only want to receive the last

[sqlite] How to insert control characters into a table

Hi, how can I insert a control character like carriage return? Something like: update fielddefs set choices = 'Male' || '\r' || 'Female' where id = 2 Thanks for any help Kai ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] [OT] Re: Tool for database designer

Dezign for databases lets you do that: http://www.datanamic.com/dezign/supporteddatabases.html Cheers, Kai ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Newbie question

Hi all, given a table with two columns (SaleDate, SaleVolume) is it possible in one query to obtain the following three column result set: SalesCurrentYear, SalesLastYEar, SalesAllyears ? Thanks as always for any help, Kai ___ sqlite-users mailing

[sqlite] Possible in one SQL statement?

Is it possible to obtain select result set containing the table names of all user tables in a database along with their record counts? TIA, Kai ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] This query seems clumsy - can anyone do better?

On Thu, 3 Feb 2011 00:21:56 -0500, Igor Tandetnik wrote: > > select SUG.UserGrpID, SUG.GroupName, > coalesce(SUM.A_Link, 0), coalesce(SUM.B_Link, 0) from SecUserGroups SUG > left outer join > SecUserMembers SUM on (SUM.UserGrpID = SUG.UserGrpID and SUM.UserID = > 'Jane Doe'); Brilliant -

[sqlite] This query seems clumsy - can anyone do better?

Hi, the query below (ready to paste & run in the editor of your choice) works but I have a strong suspicion that it might be optimizable: DROP TABLE IF EXISTS SecUserMembers; DROP TABLE IF EXISTS SecUserGroups; CREATE TABLE SecUserMembers( UserGrpID integer NOT NULL, UserID