SQL Query to consolidate rows into new table
Hi again, I have another query to get my head around! I am trying to take an existing table in a database that looks like this Time Type Price Code 09:00:01 BID 99 A 09:00:01 ASK 100 A 09:00:01 BID 99.5 B 09:00:01 ASK 100 B 09:00:02 BID 99.3 A 09:00:03 BID 98.5 C 09:00:03 [...]

Answer Question   |  August 11, 2010  11:09 AM
Access, SQL, SQL Query, SQLite

SQL Query to get the difference from average for every row with grouping
Hi there, i was wondering if anyone would be kind enough to help with something i am struggling with… I have a table something like this: Region ID Cost s1 1 v1  s1 2 v2  s1 3 v3 s2 4 v4 s2 5 v5 s2 6 v6 What I am trying to achieve is to [...]

Answer Question   |  August 11, 2010  10:54 AM
Access, SQL, SQL Query, SQLite

help me create trigger update column
CREATE  TRIGGER Trigger_UPDATE_BIENLAI_TIENNOP ON BIENLAI FOR UPDATE,INSERT,DELETE AS IF (@@ROWCOUNT = 0) BEGIN PRINT ‘ TABLE is null’ RETURN END IF UPDATE(TIENNOP) BEGIN UPDATE BL1 SET BL1.TIENNOP = BL3.TIENNOP FROM BIENLAI BL1,DELETED BL2,INSERTED BL3  WHERE BL1.SOBL = BL2.SOBL AND (BL3.TIENNOP < 300000)  PRINT ‘ finish update ‘ END /* trigger not check ‘ BL3.TIENNOP < 300000′ [...]

Answer Question   |  May 19, 2010  7:03 AM
MySQL, SQL Syntax, SQLite

database querying question SQLite
Hi I’m setting up an SQLIte database within my C application that will be used as an intermediate stage in converting filetypes. My design tries to keep data normalized – for example, i have an Entity table, and in that table each entity has an integer type. There is another EntityTypes table with a string [...]

Answer Question   |  March 17, 2010  5:29 PM
C, Database, Design, efficiency, SQLite

Setup project force new file replacement on reinstall
Hello, I have a setup project that install a couple of projects and a couple of external files (one of which is a SQLite Database) – everything worked fine until i’ve recently modified the base database file included in the setup project. Now, every time i try to reinstall the project the new database file [...]

Answer Question   |  January 11, 2010  3:38 PM
SQLite, Visual Studio, Visual Studio 2008, Windows Application

CMake – Automatically regenerate a file using an external tool and custom target upon “make”
Hi. I’m working on a project and I use cmake for generating “projects”, that is, under Linux, a Makefile. I also use an external tool (re2c) to generate the scanner, and an included tool to generate the parser (lemon, part of sqlite). The problem is I need to “cmake” every time I change something in [...]

Answer Question   |  December 8, 2008  11:01 AM
C, CMake, Lemon Parser Generator, Linux, Makefile, re2c preprocessor, Software development, SQLite