If you base a grid on an SQL view, then make any change to the view and click the refresh button, the primary key setting is removed. Makes sense because views don't have primary keys, but if I've set one, then don't remove it. Changes are usually not to the primary key field.
Make an sql server from alpha or a way to wite a desktop only app with sql and be able to easily package it to install on another computer.
Does away with dbf in most cases?
Many users now use SQL with a single connection string. So, on the Web Project Profiles property sheet, add a General option to default to AlphaDAO and that connection string. Now, property sheets for dropdowns and edit combos default to DBF. They should default to AlphaDAO and the named connection string.
The Count(*) query is usually out of sight, out of mind, but checking my MySQL slow query log, I often find lots of these "SELECT Count(*) FROM..." queries.
These queries are created by Alpha... more »
It is very good and useful, enabling the creation of a desk top form based on SQL data source, as it is now possible in the creation of the reports. Reports can be created based on DBF table as well as on data source (SQL data source). This would avoid a lot of problems (mostly with speed and fetch limit) that we now have with link tables.
a method to create sql databases for deployment on desktop and web that does not depend on third party software. This is done with most software creation software.
This is NOT to replace the great dbf creator.
However there doesn't seem to be any way to embed JS components onto reports. I have tried via a static HTML element, but no luck which means all charts have to be recreated (as... more »