Hopefully, someone has come across something like this before.
I've checked how many rows a MapInfo table (Route) has - using
TAB_INFO_NROWS - and found that it has 66565 rows.
When I've tried inserting a field from each row into an Oracle table
(Temp_Routes), using the following code, more than 170,000 rows have been
entered (I stopped the process at thsi point).
-----------------------------------------------------
Fetch First from Route
Do While Not EOT(Route)
li_Route_ID = Route.ROUTE_ID
lc_select = "Insert into Temp_Routes (ROUTE_ID) Values (" +
li_Route_ID +
")"
gi_hstmt = server_execute(gi_hdbc, lc_select)
server gi_hstmt Close
Fetch Next From Route
Loop
-----------------------------------------------------
There are no duplicated rows within the Oracle table.
Does anyone have any idea where I'm going wrong?
Thanks in advance.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
