Once you've set up your connection to MySQL (see JP van de Giessen's post), you can map a Database Record to a table as follows:Name the database record using the table name in the database (note that mapping is case insensitive and replaces spaces and other non-alphanumeric characters with underscores, so that the Tersus database record element Stock Item will map to the database table STOCK_ITEM), or alternatively call it whatever you like in Tersus and override the name mapping by setting tableName shared property to the name in the database. Columns map in the same manner, except that overriding is achieved by adding a columnName local property to each field and setting it.
Mapping auto-generated fields is tricky (to be more precise the tricky part is inserting data to it, as opposed to find, update & delete which should work seamlessly).Try one of the following options (success is dependent on the specific database used):
Note that both options are problematic, in that Insert will not return the auto-generated Id. You may be able to overcome by writing a stored procedure which inserts the data and returns the Id.
To use the full functionality of this web site, JavaScript needs to be turned on.
For best results, use the Firefox browser..
Copyright © 2003-2017 - Tersus Software Ltd., All rights reserved. Terms of Use License Graphic design by EmaraDesign