Problem with Text Field

C

cnicolapc

Active Member
Licensed User
Longtime User
Hi,

I have a problem with text fields in a SQL database.

When in a text field of a SQL Databse insert the apostrophe me an error sintax.
Example: If a text field called TITLE Enter VENT'ANNI generates error sintax while if I enter VENT ANNI no generates error
It happens both with INSERT and UPDATE.
How can I solve this problem.
Thanks in advance
Nicola
 
Sort by date Sort by votes
G

glook

Member
Licensed User
Longtime User
In a regular SQLite INSERT or UPDATE you can escape a single quote by adding another one.

Or if you are able to use a "parameter" insert, as it is possible with B4A, then you do not need to worry - the single quote will be accepted.

sql.ExecNonQuery2(INSERT INTO mytable VALUES (?,?), Array as Object(data1,data2))

The single quote escape way is for SQLite in any language. I sometimes write a little subroutine to replace all single quotes with 2 single quotes and then wrap the string with a quote at each end, ready for SQLite.
 
Last edited:
Upvote 0
D

Deleted member 103

Guest
Ciao Nicola,

prova questo:
try this:

PHP: 
dim ventanni as string
ventanni="VENT'ANNI"

ventanni=ventanni.Replace("'","''")

L'apostrofo si deve raddoppiare.
The apostrophe should be doubled.

Ciao,
Filippo
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Question
Android Question [SD_SQL] Read image field
Replies
1
Views
141
vecino
R
  • Question
Android Question Set font size of text fields in B4XPreferencesDialog
Replies
3
Views
179
RB Smissaert
R
A
  • Solved
Android Question B4XFloatTextField - Find view with tag problem
Replies
2
Views
272
amiiir74a
A
  • Locked
Bug? Security problem with the reveal functionality in a B4X FloatTextField?
Replies
1
Views
565
Erel
E
  • Solved
Android Question InputTemplate resize TextField1
Replies
3
Views
1K
Mahares
M
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…