HFSQL
HFSQL • www.windev.com 15 QUERY EDITOR: SQL OR GRAPHICAL Query creation is done in SQL or in WLan- guage 5GL. The queries can be directly coded, or gen- erated by the query editor (Reports & Queries). This editor comes with WINDEV and WEB- DEV, and can be freely distributed to the end users of the applications you’ve cre- ated. The query editor is used to optimize the database description (schema) by detecting and defining the necessary indexes for the best runtime performance of queries. The query editor displays the query graphi- cally, generates it in natural language, and then it generates the SQL code! This way there’s no risk of error. The query is also generated in schematic form (animated graphic). Creating a query is simple: using the wiz- ard, choose the columns to include, specify the selection conditions, then the query is automatically generated in optimized SQL code. The editor can also perform a reverse- analysis of existing queries. A query can use the result of another query as its source. Only a few clicks are required • to create an SQL query. • check it using natural language, • and view it graphically. Display all LastName, FirstName, BusPhone, Mobile- Phone, eMail, Zip, City, OrderNum, OrderDate, InvoiceNum and InvoiceDate such as LastName is equal to Last- NameParam AND FirstName is equal to First- NameParam AND Zip is equal to ZipParam OR OrderNum is equal to OrderNumParam AND OrderDate is equal to OrderDateParam OR InvoiceNum is equal to InvoiceNumParam AND InvoiceDate is equal to In- voiceDateParam . Everyday language Chart SQL
Made with FlippingBook
RkJQdWJsaXNoZXIy NDQ0OA==