Merge TPS files

questions
#1

Hi All,
I have 2 .TPS files and i want merge them! so is there and app that do this? or how can i i do that?
Thank you

#2

I’ve always used the dct ‘create a conversion program’ to create source and go from there.

#3

im new so can you send me the project or share the source code here! Thank you

#4

assuming that both files have the same fields.

program

PROGRAM

MAP
END

file1 FILE,DRIVER(‘TOPSPEED’),NAME(‘file1.tps’),pre(f1)
record record
field1 long
! ect
end
end

file2 FILE,DRIVER(‘TOPSPEED’),NAME(‘file2.tps’),PRE(F2)
record record
field1 long
end
end

code
    open(file1)
    if  errorcode()
        message('can not open file1')
        return                               
    end 
    OPEN(FILE2)
    if  errorcode()
        message('can not open file2')
        return                     
    end 
    ! READ FILE 1 AND ADD TO FILE2
    SET(FILE1)
    LOOP
        NEXT(FILE1)
        IF ERRORCODE()
            BREAK
        END
        
        FILE2.record = FILE1.record
        ADD(FILE2)
    END
    CLOSE(file1)
    CLOSE(file2)
#5

Are the files of the same structure? I have had good results in the past using the Topspeed ODBC driver and doing it all within Access or some other front end tool to write and test the INSERT queries.

I believe you used to be able to get an evaluation copy of the ODBC drivers in the past, which gives you enough time to run a conversion? Not sure if you still can now though.