Cannot generate DataDictionary

rbuser

Using D7+ReportBuilder 7.2+ADO+Informix I'm trying to create a
Datadictionary in the Dictionary Builder, I can create the tables using
"Generate" option but when I do the same in the Fields tab I get the next
error:

"Can't open table[mytable ]
Error :E42000:(-201) A sintax error has ocurred"

I get a similar error for every table defined in Table's Tab

Any suggestion?

Thanks in advance.

Edaurdo Mtz

nardmoseley

Access the RBuilder.hlp and choose ReportBuilder Reference |
Trouble-shooting | Database-specific End-user Examples. This topic show a
grid with the combinations of database products and data-access components
that we have tested. Note that not all combinations work successfully.

We have not tested using ADO and Informix - therefore this is an unknown.
Try testing this combination incrementally:

1. Test Query tools.

Use an ADOConnection to connect to the Informix data. Use the
Designer.DataSettings to connect to the ADOConnection and configure the
DatabaseType, SQLType, etc. For the DatabaseType use something that is
similar to Informix in SQL syntax.

Try creating some queries. Do not use the DataDictionary for this test.


2. Test ReportExplorer

Configure the an end-user example as shown in RBuilder\Demos\EndUser
Databases\SQLServer\ADO.

Try creating and saving folders and reports.

3. Test DataDictionary.

Below is an article on using the DD Builder at run-time. This would be a
good first test.

-------------------------------------------------------
Tech Tip: Using the DataDictionary Builder at Run-time
-------------------------------------------------------

Is it possible to run the DataDictionary Builder at run-time?

Example:


uses
daDataDictionaryBuilder;


procedure TForm1.Button1Click(Sender: TObject);
var
lForm: TdaDataDictionaryBuilderForm;

begin
lForm := TdaDataDictionaryBuilderForm.Create(Application);
lForm.DataDictionary := ppDataDictionary1;

if lForm.ValidSettings then
lForm.ShowModal
else
ShowMessage(lForm.ErrorMessage);

lForm.Free;
end;


--
Tech Support mailto:support@digital-metaphors.com
Digital Metaphors http://www.digital-metaphors.com



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

rbuser

Thanks a lot, I'll do all of this and try to keep you informed

Eduardo Mtz

rbuser

Problem solved, my mistake I defined the rb_Table and rb_Fields tables with
Char(60) and it must be VarChar(60), that was inserting extra blank
characters that messes the SQL

I guessed that out by checking the Interbase example

Thanks,

Eduardo Martinez

nardmoseley

Great!

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

rbuser

Same solution for the "Long Fields" thread above (that project is using
MSSQL but I migrated the data structure from informix).

Thanks for your help in both of them

Eduardo Martinez