nardmoseley
Comments
-
- 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…
- when compiling set the Delphi library path to RBuilder\Source and then
afterwards set it back to RBuider\Lib, set the output directories for dcp
and bpl to be blank so that the new files will be generated to
RBuilder\Source…- /do not/ modify daSQL.pas (I never mentioned that unit)
- /do/ modify daADO.pas (if you are using ADOSession type). Otherise you
need to modify the relevant plug-in. You never specified what type of data
connectivity you are…
The DADE plug-in is responsible for getting the list of available table
names. If you are using ADO to connect to MS SQL Server, then you could try
modifying the DADE plug-in for ADO. Open daADO.pas and find the method,
TdaAD…
- make sure that DataDictionary.UseTableOwnerName is set to false.
- RB internally caches information about the available tables in the
database. If some reports use a different database, that could cause an
error. You c…
- I tried a simple example using SQL Server Northwind sample data and RB 10
and it worked. I used the Query Designer to create a query on Employees. I
added a Calculated field that contains a call to the SQL Server function
G…
- The rbItems and rbFolders tables use auto increment fields to generate the
itemId and folderId field values. That might be the cause of the issue,
because typically those values will be generated by the database server and
…