View Single Post
  #1  
Old 12th February 2002, 20:17
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,905
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Code: Sample Qkey Script

Q-key has been mentioned multiple times on this site. I thought I would post a sample of one Qkey session that I just recently did. Hopefully this will help people understand the product.

I modified the tppss9161m00b session to include text for the MDD, plus allow the user to assign a number code to the MDD. This is an extension of the Baan standard program or better yet - added functionality. With Qkey you do not have to modify the Baan source script. When Baan releases a new version of this script - all I need to do is recompile my version. Unlike some of our changes I will not have to move Baans changes to our script or make new changes to the Baan source script.

You can not do everything with Qkey that you do with a source script, but you can come close. Remember this is just a sample and you must OWN or have a demo copy to run the script. Plus you also have to have the new table that it uses.

The attached file contains the script as I developed it (pre-compile tppss91610.cln) and a copy of the file after it has been compiled(qkey compiled tppss91610.cln). Also a word document is include that contains a screen print showing the two new fields.

Once again this is just a sample and you must own qkey to compile or run it. This is not an advertisement for the product, but I do find it very useful. Without Qkey I could not make the changes that I did, since we do not have the source for this session.

Mark

Code:
|**************************************************************
|* Session	:tppss9161  0  VRC B40C a1 dev1
|* Author	: Mark Holland
|* Date	: February 12, 2002
|************************************************************************
|* Script Type	: Main Session
|* Description	: Example of extending Baan functionality with out source code.
|* Category		: Sample Code
|* License		:
|* Platform     	: UNIX
|* Requirements	: Purchasing QKEY software from Redklay.
|* All Rights Reserved 
|* 
|* Permission to use, copy, modify, and distribute this software and its
|* documentation for any purpose and without fee is hereby granted,
|* provided that the above copyright notice appear in all copies and that
|* both that copyright notice and this permission notice appear in
|* supporting documentation. 
[y|* WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, 
|* WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER 
|* TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE
|* OR PERFORMANCE OF THIS SOFTWARE.
|***************************** declaration section ***************************
|*****************************************************************************
|* Maintain Manufacturing Dependent Demand
|* Mark Holland
|* 01-18-2002
|*****************************************************************************
|* Main table tppss961 Manufacturing Dependent Demand, Form Type 1
|*****************************************************************************
|***************************** declaration section ***************************
declaration:
	table	ttppss990	| Text for MDD.
	table	ttppss961	| MDD

	extern	domain	tcyesno	txta.yn		| Text present for MDD
	extern	domain	tcorno	key.code	| New numeric key for MDD
	extern	domain	tctxtn	hold.textn	| Hold Text number

	#include	<bic_text>
Attached Files
File Type: zip sampleqkey.zip (18.9 KB, 696 views)

Last edited by mark_h : 22nd August 2006 at 15:47.
Reply With Quote