RE: MI Mapbasic Create table statement

[Tim.Nuteson (Exchange)]

Title: Mapbasic Create table statement

Hi Dan.  Here's an example that works for me.  The FileSaveAsDlg() function prompts user to specify a table name, and returns the full path info for the specified location.  You then need to use PathToTableName$() to extract the tab name from the full path.

 

Tim Nuteson

Target Corp.

 

 

Dim NewFile, NewTab as String

 

NewFile = FileSaveAsDlg("", "", "TAB", "Create New Table")

 

If NewFile = "" Then 'cancelled

    Exit Sub

Else

    NewTab = PathToTableName$(NewFile)

End If

 

' create the table

Create Table NewTab

    (Name Char(30))

    File NewFile

-----Original Message-----
From: Clark, Daniel (CRTLDN) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 20, 2000 9:08 AM
To: '[EMAIL PROTECTED]'
Subject: MI Mapbasic Create table statement

Hi List,

Is it possible to use a string variable as the table name in the MapBasic 'Create Table' statement? (ie the variable contains a user specified table name from a dialog)

I have tried the following:

Create Table UserTable (Ring Smallint, Radius Smallint,
        Units Char(10), Statistics Smallint)
File TableName   
Create Map For Buffer

Where UserTable is the variable containing the name of the table as specified by the user. When this is run I get the message "Expression does not evaluate to a column or table name"

Any help will be apprieciated.

Dan Clark

(  Tel  +44 20 7842 5066
Ê Fax  +44 20 7842 5276
*  [EMAIL PROTECTED]