A Query and Capability not supported error 
Author Message
 A Query and Capability not supported error

Hi

I have a problem with a query which is baffling me.  I have a query which I
build dynamically using SQL statements.  For some reason the query fails
with a Capability not supported error.

If I remove one line from the query the query works ok.

The line in question is marked below with ***.  I can run the query in
Access and the query works.  We are using delphi 3 with the latest version
of the BDE.

Any ideas?

Cheers

Brett

SELECT [genMotherboard].[ID],
[Manufacturer].[Manufacturer],
[Motherboard Models].[Model],
[genMotherboard].[ISA Slots],
[genMotherboard].[PCI Slots],
[genMotherboard].[AGP Slots],
[genMotherboard].[Memory Slots],
[Pointing Device Interface].[Interface],  ***
[Keyboard Interface].[Interface],
[Serial Port Types].[Type],
[Printer Interface Type].[Interface Type],
[USB Types].[Type],
[genMotherboard].[Onboard Devices],
[genMotherboard].[Processor Slots],
[Memory Capacity].[Capacity],
[BIOS Type].[Bios]

FROM [genMotherboard],
[Manufacturer] [Manufacturer],
[Motherboard Models] [Motherboard Models],
[Pointing Device Interface] [Pointing Device Interface],
[Keyboard Interface] [Keyboard Interface],
[Serial Port Types] [Serial Port Types],
[Printer Interface Type] [Printer Interface Type],
[USB Types] [USB Types],
[Memory Capacity] [Memory Capacity],
[BIOS Type] [BIOS Type]

WHERE [genMotherboard].[Manufacturer]=[Manufacturer].[ID]
AND [genMotherboard].[Model]=[Motherboard Models].[ID]
AND [genMotherboard].[Mouse Port]=[Pointing Device Interface].[ID]
AND [genMotherboard].[Keyboard Port]=[Keyboard Interface].[ID]
AND [genMotherboard].[Serial Ports]=[Serial Port Types].[ID]
AND [genMotherboard].[Printer Ports]=[Printer Interface Type].[ID]
AND [genMotherboard].[USB Ports]=[USB Types].[ID]
AND [genMotherboard].[Max Cache]=[Memory Capacity].[ID]
AND [genMotherboard].[BIOS]=[BIOS Type].[ID]



Wed, 18 Jun 1902 08:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Capability Not Supported Error

2. Error: 'Capability not supported'

3. sql capability not supported error

4. SQL error - capability not supported...Why ?

5. Capability Not supported.....why not?

6. capability not supported

7. capability not supported

8. Capability Not Supported, Delphi 4, Oracle 8

9. "capability not supported" w/MSAccess DB

10. Capability not supported - runtime only???

11. capability not supported

12. SQL capability not supported

 

 
Powered by phpBB® Forum Software