PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEV, WEBDEV e WINDEV Mobile

Inicio | Mensagens recentes | Conecte-se... |  | Português FR
Inicio → WEBDEV 2024 → select distinct
select distinct
Iniciado por Marc Muylaert, out., 26 2008 1:03 AM - 1 resposta
#1
Publicado em outubro, 26 2008 - 1:03 AM
webdev 12 : a simple select distinct in a query that returns correct
results when testing the query is NOT giving the same results when I
bind this query with a table control.. in webdev11 all ok..

webdev 11 : in table control returns null,bb,gen,mus
webdev 12 : returns null,bb,bb,gen (twice bb??)

anyone an idea where to search ?
thx
Marc
#2
Publicado em outubro, 26 2008 - 11:41 AM
Marc Muylaert wrote:
webdev 12 : a simple select distinct in a query that returns correct
results when testing the query is NOT giving the same results when I
bind this query with a table control.. in webdev11 all ok..

webdev 11 : in table control returns null,bb,gen,mus
webdev 12 : returns null,bb,bb,gen (twice bb??)

anyone an idea where to search ?
thx
Marc

Added : database used is sql 2005, oledb. When I convert the file to
hyperfile all is ok... error occurs when accessing the sql 2005 database
directly.. tested on an xp and a vista pc
→ Voltar para WEBDEV 2024