Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

Unable to open Dataset

edited February 2003 in End User
System Environment=RB 6.03 and Oracle
I created a dictionary.
Now I Try to open two tables (or better views). In some cases I got
TDaMetadataset.GetFieldLengthfromDataSet unable to open dataset.
If I open the displayed view separately it works fine. But in combination to
another this error occurs.
Did I made somthing wrong?

Regards
Nicolas

Comments

  • edited February 2003

    Sorry, I do not understand the question/issue.

    Using the RBuilder\Demos\EndUser Databases\Oracle examples and the Oracle
    demo data, please provide detailed steps for reproducing the issue.

    Also, please specify the Delphi version and type of connectivity: DOA, BDE?


    --
    Nard Moseley
    Digital Metaphors
    http://www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited February 2003
    > Sorry, I do not understand the question/issue.
    BDE?
    This happens if I try to select two of my tables.

    The Environment is RB 6.03 Pro
    Delphi ENterprise 5
    BDE 5.11 and sq?ora32.dll
    Oracle 8.1.7 server site / Oracle 9.02 Client site

    Regards
    Nicolas
  • edited March 2003
    Without RB involved, can you connect a TDBGrid on a TForm to your data? Then
    can you connect a TppDBPipeline on the form to this same datasource and see
    data in a simple report without the Data tab (DADE) involved?

    Check your datasettings in DADE to be sure that they are correct.

    Disconnect the Data Dictionary and retest in DADE.

    DADE simply creates a TQuery, TDatasource and TppDBPipeline for each BDE
    query dataview that you define.

    If you create a dataview, crtl click over it to view the magic SQL that is
    generated by us to be sent to the server. Can you copy this SQL text into a
    TQuery on a form and execute it outside of RB?


    Cheers,

    Jim Bennett
    Digital Metaphors


This discussion has been closed.