Home rbuser Comments
New Blog Posts: Merging Reports - Part 1 and Part 2

rbuser

About

Username
rbuser
Joined
Visits
1
Last Active
Roles
Member

Comments

  • Thanks, that helped. I've figured it out now.
    I wasn't overriding all the abstract methods I needed to in my DADE unit.

    BTW: If any one needs an IBO 4.2 DADE just drop me an email. No guarantees
    it works though.

    Adam<…
  • Hi Adam,

    Do you know which abstract method was called?
    Avoid calling abstract methods.
    If your code doesn't call a abstract method try to override the abstract method.

    sorry for abstract help only,
    Chris Ueebrall…


  • I have done this, of sorts and have it working fine. Temp DB files
    delete fine. I'll now re-visit my project which doesn't work and try
    and mirror the working system better. Thanks.
  • After looking at this a little more, it seems that the problem is not
    directly related to DBISAM, but is in the routine that creates the table
    alias itself. It uses a function (daInvalidChar) to strip out invalid
    characters when crea…
  • yes, this would be a big feature!
    chris


  • We are writing in a temorary sql-table with all related IDs. (We use Autokey
    for each table). Also with the ID we are saving the SQL-Server SPID, which
    is unique to a current connection. So every user could have as many
    different conn…
  • Yes, I am using MSSQL

    Would appreciate any advice on how to execute a report against a set of
    records selected from a grid.

    Cheers,
    Ben
  • Do you using MSSQL?
    if so, i have a interresting solution to get only secial items (like grid
    selection).

    chris

  • Well, good news about RB7...

    I actually already own a copy of D7E and RB7 - I'm just a little nervous
    about updating this old D5Pro and RB6 box - there is a LOT of code
    dependent on some pretty weird low-level manipulation of…
  • Nard,


    What steps do I need to follow to recompile after adding that code?
    Thanks.

    Regards,

    Stefan Sebregts.

  • Nard,

    Thanks. Will experiment with that, and will await a new version
    of RB that fully supports Table views.

    Regards,

    Stefan.

  • Thx! It's running =]

  • >>don't show the tables for to make query wizard
    ops, this is showing :)
  • I am using report builder 6.03 and IBO 4.0
    I am running this demo, and don't show IBOsession in design time (only
    runtime) and don't show the tables for to make query wizard
    IBOSession dont't show in designer time?
    I need help ag…
  • Sample of SQL statement generated :

    SELECT * FROM CUSTOMER__________________________ WHERE ''c'' <> ''c''

    EDatabaseError : Cannot open.
    I spend too much time modifying RB, is there another way to find
    informati…
  • I rapidly modified The GetTableNames procedure in daDbExpress.pas like below
    for tests.
    The dbExpress demo with Interbase now run (I can see the tables) but :
    The DataDictionary doesn't work at all and (more important)
    It is impo…
  • Yes I can connnect correctly to employee.gdb without RB.
    Yes the designer.datasettings are ok at runtime and design time.

    The bug :
    If I build a small app using a TSqlConnection pointing to employee.gdb and I
    do this below …
  • Sorry Jim, I think it is a Delphi bug (my version is 7 build 4.453)

    TSqlConnection.GetTableNames does'nt work.
    (I haven't try yet with TIbConnection)
    Have you heard about this ?
    Have you got an idea to resolve this problem …
  • I think I isolated the bug in daMetaData.pas

    *** dbExpress Unsupported Operation exception ***

    procedure TdaMetaData.GetTables(aTables: TList);
    begin

    if (FCache.Active) and (FCache.Populated) then
    FCa…
  • It appears that RB7 doesn't work at all with Interbase 6.5.
    All the RB demo with Interbase don't work at run-time.
    (the BDE one provide no error message but no tables are available for
    building a query)
    I'am very disappointed and…
  • Interbase verion : 6.5
    No problem tu execute a simple query on employee.gdb
    Yes I run the SQL script from the Interbase demo directory.
    It's really strange, after hours of work I still don't understand why
    at design time it's ok …
  • I found something :
    RB dbExpress demo :
    If I change the properties of the TSimpleDataSet.DataSet.CommandType to
    ctQuery (and the CommandText to the right Sql text)
    I can now launch the report explorer.
    But that's all.
    I…
  • I send an error, neither dbExpress and IBExpress demos provided by RB work.

    IbExpress :
    TdaMetaData.GetFieldsfromDataSet: Unable to open dataset: X error message
    when trying to build a query.

    dbExpress :
    Unsuppo…
  • I know Jim, sorry for my poor english, but the problem is still the same

  • Hi Jim,
    well the dbexpress demo can be built but I can't do anything with it :
    as I want to launch the report explorer I have a dbexpress unsupported
    operation.
    I inserted too end user tables on my employee.gdb.
    I also have …
  • Thanks Jim,
    It works ok now.

    Best regards,
    Arjen

  • Hello,
    Can the query designer build sql statement like this ?

    Select A from X where A In (Select A in Y where B...) ?

    Have you got infos about the datadictionary ?
    Thanks
    Regards

    Marc
  • Hi,
    Many thanks it works well now.
    Regards
    Marc
  • Sorry Jim but I have already tried to intall completly D7 on another
    partition of my hard drive (w98 as the primary one) and
    installed RB.
    I ran the script located in the Interbase demo dir (there is by another way
    a little probl…