Escape sequence for Report control vs DB

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I am using XTP report control where user can type in I/P or import from any flat file.
While trying to type the following data, I am guessing there is a problem due to escaping is not done:
I/P: "tom cruise" <tomc@hotmail.com>
In DB: tom cruise" <tomc@hotmail.com>
Note: That is the left side quotes is missing in DB as well as in grid cell.

Is there any predefined function in XTP library for escaping and unescaping while saving and retrieving from SQLite DB from report control?

I want to escape entire data before it is saved into DB from report control.
Any suggestion would be greatly appreciable..

Thanks & Regards

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
rapid Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 11 March 2009 Status: Offline Points: 10	Post Options Post Reply Quote rapid Report Post Thanks(0) Quote Reply Topic: Escape sequence for Report control vs DB Posted: 01 February 2012 at 4:10am
	I am using XTP report control where user can type in I/P or import from any flat file. While trying to type the following data, I am guessing there is a problem due to escaping is not done: I/P: "tom cruise" <tomc@hotmail.com> In DB: tom cruise" <tomc@hotmail.com> Note: That is the left side quotes is missing in DB as well as in grid cell. Is there any predefined function in XTP library for escaping and unescaping while saving and retrieving from SQLite DB from report control? I want to escape entire data before it is saved into DB from report control. Any suggestion would be greatly appreciable.. Thanks & Regards