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]
