SQL

A

Amateur

I have my database on an external server.
If I would like to access the database report pages over the internet a
message box appears telling me that it could not find the data provider. The
pages are shown just without any data.
Someone told me that I have to change the SQL statement. If that is correct
can someone tell me how to do that so that the data is shown on my pages?
The database is on my ftp for www.bellfield-barna.com.

The SQL for my page looks as follows:
SELECT [Total Balance without open Position Query].[Customer ID:], [Total
Balance without open Position Query].[Bellfield Product:], [Total Balance
without open Position Query].[Initial Investment:], [Total Balance without
open Position Query].[Guaranteed equity], [Total Balance without open
Position Query].[Month starting balance:], [Total Balance without open
Position Query].[Sum Of Contract Value], [Total Balance without open Position
Query].Commission, [Total Balance without open Position Query].[Management
fee], [Total Balance without open Position Query].[Incentive fee], [Total
Balance without open Position Query].[Electronic fee:], [Total Balance
without open Position Query].VAT, [Total Balance without open Position
Query].[Adjustment:], [Total Balance without open Position Query].[Net
liquidation balance], [Open Orders Total Value Query].[Sum Of Open P & L],
[Open Orders Total Value Query].[Sum Of Initial Margin requirement], [Open
Orders Total Value Query].[Sum Of Maintenance Margin requirement], [Net
liquidation balance]+[Sum Of Open P & L]+[Sum Of Initial Margin
requirement]+[Sum Of Maintenance Margin requirement] AS [Open trade balance],
Date() AS BalanceTransferDate
FROM [Total Balance without open Position Query] INNER JOIN [Open Orders
Total Value Query] ON [Total Balance without open Position Query].[Customer
ID:] = [Open Orders Total Value Query].[Customer ID:]
WHERE ((([Total Balance without open Position Query].[Customer
ID:])="43001000-0000"));
Please , urgent help needed.
Thank you very much in advance
Klaus
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top