|
| Is webdev able to run PL/SQL ? |
| Iniciado por guest, 06,oct. 2015 16:15 - 1 respuesta |
| |
| | | |
|
| |
| Publicado el 06,octubre 2015 - 16:15 |
Hi,
Can webdev execute PL/SQL ?
Regards,
Peter Zhou |
| |
| |
| | | |
|
| | |
| |
| Publicado el 07,octubre 2015 - 12:21 |
Peter
In general yes as SQL is a common standard but you have to bear in mind that the PL is Oracles own extension to the standard as is the T when using MSSQL - each have there own variations.
The main area to be aware is when describing a calculated item in the generator.
Do not use the WL functions - these will always fail.
Use the correct SQL statement from the displayed list - check the database docs to make sure they are supported or that the statement you require is in the list.
WD has historically always allowed its own variations.
By example to concatenate 2 fields in HFSQL then Field1+' '+Field2 is good.
For MySQL and others this needs to be CONCAT(Field1,' ',Field2) - WD of course accepts either syntax for HFSQL.
For more complex queries consider writing them manually and using HExecuteSQLQuery() |
| |
| |
| | | |
|
| | | | |
| | |
|