rbuser
Comments
-
Thank you for your prompt attention.
Unfortunately the problem has not yet been solved.
We are preparing a small program to help them understand and solve the
problem.
Regards
Edgar Brtiez
www.s… -
I got this partially figured out. I stepped through the code and saw
that I had to setup report level parameters that were named the same as
the SQL parameters before doing the manual SQL. Otherwise it replaces
populates the pa… -
I am using RB 12.01 with daIBO; dtFirbird, IBOSession
I am currently getting an error with the following SQL Text:
Select * from SP_GetAllSales(:Begin_Date,:End_Date)
Error:
Invalid SQL Statement
Sorry, didn't mean to double post. Didn't think the first message was
posted...
Hi Nard,
it's Delphi 7, RB 11.04, MS SQL.
I can't manually edit sql because I need user to specify parameters using
autosearch fields (see qry
Select e.*
From Employee e
where e.uid not in
(Select t.Empl…"Nico Cizik \(Digital Metaphors\)" wrote
"Nico Cizik \(Digital Metaphors\)" wrote
Hi Nico,
I am not using DataDictionary. The problem solved itself in some strange
way, because of a restart of the computer maybe. The table was available in
the report when i opened it in designmode (in Delphi IDE) today. Yo…I probably should explain this better. I have a TReport on a form and the
DataPipeline is a daADOQueryDataView. I have tried this
gMetaDataManager.Clear, but that dit nothing. Where do i put this line to
get it to work? As the repo…Is there no way to do this in designmode?
Terje
Nico Cizik (Digital Metaphors) wrote:
Hi Nico,
I have found it falls over at the following routine in LoadTemplate.
{convert the binary stream to text}
ObjectBinaryToText(lBinaryStream, lTextStrea…Addenda - Would this be a compatability issue with using Delphi XE?
Hi Nico,
OK. Having a play with the example, and, per the instructions, I am
getting the Invalid format error. I am using Advantage. The following
is my top end...
{Code Snippet}
unit rbEditTemplatesAsT…Nico Cizik (Digital Metaphors) wrote:
Hi Nico,
Will look at it. Saved a template as text and edited OK. Small
problem, where are the 'Calc's saved? They didn't appear in the report
template that I can see.Thanks Nico,
All sorted, although I think I lost a variable calculation when I
saved a Template without raIDE available.
Related, sorta, question.
In the Templates they refer to tables like 'Invoice', 'Custom…Nico -
Thanks for the repsonse. The issue is that i'm not trying to alter the
search criteria after selection, or add the results of the criteria to
another query ( which I can do ! ), but set it so that when the user
s…Thanks NICO!!! solved.
Hi Nico,
i saved report with scaleimage= false and properties is saved into RTM
Thansk
Regards
Paolo
Hi, Nard,
Ok, but how do I get access to the AutoSearchField associated to the
parameter? It is a private field of the parameter right now, and the
AutoSearchCriteriaByName cannot locate it because when it was created,Hi, Nico!
Thanks for the information. I went through this process when going from
FlashFiler to NexusDB, and then from NexusDB to kbmMW. With kbmMW,
however, I'm looking to eliminate this problem: I use the same DataView
c…After further research...
It appears none of my existing reports have the DatabaseType property
of the TdaSQL object in the .RTM files or in the database templates
(they were saved using RB6.03). However, the one I just saved w…I found where the Parameterized SQL is generated. However, I might not
be understanding how the Parameterized SQL works at all.
I added some test code to force the parameter type of my query in
dakbmMW, just before my query is e…We use RB 12.04 with SQL db, I think I found out what our problem is.
I tried entering the dates manually in the onbeforeautosearch, it
worked...so I guess it was a problem with the data...
In version 10 the searchexpression wa…Nico,
Thanks for the reponse.
I think I'm doing the Manual linking, clicking on the link icon and
matching the fields.
Since the manual query that has the "NOT IN" clause I'm not able to view the
Magic SQL.
Neithe…Patch received and it works fine now!
Thank you
We use MS SQL (2000, 2005, 2008, 2008R2).
I'll create a simple SQL2000 database and use de ADO drivers.
If I send you the .bak file you should be able to load it anywhere.
I'm trying to build a demo project in Delphi using the DBDEMOS database but
I can't add any combination of "expression" and calcs.
As soon as I've added a SUM or COUNT and try to add an expression
(LOWER(city) for example) I get the…It still doesn't work, but I get the fields back now so I can see why it's
not working.
I have 4 calculated fields, 2 of them with an expression (CASE WHEN...) ,
one SOM and one COUNT.
Only the 2 non aggregate expressions…Sorry for the "from" name, windows mail filled it automatically with the
group name, I think I've corrected this now.
I think I found what our problem is.
We don't use ado to reach the database but another component from RemObj…Thank you Nard,
Jason.