Error: No records SQL2GMS

[Javier]

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

[Edson Cordeiro do Valle]

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:

[dave shermo]

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