Date null from VFP

Discussion in 'ASP .Net' started by Marcos G., Jun 8, 2010.

  1. Marcos G.

    Marcos G. Guest

    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
    Marcos G., Jun 8, 2010
    #1
    1. Advertising

  2. Marcos G.

    Mel Weaver Guest

    so in the where part of the commandText add ""WHERE refcia19=(?) and
    Fcarta19 is not null" &_

    "Marcos G." <> wrote in message
    news:...
    > 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
    Mel Weaver, Jun 8, 2010
    #2
    1. Advertising

  3. Marcos G.

    Marcos G. Guest

    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" <> escribió en el mensaje de
    noticias:...
    > so in the where part of the commandText add ""WHERE refcia19=(?) and
    > Fcarta19 is not null" &_
    >
    > "Marcos G." <> wrote in message
    > news:...
    >> 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

    >
    Marcos G., Jun 8, 2010
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?S2VubmV0aCBQ?=

    asp.net with vfpoledb driver and vfp database

    =?Utf-8?B?S2VubmV0aCBQ?=, Oct 27, 2004, in forum: ASP .Net
    Replies:
    0
    Views:
    658
    =?Utf-8?B?S2VubmV0aCBQ?=
    Oct 27, 2004
  2. JeffP@Laptop

    dBase VFP OleDb or ODBC Drivers

    JeffP@Laptop, Jan 25, 2006, in forum: ASP .Net
    Replies:
    0
    Views:
    2,770
    JeffP@Laptop
    Jan 25, 2006
  3. John Fabiani

    From VFP to Java trouble (newbie)

    John Fabiani, Nov 2, 2003, in forum: Java
    Replies:
    1
    Views:
    2,099
    Raymond DeCampo
    Nov 9, 2003
  4. Peter Grison

    Date, date date date....

    Peter Grison, May 28, 2004, in forum: Java
    Replies:
    10
    Views:
    3,244
    Michael Borgwardt
    May 30, 2004
  5. Replies:
    0
    Views:
    814
Loading...

Share This Page