Apps [Q] help scripting sooo close

[dcooterfrog]

i am so close
I was able to manipulate a database using sqlite
and wrote the following script

#stuff

su
sqlite3 /data/data/com.nitrodesk.drois20.nitroid/databases/windroid.db <<SQL_ENTRY_TAG_1
    update table
    set boolean=0 ;
    commit;
    .exit
SQL_ENTRY_TAG_1
exit

and called it xxx.sh
i can navigate to the directory and cat the file

cat xxx.sh

shows properly
if I drop in to su and try to execute it I get

xxx.sh not found

chmod 777 xxx.sh
did not help

when I get it to work for sure
i will add it to the phone priortizer app and schedule it.

 

[pworcester]

try this;
#./xxx.sh

 

[dcooterfrog]

try this;
#./xxx.sh

$su
#./xxx.sh

 ./xxx.sh: permission denied

what was that supposed to do run or change permissions

#chmod 777 ./xxx.sh

resulted in o message
#ls -l shows
----rwxr-x system sdcard_rw 245 data time xxx.sh

why not rwxrwxrwx

 

[dcooterfrog]

doh can't run a script form the sd card

 

[savoxis]

Yes, you can

call sh to run it:

sh /sdcard/xxx.sh

 

[dcooterfrog]

Yes, you can

call sh to run it:

sh /sdcard/xxx.sh

I'll try that.
I solved my problem another way. I just added a database trigger to unchanged a change made by the program that I wanted to stop. Actually cleaner than my first idea. Which was to run a script every x hours.
Thanks