Re: CheckMod.db

From: Júlio Silva (jquim_at_kqnet.pt)
Date: 03/24/04

  • Next message: crystal: "Re: XML file to ADO table" 
    Date: Tue, 23 Mar 2004 23:58:19 -0000

    Dear Brian:

    Unfortunaltly neither of them worked. Any how thanks.
    Joaquim Silva

    "Brian Bushay TeamB" <BBushay@Nmpls.com> wrote in message
    news:4bos501u8pdaslnhji8ggcb2pt0luane0v@4ax.com...
    > >How can I write this query passing over the error caused by the
    > >CheckMod.DBF.ENTRYID clause. It gives an error due to the double ..
    > >
    > > with SQL do
    > > begin
    > > Clear;
    > > Add(' UPDATE CheckMod.DBF ');
    > > Add(' SET O_Disc = ( ');
    > > Add(' SELECT AMT FROM GNDLine.DBF AS Li ');
    > > Add(' WHERE CheckMod.DBF.ENTRYID = Li.ENTRYID ) ');
    > > end; // with SQL do
    >
    > try
    >
    > Add(' WHERE [CheckMod.DBF].[ENTRYID] = Li.ENTRYID ) ');
    >
    > and
    >
    > Add(' WHERE "CheckMod.DBF"."ENTRYID" = Li.ENTRYID ) ');
    >
    >
    > --
    > Brian Bushay (TeamB)
    > Bbushay@NMPLS.com

  • Next message: crystal: "Re: XML file to ADO table"