Page 1 of 1
__dbOpenSDF keeps giving me errors.
Posted: Sat Jul 18, 2026 10:32 pm
by 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
Re: __dbOpenSDF keeps giving me errors.
Posted: Sun Jul 19, 2026 6:34 am
by serge_girard
Try this way:
IF !__dbOpenSDF("testlong.txt", aStruct)
Re: __dbOpenSDF keeps giving me errors.
Posted: Sun Jul 19, 2026 5:21 pm
by 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
serge_girard wrote: ↑Sun Jul 19, 2026 6:34 am
Try this way:
IF !__dbOpenSDF("testlong.txt", aStruct)
Re: __dbOpenSDF keeps giving me errors.
Posted: Sun Jul 19, 2026 5:27 pm
by 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
Re: __dbOpenSDF keeps giving me errors.
Posted: Mon Jul 20, 2026 1:35 am
by 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
serge_girard wrote: ↑Sun Jul 19, 2026 5:27 pm
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