<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/tt/onlinemanual/100123" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">DAL 1 Overview</Title>
		<Keyword ContextSensitive="No"><Level1>DAL</Level1>
		</Keyword>
		<Keyword ContextSensitive="No"><Level1>Data Access Layer</Level1>
		</Keyword>
	</Header>
	<GeneralSection ID="dal1"><Paragraph class="Default">DAL 1 scripts were introduced in Infor ERP Baan5.0. A DAL 1 script contains database logic (e.g. logical integrity rules), but it usually does not contain <Emphasis>all</Emphasis> business logic for the table it belongs to. Very often business logic is spread across the DAL 1 script and the UI scripts.</Paragraph>
		<List><ListIntro>Most UI scripts still contain business logic. They can contain, for example, logic to:</ListIntro>
			<ListItem>make fields read-only.</ListItem>
			<ListItem>determine which enum constants can be selected in an enumerated field.</ListItem>
			<ListItem>update a field after a change to a related field.</ListItem>
		</List>
		<Paragraph class="Default">Therefore it is very hard to use the DAL 1 scripts for integrations via Infor ERP LN Business Adapter: the business logic in the UI scripts is skipped if another application connects to a ERP LN table. Therefore this logic must be rebuilt in the <Link href="/baanerp/tt/glossary/glossary#100082" role="glossary">BOIs</Link> that provide the connection. If you change the business logic in the UI scripts, you must adapt the corresponding BOIs as well.</Paragraph>
		<List><ListIntro>A DAL 1 script can contain the following types of hooks:</ListIntro>
			<ListItem>Object hooks: to check the logical integrity of records in a table. Object hooks replace the "main.table.io" sections in the program scripts and can be used, for example, to automatically perform update actions in other tables after saving or deleting a record.</ListItem>
			<ListItem>Property hooks. A property hook is related to a specific table field. These hooks are, among other things, used to check the input for table fields.</ListItem>
		</List>
		<Paragraph class="Default">You can view and edit DAL 1 scripts via the <Link href="/baanerp/tt/adv/ttadv2530m000" role="session">Program Scripts / Libraries (ttadv2530m000)</Link> session. The script type is "DAL".</Paragraph>
		<Paragraph class="Default">For details on DAL 1 scripts, refer to "Data Access Layer" in the <DocRef>ERP LN 6.1 Programmer's Guide</DocRef> ( <Code>progguide.chm</Code> Help file), which is stored in the <Code>help</Code> folder in the installation folder of your Infor BW Client.</Paragraph>
		<Note><SectionTitle>
                                 Note
                              </SectionTitle>
			<Paragraph class="Default">The <Code>progguide.chm</Code> Help file is delivered with the Dynamic Form Editor ( DFE ). If the file is not present on your PC, you must first install the DFE from the ERP LN installation CD.</Paragraph>
		</Note>
	</GeneralSection>
	<RelatedTopics><SectionTitle>
                              Related topics
                           </SectionTitle>
		<RelTopic><Link href="/baanerp/tt/onlinemanual/100124" role="manual">DAL 2 Overview</Link>
		</RelTopic>
	</RelatedTopics>
</ManualTopic>
