This SQL is running in SQL Builder BUT

Scriptcase 8 Discussion
#1

This SQL is running in SQL Builder BUT in Grid SQL is not working.
Where is my fault?

SELECT
t.Tarih,
t.IsinAdi,
t.IsinSorumlusu,
t.Tipi,
t.Kesif,
t.Il,
t.Ilce,
t.Talep,
t.Havale,
t.SonDurum,
t.Bolge,
t.Login
FROM
muhendisler m INNER JOIN tumisler t ON m.Bolgesi = t.Bolge AND m.Login = t.Login

Thanks

#2

Best option is to turn on debug and it will show the sql being ran look at the error for more information.

Kev

#3

I actually tried to do something:
but the company has employees in different cities. and the managers in each city could see the data of their employees. Besides its corporate headquarters Allow access to data for all cities.

#4

Hello, this is pretty normal warning.
Everytime that you edit a sql statement ScriptCcase regenerates the fields according to the selected columns of the new query, so your SQL statement has not error, but need to edit the grid’s fields to be displayed again. Go to “Edit fields” and drag the the fields from “Fields not shown” to “Page 1”.

#5

Try with


SELECT
t.Tarih as Tarih,
t.IsinAdi as IsinAdi,
...
#6

Scriptcase has it’s own sql parser which is needed for the code generation. If sql get’s too complex for the parser you might run into issues like these. I think that GIU’s suggestion will work, if not you can apply a view to your database. That is treated as a simple table and will do the job.

#7

But the error displayed in image has not relation with SQL query, in fact, the query was parsed correctly, this happen to me every time I update a SQL query for new columns. Just trebuild the grid columns dragging and dropping fields from “non showed” to “page 1”.

#8

thanks for helping…
I did that say manfred and success :slight_smile: