Re: Remote View Problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: JPC (jpc_at_hotmail.com)
Date: 07/14/04

  • Next message: Thomas Ganss: "Re: Foxpro sql limitations" 
    Date: Tue, 13 Jul 2004 20:55:02 -0400

    It would be similar to this:

    SELECT *;
      FROM DCJDE.MAP_LOC Map_loc;
      WHERE Map_loc.LOCATION > 'G1';
        AND Map_loc.LOCATION < 'J1';
      ORDER BY Map_loc.LOCATION

    Anders Altberg wrote:
    > could you post an example of such a Whewre clause?
    > -Anders
    >
    > "JPC" <jpc@hotmail.com> wrote in message
    > news:B6-dnWuRYOc1Y3LdRVn-ig@wideopenwest.com...
    >
    >>Using VFP 6.0 and creating a remote view to an IBM DB2 database using
    >>the interface. Sometimes when I include a where clause, save the view
    >>and try to reopen it I get an error message stating that there is a
    >>"Missing operand" and the view won't open.
    >>
    >>Does anyone know what's causing this?
    >>
    >>Thanks in advance for any assistance.
    >>
    >
    >

  • Next message: Thomas Ganss: "Re: Foxpro sql limitations"