[progress Communities] [progress Openedge Abl] Forum Post: Re: Dataserver Noob Questions

  • Thread starter Thread starter smat-consulting
  • Start date Start date
Status
Not open for further replies.
S

smat-consulting

Guest
As Valeriy said, the schema-holder is a basically "empty" DB that holds only the schema, so 4GL can be compiled. The actual data, however, comes from the foreign DB. If you want to look at the schema (like _File and _Field records, for example to build dynamic queries for any table) you need to look at the schema-holder. Be aware, though, that one schema-holder can hold the schema of multiple foreign DBs, not just one. So you need to look at the _DB record first to select then you want, then look at the related _File records... As much as I remember you can also store connection parameters in the schema-holder, so progress can connect to the foreign DB automatically for you when you run a program accessing it and it is not yet connected...

Continue reading...
 
Status
Not open for further replies.
Back
Top