Table doesn't exist error

[Nathan White]

I'm trying to use the following at the end of one of my scripts to import a file.rtf to a table where the record contains only 1 field 80 characters wide (thus, each line from the file.rtf would be one record in the table). I keep getting the error "Table.import() no such table", so what does this mean?

Here's the end of my script where the error is occurring:
'---------Table.import() from TimepayMod.rtf--------
import.type = FILE_FORMAT_RICH_TEXT
import.names = "none"
import.file = filename3
import.db = "C:Program FilesA5V4_RuntimeTimepayTimepay2.dbf"
import.skip_lines = 0
import.skip_bytes = 0
import.field_sep = ""
import.record_sep = ""
import.record_len = 80
import.rem_blanks = .F.
import.text_qualifier = ""
import.fields = 1
import.field1 = "Record,c,0,80,0"
Table.import()


END '-----------------------BYE!----------------------------

[Stan Mathews]

RE: Table doesn't exist error

Nathan,

Does filename3 refer to a file in the current directory? If this file is not in the same directory as your Alpha files, you probably have to refer to it with a full path, i.e. C:\some directory\some sub directory\filename3

I don't know that this your problem, it's just the only place I see that might cause a problem.

Stan

[Nathan White]

RE: Table doesn't exist error

Stan:
filename3=("C:Program FilesA5V4_RuntimeTimepayTimepayMod.rtf")

Is this direct enough or do I need to do something different. I don't understand why "no such table" would come up. Is something wrong with the Table.Import.

I don't care how I do it. I just want to enter each line of a .rtf file as one record; whether it is blank or not. Is there a different method I can use.

Please keep in mind, each time that I import to the table I want the old info removed prior to the new info being entered. I'm open to suggestions here too. Thanks for your help.

NATE

[Nathan White]

RE: Table doesn't exist error

I think I found the reason why!

If you look at import.type I originally used the code supplied by the ref. manual. I used "FILE_FORMAT_RICH_TEXT" and that didn't work. However, I used a "0" zero to replace that code and the error no longer occurred. Thus, I have deduced that either Table.import() doens't reconize "FILE_FORMAT_RICH_TEXT" or I need the numerical code that represents "FILE_FORMAT_RICH_TEXT". If this is the case, do you have that numerical code? Thanks!



NATE

[BRochford]

RE: Table doesn't exist error

Codes for import format:
Char-Sep ASCII=0, so on from there and
Lotus Symphony, Version 2.0 = 9

-Barry

[Stan Mathews]

RE: Table doesn't exist error

To expand on Barry's answer:

from the old ver 3 manual

Code Import Format Type Extension
0 Character-Separated ASCII .ASC
1 Table ASCII .TBL
2 Rich Text Format (RTF) .RTF
3 Microsoft Excel, Version 3.0 .XLS
4 Microsoft Excel, Version 4.0 .XLS
5 Lotus 1-2-3, Version 1.0/1A .WKS
6 Lotus 1-2-3, Version 2.0 .WK1
7 Lotus 1-2-3, Version 3.0 .WK3
8 Lotus Symphony, Version 1.0 .WRK
9 Lotus Symphony, Version 2.0 .WR1

Can anyone spell B-U-G?