Code: Select all
Let>SQL_query=SELECT * FROM cad_file_data WHERE folder_='k:\se\0d140';
Let>DB_connection=Provider=MSDASQL.1;Persist Security Info=False;Data Source=seeeds_server
DBConnect>DB_connection,dbH
DBQuery>dbH,SQL_query,DB_r,DB_n,DB_f,1
DBClose>dbH
//the () or lower() will crash the script
Let>SQL_query=SELECT * FROM cad_file_data WHERE lower(folder_)=lower('k:\se\0d140');
Let>DB_connection=Provider=MSDASQL.1;Persist Security Info=False;Data Source=seeeds_server
DBConnect>DB_connection,dbH
DBQuery>dbH,SQL_query,DB_r,DB_n,DB_f,1
DBClose>dbH