rbuser
Comments
-
Good point .... modified code below
cheers
//==================================================================
procedure TdanxSession.GetTableNames(const aDatabaseName: string; aList:
TStrings);
var
lDat… -
Nard,
here is the DADE mod for accessing nexusDB v2 views.
note that the associated TnxDatabase cannot be set to "readonly" for a
TnxQuery to query a view (not sure why)
cheers
Ron
//============… -
thanks Nard
I'll have a play
-
Thanks Nard,
Not as simple as that unfortunately, and I'm getting a bit out of my depth
Modifying daNexus.pas is simple to have the view listed as a table.
Getting the field list is another story
TdaMetaData.Ge… -
I tried this - fiddled with the report data views and saved the whole shoot
back to the database.
Then I closed the application, switched on the property UseDataDictionary,
recompiled and reran the report. I still get the mes… -
Nard
Looks like it's got nothing to do with RB.
I added the connection objects as suggested and I still had the problem. So
I removed everything to do with RB so it was just a simple app that loaded
the DLL which ac… -
OK
Thank you for these advice. I will try like this.
Jerome
-
Hi,
How to access, in report, the values specified by user in "autosearch"
dialog (at runtime) ?
I need this information to print it on footer of report.
Thanks and sorry my poor english.
Samuel
I am trying really hard to decode your tips, but so far I am having trouble.
I would really appreciate if you could please be more specific.
Are you saying that I need to create an SQL object in RAP (in which event
;(?? ), the…>>Database Server Error: Cannot create new transaction because capacity was
This occurs because the OLEDB Driver for SQL Server does not support nested
transactions. My guess is you are trying to do two updates in the datab…Have Dowloaded 10.04 and installed it. MSSQL Server now appears in the data
base list of the Data Settings Form. However the list of tables is still
empty when I go into the Query Wizard to create a query.
What else is it th…Thanks. Have sent the email.
Nigel.
Thank you for the tip.
It works just fine.
We've answered our own question. We found SQLBuilder.LinkBroker and
CreateLink.
Jason.
That's terrific thanks Nard, helpful as always.
We have started to use the SQLBuilder stuff now and we're getting further
with it, so that's good.
You're right about assigning the TdaSQL back to the TdaQueryDataView, weNard,
Thanks for the response. It turns out we're not actually using the
SQLBuilder class itself, we're manually getting the dataview, it's query,
etc. I'm assuming this is what the SQLBuilder class was introduced for in
v9…Never mind. Dumb question. I just worked it out.
Nigel.
FYI... I un-installed Delphi 2006 - (I kept getting an "out of resources"
error with the applications compiled with D2006) - and went back to Delphi
7. I installed the same NexusDB 2.5, RB 10.4, TeeChart 7.07, etc...(the D7
versio…I'm not sure who supplied the Word document for installation instructions of
the NexusDB plugin... but... there are 2 references to FlashFiler... and one
reference to daFF.pas. I'm assuming these are left over from a previous
vers…There seems to be a bug in the requires section. If you add NexusDB205sq70
it will compile fine.
Ken
Using Delphi 2006, RB 10.04, NexusDB 2.05...
I'm missing something somewhere.... I followed the instructions (at least I
think I did) included with the DADE plug-in. When I got to step 7 and
attempted to compile the package.…Sorry 'bout that.... I had overlooked an update... I had an earlier version
of RB10 - and the NexusDB pugin was missing. Thanks for the wakeup....
The one supplied works perfectly with nx2 rb10.
Ken
As a Followup the following does work:
var
LSQLBuilder : TdaSQLBuilder;
LSQL : TStringList;
begin
LSQL := TStringList.Create;
LSQL.Clear;
LSQL.Add('SELECT customer.CustNo, customer.Company, '…I looked at the example you have provided and got a good idea of where we
are going. The Help File Topic for the TdaSQLBuilder doesn't mention the
SQL property of the class or that and the entry for the TdaSQL class doesn't
mentio…> - rather than using a RAP passs-thru function to modify the SQL, I
Yes that works - if I used the visual tools to do the query . In this case
I diddn't - I manually typed in the SQL myself (Since I am retrieving a
datse…why I cannot find rbADO.dpk? My ReportBuilder is 9.02. I don't see a
rbADO96.dpk either.
Sorry, my mistake. It is ADOSession type. So after modify daADO.pas, what
should I recompile to make that into effect?
Should I make change in daSQL.pas directly? If so, what project should I
recompile and install after changing?
Thanks Nick,
I'm using Data Dictionay to and my TMDDField table has field name and field
alias different but the moment it goes to SQL.SelectFields[ i];
It loads the and I said f.FieldAlias it is same as fieldName but in
tmddtabl…