A quick fix for a potential issue the boys at Agility discovered.

The default SQL metadata query can sometimes not pick up a primary key if  it has other constraints against the column. If you are familiar with the default query it just gets a top 1 on the constraints linked to the column, so if there are multiple constraints you aren’t necessarily going to pick up the “PRIMARY KEY” constraint all the time.

For now I’ve limited the constraints to being “IN (‘PRIMARY KEY’, ‘FOREIGN KEY’)”. The compatibility checker will modify the particular query for you when you load an older version.

The issue with multiple constraints has got me thinking, what about if you want to get just indexes? <<!for idxcolumn col in tablevar!>>

Another little nugget to implement in there.

Anyway, there were a couple of other little issues:

• The “adduseonly” and “addignore” functions weren’t behaving correctly.
• It would have been nice to indicate “project/folder/paths” for packages within any project folders. So this was put in there. Nice.

What’s for Beta 0.11? Well hopefully:

1. CodeDOM implementation. Call .NET code from within a template.
2. Execute a SQL script against a source.
3. It would be really frikken handy to enable repositioning of tabs (grab and slide).
4. Variables and probably templates declared against a symbol table.
5. Another nice feature <<!for table tbl in table!>>. Meaning loop through tables linked to a parent table by foreign key.
6. More code completion tweaks and enhancements.

After this we should be good to go for version 1.0. Promise!

 

Comments are closed.