Baanboard.com

Go Back   Baanboard.com

User login

Frontpage Sponsor

Main

Baanboard at LinkedIn


Poll
What actions do you take to ensure compliance with the sanction/embargo lists published by the EU and the US?
don't know what you are talking about
55%
we are scanning customers, suppliers and employees using own programs on a regular basis
12%
each delivery/purchase adress is checked immediately with own programs
2%
we are using third party software for this purpose
10%
we simply don't bother
20%
Total votes: 49

Reference Content

 
quoted.string()
By patvdv at 26 Feb 2008 - 21:57

quoted.string()

Syntax

string quoted.string$( string_expr )

Description

quoted.string() assures that the contents of the variable can be used as a string for the query processor. If the string_expr contains a quote or double quote, the query processor will generate an error. This function inserts the necessary escapes for the string.

Note

These functions can handle multibyte characters.

Context

3GL functions.

Example

 query.extend.where("tcibd001.item <> """ & tibom010.mitm & """")   | WRONG
 query.extend.where("tcibd001.item <> " & quoted.string(tibom010.mitm))   | CORRECT

Related topics



0
No votes yet


All times are GMT +2. The time now is 02:00.


©2001-2008 - Baanboard.com - Baanforums.com