Hi
As i’m new to SQLite and Xojo i’m asking for little help… Cant get right SQLite view from this MS SQL view…
And help and pointer would be helpful… or example cose i learn best from example
[code] SELECT
Good_Id,
COUNT_BIG(*) AS ProductCount,
SUM(ISNULL(Quantity,0)) AS Quantity, Created
FROM dbo.InventoryItemBases
where IsDeleted = 0 and Good_Id is not null
GROUP BY Good_Id, Created;[/code]