Re: MI MB: Creating and Committing tables (Urgent!)

[Peter Møller/Kampsax]

Hi Chris,

The problem is in the Commit Table line. You cannot specify a filename in
the way you do
it here. You have to enter the full path to the files location, that is
either a UNC or a hard-/network
drive.

Like this:

Commit Table x2010dm_TR_100plus As "D:
\working\96-10dm\x2010dm_TR_100plus.TAB"

If working is the name of a variable with a path, then this is the way:
Commit Table x2010dm_TR_100plus As working + "
\96-10dm\x2010dm_TR_100plus.TAB"

Best regards,

Peter

Peter Moller[EMAIL PROTECTED]
GIS-Developer   Direct: +45 6313 5008
KampsaxVoice: +45 6313 5013
Rugaardsvej 55  Faximile: +45 6313 5090
DK 5000 Odense CWeb: www.mapinfo.dk
MapInfo Authorized Partner

---
Chris Martin wrote:
I've got some code which takes in some data, does some calculations and
then
produces a host of other tables...
e.g.

Select NISLID, R_FLOW, RDNAME, FLOW, FLOW / R_FLOW "Stress_All"
  from x2010dm_TR
  where Flow_Category = 3
  into x2010dm_TR_100plus
Commit Table x2010dm_TR_100plus As "working\96-10dm\x2010dm_TR_100plus.TAB"
TYPE NATIVE Charset "WindowsLatin1"


--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]

RE: MI MB: Creating and Committing tables (Urgent!)

[David Booth]

Hi Chris,

It's nothing to do with the actual file names having spaces in them
(interpreted by Mapinfo as underscores), is it?

For example

long file name.tab

would get opened in MapInfo as

long_file_name

The other possibility is if there was a table with that name and somehow
only some of its component files got deleted (eg no .tab, but .dat and .id
files still present).

-
David Booth
Senior GIS Officer
Merseyside Information Service

> -Original Message-
> From: Martin, Christopher (WSA Telford) [SMTP:[EMAIL PROTECTED]]
> Sent: 22 September 2000 10:04
> To:   '[EMAIL PROTECTED]'
> Subject:  MI MB: Creating and Committing tables  (Urgent!)
> 
> I've got some code which takes in some data, does some calculations and
> then
> produces a host of other tables...
> e.g.
> 
> Select NISLID, R_FLOW, RDNAME, FLOW, FLOW / R_FLOW "Stress_All"
>   from x2010dm_TR
>   where Flow_Category = 3
>   into x2010dm_TR_100plus
> Commit Table x2010dm_TR_100plus As
> "working\96-10dm\x2010dm_TR_100plus.TAB"
> TYPE NATIVE Charset "WindowsLatin1"
> 
> When I run this code, I get an error at the Commit Table line: 'File
> "x2101dm_TR_100plus.TAB" does not exist. Unable to create table.'
> 
> Old versions of this table exist but aren't read-only or anything.
> However,
> I tried deleting them, but still got the same error message...
> 
> Any thoughts?
> 
> 
> Chris Martin
> GIS Consultant
> WS Atkins Consultants Ltd
> (01952) 201234
> 
> --
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]