Date null from VFP

  • Thread starter Thread starter Marcos G.
  • Start date Start date
M

Marcos G.

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
 
so in the where part of the commandText add ""WHERE refcia19=(?) and
Fcarta19 is not null" &_
 
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?
 
Back
Top