why is it only my first row of my sql table is being read :(
so I am trying to make this feature where the program checks the sql table every minute and if the due date is 5 minutes before the current date a notification is popped up to the users desktop screen. I am using Tulpep for the notifications, and the windows task scheduler to run the program in the background. now what happens is that the first row is read and thats not all the rows of my sql table. here is what the event viewer shows me when it does the task
Log Name: Application
Source: TaskReminderService
Date: 28/07/2024 21:50:35
Event ID: 0
Task Category: None
Level: Information
Keywords: Classic
User: N/A
Computer: Zeeshan
Description:
Sending notification for task: Watch the new movie , Description: new action film
Event Xml:
<Event xmlns="xxxxx">
<System>
<Provider Name="TaskReminderService" />
<EventID Qualifiers="0">0</EventID>
<Version>0</Version>
<Level>4</Level>
<Task>0</Task>
<Opcode>0</Opcode>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2024-07-28T20:50:35.1964862Z" />
<EventRecordID>62052</EventRecordID>
<Correlation />
<Execution ProcessID="xxxxx" ThreadID="x" />
<Channel>Application</Channel>
<Computer>Zeeshan</Computer>
<Security />
</System>
<EventData>
<Data>Sending notification for task: Watch the new movie , Description: new action film :D</Data>
</EventData>
</Event>
as you can see it only reads my first line of my sql table and stops and when the task runs again it still only reads the first line.
Log Name: Application
Source: TaskReminderService
Date: 28/07/2024 21:50:35
Event ID: 0
Task Category: None
Level: Information
Keywords: Classic
User: N/A
Computer: Zeeshan
Description:
Sending notification for task: Watch the new movie , Description: new action film
Event Xml:
<Event xmlns="xxxxx">
<System>
<Provider Name="TaskReminderService" />
<EventID Qualifiers="0">0</EventID>
<Version>0</Version>
<Level>4</Level>
<Task>0</Task>
<Opcode>0</Opcode>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2024-07-28T20:50:35.1964862Z" />
<EventRecordID>62052</EventRecordID>
<Correlation />
<Execution ProcessID="xxxxx" ThreadID="x" />
<Channel>Application</Channel>
<Computer>Zeeshan</Computer>
<Security />
</System>
<EventData>
<Data>Sending notification for task: Watch the new movie , Description: new action film :D</Data>
</EventData>
</Event>
as you can see it only reads my first line of my sql table and stops and when the task runs again it still only reads the first line.
