Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\AEMIG\apm_recforms.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>Reviewing Retrieved Forms</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T18:4:45Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Reviewing Retrieved Forms" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E12509-01" /> <link rel="copyright" href="../dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="../dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="up" href="preface.htm" title="Home" type="text/html" /> <link rel="up" href="appmgr.htm" title="Migrating a Microsoft Acces..." type="text/html" /> <link rel="up" href="apm_howrevobj.htm" title="Step 5: Review Your Retriev..." type="text/html" /> <link rel="up" href="apm_recforms.htm" title="Reviewing Retrieved Forms" type="text/html" /> <link rel="prev" href="apm_recquery.htm" title="Previous" type="text/html" /> <link rel="next" href="apm_recreports.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface.htm" title="Home">Home</a> > <a href="appmgr.htm" title="Migrating a Microsoft Acces...">Migrating a Microsoft Acces...</a> > <a href="apm_howrevobj.htm" title="Step 5: Review Your Retriev...">Step 5: Review Your Retriev...</a> > Reviewing Retrieved Forms</p> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="apm_recquery.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="apm_recreports.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CBBHFIBF" name="CBBHFIBF"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1><a name="AEMIG115" id="AEMIG115"></a>Reviewing <a id="sthref62" name="sthref62"></a>Retrieved Forms</h1> <p>Next, review the forms retrieved from the Microsoft Access export. Application Migration identifies invalid forms and lists additional information, such as the form's source type and source name.</p> <p>For valid forms with a source type of table, you can select the type of object you want the form to become within Oracle Application Express: form (default), report and form, or tabular form.</p> <p>Microsoft Access forms based on a query are migrated to Oracle Application Express forms. Microsoft Access forms based on a SQL query are migrated to Oracle Application Express reports.</p> <p>After you update the forms, select the ones you want to include in the migration.</p> <p>To review retrieved forms:</p> <ol> <li> <p>From the project page, click <span class="bold">Forms</span>.</p> <p>The Forms page appears, showing the status of the objects ready for migration.</p> <img src="img/acmg_frm_pg.gif" alt="Description of acmg_frm_pg.gif follows" title="Description of acmg_frm_pg.gif follows" longdesc="img_text/acmg_frm_pg.htm" /><br /> <a id="sthref63" name="sthref63" href="img_text/acmg_frm_pg.htm">Description of the illustration acmg_frm_pg.gif</a><br /> <br /> <p>For each Microsoft Access form, the Forms page shows the following information, if available:</p> <ul> <li> <p>Source type:</p> <ul> <li> <p>Table</p> </li> <li> <p>Query - The Oracle view that was migrated from the Microsoft Access query.</p> </li> <li> <p>SQL Query - The original Microsoft Access SQL query that the Microsoft Access form is based on. Note that this query has not been parsed by the Oracle Migration Workbench. Therefore, you might must edit it to make it valid Oracle SQL syntax.</p> </li> <li> <p>Nothing - The form has no underlying source type.</p> </li> </ul> </li> <li> <p>Source name - The Oracle table or view name if the source type is a table or query.</p> </li> <li> <p>Status - Form status as Valid or Invalid. The source of the form must have a status of Valid before you can select it for migration.</p> <p>A form's status is based on two factors: status of its underlying source object and inclusion of the source object in the migration. Specifically, a form has a status of valid if either one of these situations exists:</p> <ul> <li> <p>Its Source Type object (table, query, or SQL query) is valid, and it has been included in the migration. Its check box is enabled and can be selected.</p> </li> <li> <p>Its Source type object has a status of valid, but the source object was not included in the migration. Its check box is disabled.</p> </li> </ul> <p>A form has a status of invalid if either one of these situations exists:</p> <ul> <li> <p>No Source Type is listed. Its check box is disabled.</p> </li> <li> <p>Its Source Type object (table, query, or SQL query) is invalid. Its check box is disabled.</p> </li> </ul> </li> <li> <p>Startup form - Identifies the form that displays when you open your Microsoft Access database.</p> </li> <li> <p>Parent form - Indicates the form/subform relationship that existed in your Microsoft Access database. For example, the <span class="bold">CallListSub</span> form shows <span class="bold">Contacts</span> as its Parent Form.</p> </li> <li> <p>Migrate to: Form, Tabular Form, or Report and Form - The select list appears if the source type is a valid table.</p> </li> </ul> </li> <li> <p>To run a bulk process that attempts to compile all invalid SQL queries, click <span class="bold">Attempt to compile invalid SQL queries</span>.</p> <p>Using this option can validate some SQL queries that show a status of invalid. Note that SQL queries from Microsoft Access forms are not loaded into the Oracle Migration Workbench, and are therefore not parsed.</p> </li> <li> <p>To edit a SQL query:</p> <ol> <li> <p>On the Forms page, click the SQL Query you want to edit.</p> </li> <li> <p>Click <span class="bold">Validate</span> to find the invalid part of the SQL query.</p> </li> <li> <p>Click <span class="bold">Edit</span>.</p> </li> <li> <p>Update the query and validate it.</p> </li> <li> <p>When it is validated, click the project name breadcrumb.</p> </li> <li> <p>To include the validated query, click <span class="bold">Forms</span> on the project page to go to the Forms page. Then select the newly validated query in the left column and click <span class="bold">Apply Changes</span>.</p> </li> </ol> </li> <li> <p>To edit a query:</p> <ol> <li> <p>On the Forms page, click <span class="bold">Query</span> for the form you want to edit.</p> </li> <li> <p>Click <span class="bold">Compile</span> to find the invalid part of the query.</p> </li> <li> <p>Click <span class="bold">Access Query</span> to review the initial query and compare it to the converted query.</p> </li> <li> <p>Click <span class="bold">Edit</span>.</p> </li> <li> <p>Update the query and recompile it.</p> </li> <li> <p>When it is validated, click the <span class="bold">Queries</span> breadcrumb.</p> </li> <li> <p>To include this validated query, select it in the left column on the Queries page and click <span class="bold">Apply Changes</span>.</p> </li> </ol> </li> <li> <p>To review details about a form, click the link in the Access Form column.</p> </li> <li> <p>To include forms in the migration, select them in the left column.</p> </li> <li> <p>Click <span class="bold">Apply Changes</span> to save your selections.</p> </li> </ol> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">See Also:</p> <a href="apm_recreports.htm#CBBIAIFD">"Reviewing Retrieved Reports"</a>, <a href="apm_howrevobj.htm#BGBHBHFA">"Step 5: Review Your Retrieved Objects"</a>, and <a href="apm_howmigproj.htm#BGBIDFDB">"How to Migrate a Microsoft Access Application"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="sect2" --> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright © 2003, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="../dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td> <td align="center"><a href="apm_recquery.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="apm_recreports.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de