Hi John,
I'm not sure that I understand your question. Maybe you have a network
server with a Paradox table on it? (Paradox being a desktop DB with no
DB Server). If you were using the BDE and you set up an alias in BDE
Administrator, then you might use something like the following (from a
dfm file). Ignore the fact that it's a TwwQuery and that it has a parameter.
object qryPurchases: TwwQuery
DatabaseName = 'MyAlias'
SQL.Strings = (
'Select L."Part Code", L.Description, L."Date Due"'
'From POLine L'
'Where L."PO Number" = :PONumber'
'Order By L."Part Code"')
ParamData = <
item
DataType = ftInteger
Name = 'PONumber'
ParamType = ptInput
end>
end
Not sure if this helps.
Cheers,
Craig.
John wrote:
Hi all
How can I select a server's table (Paradox)?
Neither of the following seems to work:
select name
from ESLConsents.users
select name
from [EMAIL PROTECTED]
select name
from users:ESLConsents
Any suggestions at all?
John
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
