<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div apple-content-edited="true"><div><p style="margin: 0.0px 0.0px 0.0px 0.0px">I'm trying to get a bit of information about a database with the following code:</p><p style="margin: 0.0px 0.0px 0.0px 0.0px"><br></p><p style="margin: 0.0px 0.0px 0.0px 0.0px"><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "> dim DatabaseInfo as String</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "> for currentTable as Integer = 0 to theDatabase.TableCount</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "> DatabaseInfo = DatabaseInfo + EndOfLine + "Table: " + theDatabase.Table(currentTable).Name + " " + str(theDatabase.Table(currentTable).RecordCount)</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "> next</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">But this also returns the system tables. In 2007 Ruslan wrote:</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "></div><blockquote type="cite"><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Date: Mon, 05 Nov 2007 15:59:47 +0200<br>From: Ruslan Zasukhin <<a href="mailto:sunshine@public.kherson.ua">sunshine@public.kherson.ua</a>><br>Subject: Re: Tableschema<br>To: "<a href="mailto:valentina@lists.macserve.net">valentina@lists.macserve.net</a>" <<a href="mailto:valentina@lists.macserve.net">valentina@lists.macserve.net</a>><br>Message-ID: <<a href="mailto:C354EE73.82B17%sunshine@public.kherson.ua">C354EE73.82B17%sunshine@public.kherson.ua</a>><br>Content-Type: text/plain;<span class="Apple-tab-span" style="white-space: pre; "> </span>charset="US-ASCII"<br><br>On 5/11/07 3:02 PM, "Mr. Bart Pietercil" <<a href="mailto:bart.pietercil@gmail.com">bart.pietercil@gmail.com</a>> wrote:<br><br><blockquote type="cite">Problem is that this code also seems to find sys tables (it found<br></blockquote><blockquote type="cite">sysItems).<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">So what is the way to read the schema of a DB (prefer classway) from<br></blockquote><blockquote type="cite">within RB ?<br></blockquote><br>1) API way<br><br> count = db.TableCount<br> loop <br> tbl = db.Table(i)<br><br>Yes we return sys tables also, you need add own filter to check flag of<br>Vtable.IsSytem.</div></blockquote><p style="margin: 0.0px 0.0px 0.0px 0.0px"><br></p>However, I can't find anything about this flag. Is the feature missing from V4RB?<br><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><br></div></p></div></div><div apple-content-edited="true"> <div><p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="3" style="font: 12.0px Helvetica">Mit freundlichen Grüßen/Regards</font></p> <p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; min-height: 14.0px"><br></p> <p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="3" style="font: 12.0px Helvetica">Trixi Willius</font></p> <p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; min-height: 14.0px"><br></p> <p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="3" style="font: 12.0px Helvetica"><a href="http://www.mothsoftware.com">http://www.mothsoftware.com</a></font></p> <p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="3" style="font: 12.0px Helvetica">Mail Archiver X: archive, clean and search email</font></p> <p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="3" style="font: 12.0px Helvetica"><a href="http://www.beatrixwillius.de">http://www.beatrixwillius.de</a></font></p> <p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="3" style="font: 12.0px Helvetica">Fractals, 3d landscapes etc.</font></p> </div> </div><br></body></html>