HELP!!! - Urgent assistance is needed
- From: "Anders Balslev" <itq@xxxxxxxxxxxxxxxx>
- Date: Wed, 5 Dec 2007 12:59:34 +0100
Hi
BDS 2006
MSSQL 2000
I have faced a very strange and unexplainable error.
I do have a MS SQL database, containing a number of interrelated tables.
A Mastertable, and > 15 detail tables.
In my datamodule, I have an ADODataset for each table, and arranged
MasterDetail relations in the datamodule (MasterSource-->MasterFields etc.).
All my keyfields are 'UniqueIdentifier' type
I have a DatasetProvider pointing on the mastertable, and by adding fields
in the field editor, I see all the fields from the database, and also the
datasetfields (Nested datasets).
Apparently, when I have more than 13 details tables (nested datasets), and I
click on the "add fields" on the editor, (or trying to open the CDS in
designtime, also when no persistant fields are added) I get following
errormessage:
"Operation not applicable"
Regardless which one I remove, I again can add the fields, so I presume it
has something to do with resources.
Of cource, same error comes in runtime by attempting to open the CDS
The ADODatasets can all be opened without problems
I have no idea where to search
Any help will be highly appreciated
Anders
.
- Follow-Ups:
- Re: HELP!!! - Urgent assistance is needed
- From: Anders Balslev
- Re: HELP!!! - Urgent assistance is needed
- Prev by Date: Re: MS SQL 2000, ADO and edit lock
- Next by Date: ADOStoredProc and Oracle BLOB
- Previous by thread: sorry once more in english: sql : little differences big effects ??
- Next by thread: Re: HELP!!! - Urgent assistance is needed
- Index(es):