Error: No records SQL2GMS

GAMS
1

Hi all

By using the program SQL2GMS me is reporting an error to find an empty
query, the query is fine as the table on which the query is empty. For
the real case operating model, the information system may have no
information table for example, may be that the table that indicates if
there are shipments of goods is empty because you might not have
planned to ship goods between distribution centers

What I would like you to please show me how you can solve this
problem.

This is what the program reports SQL2GMS:


Query: SELECT [ESC__HPL$].COD__PER,COD_TIV,COD_COR,CTTP FROM [TIDESCO
],[ESC__HPL] WHERE [ESC__HPL$].FECHA=[TIDESCO$].FECHA AND COD_TIV IN
(SELECT COD_TIV FROM [ESC_TIV$]) AND COD_COR IN (SELECT COD_COR FROM
[ESC_COR$])
Error: No records


I thank you in advance for the cooperation that can provide me

JN

\

2

Javier
As far as I know this is not a Sql2gms problem, it’s from the odbc/database. Every time the search engines from a database (such as sql, oracle, etc) don’t find anything that matches your query, it returns an error. Maybe you can initialize the specifc field in the table with a default value to get the at least a valid line, then, inside gams, you can ignore it.
Regards
Edsoncv


Javier escreveu:

Hi all

By using the program SQL2GMS me is reporting an error to find an empty
query, the query is fine as the table on which the query is empty. For
the real case operating model, the information system may have no
information table for example, may be that the table that indicates if
there are shipments of goods is empty because you might not have
planned to ship goods between distribution centers

What I would like you to please show me how you can solve this
problem.

This is what the program reports SQL2GMS:

Query: SELECT [ESC__HPL$].COD__PER,COD_TIV,COD_COR,CTTP FROM [TIDESCO
],[ESC__HPL] WHERE [ESC__HPL$].FECHA=[TIDESCO$].FECHA AND COD_TIV IN
(SELECT COD_TIV FROM [ESC_TIV$]) AND COD_COR IN (SELECT COD_COR FROM
[ESC_COR$])
Error: No records

I thank you in advance for the cooperation that can provide me

JN

–
To post to this group, send email to gamsworld@googlegroups.com.
To unsubscribe from this group, send email to gamsworld+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/gamsworld?hl=en.

\

3

Change AllowEmpty=0 to AllowEmpty=1 in sql2gms.ini

–
To view this discussion on the web visit https://groups.google.com/d/msg/gamsworld/-/Bo-UHbM13usJ.
To post to this group, send email to gamsworld@googlegroups.com.
To unsubscribe from this group, send email to gamsworld+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/gamsworld?hl=en.