How do I return a real value from a calculation of 3 intergers. Below
is the sql staement I am trying to excute
UPDATE Shots SET Edit_Frequency = 120, Edited_Time =
(((Edited_Frame_Out-Edited_Frame_In)+1)/Edit_Frequency) WHERE Shot_Id
Here are the listed values
Edited_Time is defined as a Real data type of size 4 in my Table and
(Edited_Frame_Out & Edited_Frame_In & Edit_Frequency) are defined as
Int of size 4.
After running this Edited_Time equals 4 when I need it to equal
How can I make this happen?
Thanx in Advance