[VXCMD] Cursor_AddRecords Bug Testing Stack

[Ken Ray]

Brian,

That worked just fine! I guess what I don't understand are the
following:

1) Isn't TAB and CR the *default* options for the Cusor_AddRecords call
if not provided? When I omitted the delimiters and let it use the
default, it was all screwed up. If MetaCard was keeping newlines at the
end of lines, using CR as a delimiter wouldn't work; consequently, if it
was keeping CRs at the end of the lines, I shouldn't need to specify
it...

2) Why would "\t" and "\r" work for the first 4 records, but not for the
5th (which was messed up) and 6th-10th (which didn't appear at all?

Thanks,

Ken Ray
Sons of Thunder Software
Email: kray at sonsothunder.com
Web Site: http://www.sonsothunder.com/ 

> -----Original Message-----
> From: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of 
> Yennie at aol.com
> Sent: Sunday, March 23, 2003 3:05 PM
> To: valentina at lists.macserve.net
> Subject: Re: [VXCMD] Cursor_AddRecords Bug Testing Stack
> 
> 
> Ken,
> 
> I don't think VXCMD recognizes escaped characters, i.e. "\t" 
> and "\r" (unless 
> it's been added recently). You may get better results with:
> 
> get Valentina("Cursor_AddRecords",cursorRef,fld "Data", tab, cr)
> 
> One workaround if you really get stuck and want bulk-loading 
> speed would be 
> to use the Cursor_ImportASCII call- you would need to write 
> the data out to a 
> file first, but it's real fast.
> 
> HTH,
> Brian
> 
> >   get Valentina("Cursor_AddRecords",cursorRef,fld "Data","\t","\r")
> > 
> > and it works *better*, but still not properly. I get the 
> first 4 lines 
> > correct, and then on the 5th line it starts messing up again. I'll 
> > send you a revised version of the stack and you can tell me 
> what you 
> > find.
> > 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net 
> http://lists.macserve.net/mailman/listinfo/val> entina
>