We are the programmers=92 team which has been using CLARION for last
twenty years.
For period of one year we are making ERP which should have 1500-2000
procedures, ( we made 600) and, in last few months we are trying to
solve problem that bothers us and we can=92t find a solution.
ENVIRONMENT:
Hardware: Processor 2Ghz, 1GB RAM=85
OS: MS VISTA Professional
Database: MS SQL 2005
Clarion 6.1
+++++++++++++++++++++++++++++++++++++++++++++
Since now, we made two essentially different scenarios.
SCENARIO ONE:
1. Single FaraonDCT.dll with global variables and procedures
2. Single FaraonERP.exe which represents basic menu
2.1. Procedure 1: Collecting connect string with login
information
2.2. Procedure 2: Represents main menu and START (Procedure3)
2.3. Procedure 3: Creates user menu and START (Procedure 4, =93
Procedure name =94)
2.4. Procedure 4: Recognizes =93Procedure name=94 and calls correct
MDI child procedure placed in dll
3. 12-15 dll=92s which had 50-100 procedures, each (two of those dll=92s
were over 4 Mb). One dll handles one logical part (HR, finances, etc)
Result: Program crashed in different parts and events without
apparent reason. In The Task Manager we see that program was engaging
more and more RAM illogically. Sometimes, program crashes with error
report (GPF), sometimes without any error report. ?!!
SCENARIO TWO:
1. Single FaraonDCT.dll with global variables and procedures (like
scenario one)
2. Single FaraonERP.exe which represents basic menu (like scenario
one)
3. 37 dll=92s which had 4-5 procedures each (browse, select, update
and report for one table)
Result: Program starts to load and then disappears without any error
report. Interesting point: Deleting any single procedure from dll
makes program start normally. After that, adding any other procedure
makes program disappear.
++++++++++++++++++++++++++++++++++++++++++++
QUESTIONS:
Q1. Is there any other scenario? Note: We don=92t want an exe file for
each logical part (HR, finances, etc)
Q2. Does CLARION have any limitations on number of:
2.1. procedures
2.2. dll=92s
2.3. modules per single dll
Q3. Is there anybody who tried to make an ERP in Clarion before?
Q4. Is any tuning of OS needed, to make the program with so many
(1500-2000) procedures work?
Q5. What tool, instead of Clarion, is suitable for this task?
|
