Problem on String

[Agnes]

my simple commandtext is ="update mytable set equipname = ' " &
Me.txtEqip.text & " ' " ... where
Now, if Me.txtEqip.text = 20' <-----------I will got the error on this
command,
Please help ~

 

[smith]

Option Strict On?

Same thing happen with Me.txtEquip.text = "20" ?

What exactly is the exception?

 

[Hal Rosser]

Option Strict On?

Same thing happen with Me.txtEquip.text = "20" ?

What exactly is the exception?

Check the database - does it allow non-numeric characters ? How many ?
What type of data is allowed ? Can more than 1 record have the same value
for that field ?

 

[Herfried K. Wagner [MVP]]

my simple commandtext is ="update mytable set equipname = ' " &
Me.txtEqip.text & " ' " ... where
Now, if Me.txtEqip.text = 20' <-----------I will got the error on this
command,

Think about using '*UpdateCommand' classes with parameters instead of
constructing the SQL command directly. This will prevent SQL injection.
Maybe you can solve your problem by replacing "'" with "''" before inserting
it into the SQL command (if you still want to use the unsecure way of
constructing SQL command strings by hand).

 

[C-Services Holland b.v.]

my simple commandtext is ="update mytable set equipname = ' " &
Me.txtEqip.text & " ' " ... where
Now, if Me.txtEqip.text = 20' <-----------I will got the error on this
command,
Please help ~

You need to parse your values to replace single quotes with double
quotes. The resulting query you have now looks like this:

update mytable set equipname = ' 20''

That's one quote to many. If Me.txtEqip.text contains 20'' it should
work and enter only one quote into the database. This is especially
important for web applications to prevent SQL injection.