Help to store in Ms Access

[Vinay Patel]

hi All

Q1.
i want to store string like

" vinay's home " in access database using vb.net

but my query get dropped because of " ' " in string input

and it become

Qry="Insert into info values('vinay's home')

i got error in this case so any one knows

how can i resolve it ??


Q2
is there any way to create store procedure for Access database if yes
than how ?


Waiting for Reply

Thanks in advance

With Regards

Vinay Patel

 

[Rad [Visual C# MVP]]

hi All

Q1.
i want to store string like

" vinay's home " in access database using vb.net

but my query get dropped because of " ' " in string input

and it become

Qry="Insert into info values('vinay's home')

i got error in this case so any one knows

how can i resolve it ??

Q2
is there any way to create store procedure for Access database if yes
than how ?

Waiting for Reply

Thanks in advance

With Regards

Vinay Patel

Two options
1) Use parameterized queries (OleDB commands using OleDbParameters)
2) Replace all ' with '' using the String.Replace method

 

[Cor Ligthert [MVP]]

Hi Vinay

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acfundsql.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acintsql.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acadvsql.asp

I hope this helps a little bit?

Cor

 

[sloan]

Open up the database.

Add a new Query. Change the type to "Updateable" I think it is.

Start out with something simple like

qryCustomerUpdate

Maybe supply 2 parameters

pCustomerID , pLastName

and the query is

Update Customer Set LastName = pLastName where CustomerID = pCustomerID

the last time i did this (circa 2001 I think) i used to put 'p' s in for
parameters, to increase readability, since there is no @variableName like in
sql server.

It's something along those lines.