Re: Extra Empty Record

From: Larry <lfranklin_at_my-deja.com>
Date: Fri, 17 Dec 1999 13:53:08 GMT
Message-ID: <83df83$nis$1@nnrp1.deja.com>

Is is possible that your query is returning null records? Could be possible if you are querying nullable columns. Is so, add to the where clause: AND whatever_field IS NOT NULL

Larry

In article <945378809.15497.0.nnrp-01.9e984b29_at_news.demon.co.uk>, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
> Try adding:
> btitle off
> ttitle off
> set embedded on
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> Alan Shein wrote in message <83b51j$bdp$1_at_bob.news.rcn.net>...
> >Just edit the spool file.
> >
> >Mitch <mitchell7468_at_my-deja.com> wrote in message
> >news:838v05$j88$1_at_nnrp1.deja.com...
> >> The following psuedo-query seems to put an extra empty record into
the
> >> text file it spools to. Thus, when I import the text file into MS
> >> Access I get an import error when I import with a primary key
defined.
> >> I'd appreciate it if someone could let me know how I could get rid
of
> >> the extra record.
> >>
> >> SPOOL C:\Sample.txt
> >> SET NEWPAGE 0
> >> SET SPACE 0
> >> SET LINESIZE 150
> >> SET PAGESIZE 0
> >> SET COLSEP |
> >> SET ECHO OFF
> >> SET FEEDBACK OFF
> >>
> >> Select ?????????
> >> From ?????????
> >> Where ?????????
> >>
> >> SPOOL OFF
> >>
> >> Thanks Much
> >>
> >> Paul
> >>
> >>
> >> Sent via Deja.com http://www.deja.com/
> >> Before you buy.
> >
> >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 17 1999 - 07:53:08 CST