I don't really want to get into an argument with
the topic police. I know the SQL is correct according
to the SQL standard and it works in the MS SQL query
analyser. I know that the C++ that sends the query to
the database correctly, because I can do
other queries which don't include aliases with the
same code. So I don't need any help from SQL experts.
My question is for users of the Visual C++ environment
which does support SQL. It has a data view feature and
it allows you to run SQL scripts directly. All I want
to know is if any one else has had difficulty with
aliases or there are any differences in syntax which
apply when running these scripts from the Visual
C++ program interface. For example, I have noticed that
some sample code uses square brackets on field names.
The error that gets produced refers to the exception
message that is returned when the database rejects the
script.
I will try the other group you suggested anyway though.
My question is basically f
Jack Klein <jackklein@spamcop.net> wrote in message news:<8kb320lkad0rkdq4dsibg89q983r92vthb@4ax.com>. ..[color=blue]
> On 4 Feb 2004 18:11:57 -0800,
bweep49@hotmail.com (Kevin) wrote in
> comp.lang.c++:
>[color=green]
> > I'm making my first attempt to put embedded
> > SQL in a visual C++ application and I'm
> > having trouble getting aliases to work.
> > If I try the following SQL query on MS SQL 7.0
> > it works fine.
> >
> > SELECT MTI.Mesh_Window_ID Window_ID FROM
> > Mesh_Transform_Indices MTI
> > WHERE MTI.Mesh_Window_ID = 200[/color]
>
> [snip]
>
> Sorry, you're off-topic here. The C++ language standard does not
> define or support "embedded SQL", and the stuff you wrote above is
> just a syntax error in C++.
>
> There should be support groups on Microsoft's server
> msnews.microsoft.com in the news:microsoft.public.* family.[/color]
