Table Read-only error.

Thread View: borland.public.intrabuilder.data.sql

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Scott Josephson Thu, 30 Apr 1998 00:00

#69

Author: Scott Josephson
Date: Thu, 30 Apr 1998 00:00

21 lines
1163 bytes

When I assign the following SQL statement to the Sql Query property I
get a database engine error message: "Table Read-Only".

SELECT ITEMS.LATIN_NAME,ALL_INVENTORY.TREE_SIZE ,
ALL_INVENTORY.SIZE_UNITS , ITEMS.IMAGE
FROM ITEMS,ALL_INVENTORY
WHERE ( (ALL_INVENTORY.LATIN_NAME = ITEMS.LATIN_NAMES) AND
(ITEMS.LATIN_NAME = "Magnolia GranDihora Migtig") AND
(ALL_INVENTORY.TREE_SIZE = 8 ) AND ( ALL_INVENTORY.SIZE_UNITS = "feet" )
)

 ALL_INVENTORY is defined as a view in the Interbase database I am
using.
This SQL statement works when I plug it into the Interbase's SQL tool.

Why is this happening?

Thanks.

Scott

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads