FmPro Migrator Platinum full Edition cracked download new as

FmPro Migrator Platinum full Edition cracked download









http://ryushare.com/45cr0q9u1pwa/FmPro_Migrator_Platinum_full_Edition_cracked_download_.iso










FmPro Migrator Platinum Edition generates a full-featured LiveCode database front-end application from FileMaker Pro and Microsoft Access database files. This feature converts layouts/forms, scripts, relationships, and value lists into a LiveCode database application.
Utilizes the SQL Yoga Database Framework
FmPro Migrator Platinum full Edition cracked download

All of the database management code generated by FmPro Migrator is implemented by using the SQL Yoga database framework from Blue Mango Learning Systems. SQL Yoga simplifies the development of LiveCode applications by enabling the developer to work with properties and arrays instead of writing SQL code and easily manage the relationships converted from the source database. Related records are retrieved within nested arrays which can easily be passed on to the LiveCode Data Grid object. The SQL Yoga code generated by FmPro Migrator works efficiently with large data sets. First, all of the Primary Key values for a database table are retrieved into an array in memory. All of the data for an individual database record is retrieved only for the current record being viewed by the user. A new record is only loaded from the server when the user clicks the Next/Previous buttons or moves the scrollbar to the new record. This technique reduces the load on the SQL database server, reduces network bandwidth requirements and reduces the possibility of having stale data in memory.
Query By Example & Found Set Processing
FmPro Migrator Platinum full Edition cracked download

FmPro Migrator generates sophisticated Query By Example infrastructure enabling your application's users to enter Find Mode, fill in the appropriate fields and then press the Find button to retrieve the records. Search criteria symbols are implemented with a handy pop-up menu, which inserts the requested symbol into the currently selected field. Once the user clicks the Find button, the search conditions are gathered from each of the fields and a SQL Yoga query is run against the SQL database.
Portal to Data Grid Conversion
FmPro Migrator Platinum full Edition cracked download

FileMaker Portals and Microsoft Access SubForms are converted into LiveCode Data Grid objects. Each Data Grid includes fields, menus, checkboxes, radio button groups, image objects and button objects. The alternate row color info from the original Portal is also configured within the Data Grid. Related records are gathered based upon a conversion of the original database relationships in order to automatically fill the Data Grid with related records. Each field of data is drawn to utilizes the TruncateTail Data Grid function, as shown for the Date and Notes fields above. Image fields, drop down menus, pop-up menus, checkbox groups, radio button groups, oval, rectangle, rounded rectangle, button and image objects are drawn in the same positions within the Data Grid as they were originally located within the portal object. [Note: Some objects, including drop down menus, checkbox and radio button groups are drawn slightly larger in LiveCode compared to their sizes in the original FileMaker database layout. Therefore some slight manual modification of object position and size maybe required in the Data Grid Row Template.] A New Record button represented as a green (+) symbol is added to the card near the upper right corner of the Data Grid object. Clicking this button creates a new record in the related table and automatically fills the Foreign Key column with the Primary Key value from the current parent record. Within FileMaker Portals, it is common to have a button object or an image object with an embedded "Delete Portal Row" script script. Clicking the button will delete the selected row of the portal. FmPro Migrator implements this same functionality within LiveCode Data Grid objects by converting the "Delete Portal Row" script step into code which deletes the selected row of data in the Data Grid (and in the related database table).
Tab Control to LiveCode Tab Panel Group Conversion

Tab Controls from databases like FileMaker or Microsoft Access need to be handled a little differently within LiveCode stacks. FmPro Migrator converts each individual tab of a Tab Control into a Tab Panel object within a group having the same name as the Tab Panel. Each object within the particular Tab is created within this group. LiveCode menuPick code is placed into each group to automatically hide the current Tab Panel group and show the next group when a different Tab Panel tab has been clicked. Hiding or showing the enclosing group automatically hides or shows each of the objects created within the group, thus simulating the graphical interface of the original database. Tab controls can contain most other types of objects including fields, checkboxes, radio buttons, graphics and images.
Insert Picture Processing for Image Fields

