General information
Title:
View definition has been changed
My form runs this view first and works every time:
SELECT Btstorge.store_type, Btstorge.location, SPACE(8) AS co_id,;
SPACE(5) AS info_type, CTOD("12/12/12") AS finan_dt, Btstorge.max,;
Btstorge.nbr_boxes, Btstorge.user_id, Btstorge.added, Btstorge.modified;
FROM bt!Storage Btstorge;
WHERE Btstorge.store_type = "B";
AND Btstorge.nbr_boxes = 0
Immediately after, it runs this view and often gives me the error View definition has been changed, but not all the time:
SELECT Btstorge.store_type, Btstorge.location, SPACE(5) AS info_type,;
CTOD("12/12/12") AS finan_dt, Btstorge.nbr_boxes, Btstorge.max,;
VAL(STR(0)) AS qty;
FROM bt!Storage Btstorge;
WHERE Btstorge.store_type = "S";
AND Btstorge.max > Btstorge.nbr_boxes;
ORDER BY Btstorge.location
I found that if I put Open Database BT before the problem view, it works each time. Can anyone give me a clue as to what in the second view is different that would cause this issue and why the first one always works?
Thanks!
Sally
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only