Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Date null from VFP

Reply
Thread Tools

Date null from VFP

 
 
Marcos G.
Guest
Posts: n/a
 
      06-08-2010
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

 
Reply With Quote
 
 
 
 
Mel Weaver
Guest
Posts: n/a
 
      06-08-2010
so in the where part of the commandText add ""WHERE refcia19=(?) and
Fcarta19 is not null" &_

"Marcos G." <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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


 
Reply With Quote
 
 
 
 
Marcos G.
Guest
Posts: n/a
 
      06-08-2010
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" <(E-Mail Removed)> escribió en el mensaje de
noticias:(E-Mail Removed)...
> so in the where part of the commandText add ""WHERE refcia19=(?) and
> Fcarta19 is not null" &_
>
> "Marcos G." <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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

>

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
VFP9 and SQL 2005 using VFP remote view Cannot insert the value NULL into column diane@keynston.co.uk ASP .Net 0 05-31-2007 10:05 AM
"stringObj == null" vs "stringObj.equals(null)", for null check?? qazmlp1209@rediffmail.com Java 5 03-29-2006 10:37 PM
Certification in VFP Franklin Garzon Microsoft Certification 4 06-22-2004 02:26 PM
Date, date date date.... Peter Grison Java 10 05-30-2004 01:20 PM
VFP CERTIFICATIONS EXAMS QUESTIONS MCSD 1 12-04-2003 07:20 AM



Advertisments