I am wondering if someone could help me please . I am trying to run a query
while select salesline where salesline.createdDate==systemDateget()
but when i execute either by job or on table my system goes crash . i have took to following step.
I can fetch the data by any other field like i can do
while select salesline where salesline.itemId==“A-Bh009”
it works fine . i have tried to run the same query on data base server it works fine .
i can retrieve the record from any other table like purchTable on the base of createdDate field.
So the only issue is with the salesline table where i cant fetch the record by date field . I am so confuse coz this is happening on test system as well .I would appreciate immediate help .