General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Found the problem. It was not a corrupt table. In all of my sql statements that select by a date range I use variables of startdate and enddate. I recently added a new field to the table (you guessed it) startdate. My sql statements were looking at the table startdate instead of the variable.
Example
select startdate;
from calls;
where calls.startdate >= startdate;
into cursor c1
I was under the assumption that if no table was given then the system looked vor a variable. OOPS.
Thanks for you advise.
Dennis
Previous
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