?
Solved

Cross Tab Query in Interbase 6

Posted on 2001-06-26
7
Medium Priority
?
281 Views
Last Modified: 2010-05-18
How do i wriite cross tab query in interbase6.
0
Comment
Question by:princemahesh
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6230106
?
select afield, sum(afield2), max(afield3) from tablelist where condition group by afield


alternate
use the decissioncube-components
0
 
LVL 9

Expert Comment

by:ITugay
ID: 6230307
Hi princemahesh,
meikl :)

I saw crosstab query in MS Access. It's different from SQL statements usually we use :-) There is no analog for Interbase.

Try to use decissioncube as meikl told you, or prepare result in memory and then put it into grid.

-----
Igor.
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6230446
hi igor ;-)
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:princemahesh
ID: 6230629
Where can i find decissioncube-components.
0
 
LVL 9

Expert Comment

by:ITugay
ID: 6230649
It should be in "Decision Cube" component palette.
0
 

Author Comment

by:princemahesh
ID: 6230717
I have installed delphi5 Professional but it is not showing me the decisioncube components.  
0
 
LVL 9

Accepted Solution

by:
ITugay earned 150 total points
ID: 6230763

"Decision Cube CrossTab for multidimensional analysis of data" components pack available only in enterprise edition.

btw, it located in dcldss50.bpl (~83kb size). Not sure about licensing agreement, but you can try to download this file somewhere.

-----
Igor.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses
Course of the Month10 days, 18 hours left to enroll

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question