RE: Field name truncation

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: bin_leigh <binleigh@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 11 Aug 2005 15:58:03 -0700

Syntax issue... 0059 is seen as a number hence the 59.

Aliases can't start with a number.... I assume your query is going into a
form or report. Set the caption their not in SQL.

Regards....

sorry I didn't really help.
.

References:
- Field name truncation
  - From: Ron Sellers

Prev by Date: Re: DISPLAY ONLY IF PART# if is in all three locations.
Next by Date: RE: Delete Query problems
Previous by thread: Field name truncation
Next by thread: Re: Field name truncation
Index(es):
- Date
- Thread

Relevant Pages

Action URL
... I have a syntax issue. ... I can run the last line of this query in the ... MDX sample application and get results. ... Prev by Date: ...
(microsoft.public.sqlserver.olap)
URL Action
... I have a syntax issue. ... I can run the last line of this query in the ... MDX sample application and get results. ... Prev by Date: ...
(comp.databases.olap)
Format Date in GroupBy query
... What is the syntax for a query that will give me the Count of [PartID] ... Prev by Date: ...
(microsoft.public.sqlserver.mseq)
calling modules syntax
... the syntax to call my procedure from a query. ... Basically all i want is to be able to compare two numbers (contained in two ... Prev by Date: ...
(microsoft.public.access.modulesdaovba)
Re: Using queries in a table adaptor?
... When added a query ... I then added the two queries shown in the original message. ... columns with an aliases and returns one row. ... I did not need them explicitly because I bound them to a C1 flex grid. ...
(microsoft.public.dotnet.framework.adonet)