On 3/14/06, marcelo schiavone <[EMAIL PROTECTED]> wrote: > Hi, does someone know the way of doing that "MiddleKit" works with a > remote (existing) database, using MSSQL? > > The database already exists and the idea is to realize an application > in Webware in another PC that accedes to the above mentioned database > using MiddleKit.
Hi Marcelo, I'm the main author of MiddleKit. When I wrote it, I did not need to deal with existing databases so I designed it from the perspective of working on new projects and having MiddleKit generate the tables in the fashion that suited it. Later on I did need to deal with existing tables and consequently I can share the following tips: - You can dictate the SQL type of an attribute by setting it's SQLType in the model. You would only need this if no MK type matched the MS SQL types. For example, I have an MS SQL Server project where there are a few SQLType='image' in the MK model. You can put that in the Extras column, or have a column called SQLType. - If you don't want MK to generate SQL for a particular table, you can mark it as isAbstract (usually in the Extras column). But since MK isn't often used for existing databases, I don't know how easy or hard it will be for you. I haven't thought much about obj refs and lists for existing databases. At the very least, you'd have to override those properties/methods in your class. I think SQLObject may be more suited to existing dbs, so if MK doesn't work for you, that's another option to consider. -Chuck ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642 _______________________________________________ Webware-discuss mailing list Webware-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/webware-discuss
