Recent content by Bku

Hi, I have a problem. I'm fairly new to VBA and I can't figure out how to sort a multidimensional array by the first column. An example of how to move the whole row based on the first column would help. Thanks. the array is: Dim arrVehicles(1 to 10398, 1 to 6)

That worked! thanks, you were very helpful. I learn a lot from reading stuff here.

Thanks for all your help. Here it is. /* Domain definitions */ CREATE DOMAIN "T_YESNO" AS INTEGER DEFAULT 0 CHECK((VALUE IS NULL) OR (VALUE IN (0,-1))); /* Table: TASK, Owner: MSUSER */ CREATE TABLE "TASK" ( "TASKID" INTEGER NOT NULL...

MartijnTonies, I ran your query in Interactive SQL but this is what I get: Dynamic SQL Error SQL error code = -104 Token unknown - line 4, char 1 I'm begining to think there is something wrong with my IBConsole ver 1.0.0.336

SELECT Task.OwnerID, SUM(IsComplete = -1) as CompleteTrue, SUM(IsComplete = 0) as CompleteFalse FROM Task WHERE TaskType = 2 GROUP BY OwnerID Sorry about that. I'm trying to SUM the number of True/False responses in the 'IsComplete' field for each 'OwnerID'. My sum statement is trying...

Hi, I'm a newbie. I tried the following in Access and it worked, but then I tried it in Interbase and it didn't like the SUM lines. Is there an equivalent for this statement? The query is from one table only. Thanks. ---------------------------------------------- SELECT Task.OwnerID...