rbuser
Comments
-
Thanks Nico, I can confirm this has worked.
Jason.
-
Thanks for the reply Nard,
However, everything you've written is already understood and anticipated
by me. All joins in my query use correctly indexed columns, but as good
as NexusDB is, there are known weaknesses with (necess… -
Hello Nico,
That's fixed it - and I see you have disabled "magic SQL" too. I'd say
that this is a good one to catch
in Cannot link detail query if master query is sorted on a Calc field
Comment by rbuser
September 2014
-
Nico,
Thanks for the demo app - it illustrates the problem perfectly
The report on page 1 shows customer… -
On 19/09/2014 17:44, Paul Toms wrote:
And of course when making the link, if the default of Magic SQL isn't
possible then surely a warning message should be shown - it shouldn't
just do nothing. But that's a separate issue..fo… -
On 19/09/2014 16:53, Nico Cizik (Digital Metaphors) wrote:
I did mention that neither of the other linking options work.
-
ok, i found the problem.
every time i open my rtm , i always should go to file , select
"database settngs" and reselect my db type and db name.
after doing this, query are made correctly!
thanks!
Nel suo s… -
Hi Nico,
Thanks for the assist on this - the main problem I have is that the
database user in question has limited permissions with respect to what
tables can be accessed.
I've given up - I'm just going to create a ne… -
Hi Nico,
Once again sleep-deprivation sneaks in - I'd set the source path in the
project search path, not the library path.
With that fixed, the issue is clear:
When the call to get field names… -
Thanks for input.
I'm using RX10.1, but that's easy:
if lSQLConnection.Connected then
{$IFDEF Delphi7}
if GetDatabaseType(aDatabaseName) = dtMSSQLServer then
lSQLConnection.GetTableNames(aList, '… -
I just tried this:
copy dclRBDBE1724.dpk, rbDBE1724.dpk, daDBExpress.pas and
daDBExpress.pas to a new folder.
Renamed all the files, renamed the classes (eg
TdaChildNewSQLClientDataSet), changed the references i… -
Hi Nico,
Definitely should have started when I wasn't so tired...
I can see how to change GetTableNames to use the 'dbc' schema.
I'm just not clear on how to get that change (even to test to see if it
wo… -
Hi Nico,
I just spent 3 hours trying every combination I could think of to get
FireDAC connection working (there are a lot of options there!).
No joy.
The FDconnection will connect - it just won't return table n… -
Hi Nico here's an example (attached linking example.rtm):
Not sure how much use this will be to you without tables to use it
with.
Unlinked there is a simple master detail as follows (pic1.png)
There SQl s… -
This doesn't seem to be it either. I started with my bug project, still
available at:
http://msedd.com/bug.zip
And did the following:
1) Changed the RefCla… -
Filipe,
myDataPipeline.FieldObjects['myFieldName'].IsNull
... is pure RAP!
regards,
Chris Ueberall;
-
Hey, Chris
I had to do it ?cause I?m working outside delphi, with the reports stored in
a database . So, I
can?t use DataPipeline or any of that stuff, only the rap functions.
If you know a different way to do it,
duplicate message.
Hey, man
Unfortunatelly, Report Builder don?t like to have null in the fields he
works. So, RB put '' (empty string) in the field that have the NULL value. I
cracked my brain to find this and, to make my work easyer, I registere…hi,
try the following:
if Datapipline.FieldObjects['FieldName'].IsNull ... (do something)
chris
Hi Filipe,
pls see my answer to Jim, you don't need an additional RAP function to test
for NULL values.
You can use the following ...
myDataPipeline.FieldObjects['myFieldName'].IsNull
... to test for NULL values.
Hey, man
Unfortunatelly, Report Builder don?t like to have null in the fields he
works. So, RB put '' (empty string) in the field that have the NULL value. I
cracked my brain to find this and, to make my work easyer, I registere…Thanks Chris,
I think you must be right, there is a character in the supposedly empty
field. I am pursuing that angle.
Hi Jim,
I guess the BLOB isn't null and contains a non displayable character.
Did you see any 'N/A' values? You should if there are NULL values.
Assign a simple string constant for the case the value is not NULL to verify
t…Chris,
I have tried exactly what you suggest but it isn't working.
Here is my actual code:
if Questionnaire_Result.FieldObjects['User_Question'].Isnul then Value :=
'N/A'
else Value := Questionnaire_R…Hi Jim,
if Questionnaire_Result.FieldObjects['User_Question'].IsNull then ...
regards,
Chris Ueberall;
Thanks for the quick response. I will look up the TechTip.
Jim,
Do you have an example project and report which demonstrates this. I have
searched the newsgroups, and I have seen references to demos in
www.digital-metaphors.com/tips/... However, this link does not work. Please
emai…Hi John,
create a RAP pass-through function.
From your description it isn't clear what you want to achieve and why you don't want (or can't) to use a standard data pipeline.
regards,
Chris Ueberall;