error during reading the names

[veer]

Hi!
i made a programe in which i want to print the names but
when the names like " Women's " which contain this " ' " sign it produces the syntax error
how can remove this error because i have to print this name in the same way

[QVeen72]

Hi,

Do Input Validation for the TextBox.. Dont Allow User to Enter '
Write This Code in KeyPress Event of the TextBox:

[code=vb]
If Chr(KeyAscii) = "'" Then KeyAscii = 0
[/code]

REgards
Veena

[veer]

Hi!
Actually i am accessing a file which already have these name
and through my programe i did some changing and then print all these names
thanks

Hi,

Do Input Validation for the TextBox.. Dont Allow User to Enter '
Write This Code in KeyPress Event of the TextBox:

[code=vb]
If Chr(KeyAscii) = "'" Then KeyAscii = 0
[/code]

REgards
Veena

[QVeen72]

Hi,

So you are getting error in SQL Select Statement..?
Print the Select statement here..

REgards
Veena

[veer]

this is my select statement
Select * From " & dbfname & " Where CMPNYNM='" & rsMn(0) & "'"

THANKS

Hi,

So you are getting error in SQL Select Statement..?
Print the Select statement here..

REgards
Veena

[QVeen72]

Hi,

Try this :

[code=vb]
sSQL = " Select * From " & dbfname & " Where CMPNYNM='" _
& Replace(rsMn(0) ,"'","''") & "'"
[/code]

Regards
Veena

[veer]

Thanks it's working
Yesterday i asked a question to you about comparision of two columns
actually i want a order of data like
company name ---------indent
Hadley Dodd ---------- 0
Hadley Dodd --------- D

above example means
i have a column contains some company names and other has some indents like 0,D,1 . Firstly the name " Hadley Dodd" with indent "0" comes and print and then if same name comes but indent should be "D" or "1" etc print and then go to next record and if the same name does't come then move to next record

if you understand the programe then please give me some tips how i can search the columns
thanks

Hi,

Try this :

[code=vb]
sSQL = " Select * From " & dbfname & " Where CMPNYNM='" _
& Replace(rsMn(0) ,"'","''") & "'"
[/code]

Regards
Veena

[QVeen72]

Hi,

I didnt understand your Problem..
But is it that you are Looking for "Order By"..?:

Try This :

Select * From MyTable Order By CompName, Indent

REgards
Veena

[veer]

Hi!
actually i have a file in which data is randomly inserted
and i am accessing that file which have two columns i,e Company_Name , Indent. In company_name column one name may be repeated saveral times but with different indents like "0","D","1" , "M" etc and i want the order like i have mentioned you in previous post

Hi,

I didnt understand your Problem..
But is it that you are Looking for "Order By"..?:

Try This :

Select * From MyTable Order By CompName, Indent

REgards
Veena

[QVeen72]

Hi,

So, is it a Text File..?
Means, You want To Parse a Text File..? How are the 2 Columns Seperated in the Text File ? (Any Special Characters To identify Column..?)

If not text file, and if it is Table, then use Select Statement (prev Post)

Regards
Veena

[veer]

No its a .dbf file
i think you are not understanding my programe i attach a sample of file in doc format in which two tables are made the table contained random data
and the second contain a order wise data


please check and give some idea

Hi,

So, is it a Text File..?
Means, You want To Parse a Text File..? How are the 2 Columns Seperated in the Text File ? (Any Special Characters To identify Column..?)

If not text file, and if it is Table, then use Select Statement (prev Post)

Regards
Veena

[QVeen72]

HI,

If it is a dbf File, Create a Connection to DBF and Open a Recordset for the selected file...

or else
Post the code here..

REgards
Veena