I try in cloud .. in the stack dot net the following SQL, mysql:
SyntaxEditor Code Snippet
SELECT 1990 + level from dual connect by level < 10
Unfortunately there is error: Incorrect syntax near keyword by. The widget i use is SQL.
thank you.
Can you do it using a cycle and ListAppend? Something like this:
Hi Indra
Can you explain me a bit better what is the database you are trying to connect with? That syntax only works with Oracle and not MySQL.
In Oracle I can't seem to replicate the problem. Can you post here a printscreen of your SQL window and/or the error stack from ServiceCenter?
João Amorim wrote:
thank you. The database is in the cloud... outsystems, but the stack is dot net.. i do not know exactly what the database is. The error is:
It does look like the database is not Oracle, and if that's the case your query won't work.
Can you try running the following query to see if it works?
SELECT * FROM PRODUCT_COMPONENT_VERSION
If it doesn't work it means that the DBMS is not Oracle.
Can I ask why you are generating the years using a query?
tq.
Because i want to create a list that contains the years of vehicles to sell. So, i need a query to populate a list. I can us an extended properties of HTML 5, but it it not pop up...like slider...