Senanayake Google Drive Issue

First check the number of files

select pcode,count(pcode) from tblGoogleDriveUpload_UploadLog where isdel = 0 group by pcode

Before remove the temp files first empty the drive folder id by run this query

update tblpcenter set googledrivefolderid= '' where pcode='AL'

⁠

⁠

use flexinfo_fitinvsena

select pcode,count(pcode) from tblGoogleDriveUpload_UploadLog where isdel = 0 group by pcode

select * from tblpcenter where pcode='AL'

update tblpcenter set googledrivefolderid= '1ITJXpY0HUQKIyOGKCg3jAvuZbW0-yD13' where pcode='AL'

update tblpcenter set googledrivefolderid= '' where pcode='AL'

update tblGoogleDriveUpload_UploadLog set isdel = 1 where isdel = 0 and pcode='AL'

--select * from tblGoogleDriveUpload_UploadLog

After the remove docs from temp folder run this query first

update tblGoogleDriveUpload_UploadLog set isdel = 1 where isdel = 0 and pcode='AL'

2. Then Update the folder ID

update tblpcenter set googledrivefolderid= '1ITJXpY0HUQKIyOGKCg3jAvuZbW0-yD13' where pcode='AL'

This link can't be embedded.

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.