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.
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.
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?
Grid components execute two queries when opened--the main SELECT statement that the developer enters and a secondary SELECT Count(*) statement for displaying the number of records, dealing with record pagination, navigation, etc. 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 »
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.
When adding a bunch of lookup tables at same level in the tree, it would be nice if the parent table did not have to be reselected before clicking "Add Table" again. Alter current "Add Table" button text to "Add Table >" and set its bubble help to "Join a Table to currently selected table." The ">" gives visual indication the added table would be indented in the tree from the current table. Add a new button title "Add ...more »
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.