dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

TextStream Problem in Paradox 10 - Paradox Database

This is a discussion on TextStream Problem in Paradox 10 - Paradox Database ; Hi all, I've downloaded a very large .htm file from the internet which consists of many separate tables and need to break them up into separate lines so I can import the tables into Paradox. I've set up an advMatch() ...


Home > Database Forum > Other Databases > Paradox Database > TextStream Problem in Paradox 10

Reply

 

LinkBack Thread Tools Display Modes
) and then I use the readChars() method to post that text into a variable. I then use the readLine() method to post the rest of the line into another variable. I then add these 2 variables together inserting chr(13) and chr(10) between the 2 parts to get a CR/LF and then use the writeLine() method to output to a new data into the text file.
Typically text "xxxxxxxxxxxx" becomes
xxxxxxxxxxxx
once the CR/LF characters have been inserted.

However, this works perfectly for about 100 lines or so (it varies) and then it just stops working (as if I've hit a buffer limit problem or similar) and then all remaining text just goes in as it was with no CR/LF inserts.

I've set up view()'s on various fields and these look fine stepping through the data and it appears to work according the the view() windows but when I open the file I find it has only applied the CR/LFs to 100 or so lines and the rest is still in a block.

I've checked out the smallInt / longInt numbers and this does not appear to be the problem.

I've been on this now for 2 days and am getting brassed off.

Has anybody got any ideas?

Thanks

Bernard Norrie (New to this Forum)
Reply With Quote
  #1  
Old 10-04-2009, 09:24 AM
Database Newbie
  
Join Date: Oct 2009
Posts: 3
Bernard Norrie is on a distinguished road
Default TextStream Problem in Paradox 10
Hi all,
I've downloaded a very large .htm file from the internet which consists of many separate tables and need to break them up into separate lines so I can import the tables into Paradox. I've set up an advMatch() in TextStream to identify the bits of text I need to start my lines with (usually
or
yyyyyyyyyyyyyyy yyyyyyyyyyyyyyy
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode


Similar Threads

Thread Thread Starter Forum Replies Last Post
Overview of Paradox database structure and architecture Database Administrator Paradox Database 101 08-06-2008 12:20 PM
Embarcadero - what does this meanfor the futur of Paradox? Database Administrator Paradox Database 5 05-26-2008 11:30 AM
Problem with Paradox database nivetypearljam Paradox Database 0 05-20-2008 09:05 AM
SQL Server 2000 linked server problem Database Administrator ms-sqlserver 10 01-13-2008 09:56 PM
SQL RS 2000 problem with web service/Virtual directory Database Administrator ms-sqlserver 9 11-09-2007 12:57 PM


All times are GMT -4. The time now is 12:11 AM.