Programming with dBASE - Select question

Author

Select question

Charlie Lutz

2005-12-09, 8:23 pm

Can I use a memory variable in a select statement? The tables are not
in the database path, just in a temp folder.

This works:
[Select * from " c:\data\temp\mytable
"]

This is what I would like to work:
cPath = "c:\data\temp\"
"select * from cpath + mytable"

If I put in the complete path it works but I can't find the syntax for
the cPath variable (if it exist).

Thanks,
Charlie
--

____________________
________
Charlie Lutz
#1000441

Todd Kreuter

2005-12-09, 8:23 pm

Charlie Lutz wrote:
>
> Can I use a memory variable in a select statement? The tables are not
> in the database path, just in a temp folder.
>
> This works:
> [Select * from " c:\data\temp\mytable
"]
>
> This is what I would like to work:
> cPath = "c:\data\temp\"
> "select * from cpath + mytable"
>
> If I put in the complete path it works but I can't find the syntax for
> the cPath variable (if it exist).

Sure, something like:

sql = [Select * from '] + cPath + [MyTable']

--
Todd Kreuter [dBVIPS]

*Lysander*

2005-12-10, 7:23 am

In article <4399F9CE.5B72C355@dbvips.usa>, tkreuter@dbvips.usa says...

[color=darkred]
> Sure, something like:
>=20
> sql =3D [Select * from '] + cPath + [MyTable']

For me also works this:
private cPath
cPath =3D "c:\data\temp\"
'select * from "&cPath\<mytable>"'

As usual... dBL offers several ways to the target :)

ciao,
Andr=E9
=20

Charlie Lutz

2005-12-12, 9:23 am

In article <MPG. 1e03b4a61084e7a39896
b7@news.dbase.com>, Charlie Lutz
<lutzc@(remove)wes.army.mil> says...
> Can I use a memory variable in a select statement? The tables are not
> in the database path, just in a temp folder.
>
>
> This works:
Todd and Andr:

Many thanks. Obviously I had the right idea, just could not figure out
what combination of ['" I needed and in what order. It always boggles
me, they are all the same thing, except when they are not!

It works fine now.

Charlie
--

____________________
________
Charlie Lutz
#1000441

Sponsored Links