main logo
Subject: SQL string functions
Author: "Carlo Sacchetti"
Posted: 2002/06/25 10:14:19
 
View Entire Thread
New Search


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
<-- Prior Message New Search Next Message -->