fbpx
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: AppendDelimited

AppendDelimited 1 year 6 months ago #3554

  JKW's Avatar Topic Author JKW Offline Posts: 27
Dear

I do not get the AppendDelimited to work.
In VO it was not a problem, any idea?

Thanks for the reply

Johan Kwaspen

Source:

oSvr_lgt := DbServer{workdir()+"lgt.dbf", false, false}

if oSvr_lgt:AppendDelimited(workdir()+"lgt.csv") = false
ErrorBox{nil, "ERROR AppendDelimited "+workdir()+"lgt.csv"}:Show();
endif

The CSV-file:
20024385,10.000
20024388,50.000
20024389,100.000
20024391,50.000

Please Log in or Create an account to join the conversation.

AppendDelimited 1 year 6 months ago #3555

  Chris's Avatar Chris Offline Posts: 1226
Hi Johan,

That's because AppendDelimited() depends on the DELIM RDD to parse the data, and this RDD (together with the SDF RDD) were never implemented in Vulcan. Guess we can do them for X#, although I am not sure if there's much interest for them.

Anyway, for now you'd need to change that code to manually parse the data and put it in the dbf file. If you need any suggestions/sample code on how to do that, please let us know.

Chris
XSharp Development Team
chris(at)xsharp.eu

Please Log in or Create an account to join the conversation.

AppendDelimited 1 year 6 months ago #3557

  JKW's Avatar Topic Author JKW Offline Posts: 27
Hello Chris,

Ok, I will adjust the code and parse the data manually in the dbf.

For larger data I use SQL but to read small data I still used the dbf, can I see the XML as an alternative to DBF. (max. 5 fields and 5000 records)

Thanks !

Johan Kwaspen

Please Log in or Create an account to join the conversation.

  • Page:
  • 1