This is a multi-part message in MIME format.
------=_NextPart_000_0005_01C21C6B.BE453440 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello Ruslan, I need understand how I can use string function ("locate") of SQL with = Valentina. The manual have a exemple like this: locate('bar','foobarbar')
Now I don't understand how I have to insert it in my string of SQL in = valentina. Exemple: myCursor =3D new(xtra "VCursor", getRef(gDB), "Select trova from = paragrafi where testo like 'amore'")
It is very important for me to learn this function. Can you help me? Can you send me a more precise exemple? Thanks
Carlo Sacchetti
------=_NextPart_000_0005_01C21C6B.BE453440 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Hello Ruslan,</FONT></DIV> <DIV><FONT face=3DArial size=3D2>I need understand how I can use = string=20 function ("locate") of SQL with Valentina. The manual have a = exemple like=20 this:</FONT></DIV> <DIV><FONT face=3DArial size=3D2>locate('bar','foobarbar')</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Now I don't understand how I have to = insert it in=20 my string of SQL in valentina.</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Exemple:</FONT></DIV> <DIV><FONT face=3DArial size=3D2>myCursor =3D new(xtra "VCursor", = getRef(gDB), "Select=20 trova from paragrafi where testo like 'amore'")</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>It is very important for me to learn = this=20 function.</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Can you help me? Can you send me a more =
precise exemple?</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Carlo = Sacchetti</FONT></DIV></BODY></HTML>
------=_NextPart_000_0005_01C21C6B.BE453440--
------=_NextPart_000_0005_01C21C6B.BE453440 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable ©2002 Carlo Sacchetti |