Microsoft Access OLE Object and FileMaker Container fields are converted into BLOB columns within SQL database tables. A pop-up menu is created over top of the LiveCode image object for each one of these fields. Clicking the field brings up the Insert Picture dialog box for selection of a file from the local disk. Cancelling this dialog clears the image data from the field, selecting a file saves the file into the database column and displays the new image. Non-image data could also be handled with additional application-specific code. The Insert Picture dialog also works for image fields displayed within the rows of a Data Grid.
Layout Images and Vector Graphic Objects
FmPro Migrator Platinum full Edition cracked download

Custom Value Lists are read from the FileMaker Pro DDR XML file or extracted from the Microsoft Access database file and then are used to populate drop down menus, pop-up menus, checkbox or radio button groups wherever the value list is utilized within the layouts of the database. Within FileMaker databases, Rectangle, rounded rectangle, and oval graphics objects are converted into their equivalent LiveCode vector graphic objects and placed onto the new card in the same location. Embedded images like the drag & drop icon, New, Delete and Find icons are imported as paint objects and placed onto the card. FmPro Migrator attempts to build objects in a specific order to minimize the overlapping of objects. For instance in this screenshot, the yellow rectangle was built first, then the fields and text labels were created to sit over top of the rectangle. This technique is used because there isn't any method available to determine the z-order stacking of the objects created on a FileMaker layout or a Microsoft Access database form. It is likely that some manual changes will generally be necessary to fine tune the z-order stacking of objects on the card.
Layout Objects Group & Geometry Manager
FmPro Migrator Platinum full Edition cracked download

Each object within the newly created LiveCode card is created within group named "Layout_Objects_Group". Resizing this group and setting the Geometry Manager settings enables the objects to be scrolled in the same manner as in the original database application. This feature is also used to implement the Hide/Show Status Area feature. Hiding the Status Area hides the Status Area group and moves the Layout_Objects_Group and its contents left to take its place. The opposite is done when enabling the Status Area.
Customized Card Handlers

FmPro Migrator will typically generate a few hundred lines of customized LiveCode code within each card of the converted stack. These handlers are customized to implement the functionality required to support the unique set of fields and Data Grids built into each card. These handlers include: clearAllPortalContents - Sets the dgData to empty for each Data Grid on the card. This handler runs when all fields and Data Grids are cleared when entering Find Mode. All of the fields are cleared in preparation deleteRecord - Deletes the currently displayed record in Browse mode or Found Set mode. findRecords - Gathers search criteria entered by the user from each of the fields on the card, and formulates a SQL Yoga query to find the records. Displays a dialog with Cancel/Modify Find options if no records were found. getData - Retrieves a list of Primary Key column values for the table associated with the card. If the PK array doesn't need retrieved again, then this process is skipped. This is because the user might have simply switched from one card to another and the data might not need to be retrieved again. Passing a value of 1 in the pRefreshAllFlag parameter forces a retrieval of all of the PK values regardless of whether the array already contains values. newRecord - Creates a new record in the table associated with the card. preOpenCard - Sets the currently displayed card name as the label of the Layouts menu, calls the getData and refreshFields handlers. refreshFields - Gathers the column data for each column of the table associated with the card along with all of the related records from related tables. Fills all of the fields and Data Grids on the current card. updateDBRecord - Updates columns in the table associated with this card and all of its related tables. First, the SQL Yoga data arrays are updated, and then the sqlrecord_update SQL Yoga function is called to update the SQL database table. [There are additional customized handlers built into many of the objects on the card, including radio button groups, checkbox groups and tab panel objects. There is also static LiveCode code written into the stack script.]
Relationship Conversion
FmPro Migrator Platinum full Edition cracked download

Each FileMaker Pro relationship imported by FmPro Migrator is converted into two SQL Yoga relationships. Both forward and reverse relationships are created within the SQL Yoga _CreateRelationships handler, to operate in the same manner as the original relationship. [Note: Though SQL Yoga does not require two sets of relationships to be created in this manner, it streamlines the code generation process for FmPro Migrator to work with both relationships separately. It also improves the readability of the generated LiveCode code within each individual card script.]























FmPro Migrator Platinum full Edition cracked download