Cursor_ImportASCII

[Ruslan Zasukhin]

on 8/20/03 10:39 PM, edeleur at euronet.nl at edeleur at euronet.nl wrote:

> Name:      E. de Leur
> 
> Question regarding: vsdk
> 
> Can you tell me the proper use of the
> function: Cursor_ImportASCII
> I try  to import a comma delimited ASCII file but can't figure it out.
> Some example will help.
> I use C VSDK for MAC OS.
> Thanks, Edwin

Hi Edwin,

Assume in the ASCII file you have 5 fields.
You want import them into some 5 fields of some table (which can have even
10 fields.)

So you build empty cursor with 5 fields that have needed order corresponding
to your import file

    SELECT f1, f2, f3, f4, f5
    FROM T
    WHERE RecID = 0

When you get this cursor you simply call that method

    cursor_ImportASCII( pathToFile, ',' , '\r'  )


As result your cursor will have N imported records.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------