@, [ , ] in SQL (VB)

BKtje

Creating a database in Oracle using VB.

However when i try to enter a field using the above options (ie @ [ ]) i get an SQL statement error. This is very annoying for obvious reasons.
Is there any way around this? patches or the likes?

Thanks.

Typedef

BKtje

sorry i think you mis understand (or i do) but when entering a form into the database.
ie a mail address such as me@lookatme.com.
When i hit enter/save changes it gives me a SQL error and says database not updated. I can't expect clients to type me\@lookatme.com. or did you mean something else?

hussey

I can't expect clients to type me\@lookatme.com. or did you mean something else?

your right .. but we expect you to change the way it gets delivered

instead of
WHEN 'enter pressed' CALL FUNCTION:update database

have

WHEN 'enter pressed' CALL FUNCTION:checkfield THEN CALL FUNCTION:update database

where checkfield would change the value of
and check for other characters etc

Evil Phil

Aye, parse your String for special characters and add an escape sequence. Watch out for single and double quotes as well.

BKtje

ahhhh ok, think i gotcha

Thanks for the help!

Kernel32

You could use stored procedures as well and avoid those problems.