Prev: Fail to preview CR
Next: Which files and folders from the two solutions must be merged to combine web sites solutions
From: Marcos G. on 8 Jun 2010 13:23
Hi i need to extract data from .DBF tables, but when i bring the data and
the column with "date" don't have any data i see the date: 30/12/1899
12:00:00 a.m. in the grid and i don't want to see anythink in that cases,
this is part of my code for that:

cmd.CommandText = "select numcon19 as contenedor, fcarta19 as entrega from
stcont19, IIF(year(fcarta19)<=1999,"",fcarta19) " & _
"left join ('c:\Recocabezut\trafico\Data\stctrl21') AS
REFERENCIA ON STCONT19.REFCIA19=REFERENCIA.REFCIA21 " & _
"WHERE refcia19=(?) " & _
"ORDER BY contenedor INTO CURSOR CONTENEDORES"


but it does'nt work �can you help me?

Sorry for my bad english :( �do you know a news in spanish?

Thanks a lot

From: Mel Weaver on 8 Jun 2010 13:40
so in the where part of the commandText add ""WHERE refcia19=(?) and
Fcarta19 is not null" &_

"Marcos G." <marcosgalaviz(a)hotmail.com> wrote in message
news:6C7A87D2-BC2B-4D37-9B66-566437473589(a)microsoft.com...
> Hi i need to extract data from .DBF tables, but when i bring the data and
> the column with "date" don't have any data i see the date: 30/12/1899
> 12:00:00 a.m. in the grid and i don't want to see anythink in that cases,
> this is part of my code for that:
>
> cmd.CommandText = "select numcon19 as contenedor, fcarta19 as entrega from
> stcont19, IIF(year(fcarta19)<=1999,"",fcarta19) " & _
> "left join ('c:\Recocabezut\trafico\Data\stctrl21') AS
> REFERENCIA ON STCONT19.REFCIA19=REFERENCIA.REFCIA21 " & _
> "WHERE refcia19=(?) " & _
> "ORDER BY contenedor INTO CURSOR CONTENEDORES"
>
>
> but it does'nt work �can you help me?
>
> Sorry for my bad english :( �do you know a news in spanish?
>
> Thanks a lot

From: Marcos G. on 8 Jun 2010 14:24
No because i want to see that records, but i don't want to se de "Default"
date: 30/12/1899 12:00:00 a.m, i just want to see in blank that column in
the grid

Thanks for your help �any other sugestions?

"Mel Weaver" <MelRemoveSpam(a)Insdirect.com> escribi� en el mensaje de
noticias:eb99hGzBLHA.1888(a)TK2MSFTNGP05.phx.gbl...
> so in the where part of the commandText add ""WHERE refcia19=(?) and
> Fcarta19 is not null" &_
>
> "Marcos G." <marcosgalaviz(a)hotmail.com> wrote in message
> news:6C7A87D2-BC2B-4D37-9B66-566437473589(a)microsoft.com...
>> Hi i need to extract data from .DBF tables, but when i bring the data and
>> the column with "date" don't have any data i see the date: 30/12/1899
>> 12:00:00 a.m. in the grid and i don't want to see anythink in that cases,
>> this is part of my code for that:
>>
>> cmd.CommandText = "select numcon19 as contenedor, fcarta19 as entrega
>> from stcont19, IIF(year(fcarta19)<=1999,"",fcarta19) " & _
>> "left join ('c:\Recocabezut\trafico\Data\stctrl21') AS
>> REFERENCIA ON STCONT19.REFCIA19=REFERENCIA.REFCIA21 " & _
>> "WHERE refcia19=(?) " & _
>> "ORDER BY contenedor INTO CURSOR CONTENEDORES"
>>
>>
>> but it does'nt work �can you help me?
>>
>> Sorry for my bad english :( �do you know a news in spanish?
>>
>> Thanks a lot
>
 | 
Pages: 1
Prev: Fail to preview CR
Next: Which files and folders from the two solutions must be merged to combine web sites solutions