nardmoseley
Comments
-
- Limit your code mods to the daNexus.pas unit. It is isolated to Nexus and
will not affect any other database connectivity. Perhaps make a copy of the
unit and then play with it.
- TnxQuery is being used by the daNexus … -
- open daNexus.pas and find the method implementation for
TdanxSession.GetTableNames.
- the TdanxSession.GetTableNames method is calling
TnxDatabase.GetTableNames to get the list of available table names. If there
The DataDictionary is only used to create/edit a query dataview. Once the
query dataview is saved, the data dictionary is not used to execute the
query and generate the report.
Run the application with UseDataDictionary …
This will be fixed for RB 10.03, which will be released soon...
- Make sure that you use a connection object placed on the form/datamodule
that contains the report component. Configure the connection object to
connect to the database and then configure RB to use the connection.
- To …
Thanks for the feedback. I put these on the list of items to research...
- for examples of using the report explorer with various database engines
and data access component sets see RBuilder\Demos\EndUser Databases. The
examples include SQL scripts for creating the supporting tables and a
ReadMe.d…
Try
myReport.Template.New; // clear layout
myReport.FreeModules; // free TdaDataModule and TraCodeModule
Here is a downlaod link to the DADE plug-in for FF
www.digital-metaphors.com/rcl/dade/daFF.zip
- The key here is that you said it was working before you deleted the
TADOConnection component. I do not recommend doing that. You are just making
things more complication. Instead, I recommend that you speficy the
TADOConnec…
For an example, check out RBuilder\Demos\AutoSearch\Build Description of
AutoSearch Settings
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
- Please do not post attachments to the newsgroups. If you would like to
create a simple example that demonstrates what you are trying to accomplish
you can email to support@digital-metaphors.com in zip format. Please use
sta…
- A report definition typically consists of layout elements, data access
elements, and code. Using RB Enterprise, all of these can be created via the
report designer and saved externally (i.e. outside of the .exe).
- RAP…1. ReportBuilder does not currently contain support for Unicode. (This is a
feature that we would like to add and we are hopeful that Borland will add
Unicode support to the VCL in a future release - to make this a more
manageable …
Thanks for the feedback, I will add this to the request list.
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
I installed SQL Server and performed some testing using D2006, RB 10.04, and
dbExpress
- the query tools work fine. I encountered no issues with gettingthe list of
tables or fields. Make sure that you have DataSettings.U…
I researched this and have updated the DADE plug-in for DBExpress,
daDBExpress.pas for RB 10.03. Send an email request to
support@digital-metaphors.com and we can send you the updated unit.
--
Nard Mose…
Can you provide information about the SDAC plug-in so that we can we add a
listing to the DADE plug-ins page on our web site?
http://www.digi…
- first you will need a DADE plug-in for SDAC, does CoreLab provide one? (we
would like to update our DADE plug-ins page to include a listing for it. )
Sorry, but I do not understand what you are asking.
- are you using the RB DataDictionary to define the tables, fields, and
relationships? If so do you have AllowManualJoins set to true?
- The Query Designer allows …
Ok, great.
For a future release, perhaps we can enhance TdaSQLBuilder to provide direct
method calls for managing the links. I will add that to the list.in Changing DADE query in code - adding fields Comment by nardmoseley August 2006
I would convert the report to use SQLBuilder if at all possible.
I think what is happening is that you are modifying the TdaSQL object (or
more likely a copy of it), but the TdaQueryDataView does not know about it.
If yo…- make sure that have a statement to free the SQLBuilder
lSQLBuilder.Free;
- you can also try adding a statement to explicitly call ApplyUpdates prior
to Free
lSQLBuilder.ApplyUpdates;
lSQLBuilder.Free;
Thanks for the feedback. For the next release we will update the references
package source and the ReadMe.doc. (and yes, the ReadMe.doc was created from
one that was written for Flash Filer)
--
Nard Moseley
Di…
RB 10 includes a DADE Plug-in for NexusDB, it is installed to
RBuilder\Demos\EndUser Databases\NexusDB
RB 10 also introduces a new ReportExplorer ItemTemplatePipeline property
that can be used to optimize performance - c…
For an example of a correct configuration using Interbase Express, check out
RBuilder\Demos\EndUser Databases\Interbase\IBExpress. Open the example and
check the Designer.DataSettings values. The SessionType is set to IBXSession
Thanks for the feeback - it could definitely be implemented better -
something like a BeginUpdate/EndUpdate feature would be nice.
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Here is an example that I created - it shows how to use SQLBuilder to edit
the SQLText and use AutoSearch. The example is implemented with Delphi code,
however it can be adapted to RAP by coding some RAP pass-thru functions.
<…
- rather than using a RAP passs-thru function to modify the SQL, I recommend
using the TdaSQLBuilder class. The TdaSQLBuilder class is designed for
eactly this purpose - to provide programmatic access to the TdaSQL object
ass…
- email info@digital-metaphors.com with your serial number and registration
information and request an update to RB 9.03, which was the last produced
release for RB 9.x
- install RB 9.03 and check RBuilder\Source for rbA…