by msedita » Thu May 06, 2010 3:17 pm
Thanks Rob. What I am working with here is a database that was converted from an older non-Servoy application. The structure is not exactly the same as the database the solution was developed with. The tables and column names are the same, but in some cases the column data type or length are different. So the dbis don't match the database. This is going to happen to us a lot as our customers migrate from our old application, where they were allowed to change these attributes.
This may be the cause of the problem. However, after changing a few things in the data structure and a few things in our solution, it seems to be OK. I'm sure though, that I'm going to run into this again. Any advise on developing in this environment, where I don't want to have to create a custom solution for each customer, where the only difference is data types and lengths?
Michael Sedita
MS Health Software Corp.
Developers of software solutions for behavioral healthcare and social service providers.
www.mshealth.com