This post is neither an advertisement or endorsement of any product other than R:Base nor an offer or request for work. I have been working with an application developed by a colleague that performs advance analysis that I want to incorporate into my own R:Base application for a client which could potentially lead to other clients looking for a similar solution. The application was written in C++ and accesses a MS Access database. Most of the primary tables in that application are based on/copied from tables in my own application so they have the same table structure My solution to date is to SConnect to the MS Access database, SAttach the required tables and synchronize data in both databases, run the analysis and then transfer results to the R:Base database. While this approach works relatively well it is probably far from optimal particularly when we scale up to a much larger data set; I would much rather use only the R:Base database and use the existing C++ code to access data and stored results directly and od away with MS Access database altogether. My questions are: what does it take to make the C++ code access data in the R:Base database? Can I access it directly or do I need to go through Oterro? The potential client has looked at the various options and his IT department has ruled out using Oterro. The options at this point are : 1 - Make the C++ code work with the R:Base database without using Oterro – Preferred 2 - Rewrite the C++ code in R:Base which would require a large amount of effort since a lot of the constructs in C++ are not readily available in R:Base and vice versa - Probably not practical 3 - Move the entire application to a different database that is accessible directly from R:Base and from C++ code and use R:Base as a front end for menus, forms and report – I understand others have done this but I have not done it myself so I am not sure on what is involved and how well it works. 4. Pass on the project and retire once and for all…perhaps the best option? Having used it for over 35 years, I would prefer to stay within the R:Base environment because I am most familiar with it. Before R:Base I spent 6 years writing C code to access databases in the Unix environment, so, while my C programming skills are dated, I can probably come up to speed fairly quickly. Any information or insights you can offer will be greatly appreciated. Javier, Javier Valencia, PE 14315 S. Twilight Ln. Olathe, KS 66062 Office: 913-829-0888 Cell: 913-915-3137
-- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAO1ueGVb5zRMiwo7hebUe7jCgAAAEAAAANC%2BXE0XbnNDs3nK1j%2BV8ZoBAAAAAA%3D%3D%40vtgonline.com.