Starnge RBDataDictionary Problem and More..
Hello Jim
I'm comming back with the results of some tests I've perfomed in order to
provide more info about that problem.
On my client's site I did tried to test to see if the data dictionary data
was corrupted or invalid. In fact I even Dropped and Recreated all the RB
DataDictionaries Oracle Tables and using the DataDictionary Builder tried to
populate them. The DataDictionary Builder enters Ok, lets me add manually an
entry but raises the very same exception (List Index out of bounds (1)) when
I try to select the "Generate or Synchronize" option. In RB6 days I was able
to assign an empty datadictionary to a report and then to open and
constract the SQL through DADE succesfully using the original coloumns
names. That's for the history; today I've established a dial-up connection
to my client's site from my office, I've logged on succesfully to my
client's network and using a new Oracle Service Alias Name I've runned my
application targeting to my client's Oracle DB as if I were another local
application client. By disabling the datadictionary from my application I've
succesfully managed to open an existing report, move to the DADE and create
a new dataview or even manipulate an existing dataview. So as far as the
datadictionary by just disabling it the RBDesigner worked ok. I even tried
to use the "Generate or Synchronize" options in the datadictionary builder
with success (no more "List Index out of bounds (1)"). But when I tried to
run a report it crashed out !! In order to be more accurate about that crash
let me describe you in brief my RB employed architechture. In most of my
reports through a procedure of mine I pass through on the fly (after my
original-general report has been loaded from my database) the proper
AutoSearchCriteria and their Values. My procedure raises an exception when I
perfome that task : Clearing first All the Existed AutoSearchCriteria and
Re-Assigning the new Ones. That part of the code wasn't changed at all in my
application since the very first editions of the RBuilder and worked (still
working now) with the RBuilder Ent v6.x OK. As you can see by using the
RBuilder Ent v7 I've to forget the datadictionary but even with that I
cannot use my RB6 reports when I've to re-assign AutoSearchCriteria and
their Values at run-time. If you need the code of my RB-Related functions
and procedures please let me know where I should e-mail it. Seems to me that
it should be a more general convertion problem from RB6 to RB7. Please let
me know as soon as possible since for now my ONLY solution is to down-grade
to RB6 !!!
Note that the whole problem exists ONLY in my client's site and NOT in my
Office (NO DLLs, Simple Exe);
Looking forward for your reply
--
--
Best Regards
MYTSKIDIS GEORGIOS
Mytskidis_G@GI-Net.Gr
I'm comming back with the results of some tests I've perfomed in order to
provide more info about that problem.
On my client's site I did tried to test to see if the data dictionary data
was corrupted or invalid. In fact I even Dropped and Recreated all the RB
DataDictionaries Oracle Tables and using the DataDictionary Builder tried to
populate them. The DataDictionary Builder enters Ok, lets me add manually an
entry but raises the very same exception (List Index out of bounds (1)) when
I try to select the "Generate or Synchronize" option. In RB6 days I was able
to assign an empty datadictionary to a report and then to open and
constract the SQL through DADE succesfully using the original coloumns
names. That's for the history; today I've established a dial-up connection
to my client's site from my office, I've logged on succesfully to my
client's network and using a new Oracle Service Alias Name I've runned my
application targeting to my client's Oracle DB as if I were another local
application client. By disabling the datadictionary from my application I've
succesfully managed to open an existing report, move to the DADE and create
a new dataview or even manipulate an existing dataview. So as far as the
datadictionary by just disabling it the RBDesigner worked ok. I even tried
to use the "Generate or Synchronize" options in the datadictionary builder
with success (no more "List Index out of bounds (1)"). But when I tried to
run a report it crashed out !! In order to be more accurate about that crash
let me describe you in brief my RB employed architechture. In most of my
reports through a procedure of mine I pass through on the fly (after my
original-general report has been loaded from my database) the proper
AutoSearchCriteria and their Values. My procedure raises an exception when I
perfome that task : Clearing first All the Existed AutoSearchCriteria and
Re-Assigning the new Ones. That part of the code wasn't changed at all in my
application since the very first editions of the RBuilder and worked (still
working now) with the RBuilder Ent v6.x OK. As you can see by using the
RBuilder Ent v7 I've to forget the datadictionary but even with that I
cannot use my RB6 reports when I've to re-assign AutoSearchCriteria and
their Values at run-time. If you need the code of my RB-Related functions
and procedures please let me know where I should e-mail it. Seems to me that
it should be a more general convertion problem from RB6 to RB7. Please let
me know as soon as possible since for now my ONLY solution is to down-grade
to RB6 !!!
Note that the whole problem exists ONLY in my client's site and NOT in my
Office (NO DLLs, Simple Exe);
Looking forward for your reply
--
--
Best Regards
MYTSKIDIS GEORGIOS
Mytskidis_G@GI-Net.Gr
This discussion has been closed.
Comments
Trying to figure out what's wrong I runned into another strange behavior of
the RB. I've a checkbox which enables or disables the usage of the
DataDictionary
(If Not Checked then Begin
RBDesigner.DataSettings.DataDictionary:=Nil;
RBDesigner.DataSettings.UseDataDictionary:=False;
End Else Begin
RBDesigner.DataSettings.DataDictionary:=myDataDictionary;
RBDesigner.DataSettings.UseDataDictionary:=True;
End;)
With that option set to True I'm able to Open the designer and create a
dataview in DADE with the proper translations. I then exit the Designer,
uncheck that option (about the usage of the DataDictionary) and finally
re-open the designer. Now in DADE when I create a new dataview the
translations still exist !!!
The same happens when I start with the DataDictionary initially disabled.
The only way for the RBDesigner and the RBReport to honor my settings is to
re-start my application ... How can I somehow reset the RBDesigner ?
--
--
Best Regards
MYTSKIDIS GEORGIOS
Mytskidis_G@GI-Net.Gr
manipulating it, adding search criteria as well:
http://www.digital-metaphors.com/tips/ExtractSQLObject.zip
If you can reproduce the problem with our end user demo on your client's
machine, then we should be able to reproduce the problem at our site as
well. Can you provide us with a small demo that shows the problem:
support@digital-metaphors.com
I'm not able to reproduce the data settings problem you are describing. As
a simple test, I took the standard autojoin demo and added this code in a
button click event handler:
ppDesigner1.DataSettings.UseDataDictionary :=
not(ppDesigner1.DataSettings.UseDataDictionary);
ppDesigner1.ShowModal;
Every other time it used the data dictionary, as expected. Maybe I'm
missing something that you are doing in addition. Can you send a simple
demo of this problem to support@digital-metaphors.com ?
Cheers,
Jim Bennett
Digital Metaphors
http://www.digital-metaphors.com
info@digital-metaphors.com