×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
ok...in your SQL statements it doesn't matter if the field names are the
same...it will use the one from the file you are selecting from.
Thanks,
Tommy Holden
Robert Munday <rwmunday@xxxxxxxxxxxxx>
Sent by:
midrange-l-bounces+tommy.holden=thompsonmachinery.com@xxxxxxxxxxxx
05/16/2007 10:30 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc
Subject
Re: SQL Fun
Tommy,
-----Original Message-----
From: Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx
<<< use prefixes on the external DS... >>>
As I said before, that has not worked. Here is what I coded:
* Detail File
D PDTOTDTL E DS ExtName(PDTOTDTL) Prefix(D_)
C/Exec SQL
+ Select Count(D_QCORD#) Into :Count From FPTOTDTL
+ Where D_QCORD# = :$ORDER -- Count Order Records
C/End-Exec
This is the error it generates:
SQL0206 30 431 Position 23 Column D_QCORD# not in specified tables.
SQL0206 30 432 Position 17 Column D_QCORD# not in specified tables.
Is there an interim step or something I'm missing?
Robert Munday
Munday Software Consultants
Montgomery, AL
having SQL fun in Dublin, OH
midrange.com
