topic Re: sql query in Collaboration with other software

sql query

Achille Pavlidis — Mon, 21 May 2012 09:42:54 GMT

I have a pln with a lot of hotlinked modules. Is there a way to have an sql query to show the number of stories for each hotlinked pln???

Please help!

Re: sql query

Karl Ottenstein — Mon, 21 May 2012 17:46:21 GMT

Not that I know of. The only data available for SQL query within AC (via Calculate menu) is listed via the command "Show data structure..." This lists all tables and fields that can be retrieved. There is no information on hotlinks. The only story data is for the current project itself.

Karl

Re: sql query

Achille Pavlidis — Tue, 22 May 2012 06:35:13 GMT

Thanks Karl.

*sigh*

Re: sql query

Karl Ottenstein — Tue, 22 May 2012 17:44:32 GMT

Achille wrote:
Thanks Karl.

*sigh*

You're welcome. Maybe someone from GS will reply .. it is possible that they did not document all tables...? But, I'm also not sure that anything about the SQL feature has been changed or improved since it was first introduced...

Re: sql query

Achille Pavlidis — Tue, 22 May 2012 19:18:58 GMT

Thanks Karl.

Where can I find an online guide to sql language?

Re: sql query

Karl Ottenstein — Tue, 22 May 2012 20:37:52 GMT

Almost any SQL guide on the web that you find will be close, although GS uses the FLAT keyword that I had not seen elsewhere.

An easy way to get some correct SQL syntax is if you already happen to have a copy of Microsoft Access. You can create a visual query there and then switch to SQL mode to see the corresponding SQL code.

AC comes with a PDF called "04 ... Calculation Guide.pdf" in the Documentation folder which has info on SQL beginning on page 52. There, it mentions that the Graphisoft ODBC documentation (on GS web site) gives the details for Graphisoft's version of SQL. We used to be able to just download this. Now they have some kind of application process:
http://www.graphisoft.com/support/developer/downloads/index.html

Karl