https://community.graphisoft.com/t5/Collaboration-with-other/Zone-category-name/m-p/68726#M6572 Hi Karl<BR /> I'm referring to the internal schema. When I query AC via the sql window, I'm wanting to know all the zone info so I do the basic SELECT * FROM ZONES. Works fine. One of the pieces of info I want is simply what the <I></I><S><I><I></I></I></S>name<E></E> of the category that the particular zone belongs to. It of course gives me the zone cat ID but I thought it would have been of similar logic to include the category name? Can you nest queries?<BR /> <BR /> Ive programmed GDL for 10 years but I'm only newbie to odbc and having a little trouble getting it going with access 2002. When I link to a table via the odbc V10 the table appears completely populated with '#Deleted'. ?? I can see the headings for the table ok<BR /> <BR /> Thanks<BR /> Mark<BR /> <BR /> ACV10.1010 AUS FULL<BR /> XP Pro 2002 SP2<BR /> Xeon 3.2, 3.37g ram<BR /> Access 2002 10.6501.6626 SP3 Tue, 16 Jan 2007 21:46:19 GMT Anonymous 2007-01-16T21:46:19Z https://community.graphisoft.com/t5/Collaboration-with-other/Zone-category-name/m-p/68724#M6570 <DIV class="actalk-migrated-content"><T>Hi All<BR /> Have I missed something. Why is there a ZONES.ZONECATEGORY_ID but yet no ZONES.ZONECATEGORY_NAME in the database schema? Be nice to know what does and doesnt work as far as commands go. I notice COUNT doesnt seem to work (or I'm doing something wrong although its a very basic command)<BR /> Regs<BR /> Mark</T></DIV> Mon, 15 Jan 2007 23:44:12 GMT https://community.graphisoft.com/t5/Collaboration-with-other/Zone-category-name/m-p/68724#M6570 Anonymous 2007-01-15T23:44:12Z https://community.graphisoft.com/t5/Collaboration-with-other/Zone-category-name/m-p/68725#M6571 Which schema? The internal SQL schema (which version 9? 10?) or the ODBC schema? They are not the same.<BR /> <BR /> Internal schema is documented via the Show Data Structure menu command.<BR /> <BR /> ODBC schema can be figured out by linking all tables and studying them.<BR /> <BR /> Not really much documentation in this area.<BR /> <BR /> For the internal database, the names are ZONECATEGORIES.NAME and ZONES.NAME so I assume you're talking about the ODBC schema...<BR /> <BR /> Please give complete info in your questions - version of AC, platform, etc....<BR /> <BR /> Karl Tue, 16 Jan 2007 06:10:37 GMT https://community.graphisoft.com/t5/Collaboration-with-other/Zone-category-name/m-p/68725#M6571 Karl Ottenstein 2007-01-16T06:10:37Z https://community.graphisoft.com/t5/Collaboration-with-other/Zone-category-name/m-p/68726#M6572 Hi Karl<BR /> I'm referring to the internal schema. When I query AC via the sql window, I'm wanting to know all the zone info so I do the basic SELECT * FROM ZONES. Works fine. One of the pieces of info I want is simply what the <I></I><S><I><I></I></I></S>name<E></E> of the category that the particular zone belongs to. It of course gives me the zone cat ID but I thought it would have been of similar logic to include the category name? Can you nest queries?<BR /> <BR /> Ive programmed GDL for 10 years but I'm only newbie to odbc and having a little trouble getting it going with access 2002. When I link to a table via the odbc V10 the table appears completely populated with '#Deleted'. ?? I can see the headings for the table ok<BR /> <BR /> Thanks<BR /> Mark<BR /> <BR /> ACV10.1010 AUS FULL<BR /> XP Pro 2002 SP2<BR /> Xeon 3.2, 3.37g ram<BR /> Access 2002 10.6501.6626 SP3 Tue, 16 Jan 2007 21:46:19 GMT https://community.graphisoft.com/t5/Collaboration-with-other/Zone-category-name/m-p/68726#M6572 Anonymous 2007-01-16T21:46:19Z