__dbOpenSDF keeps giving me errors.

[HGAutomator]

I can't seem to open a tab-delimited file.

Code: Select all

IF !__dbOpenSDF("testlong.txt", aStruct, "DELIM", .T., "TESTLONG", Chr(9))

returns an error:

Error DBCMD/1015 Argument error: __DBOPENSDF

[serge_girard]

Try this way:

IF !__dbOpenSDF("testlong.txt", aStruct)

[HGAutomator]

Thanks Serge,

I was able to get it working with

xResult := !__dbOpenSDF( "testlong_comma.txt", aStruct, "DELIM", .T., "TESTLONG" )

Unfortunately, I quickly discovered the limitations of delimited RDDs, like not having record counts. We'll probably build a substitute.


T & R,

DC

Try this way:

IF !__dbOpenSDF("testlong.txt", aStruct)

[serge_girard]

Would something like this be helpful ?

Code: Select all

aStruct := {}
AADD(aStruct, { 'ID1', "C", 10, 0 })
AADD(aStruct, { 'ID2', "C", 10, 0 })
DBCREATE("testlong.DBF", aStruct)
USE  testlong
APPEND FROM "testlong.txt" SDF

[HGAutomator]

No, but thanks Serge. I've worked with that strategy in previous years, and used data dictionaries to deal with longer field names. But some of our newer delimited files are huge and surpass DBF limits.

We won't be using the RDDs for this.


T & R,

DC

Would something like this be helpful ?

Code: Select all

aStruct := {}
AADD(aStruct, { 'ID1', "C", 10, 0 })
AADD(aStruct, { 'ID2', "C", 10, 0 })
DBCREATE("testlong.DBF", aStruct)
USE  testlong
APPEND FROM "testlong.txt" SDF