Hi All...

I wonder if anyone else is using, looking at this tool. It is a free, upsupported tool developed by a MS developer in France. They put out a new build every 4-6 weeks, last one posted was Dec 6th. Here is the link:

http://www.microsoft.fr/olymars/webupdate.xml

I started playing with it last week, and I gotta admit it is pretty cool. Even if you only use it to generate your SP's. One thing about the SP's that type are generated is that in addition to retrieving data using a PK, you can also do it using a FK. It also generates data access classes, BO classes and UI classes specific to each data table. For example, it creates a Category combo which is automatically coded to use the appropirate data classes and SP's.

Another cool thing is that is creates functions so that you can add a 'display' field to the table. This field can be used in lists and combos rather than showing the FK. The functions are not overwritten if you have to generate a new SP due to a schema change.

One thing that is cool is that is uses SQL Server's extended attributes to store metadata similar to SDT in VFP. He adds attributes to the fields like Form Caption etc.

Certainly some cool concepts in here. You can get a basic ap up and running quickly as a prototype to sell the full project to your client.

If anyone is using it that would be great. I am going through the tutorial and had a few problems I was hoping someone might have figured out.

Thanks,
BOb