digitalmetaphors
Comments
-
Can you parse out commas and add quotes to the sCustomerList string variable
so that the SQL ignores the comma and lets it treate the "Jones, Bill" as
one entry?
Cheers,
Jim Bennett
Digital Metaphors
<… -
You can extract the TdaSQL object an dthen insert a criteria object. Here
is ane example which takes a dataviwe which has one criteria, adds an Or,
adds a new criterita and then modifies the new criteria after it was added.
Yes, criteria on a join expression is on our requested features list. The
current solution is to edit the SQL text. You're right, when the criteria is
placed in the WHERE clause instead of the join, it effectively creates an
inner joi…Those settings appear to be correct in comparison to the ASTA RB EU project
I have running for other databases.
What happens when you comment it out? Does it not work?
Cheers,
Jim Bennett
Digital Metaphors<…Can you run a ASTA demo server with the ASTA RB End User demo project from
ASTA's website? Which database are you using? If it is Interbase, then try
setting ForcedRefresh property on the Interbase data access components on
the serve…Not that we are aware of.
You'll have to modify the GetTableNames method on the DADE plugin's session
class and the GetFieldNamesForSQL on the dataset class of the DADE plugin.
Cheers,
Jim Bennett
Dig…I looked back at our conversation and I found that I was able to reproduce
your problem with the WHERE clause in RB 6.03, but not able to reproduce the
problem in RB 7 right before we released RB 7. Can you download the RB 7
demo vers…The changes which were made for RB 7 from 6.03 were architecturally related
to the report server edition and making the report engine threadsafe as well
as other enhancements to the engine and new features such as the
DBArchiveReader.…You'll have to edit the SQL object before the report prints in order to add
the path name to the table in the SQL. DADE doesn't support multipl
edatabase connections at one time. You will need to do what you were doing,
extract the SQ…Is the datapipeline assigned to the subreport? Check the Report | Data menu
from inside the subreport layout in the designer. Are the fields connected
to the datapipeline and datafields? Is ParentDatapipeline set to true on
the data …You can use any proper TDataset descendent with RB's data pipeline
architecture. If the dataset supports bookmarks along with the standard
traversal methods on the TDataset interface, then it should work with the
Standard Edition of R…Create a simple test project based on our DBISAM end user demo with the data
dictionary and its data access components deleted.
When are you creating/destroying the temporary tables? You will want to
clear the meta data cache if…DBISAM works fine in tests here. It sounds as if your datasettings on the
designer have changed, which is why the meta data cache can't find the
table. You need to clear the meta data cache at runtime after you change the
datasetting…Compare daDBBDE.pas to daDBISAM.pas. In the BDE plugin, you should see that
TdaBDESession.GetDatabaseNames adds aliases, while
TdaDBISAMSession.GetDatabaseNames just calls inherited. You could try adding
the remote database to this l…We have to support all the different databases that we support:) This means
that there is a lowest common denominator in each of the SQL standards that
we support for our SQL generation. Yes, we are aware that each database has
their …This is a multi-part message in MIME format.
If you test with RB 7.01 does the problem go away?
If you are using Delphi 5, do you have update pack 2 installed?
If you remove this code do you still get the ADO timeout error?
Can you reproduce this problem using …ReportBuilder's data access environment needs to know the available table
names in order to support the query tools. You could try using the Data
Dictionary component to define the table/field/join names. RB will use the
data dictiona…We support the SQL 2 standard as much as we possibly can and support all the
different databases that we can. However, this isn't supported. Can you try
using the WHERE clause (search criteria in DADE) to create this dataset?RB doesn't support every single feature found in the many different flavors
of SQL, nor all possibilities of standard SQL syntax. Sorry, but you'll have
to edit the SQL as text to enter the join expression constant manually and
lose t…This isn't supported on all SQL engines. We have to support the least common
demoninator for SQL engines in DADE. Unfortunately, again, you'll have to
edit the SQL text to enter this SQL for your query, and lose the query tools
suppor…Yes, you'll have to install our rbIBO package in our demo directory for
Interbase/IBO inorder to get the Delphi design time support in DADE. Does
the rbIBO package not compile and install? Double check the output bpl and
dcp director…Which version of RB are you using? You should use the one that is located in
the RBuilder end user databases demos installation directory for
Interbase/IBO. I know in RB 7.0, there was a problem with compatibility of
the out of the bo…Are you using the TSQLConnection's connection builder?
I dropped a TSQLConnection on a form. I added a button and a memo. I
configured the connection object to point to the employee.gdb Interbase
database. In the button click ev…No, I have not heard of this behavior. Can you connect to the Employee.gdb
sample database using dbExpress without RB components being involved? I am
using D7.0 build 4.453 as well.
Using RB's dbExpress end user demo, set Design…In Delphi 7, using RB 7.01's installed demos, both the IBExpress and
DBExpress demos worked just fine. What version of Interbase are you using?
Cna you execute a simple query by itself on a TForm on the Employee sample
database withou…Yes, RB needs a non-unidirectional dataset. This means that you have to use
the TSQLClientDataset which can be traversed in either direction. The other
datasets are unidirectional and can't be used with RB. That is most likely
the pro…What does the SQL look like? Hit Ctrl-Click over the lowest child level
detail dataview. This is the magic linking SQL that is sent to the interbase
server. The other SQL (SQL view in query deisgner) is specific to the
dataview if it …No, there is no built in support in ReportBuilder for this kind of
import/export of the data stucture on a database. You'll have to use a
database management utility to export the table data to a file and then
import it from file.
There is no documentation on TdaSQL. The source is the documentation. DADE
was supposed to be an internal library, but it is possible to interact with
it at runtime. You'll have to use smoe more code. In the demo, there is a
line whi…