codemorphis.com Forum Index codemorphis.com
Software development: pure and simple.
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

database programming

 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    codemorphis.com Forum Index -> Visual Programming Forum
View previous topic :: View next topic  
Author Message
CodeMorphis



Joined: 02 Dec 2003
Posts: 252

PostPosted: Wed Apr 06, 2005 8:32 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
CodeMorphis



Joined: 02 Dec 2003
Posts: 252

PostPosted: Mon Apr 11, 2005 8:58 am    Post subject: Reply with quote

You are very welcome. Please always feel free to post your questions.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    codemorphis.com Forum Index -> Visual Programming Forum All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group