Understood - the first version of Insider that supported DDL's created all numeric values at reals! Agreed - the syntax was very particular though, once you got the hand of the DDL structure, it worked very nicely.
Back in the mid-90's I actually sold a program that allowed you to create and reuse "structure definitions". DADS would log into an application using 4D Open an extract the metatadate into a structure definition. You would then use the structure definition editor which consisted of two sets of AreaList columns, the left column for tables, the right column for fields so when you clicked on table 1 in in Column A, the fields for Table 1 would display in Column B. The reason for two sets of columns was that you could create a new structure definition by dragging from the left to the right to create new tables and fields. I sold just over 50 copies and actually licensed the source code to Doug Blew, if that name rings a bell. John Foster has taken the idea to a much higher level, incorporating 4D Draw to represent schemas and to allow you to do rebuild a db by changing source code. "Ideally, I would like to have A4D create the DDL and then push it into the database. That way I could create a 'standard' DDL and use it to seed a fusebox framework or even build the database from config files like YAML. Now that would be sweet." So you want to create the DDL offline and then have 4D build the tables? I did YAML in 5 minutes - I see where they're coming from. It would not be that difficult to convert SQL to YAML. Are saying that you'd create the schema using SQL and YAML to build the fusebox? On Fri, Jun 13, 2008 at 6:53 AM, Michael Check <[EMAIL PROTECTED]> wrote: > Douglas > > Yes, I had forgotten that. However, I remember trying to import the > SQL DDLs and found them to be non-standard commands. I tried to find > a way to create the DDLs but Insider was VERY finicky and not easy to > play with. My patience ran out quickly. > > And I need a programmatic way to create them. I remember the product > DataSomethingOrOther Gold that did something like that, but it was too > cumbersome for managing a changing structure. > > Ideally, I would like to have A4D create the DDL and then push it into > the database. That way I could create a 'standard' DDL and use it to > seed a fusebox framework or even build the database from config files > like YAML. Now that would be sweet. > > Thanks, > > Michael Check > > On Thu, Jun 12, 2008 at 5:45 PM, Douglas von Roeder > <[EMAIL PROTECTED]> wrote: > > You've been able to create 4D db's using SQL DDL's for about a decade now > - > > since version 6 was released. > _______________________________________________ > Active4D-dev mailing list > [email protected] > http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev > Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/ > -- Douglas von Roeder Voice Phone 714.793.8496 _______________________________________________ Active4D-dev mailing list [email protected] http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/
