[V4MD] tableName variable query

[info at vallemediatime.com]

Thanks,
it's very simple, 
but often I try complicated and bad solutions, sorry  :-)

----- Original Message ----- 
From: "Ruslan Zasukhin" <sunshine at public.kherson.ua>
To: <valentina at lists.macserve.net>
Sent: Monday, June 06, 2005 9:08 AM
Subject: Re: [V4MD] tableName variable query


> On 6/6/05 10:02 AM, "info at vallemediatime.com" <info at vallemediatime.com>
> wrote:
> 
> Hi Paolo,
> 
> > I need to know how to write in a SQL query the tableName as variable
> 
> > -- query = "SELECT RecID, * from STUDENTS" -- this works
> 
> 
> > -- Look here: this don't works...
> > query = "SELECT RecID, * from '" & TableName & "'"
> > 
> > -- ...and give me a alert "unespected token: STUDENTSI"
> 
> Right, look on query which works.
> You do NOT have single quotes around STUDENTS
> 
> So why you have them when you use concat ?
> Should be as
> 
>      query = "SELECT RecID, * from " & TableName
> 
> -- 
> Best regards,
> 
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
> 
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
> 
> [I feel the need: the need for speed]
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
> 
> 
> 
> -- 
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.322 / Virus Database: 267.5.1 - Release Date: 02/06/2005
> 
>