Skip to Content (Press Enter)
UserImage.jpg
JAYANT BHRARA
69Views
5Comments
Solved
Runtime error on testing SQL
Question
Mobile
SQL
Database
Application Type
Mobile

Hi All,


I am getting the below error on testing a SQL within Outsystems. Any suggestions why this might be happening please would really help:

0
0
07 Sep 2021
Copy Link
2021-07-07 13-36-32
Hans Dollen
Solution

In addition:  check your SQL as well. 

Select * from {Credential}.*

should be

Select {Credential}.* from {Credential}

regards Hans


See solution in context
1
0
07 Sep 2021
Copy Link
2023-10-25 10-09-21
Luis Filipe Oliveira

Yup, that should be the fix. I just did a quick test and showed a similar error.

Regards,

Luis Oliveira

0
0
07 Sep 2021
Copy Link
UserImage.jpg
JAYANT BHRARA

Replying to Luis Filipe Oliveira's comment on 07 Sep 2021 11:45:20

Hi Luis, Hans

Thanks, that solved, just one more query. I query the database in "Data" view and it returns me the below as the result: 

However, running the SQL for same returns me the below result set, any thoughts why the system is reading the Id value as Email Address and the email value as the Password. 


0
0
07 Sep 2021
Copy Link
2023-10-25 10-09-21
Luis Filipe Oliveira
Solution

Replying to JAYANT BHRARA's comment on 07 Sep 2021 12:16:36

Hi Jayant,

That is happening because your structure only has 2 fields. Since the output returns the first 2 and discards the others, that's why it shows only those.

If you want to output the email and password, you should put 

Select {Credential}.[email],{Credential}.[password]

from {Credential}

0
0
07 Sep 2021
Copy Link
2023-10-25 10-09-21
Luis Filipe Oliveira
Solution

Replying to JAYANT BHRARA's comment on 07 Sep 2021 12:16:36

Hi Jayant,

That is happening because your structure only has 2 fields. Since the output returns the first 2 and discards the others, that's why it shows only those.

If you want to output the email and password, you should put 

Select {Credential}.[email],{Credential}.[password]

from {Credential}

See solution in context
0
0
07 Sep 2021
Copy Link
2021-07-07 13-36-32
Hans Dollen
Solution

In addition:  check your SQL as well. 

Select * from {Credential}.*

should be

Select {Credential}.* from {Credential}

regards Hans


1
0
07 Sep 2021
Copy Link
2023-10-25 10-09-21
Luis Filipe Oliveira

Yup, that should be the fix. I just did a quick test and showed a similar error.

Regards,

Luis Oliveira

0
0
07 Sep 2021
Copy Link
UserImage.jpg
JAYANT BHRARA

Replying to Luis Filipe Oliveira's comment on 07 Sep 2021 11:45:20

Hi Luis, Hans

Thanks, that solved, just one more query. I query the database in "Data" view and it returns me the below as the result: 

However, running the SQL for same returns me the below result set, any thoughts why the system is reading the Id value as Email Address and the email value as the Password. 


0
0
07 Sep 2021
Copy Link
2023-10-25 10-09-21
Luis Filipe Oliveira
Solution

Replying to JAYANT BHRARA's comment on 07 Sep 2021 12:16:36

Hi Jayant,

That is happening because your structure only has 2 fields. Since the output returns the first 2 and discards the others, that's why it shows only those.

If you want to output the email and password, you should put 

Select {Credential}.[email],{Credential}.[password]

from {Credential}

0
0
07 Sep 2021
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.