creating a table in a database?

[hipopony66]

Ok, I want to create a table in a database but I'm having one big problem. I don't want to do this through SQL. I'm a little familiar with the ADO control since I'm taking a VB class this semester. I plan to loop through a filelistbox obtaining information about the file and storing the different pieces of info as string variables. I will then add records to my created table based on the strings. The problem I'm having is that if one of the stored strings contains a ' then an error occurs. How can I get around this? Any help appreciated.

[The Hobo]

Why don't you want to use SQL? SQL = Magic.

[Dalceon]

could you give me an example of the code you are using?
I'm sure there's a way around it.

[The Hobo]

Originally posted by hipopony66
Ok, I want to create a table in a database but I'm having one big problem. I don't want to do this through SQL. I'm a little familiar with the ADO control since I'm taking a VB class this semester. I plan to loop through a filelistbox obtaining information about the file and storing the different pieces of info as string variables. I will then add records to my created table based on the strings. The problem I'm having is that if one of the stored strings contains a ' then an error occurs. How can I get around this? Any help appreciated.

Do this:

Replace(strYoureUsing, "'", "\\'")

[Dalceon]

that works??
I never knew that

[The Hobo]

\ is the escape character. If he's having a problem with ', it probably needs to be escaped. Although since I don't know what he's doing, I can't be certain that it will help.

Edits in bold.

[Dalceon]

Woo HOO I'm a lively member now.

Hey Hobo, are you really a HOBO??