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 email
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
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
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 from MyTable
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 LanguageMaster lm INNER JOIN Translations tr ON
(tr.MasterID
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
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
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
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
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
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
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
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
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 - just
14 matches
Mail list logo