Home » Developer & Programmer » Forms » creation of procedure - which is better???
creation of procedure - which is better??? [message #82739] Mon, 30 June 2003 00:09 Go to next message
Messages: 152
Registered: July 2002
Senior Member
Which is the best one?
1.Creating a procedure in database.
2.Creating a procedure in program units.
3.Creating a procedure in library.

Please elaborate it.
Re: creation of procedure - which is better??? [message #82742 is a reply to message #82739] Mon, 30 June 2003 02:25 Go to previous message
Messages: 7065
Registered: December 2001
Senior Member
Depends on what you are trying to do and what standards you have set.

Libraries are useful for Forms-specific code, including Forms built-ins and of which you want the code to be shared over more than 1 Form.

Program Units are useful for Forms-specific code which isn't shared but created for the current Forms module only.

Database objects are useful for database operations the database handles it the fastest, and you won't have as much network trafic. Might I suggest that you'd better call database procedures through libraries (if anything changes you won't have to change each and every form)?

So "best" is a relative term here.

Previous Topic: Public Functions
Next Topic: Storing file names from a specified folder
Goto Forum:

Current Time: Sat Mar 02 21:48:41 CST 2024