Sqlite query

sigster

Member
Joined
Feb 7, 2010
Messages
7
Programming Experience
Beginner
Hi

I am try to change from Microsoft access mdb to sqlite

This is my query to day with mdb database anyone here who can help me so I can use this with sqlite

VB.NET:
Dim queryString As String = "TRANSFORM Sum(databasere.total) AS SumOftotal SELECT databasere.Textkey, Sum(databasere.total) AS [totalsum] FROM databasere WHERE YEAR(Date_change) = '" & Cbo_talnng_ar.Text & "' GROUP BY databasere.Textkey ORDER BY databasere.Textkey PIVOT Format([Date_change],""mmm"") In (""jan"", ""feb"", ""mar"", ""apr"", ""maí"", ""jún"", ""júl"", ""ágú"", ""sep"", ""okt"", ""nóv"", ""des"")"


Regards
Sigster
 
Top Bottom