 | | From: | Charles | | Subject: | sql help | | Date: | Sun, 16 Jan 2005 01:55:21 -0500 |
|
|
 | What is the syntax for selecting a folder across a network using a variable for the folder name?
Charles
|
|
| | From: | Roland Wingerter | | Subject: | Re: sql help | | Date: | Sun, 16 Jan 2005 14:23:09 +0100 |
|
|
| Charles wrote:
> What is the syntax for selecting a folder across a network using a
> variable for the folder name?
-----
The recommended way is to set up a database alias and use that.
Roland
|
|
| | From: | Charles | | Subject: | Re: sql help | | Date: | Sun, 16 Jan 2005 16:00:13 -0500 |
|
|
| Roland Wingerter Wrote:
> Charles wrote:
> > What is the syntax for selecting a folder across a network using a
> > variable for the folder name?
> -----
> The recommended way is to set up a database alias and use that.
>
> Roland
What I had before I upgraded to XP and lost the use of Lantastic was to store the path in a database file. I will end up using an alias, but I need a quick fix for now.
Charles
>
|
|
| | From: | Silvio Genco | | Subject: | Re: sql help | | Date: | Sun, 16 Jan 2005 13:47:59 +0100 |
|
|
| "Charles" ha scritto nel messaggio
news:whC9Yh5%23EHA.708@news-server...
> What is the syntax for selecting a folder across a network using a
variable for the folder name?
>
> Charles
Vpath = "YourPath\YourFile"
StrSql = "select * from '"+Vpath+"'"
q = new query()
q.sql = StrSql
q.active = true
Silvio
|
|
| | From: | Charles | | Subject: | Re: sql help | | Date: | Sun, 16 Jan 2005 15:57:13 -0500 |
|
|
| Silvio Genco Wrote:
> "Charles" ha scritto nel messaggio
> news:whC9Yh5%23EHA.708@news-server...
> > What is the syntax for selecting a folder across a network using a
> variable for the folder name?
> >
> > Charles
>
> Vpath = "YourPath\YourFile"
> StrSql = "select * from '"+Vpath+"'"
> q = new query()
> q.sql = StrSql
> q.active = true
>
> Silvio
Thanks!
|
|
| | From: | Charles | | Subject: | Re: sql help | | Date: | Sun, 16 Jan 2005 23:13:11 -0500 |
|
|
| Silvio Genco Wrote:
> "Charles" ha scritto nel messaggio
> news:whC9Yh5%23EHA.708@news-server...
> > What is the syntax for selecting a folder across a network using a
> variable for the folder name?
> >
> > Charles
>
> Vpath = "YourPath\YourFile"
> StrSql = "select * from '"+Vpath+"'"
> q = new query()
> q.sql = StrSql
> q.active = true
>
> Silvio
I tried to put this in the module, but it give the error that the path and database does not exist. When I check the value of the variable it does show correctly. Is this something that just won't work in modules?
Charles
|
|
| | From: | David Stone | | Subject: | Re: sql help | | Date: | Sun, 16 Jan 2005 23:26:15 -0800 |
|
|
| Charles wrote:
> I tried to put this in the module, but it give the error that the path and database does not exist.
Did you try it from the command line (or from a prg) using the literal path/filename string instead of the variable?
David
|
|
| | From: | Charles | | Subject: | Re: sql help | | Date: | Mon, 17 Jan 2005 22:04:08 -0500 |
|
|
|
David Stone Wrote:
>
> Did you try it from the command line (or from a prg) using the literal path/filename string instead of the variable?
>
> David
I tried it in a module with both the literal and variable. The literal works fine, but the variable does not.
Charles
|
|
