Thank you, Simon and Igor. I will investigate about your opinion, as you mentioned.
In general, if parameter string contains alphabets only, it doesn't make any problems. However, I couldn't check that my function is used correctly for every applications. Some developers don't know why does it fails when using special characters and applications can be packaged with hidden issues. For this reason, I was looking for some solutions that I can send warning messages to application developers if they use plain text without binding arguments. Best regards, Yongil jang. 2013. 4. 3. 오후 10:13에 "Igor Tandetnik" <i...@tandetnik.org>님이 작성: > On 4/3/2013 8:58 AM, Yongil Jang wrote: > >> For more information, >> I just made some functions that handling files path. >> But, if file name includes "Special characters(ex: '"') " or "Unicode" and >> it is used for myFunc() >> then it makes "Syntax error" error code and execution is failed. >> What I want to do is to make an "WARNING" message if parameter is not >> dynamic binding value for developers who would use myFunc(). >> > > If the string literal is syntactically invalid, any syntax errors would be > reported at the time the statement is prepared. Naturally, a statement with > syntax errors cannot be executed, so your function wouldn't be called in > the first place; of course, if it's not called, it can't issue any warnings. > > If your function is running, this means it's been given a valid string, > whether as a string literal or a bound parameter. > -- > Igor Tandetnik > > ______________________________**_________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
