Hi guys,

It's prolly just me but the APPEND FROM (DBIMPORT), doesnt seem to be 
working the same way as clipper, and I didn't find anything on the help that 
explains this behave:

*********
Environment:
Xbase++ 1.82.294 (with build 306 dlls)
vs
Clipper 5.3b

*********
Situation:
We have a temporary file w/ 3 fields:
TEMPTXT     C(300)
CLID             C(12)
SCLID            C(12)

We have a text file with 264 chars (ending lines w/ chr(13)+chr(10))

*On clipper when used: APPEND FROM MYTEXT.TXT SDF
all the 264 chars for each line are saved on the field TEMPTXT  (1 line per 
record)

*On Xbase++ when used: APPEND FROM MYTEXT.TXT SDF
The text file seems to be read until it reaches 326 chars (ignoring the line 
ends) and then commited to the record on the table. So basically im off 62 
chars per record.


Well again I might just be me, but I cannot find where i'm missing 
something..?

Thanks for the help!
Marcelo

Marcelo,

I can confirm that APPEND FROM ... SDF is different in Xbase++ from clipper. 
The SDF file and the DBF table must have a matching record size.  Two notes:

The SDF file is opened with the SDFDBE data engine, so it is good to look at 
the docs on the SDFDBE to understand its operation.

The APPEND FROM is implemented in the SOURCE\SYS\DBBULK.prg source code that 
is provided.  You can step this in the debugger to determine the problem. 
You can also enhance this file as necessary for your specific situation.

Rodd

"Marcelo Ramos" <mramos@caisoftdesign.ca> wrote in message 
news:cks3O4kBGHA.2944@S15147418...
> Hi guys,
>
> It's prolly just me but the APPEND FROM (DBIMPORT), doesnt seem to be 
> working the same way as clipper, and I didn't find anything on the help 
> that explains this behave:
>
> *********
> Environment:
> Xbase++ 1.82.294 (with build 306 dlls)
> vs
> Clipper 5.3b
>
> *********
> Situation:
> We have a temporary file w/ 3 fields:
> TEMPTXT     C(300)
> CLID             C(12)
> SCLID            C(12)
>
> We have a text file with 264 chars (ending lines w/ chr(13)+chr(10))
>
> *On clipper when used: APPEND FROM MYTEXT.TXT SDF
> all the 264 chars for each line are saved on the field TEMPTXT  (1 line 
> per record)
>
> *On Xbase++ when used: APPEND FROM MYTEXT.TXT SDF
> The text file seems to be read until it reaches 326 chars (ignoring the 
> line ends) and then commited to the record on the table. So basically im 
> off 62 chars per record.
>
>
> Well again I might just be me, but I cannot find where i'm missing 
> something..?
>
> Thanks for the help!
> Marcelo
>
>

Thanks, I'll see if I can adapt that to my needs! :D

"Rodd Graham" <rodd@tpmco.com> wrote in message 
news:tuK8UAlBGHA.2944@S15147418...
> Marcelo,
>
> I can confirm that APPEND FROM ... SDF is different in Xbase++ from 
> clipper. The SDF file and the DBF table must have a matching record size. 
> Two notes:
>
> The SDF file is opened with the SDFDBE data engine, so it is good to look 
> at the docs on the SDFDBE to understand its operation.
>
> The APPEND FROM is implemented in the SOURCE\SYS\DBBULK.prg source code 
> that is provided.  You can step this in the debugger to determine the 
> problem. You can also enhance this file as necessary for your specific 
> situation.
>
> Rodd
>
> "Marcelo Ramos" <mramos@caisoftdesign.ca> wrote in message 
> news:cks3O4kBGHA.2944@S15147418...
>> Hi guys,
>>
>> It's prolly just me but the APPEND FROM (DBIMPORT), doesnt seem to be 
>> working the same way as clipper, and I didn't find anything on the help 
>> that explains this behave:
>>
>> *********
>> Environment:
>> Xbase++ 1.82.294 (with build 306 dlls)
>> vs
>> Clipper 5.3b
>>
>> *********
>> Situation:
>> We have a temporary file w/ 3 fields:
>> TEMPTXT     C(300)
>> CLID             C(12)
>> SCLID            C(12)
>>
>> We have a text file with 264 chars (ending lines w/ chr(13)+chr(10))
>>
>> *On clipper when used: APPEND FROM MYTEXT.TXT SDF
>> all the 264 chars for each line are saved on the field TEMPTXT  (1 line 
>> per record)
>>
>> *On Xbase++ when used: APPEND FROM MYTEXT.TXT SDF
>> The text file seems to be read until it reaches 326 chars (ignoring the 
>> line ends) and then commited to the record on the table. So basically im 
>> off 62 chars per record.
>>
>>
>> Well again I might just be me, but I cannot find where i'm missing 
>> something..?
>>
>> Thanks for the help!
>> Marcelo
>>
>>
>
>

