- Original Message -
From: "Frontier Mapping Pty Ltd" [EMAIL PROTECTED]
To: "Scott Fagg" [EMAIL PROTECTED]
Sent: Friday, May 12, 2000 4:03 PM
Subject: Re: MI syntax question
I've found that if you do a
Select * from xTable where rowid = y,
you can then use
xData = selection.data_column,
though this does seem a long winded way of going about things, and it
assumes that you now the rowid of the record you're trying to select.
I'm having a similar problem with columns, ie
[tablename].[stringvariable].
I've also tried [tablename].[alias] but can't get that to work either.
What
are we missing? Can anyone out there help?
- Original Message -
From: "Scott Fagg" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, May 11, 2000 6:56 PM
Subject: MI syntax question
I'm trying to do the following:
--
dim xTable as string
dim xData as integer
xTable = 'table_name'
fetch first from xTable
xData = xTable.data_column
--
I'm using xTable as a string because the actual table name is specifed
by
the user and is not known at compile time.
The error i get from mapbasic compiler is s helpful - Unrecognized
command: ..
I'm guess MI doesn't like the fact that i'm trying [string
variable].[column name] instead of [table].[column name]
So how do i get around this assuming that i dont know the table name at
compile time?
TIA
--
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]