rbuser
Comments
-
Keane,
why would you need to edit the SQL expression as text?
From the given excerpt I don't see a reason to do so.
regards,
Chris Ueberall;
-
Rather than list the whole SQL statement, I will give the first lines.
As you can see there is no mention of the autosearch function.
The statememnt goes on to define the rest of the fields which is the
same text as abov… -
Hi Keane,
please show us the current SQL expression. You should at least be able to change the expression at runtime as needed.
regards,
Chris Ueberall;
-
This is a multi-part message in MIME format.
-
This is a multi-part message in MIME format.
-
This is a multi-part message in MIME format.
-
This is a multi-part message in MIME format.
-
I set up the old machine with Delphi 5 next to the new one with Delphi 7.
When I bring up the OLD report and view the Metadata Cache (CTRL+Click) I
see fields associated with the tables. With the new report there are no
fields displa… -
That did not do it. There is no reference in the program to a data
dictionary. The only component on the form is the TppReport. Also, where
do I find the dataSettings property. It is not part of the TppReport
component. thanks, L… -
Thanks Jim. I have seen that demo, but I am confused as to how to apply
this logic to the Report Explorer and it's reports. I have enabled the
report explorer similar to the demo for that.
-
Autojoin is false, I thought that only affected joins within each
dataview -not the external ones that have the lines drawn between boxes. I
didn't know the order mattered though. So TableName1 is the master in the
DD join table?Yes, I'm using DD.
That demo is really slick. I'll use that. But in this case that would
limit flexibility. The function I want to override is in
ppUtils.StrtoDateTime. How can I overide just that function? I'm going to
have it change Stopdate to :…Let me clarify. I already have a custom autosearch dialog. I'm asking
about where the dayes are validated in the End-user RAP in the dataviewQuery
designer wizard. I want the person that is building the report to be able
to put "St…
Salut!
Why not having another table with one extra column for user identification.
That way you can create views (or selects) that returns the required fields based on
a specific user. If you base your solution on CREATIN…First of all thanks a lot for this really precious mail !
I think I'd better try to use the temporary tables because my aim is to
be able to change the fields at runtime... and if I understood your
code, I end up with a "code …Jim,
Yes, I can duplicate the problem in the demo also. However, I found that the
main problem in our customers case has to do with the date separator type.
They use - instead of / . If you use - along with dd/mmm/yy with th…Jim,
I haven't tested these changes yet against other versions of the DADE, I
will before I submit them to you. However, I was careful in my code to
ensure that my changes only take place if the '{' character is present (and
I would agree with Jim that one of the best solutions would be to
eliminate a column name that is a reserved word. However, that may not be
practical.
There is also a unit called daSQLReservedWords. In it, for each databaseJim,
Thanks for your help, I have now added in some code to format the date
correctly, just so you know I am using PDAC tables (from Pervasive) and just
the standard report builder components. In the designer, data settings…Jim,
I have tried entering the date in the same format as my regional
settings, I have tried changing my regional settings to the same as my
database manager and re-entering the values, none of which work. I keep
getti…I found a solution, but I don't know if it is good and if I will have a
side effect.
In the daMagicSQL unit in the TdaMagicSQL.GetOrderByFields method, I put
this 2 lines in comment.
// if (lField = nil) th…Hi,
I created test project and sended them to support.
Petr Slipek
I am using RB 7.02 with FF 2 as the database. The problem is there.
Petr Slipek
Dont worry about answering this post. Having spent the weekend thinking
about I have decided to change my approach to one where I create temporary
answer tables containing the master data for the more complicated stuff.
> 1. As a first step, try to run the RBuilder\Demos\EndUser
I followed the directions in the Readme.doc for installation of all the
required items. Rather than use the project above, I found the End User
Tutorial (..\RBuilder\Tutor…I can't say that I agree with this approach. I like RB as a report building
tool. It works perfectly and provides plenty of ways to build the SQL /
Query statement. I prefer that the prompts / parameters be left to the
application …> 1. For an example of using Advantage with the EndUser solution, check out
includes.
I have done that and everything works fine with Advantage ADT tables.
However, I can't get it to work with PDF tables although Advantage ha…Thanks Nard..did the trick
--
Paul Toms (mailto:paultoms@cix.co.uk)