Xbasic Append Crashes

[Jeff Stevens]

a5v4.5 b266

When I run the following code through the Debugger I get an error when it hits tbl.append()

Field and expression types must match

The tables used are exactly the same. The transaction table is simply a copy to a backup dir.

Any ideas?

Thanks, Jeff


dim tbl as p

tbl = table.open("a5v45test")
append.t_db = "c:\acebackup2\a5v45test.dbf"
append.m_key = ""
append.t_key = ""
append.m_filter = ""
append.t_filter = ""
append.type = "All"
append.m_count = 4
append.m_field1 = "LNAME"
append.m_exp1 = "@A5V45TEST->LNAME"
append.m_field2 = "FNAME"
append.m_exp2 = "@A5V45TEST->FNAME"
append.m_field3 = "ADDRESS"
append.m_exp3 = "@A5V45TEST->ADDRESS"
append.m_field4 = "LONG_LONG_LONG_NAME"
append.m_exp4 = "@A5V45TEST->LONG_LONG_LONG_NAME"
append.t_count = 0
tbl.append()
tbl.close()

end

[JerryBrightbill]

RE: Xbasic Append Crashes

Jeff

Some error messages are a bit crytic and may not represent the actual error. Verify that both tables actually exist and the table in the table.open() command is in the current directory. If the current directory is "c:\acebackup2\", you will be trying to append a table to itself. If that doesn't have any effect, try renaming the destination file to something else. While using the same name shouldn't be a problem, it is worth a try.

Jerry

[Jeff Stevens]

RE: Xbasic Append Crashes

Thanks Jerry

I found that if I include the .ddd .ddm .ddx files in the same backup dir with the .dbf file the append above works.

I have no idea why. Would like to know if someone understands the secret.

Thanks again, Jeff

[Stan Mathews]

RE: Xbasic Append Crashes

table.DDD
table.DDM
table.DDX
The table�s data dictionary files: specifically, the data
dictionary table, memo, and index file. Stores layouts,
field rules, ranges, queries, and saved utility settings.

So if you don't include these, Alpha (to be specific, the append operation) can't be positive that the data types match.

Or so it would seem.

[Michael Humby]

RE: Xbasic Append Crashes

Jeff,

Strange result because I often have the situation where I only have access to the .dbf files and the appends are quite happy.



Michael

[Michael Humby]

RE: Xbasic Append Crashes

Jeff,

Sorry, did not finish my previous message.


Strange result because I often have the situation where I only have access to the .dbf files and the appends are quite happy.

Are you sure that the fields exactly match in size and type.

Michael

[Tom Cone Jr]

RE: Xbasic Append Crashes

Jeff,

the table's dictionaries are also where fieldnames longer than 10 chars are stored, too. If the append utility can't find the long names you're using it won't work. Make sense?

-- tom

[Tom Cone Jr]

RE: Xbasic Append Crashes

Michael,

Does either table use fieldnames longer than 10 chars? I suspect not. -- tom

[Jeff Stevens]

RE: Xbasic Append Crashes

Tom

You're right, I have some file names longer than 10.

I also have some with blank spaces :-( I plan to fix these problems in the next upgrade of my app. This makes sense and the button works now.

Thanks to all