Thanks Caveat!
This little helped to me!
A good example is worthy a thousand words!
Csaba
2012/1/19, Caveat :
> As Benoit says...
>
>> SQL quoting is automatically done by the following methods of the
>> Connection class: Exec(), Find(), Edit(), Delete(), Subst(), provided
>> that:
>
>> - You use
As Benoit says...
> SQL quoting is automatically done by the following methods of the
> Connection class: Exec(), Find(), Edit(), Delete(), Subst(), provided
> that:
> - You use "&1", "&2"... inside the request string to tell where
> quoted arguments must be inserted.
> - You actually pass thes
Some more clarification of my problem:
I had two procedures to communicate with the sqlite database:
Public Sub Trans(be As String) As String
Dim atmen As String
atmen = Replace$(be, "$", ".")
atmen = Replace$(atmen, "€", "-")
atmen = Replace$(atmen, "_", " ")
atmen = Replace$(atmen, "£", "/")
atm
I'm sorry Benoit,
I would like to ask your help with this kind of insertions:
If I have a table called MyTable with creation:
CREATE TABLE CENTRAL(VName Text,FPath TEXT,FName TEXT,FSubs
INTEGER,FSize REAL,FChanged TEXT);
How could I ensure the failsafe insert query with following fields:
VName->
Yes, Benoit. I'll check the documentation, since I always used the
Myconnection.Exec("SELECT FROM table WHERE field='"& myvar & "';) form
of the querying, and now I would like to change it to a more
convenient way, since I always had to assure myvar is safe.
2012/1/18, Benoît Minisini :
> Le 18/01
Le 18/01/2012 14:17, M. Cs. a écrit :
> Hi!
> Is there any built in function in Gambas3 which can secure the
> database connection from the errors caused by special characters?
>
> I have written functions for replacing the dangerous characters like
> ', +, . and so on, but I'd like to know whether
users
Reply-To: mailing list for gambas users
Subject: Re: [Gambas-user] Database question
M. Cs. wrote:
> Hi!
> Is there any built in function in Gambas3 which can secure the
> database connection from the errors caused by special characters?
>
> I have written functions for rep
M. Cs. wrote:
> Hi!
> Is there any built in function in Gambas3 which can secure the
> database connection from the errors caused by special characters?
>
> I have written functions for replacing the dangerous characters like
> ', +, . and so on, but I'd like to know whether there is a way to make
Hi!
Is there any built in function in Gambas3 which can secure the
database connection from the errors caused by special characters?
I have written functions for replacing the dangerous characters like
', +, . and so on, but I'd like to know whether there is a way to make
queries secure from failu
Werner a écrit :
> Jean-Yves F. Barbier wrote:
>> Hi,
>>
>> Based on Database example, is there a possibility to send parms to another
>> Form? (i.e. table's name & fields' names)
>>
>> JY
>>
> If you want to access objects on a different form you need to set
> Menu Project-->Properties-->Option
Jean-Yves F. Barbier wrote:
> Hi,
>
> Based on Database example, is there a possibility to send parms to another
> Form? (i.e. table's name & fields' names)
>
> JY
>
If you want to access objects on a different form you need to set
Menu Project-->Properties-->Options "Form controls are public" t
Hi,
Based on Database example, is there a possibility to send parms to another
Form? (i.e. table's name & fields' names)
JY
--
Yes, but will I see the EASTER BUNNY in skintight leather at an IRON
MAIDEN concert?
--
Ente
12 matches
Mail list logo
