Re: Problem with field name that uses #
- From: "Viatcheslav V. Vassiliev" <support@xxxxxxxxxxxxxxx>
- Date: Wed, 24 Aug 2005 00:57:54 +0400
...
or [mt].[SS#]
//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)
"Striper" <jkaufmann@xxxxxxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:430b6fec$1@xxxxxxxxxxxxxxxxxxxxxxxxx
>I have the solution for this when using one table:
>
> Select [SS#] from MyTable
>
> The problem is that I need to use aliases because I am using multiple
> tables
> so:
>
> Select [mt.SS#], ct.Lname
> from MyTable mt, ChildTable ct
>
> Does not work
>
>
> "Striper" <jkaufmann@xxxxxxxxxxxxx> wrote in message
> news:430b4170$1@xxxxxxxxxxxxxxxxxxxxxxxxx
>> I am trying to read from an access file that has a field named SS#.
>>
>> In my SQL select clause if I do not put double quotes around it, it will
> not
>> open. If I do the query opens but trying to access the field generates an
>> error. Any suggestions for addressing this?
>>
>>
>
>
.
- References:
- Problem with field name that uses #
- From: Striper
- Re: Problem with field name that uses #
- From: Striper
- Problem with field name that uses #
- Prev by Date: Re: Problem with field name that uses #
- Next by Date: ODBC-ing my app
- Previous by thread: Re: Problem with field name that uses #
- Next by thread: Copy and Paste TADOQuery and TDataSource in 2005
- Index(es):
Relevant Pages
|
