sql :table does not exist or alias is not currently open

#11

Bertil Isberg wrote:

Quote:

marco

db.open("albe") ; and not db.open("PRIV")
...
sq=sql

/*
ALIAS: priv
*/

Opening albe and specifying :PRIV: inside the SQL comment should make
Paradox totally confused.

It "Should" but i does not because it does not care for DML.
"albe" was opened for previous sql using tables in "albe"

Quote:

The comment was once needed if you wanted to get
the answer table in an in-memory cursor , but then it had to be the same
alias as the opened database-variable.

Specifying a different database in the SQL-comment has never come to my
mind.

I understand you. Does this following code work with pdx>7? Which
database do you open?

--------------------------------
db.open("any"); or "albe" or "priv"
sq=sql
select c.numero,c.tp,m.bof
from "

riv:~contratto" C, ":albe:movi" M
where c.numero=M.numero
-------------------------------

#12

Marco

This one works in P11 build 410

var
sqlhandle sql
db database
endvar

db.open(":Test:")

sqlHandle=sql

SELECT DISTINCT d."Order No", d."Customer No", D1.Name, D1.Street
FROM ":Sample

rders.db" d, ":BUGGAR:Customer.DB" D1
WHERE
(D1."Customer No" = d."Customer No")
ORDER BY d."Order No", d."Customer No", D1.Name, D1.Street
endsql

try
sqlHandle.executeSql(db, ":WORK:X1")
onfail
errorshow()
endtry

db.close()

--
Bertil Isberg - CTECH
Paradox buglist:
online: http://hem.bredband.net/bertilisberg/

"marco" <n_sp_hum_marco.foglia (AT) tucsoft (DOT) com> skrev i meddelandet
news:461ab296$1_5 (AT) news (DOT) bluewin.ch...

Quote:

Bertil Isberg wrote:
marco

db.open("albe") ; and not db.open("PRIV")
...
sq=sql

/*
ALIAS: priv
*/

Opening albe and specifying :PRIV: inside the SQL comment should make
Paradox totally confused.

It "Should" but i does not because it does not care for DML.
"albe" was opened for previous sql using tables in "albe"

The comment was once needed if you wanted to get the answer table in an
in-memory cursor , but then it had to be the same alias as the opened
database-variable.

Specifying a different database in the SQL-comment has never come to my
mind.

I understand you. Does this following code work with pdx>7? Which database
do you open?

--------------------------------
db.open("any"); or "albe" or "priv"
sq=sql
select c.numero,c.tp,m.bof
from "

riv:~contratto" C, ":albe:movi" M
where c.numero=M.numero
-------------------------------

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

sql :table does not exist or alias is not currently open

comp.databases.paradox comp.databases.paradox

Re: sql :table does not exist or alias is not currently open - 04-09-2007 , 04:39 PM

Re: sql :table does not exist or alias is not currently open - 04-15-2007 , 03:10 PM