Differences

This shows you the differences between two versions of the page.

--- how_to:writesqlqueries [2010/01/04 17:12]
132.168.74.230 créée
+++ how_to:writesqlqueries [2010/01/04 17:36]
132.168.74.230
@@ Line 1: / Line 1: @@
 ====== How to write SQL Queries to explore database ======
-Once the connection is successful, the first simple feature is to explore the database or create SQL queries. Information on MSI database and its model is available [[http://biodev.extra.cea.fr/docs/irma/doku.php?id=msidb| here ]].
+Once you are opened an [[how to:opensession|MSI session]], you can explore the database by creating SQL queries. Information on MSI database and its model is available [[http://biodev.extra.cea.fr/docs/irma/doku.php?id=msidb| here ]].
-You can create new SQL files from hEIDI project (''File > New File'' menu then choose ''Empty File'' or directly ''New Empty File'' from hEIDI Project window) . It is also possible to select a Table under database connection and choose ''Veiw Data''.
+To create a new SQL file from an hEIDI project, select the ''File > New File'' menu, then choose ''SQL File'' under the ''Other'' Category.\\
+It is also possible to view data from a table like this:\\
+  * In the ''Services'' Window, select a database connection
+  * Expand the schema node of your choice, then the ''TABLES'' node
+  * Select a table, right-click and choose ''View data'' to display table values
 {{:sql_comment.png|}}
-** SQL queries sample **
+===== SQL queries sample =====
+FIXME Add an example here FIXME

hEIDI

User Tools

Site Tools

Differences

Page Tools