Why doesn't sc_lookup work in menu events?

Applications Menu / Menu Tree
#1

[h=2]Why doesn’t sc_lookup work in menu events?[/h] [SIZE=11px][FONT=inherit][SIZE=13px]The “Help” file says sc_lookup should work in menus. Specifically in onApplicationInit, onExecute, and onLoad[/SIZE][/SIZE]
[/FONT]

Assuming valid parameters and an established data connection why does
$check_sql = “SELECT Company Name FROM tbl_companies LIMIT 1” ;
sc_lookup(rs, $check_sql);
fail code generation with the meaningless logged error message () :
Thanks

#2

Hey man, menu has only 3 events :slight_smile:
I used onLoad, with lookup , no problems. there is something with your database/table. test your query first in database / sql builder, success