----- 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 soooo 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]
