CodeMorphis
Joined: 02 Dec 2003 Posts: 252
|
Posted: Wed Apr 06, 2005 8:32 am Post subject: |
|
|
Richard,
Thanks for your interest in Synopsis and for your questions.
Please always feel free to ask whatever questions you may have.
1) How do you handle form/subform type forms or is this not possible?
The database access provided allows for control via SQL commands. You can easily combine SQL commands that gather query data and then use Synopsis interface components to present results in your own forms and "subforms" as you like. Since Access forms and subforms tie together data queries and user interface components, it isn't practical to try to reuse them in your Synopsis program. Instead, Synopsis gives you the tools to achieve the form/subform relationships easily via the DataGrid UI component, see the "SuperStore datagrid.vpd" sample program - the example shows how you simply assign a query to the UI component and then place it in your form - the same idea as forms/subforms.
2) How do you handle forms based on more than one table? Can you get direct access to queries built in Access?
This is handled with the built-in SQL connection. You can make arbitrary queries on any number of tables, collect query results and treat the data as desired. For this reason access to queries built in Access is not necessary, since you have the means of creating and executing, from within Synopsis, any required query. Reports stored in Access can be accessed directly from Synopsis. Since the access technology is similiar for reports and queries, should this become a necessity, such a service should likely be easily implementable.
3) When you build the final program what language will it be written in? and do you get to see source code? (I only have the demo at present).
Synopsis is not a language but rather a tool that acts like a glue to bring together various technologies under one simple and easy to use IDE. Some of the components in the Synopsis component libraries are VB, others C++ or assembler, etc. Synopsis can also access external arbitrary DLL functions, of unknown compiler origin. Thus, there is no source code that is generated on build of the final program since the source code can be heterogeneous. An executable in the form of an .EXE with accompanying required DLLs is produced. You can see some example final programs generated in the "Sample Programs\Executables" directory of the Synopsis installation. These executables have the same base names as the source VPDs in the "Sample Programs" directory so you can see the source as well as the results.
Hope that this helps. |
|