L
leomfd_tec
Guest
Good night,
I have one DataTeble that execute this slq query in my access database in c#:
DataTable dtCdDvd = cls.Fun_RetornaDataTable("SELECT tblCdDvd.Cod, tblCdDvd.Nome, tblCdDvd.Tamanho, tblTipo.Tipo, tblCdDvd.Grupo FROM [tblCdDvd] INNER JOIN [tblTipo] ON tblCdDvd.Tipo=tblTipo.Cod WHERE Status = TRUE");
if i use DataRow[] result = dtCdDvd.Select("[Grupo]=0"); the result is 0 rows and exist registry with informed code.
The more interesting is if my sql query runs "SELECT Grupo FROM tblGrupo" without join table my result is different of 0.
Continue reading...
I have one DataTeble that execute this slq query in my access database in c#:
DataTable dtCdDvd = cls.Fun_RetornaDataTable("SELECT tblCdDvd.Cod, tblCdDvd.Nome, tblCdDvd.Tamanho, tblTipo.Tipo, tblCdDvd.Grupo FROM [tblCdDvd] INNER JOIN [tblTipo] ON tblCdDvd.Tipo=tblTipo.Cod WHERE Status = TRUE");
if i use DataRow[] result = dtCdDvd.Select("[Grupo]=0"); the result is 0 rows and exist registry with informed code.
The more interesting is if my sql query runs "SELECT Grupo FROM tblGrupo" without join table my result is different of 0.
Continue reading...