>>A view like this one (Allproperties)
>>
>>CREATE VIEW Allproperties AS;
>>SELECT DISTINCT Properties_list.property;
>> FROM Properties_list;
>> WHERE NOT EXISTS;
>> (SELECT SelectedProperties.Property;
>> FROM SelectedProperties,Machine_list;
>> WHERE SelectedProperties.Machine=?Machine_list.Machine;
>> AND SelectedProperties.Property==Properties_list.Property)
>>
>>
>>does not refresh properly when table buffering is enabled.
>>
>>Inserting a value in SelectedProperties will remove the value from
>>Allproperties only if buffering=3 (record)
>>
>>What´s to be done about that? And please don´t suggest setting buffering to 3!
>>
>>Help greatly appreciated!
>>
>>
>>Regards
>>
>>Peter
>
>Could you put post the code that inserts the value in SelectedProperties.Machine
>Is it possible to use a variable instead of using a value from a database for the parameter ?cMachine ?
Dan,
I don´t think a variable will do the trick, but then again, you never know.
The whole thing is a mover class, and I´d be glad to ship it, just send your e-mail address to support@post2.tele.dk.
Regards
Peter
Peter Pirker
Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?
(Woody Allen)