It is now 1.4.0.0. Thanks!

great - please keep me updated of any issues and/or suggestions as i'm now into the final few days of bedding in with this version, prior to a proper release at some point next week.

thanks again.

jimi

http://www.originaltalent.com

Well, I've run it successfully several times, just to test it out. I even added new tables to the default beer house database, and it worked like a charm.

One thing I noticed, and it could probably just go in the documentation: If you forget to make a key on a table (I had a lookup table, with two columns, ItemID and ItemDescription, and assigned it to the "Store" Provider) the tool will throw object errors when processing the "DAL_AbstractClass.cs.tpl" file each time it tries to generate one of the provider classes - even if the aforementioned table has nothing to do with the provider. This then results in the code not compiling.

Once I went back into my database and created an Identity Key on ItemID for the lookup table, then everything ran perfectly fine.

Other than that, nothing else has jumped out at me in any way :)

CF - good, glad that's worked out fine. I'll take a look at that issue re the non-indexed table and see what's happening. it 'should' be coded (the template) in such a way as to handle any such eventuality. anyway, as you say, it's more of a warning that requires action, rather than a showstopper but i'll see if i can effect a fix this week on that.

do continue to try and both exhaust and break it tho' (plenty of foreign keys and complex logic should do the trick insofar as putting it to task :)) as i'm aiming for 100% integrity on this final leg - thus as much difficult stuff thrown at it as possible is in order.

thanks again

jimi

http://www.originaltalent.com

CF - I've now updated the DLL and tweaked a few of the templates in order to report the missing primary key error inside the application, rather than as an obscure messagebox message. you can pick the latest version (DLL Version 1.5.0.0) from here:

http://www.originaltalent.com/downloads/FlixonV3.03.zip

thanks again for your support and encouragement.

jimi

http://www.originaltalent.com

once more (once more :))...

been over it all with a hoover now (as well as mr muscle), so it's as clean as an ermmm - pin. (cough) - anyway, in keeping with the promise to keep this simple and effective, i've spent a few weeks focussing on each section of the site builder and have arrived at a (almost) perfect implementation of this that is 100% fit for purpose. As before, just download from the link below and have a play.

http://www.originaltalent.com/downloads/FlixonV3.05.zip

I can only presume that the last version was so good that no-one wanted to comment (after an intial barrage of praise/critique on the 1st 2 versions, all went quiet on v3.03) :). I'd love to hear of any suggestion/criticisms on the above version as this project is aimed at 'us', and my view is that it should be taken over by the community following this version, so any thoughts at this stage would be most welcome.

All the best once more...

jimi

http://www.originaltalent.com

I have just started using your tool V306 and it is very usefull. One comment I make is when using your admin app to add/update table rows. As an example i used the tool to generate your website for TBH Articles provider (Articles,Categories, Comments tables).

While editing/inserting the Articles or Comments table the Key field (CategoryID or ArticleID) do not show the actual key field (INTEGER) but rather the TITLE field.

Since we could have identical titles, it is not obvious which category or article we are pointing to.

Is this by design or am I doing something wrong ?

Thanks

Joe

Hi Joe,

This is by design (to not 'show' the uneditable primary key), however, you could either edit the template \Flixon\Site Generator\Templates\Table\Admin_Default.aspx.tpl to 'show' this field as readonly or alternatively, edit the resulting Default.aspx and add a new

<asp:TemplateField HeaderText="CategoryID">
<ItemTemplate>
<%#Eval("CategoryID")%>
</ItemTemplate>
</asp:TemplateField>

section.

I'd suggest opening the \Flixon\Site Generator\Templates\Table\Admin_Default.aspx.tpl and having a play around with that to see if you can get it to add this functionality automatically each time you generate content. As i've said before, the actual CRUD forms were added as a little bit of sugar to test the resulting underlaying BLL/DAL but it would seem from some comments both here and on other forums that folks would like to extend and enhance the visual interface templates. this is all good stuff and i'd encourage you to have a bash at it and let me know how you get on.

cheers for now

__________________
jimi

http://www.originaltalent.com

Jimmi, thanks for your quick reply. I will soon have some time to try what you suggest and will give you feeback.
Thanks again, joe

Just a quick one to say merry xmas and seasons greetings to all!!

As a special xmas extra, i've updated the Site uilder for one last time, you can check out the changes etc here:

http://www.originaltalent.com/downloads/FlixonV3.06.zip

enjoy...

__________________
jimi

http://www.originaltalent.com