PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • How to proceed?
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Overview
The content of an analysis can be exported in the format of SQL scripts for a specified database (SQL Server, Oracle, ...). This script generates the integrity constraints, the indexes, ...
This script can be modified and run to create tables on a server.
How to proceed?
To generate the SQL script corresponding to an analysis (or to a file):
  1. Select "Structure of files .. Generate the SQL script". The wizard starts.On the "Analysis" pane, in the "Analysis" group, expand "Generation" and select "Generate the SQL script". The wizard starts.
  2. Select the tables/files for which the SQL script must be generated.
  3. Select the type of database for which the SQL script must be generated. All the available databases are listed.
  4. Specify the options for generating the SQL code:
    • Generate DROP TABLE (code for deleting the existing tables).
    • Generate the indexes.
    • Generate the integrity constraints.
  5. The generated script is displayed. This script can be saved in a specific file in order to be modified, then run.
Minimum required version
  • Version 11
This page is also available for…
Comments
Solution Error From Dual
SQLcodigo is string = "SELECT GET_BUSCA('@ID@','@VALORDIADASEMANA@','@HoraInicial@','@MinutoInicial@','@HoraFinal@') AS RESULTADO FROM T010_Vendors" // use one table in place of DUAL ***

ds_query1 is Data Source

IF HExecuteSQLQuery(ds_query1,CONN_ORACLE,hQueryDefault,SQLcodigo) = True THEN // Use connection in code***

FOR EACH ds_query1
RESULTADO = ds_query1.RESULTADO
BREAK//***
END

ELSE

RESULTADO = False

END
BOLLER
May 03 2019
SQL Oracle With Shema
SQLcodigo is string = [
SELECT
CASE
WHEN Price > 0 THEN 'Value'
WHEN Price = 0 THEN 'Not Value'
ELSE
'N'
end as STATUS
FROM
SHEMA_ALMOXARIFE.TableCustomer
]
BOLLER
May 03 2019