This page is setup to help Adilas developer's. The original goal was to help gain access to special corp-wide look-ups (dynamic table values) for different corporations.

Use the forms at the top to filter and show the records. The results will show up below the search forms.

If using the quick preset look-ups, both fields are required.

The corp key id is the first three letters of the corporation name, a dash (-), and the corp id number. For example: Say the corporation name was "XYZ Construction, Inc." and the corp id number was 500. The corp key id would be: XYZ-500.

When using the direct SQL look-up mode, use double "quotes" instead of single "quotes" for strings. This is different than normal SQL code.

If using the direct SQL mode and a like filter is needed, use the keyword "uselikecode". An example might be, say we were looking for a color - you would enter: "WHERE color uselikecode" and then the rest of the SQL statement (other where clauses or an order by clause). The application will then substitute the like filter in place of the keyword. The final code would be something like this: WHERE color LIKE "%Blue%" (assuming that the like filter had the word blue in it).

If you are using the update tables section... This tool will make an exact copy of the source table and pull it down to the current server (live server or developer's box). Only limited tables have this access option as this could be a security risk. As a note, most times you will pull the tables from the main "www.adilas.biz site". That is what we are considering the master source or data 0.

« Back . [contact Adilas support - email form]