Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Bku

  1. Bku

    Sorting Multidimensional Array

    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)
  2. Bku

    Query help

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

    Query help

    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...
  4. Bku

    Query help

    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
  5. Bku

    Query help

    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...
  6. Bku

    Query help

    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...
See more

Part and Inventory Search

Back
Top