You might also want to look at the "APPEND FROM/COPY TO" replacement on 
Alaska's ASCN page.

http://www.alaska-software.com/scripts/waa001.dll?WAA_PACKAGE=WebLib&WAA_FORM=ListFiles&WEBLIB_SECT=12

-Brent



Marcelo Ramos wrote:
> Hi guys,
> 
> It's prolly just me but the APPEND FROM (DBIMPORT), doesnt seem to be 
> working the same way as clipper, and I didn't find anything on the help that 
> explains this behave:
> 
> *********
> Environment:
> Xbase++ 1.82.294 (with build 306 dlls)
> vs
> Clipper 5.3b
> 
> *********
> Situation:
> We have a temporary file w/ 3 fields:
> TEMPTXT     C(300)
> CLID             C(12)
> SCLID            C(12)
> 
> We have a text file with 264 chars (ending lines w/ chr(13)+chr(10))
> 
> *On clipper when used: APPEND FROM MYTEXT.TXT SDF
> all the 264 chars for each line are saved on the field TEMPTXT  (1 line per 
> record)
> 
> *On Xbase++ when used: APPEND FROM MYTEXT.TXT SDF
> The text file seems to be read until it reaches 326 chars (ignoring the line 
> ends) and then commited to the record on the table. So basically im off 62 
> chars per record.
> 
> 
> Well again I might just be me, but I cannot find where i'm missing 
> something..?
> 
> Thanks for the help!
> Marcelo
> 
>

Thanks i'll take a look at that.


"Brent Dubs" <bdubs@vanityshops.com> wrote in message 
news:%23QgZOWlBGHA.3104@S15147418...
> You might also want to look at the "APPEND FROM/COPY TO" replacement on 
> Alaska's ASCN page.
>
> http://www.alaska-software.com/scripts/waa001.dll?WAA_PACKAGE=WebLib&WAA_FORM=ListFiles&WEBLIB_SECT=12
>
> -Brent
>
>
>
> Marcelo Ramos wrote:
>> Hi guys,
>>
>> It's prolly just me but the APPEND FROM (DBIMPORT), doesnt seem to be 
>> working the same way as clipper, and I didn't find anything on the help 
>> that explains this behave:
>>
>> *********
>> Environment:
>> Xbase++ 1.82.294 (with build 306 dlls)
>> vs
>> Clipper 5.3b
>>
>> *********
>> Situation:
>> We have a temporary file w/ 3 fields:
>> TEMPTXT     C(300)
>> CLID             C(12)
>> SCLID            C(12)
>>
>> We have a text file with 264 chars (ending lines w/ chr(13)+chr(10))
>>
>> *On clipper when used: APPEND FROM MYTEXT.TXT SDF
>> all the 264 chars for each line are saved on the field TEMPTXT  (1 line 
>> per record)
>>
>> *On Xbase++ when used: APPEND FROM MYTEXT.TXT SDF
>> The text file seems to be read until it reaches 326 chars (ignoring the 
>> line ends) and then commited to the record on the table. So basically im 
>> off 62 chars per record.
>>
>>
>> Well again I might just be me, but I cannot find where i'm missing 
>> something..?
>>
>> Thanks for the help!
>> Marcelo
>>
>>
>