Let's say you have an excel or csv file with random records and you want to use mass update functionality to update those records. First thing to do is to prepare an expert search query like "number isin {"IM10007", "IM10014"}". But, what if you have more than a thousand records on that file. Well, this small html will help you to prepare simple expressions with isin clause that you can use in expert search utility. Keep in mind that you may have to divide the queries due to the limit of where clause string which is 64k.
Error message that you might end up is: error: the where clause string exceeds 64k (se.search.engine,select.records)
Error message that you might end up is: error: the where clause string exceeds 64k (se.search.engine,select.records)
Note: fvlogger is used for logging functionality.
Take a look and don't hesitate to report a bug, if you find any;)
http://91.93.147.39:8080/SM/sorguhazirlama.html
Hiç yorum yok:
Yorum Gönder