Hi,
For our new project, based on C/S architecture, I made one module which displays objects for the current user.
This object tree is filled based on links between objects, which are saved in only one table (called "o2o_general", with oog_parentobject, oog_childobject and oog_relationid).
The SQL statement is very simple, since I just need a raw list of objects connected e.g. directly to current user.
The problem occurs only when I have in the list one object connected to current user twice (e.g. user is a project leader of some project and, at the same time, he is a team member -
that's two different relations).
If I run this SQL (copied from InputBox at run-time) within SQL Navigator, I get as result e.g. 20 rows.
The same SQL used in ClientDataSet, returns e.g. only 8 rows (it stops when first duplicate object is found - in this example, project where current user is project leader and team member).
After this record, property EOF becomes true and the while loop is finished, although there are still some records in DB which are not retrieved.
I've faced this problem today, and I don't know what shell I do to fix this. I have tried to run the same code against SQL Server.
We have made all SQL to be compatible for Oracle and SQL Server at the same time, and this is completely OK now, so I can choose whether I want to connect to Oracle DB or to SQL Server DB.
Guess what - it is OK on SQL Server, and all objects are displayed. Unbelievable, isn't it?
Any help will be very appreciated...
Configuration:
- Delphi 7.1 Architect
- DOA v3.4.6.4
- Oracle8i v8.1.7.0.0
Best regards,
Mickey Martinic
For our new project, based on C/S architecture, I made one module which displays objects for the current user.
This object tree is filled based on links between objects, which are saved in only one table (called "o2o_general", with oog_parentobject, oog_childobject and oog_relationid).
The SQL statement is very simple, since I just need a raw list of objects connected e.g. directly to current user.
The problem occurs only when I have in the list one object connected to current user twice (e.g. user is a project leader of some project and, at the same time, he is a team member -
that's two different relations).
If I run this SQL (copied from InputBox at run-time) within SQL Navigator, I get as result e.g. 20 rows.
The same SQL used in ClientDataSet, returns e.g. only 8 rows (it stops when first duplicate object is found - in this example, project where current user is project leader and team member).
After this record, property EOF becomes true and the while loop is finished, although there are still some records in DB which are not retrieved.
I've faced this problem today, and I don't know what shell I do to fix this. I have tried to run the same code against SQL Server.
We have made all SQL to be compatible for Oracle and SQL Server at the same time, and this is completely OK now, so I can choose whether I want to connect to Oracle DB or to SQL Server DB.
Guess what - it is OK on SQL Server, and all objects are displayed. Unbelievable, isn't it?
Any help will be very appreciated...
Configuration:
- Delphi 7.1 Architect
- DOA v3.4.6.4
- Oracle8i v8.1.7.0.0
Best regards,
Mickey Martinic
