Hi All,
I only write new code occasionally these days (for hobby use) so am getting rather rusty on somethings and have never used others within A5, my main problem is the initial design of an application (trial and error and lots of cups of coffee eventually gets me there).
I have a "virtual radar" application that allows me to identify aircraft that fly around my home.
What I want to do is write an application that would allow me to share data between the three, but am unsure as how to go about it.
I need to be able:
question is can this all be done from within A5V11?
if so ,what methods should I be using to achieve this (activeX, OLE , ODBC ?)
if not, what should I use?
finally, is it possible to show the small on-screen form AND have the workspace window minimised (so I can display "virtual Radar" screen and A5 form together) ?
thanks for your time
I only write new code occasionally these days (for hobby use) so am getting rather rusty on somethings and have never used others within A5, my main problem is the initial design of an application (trial and error and lots of cups of coffee eventually gets me there).
I have a "virtual radar" application that allows me to identify aircraft that fly around my home.
- This app has very basic OLE/COM methods to allow me access to data within it.
- there is an SQLite database that contains all the added details (maintained by myself).
- I also have an Alpha5 Application that I maintain all my aircraft hobby information (like aircraft type, when seen, where seen, operator etc etc)
What I want to do is write an application that would allow me to share data between the three, but am unsure as how to go about it.
I need to be able:
- show a small on-screen form that contains data from my virtual radar app plus variables for current date and current location.
- query each record against the SQL to see if it is present, if not write to 1st report
- query the same record against an A5 table (within the app in 3 above) to see if it is present, if not write to 2nd report
- at the same time query against a field called "as" in the A5 table and if it is blank then display record in the small on-screen form.
- if I select a record in the form from above (double-click maybe?) I want to update two fields in the A5 table and SQLite database with current date current location.
question is can this all be done from within A5V11?
if so ,what methods should I be using to achieve this (activeX, OLE , ODBC ?)
if not, what should I use?
finally, is it possible to show the small on-screen form AND have the workspace window minimised (so I can display "virtual Radar" screen and A5 form together) ?
thanks for your time
Comment