INDEPENDENCESOFT.COM
 
SQL console

 

  The SQL console offers the opportunity to enter SQL statements and send them directly to the database. As seen in the screenshot you are able to get a contextmenu by rightclicking the mouse.

The only special thing about the contextmenu is that you can prepare any SQL statements. Just put them in the file cfg/sqlStatements.sqlFree and they will appear in the contextmenu.

The menu displayed in the top of the window offers the following (from left to right):
  • Send statement to the database. Only one statement is allowed in the input window. sqlFree will automatically change to the resultviewer.
  • Check statement for placeholders. If you have been using placeholders like "$x" or "##choose x##" in your statement instead of real values then you will get a mappingtable. There you can enter the real values which shall be used when sending the SQL statement.
  • Visualize statement in the querybuilder. Please make sure that you have chosen the schema you are working on in the "visual SQL Query builder"-node. 
    sqlFree will automatically change to the SQL builder view.

 

[QUESTIONS?] :::

Contact us, and we will be pleased to help you.


 

 

 

 

 

 

 

 

>>MAIN

>>CONTACT US

:::Buy now:::
IndependenceSoft.com © 2003
:::Home:::