example paste from this site:
- Code: Select all
You may have tried to use a view in Dataface by simply
treating the view as if it was a table. You probably
would have found that it doesn't quite work. Perhaps
you only see the first row of the view in the list
tab - or perhaps it didn't work at all. This is because
Dataface depends heavily on primary keys to be able to
identify records of a table uniquely, and MySQL doesn't
provide information about which columns of a view are
part of the primary key.