Hello everyone, I am relatively new to the cache world and been working with Cache 4 for a short time, programming various software applications with it and I had a few questions that possibly you guys can help me with.
1) Does cache allow you to expore multiple tables at once to a flat file? I know you can export one at a time, but was wondering if I could do many at the same time and save me some trouble. I know other databases can do this for backup purposes. 2) Is there a way to query cache for listing tables and their attributes? Like show a tables attributes, the fields it has, their datatypes, primary and foreign keys etc through SQL? I am looking to possibly build recordsets which contain table list names and cycle through fields in a table. 3) Does cache support DCL style SQL commands like Show Tables? I know it can do things like altering tables, users, and grant/revoke privileges but I was wondering what others it supports. Thanks for your help.
