Hi,
Simpler than this, impossible: What do I need to set (and where) to fields declared as Integer (Number(15), I think) in Oracle be created as TIntegerField (and not TFloatField)?
I'd like that, when clicking "Add all fields" within the TFields Editor, those fields appear as TIntegerField...
Hi,
I have a simple query, written below, that is read-write. But when I set it as the detail of a master-detail relationship, it becomes read-only. The master query is read-write and has a master key. The detail query has a master key and a FK constraint with the master table. The queries...
Solved setting AssignedTeachers at the UpdatingTable property. As this query is read-only, no weird results are expected to happen. But this solution doesn't seem to be "obvious". Does it?
Forgot to write te message:
"Automatic Master/Detail configuration is only possible if a foreign key constraint exists between the master and the detail table.
Hi,
The below query is the detail in a master-detail relationship. When I set the Master property, I get the message "". There IS a FK constraint.
select id, name
from teachers
where
id not in (
select t.id as id
from assignedteachers at,
teachers t
where...