Losing values upon combining two identical .tab files via MapBasic

[Alan Carr]

down votefavorite

I am using mapbasic to perform some calculations on a table. Everything is fine until I combine two .tab files. Both files have identical table structures, however upon combination some numerical (float) values are being set as 0. Values from HUNDRED_CL: Values after combining the files: The CR1 data is fine, but as soon as I append the CL1 data to it, some TO values become 0, can somebody assist? Table structures for reference: Regards, Alan

[Uffe Kousgaard]

Hi,

Try to rename the TO field to something else.
You may have hit a keyword with an unfortunate result.

Regards
Uffe Kousgaard


Alan Carr wrote:

--
--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en

---
You received this message because you are subscribed to the Google Groups "MapInfo-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mapinfo-l+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Alan Carr]

Hi Uffe,

I've changed TO to CHO but unfortunately this has not resolved the problem

Regards,

Alan

[Timothy Mashford]

How are you doing the append? i.e. what's your code?

[Alan Carr]

Here is the section of code where the append occurs. Everything (each individual file) is fine up until this point

http://pastebin.com/ex1YwvQT

[Albert Tabino]

try packing all tables before you run your script....maybe that would fix it....cheers!

[Timothy Mashford]

Your code is only updating to COL9. The 'TO' column is number 10.