EXPORT length limitations?
Robert Haussmann
haussma at nextdimension.net
Mon Mar 22 05:43:16 PST 2004
> I don't know. You'll have to wait until FP Tech opens perhaps
> to find out
> precisely. I'd bet though that it might be related to
> PFIMPBUF... maybe
> not. Why, are you having a problem?
>
No specific problems, just a problem creating a *large* dataset
to be used as an input to SQL server. We've gone through a number
of different attempts, 1) using fileProODBC (seems to choke on
large varchar or text fields), 2) creating CSV files (doesn't
work because some are text fields that contain CR/LF characters
and I can't find any info about how to handle these in
CSV), and finally 3) creating SQL batch scripts to load the
data.
Using this last method we have been mostly successful. There
are still about 5% of the records not loading, and I'm trying
to track down why.
Thanks for the heads up on the import issue (I had forgotten
about PFIMPBUF as well; those I was under the impression this
is used for imports only). It's worth looking into.
Bob
More information about the Filepro-list
mailing list