Visual Basic Discussion Boards

Rajesh Anuhya12-Nov-08 0:21

12-Nov-08 0:21

try this

Private Function validatedata(data As String) As Boolean
Dim innlop As Integer
For innlop = 1 To Len(data)
If IsNumeric(Mid(data, innlop, 1)) = False Then
validatedata = False
Exit Function
End If
validatedata = True
Next
End Function

Rajesh B --> A Poor Workman Blames His Tools <--

Re: Regular Expression in VB 6.0

indian14312-Nov-08 0:44

indian143

12-Nov-08 0:44

Hi,

Thanks good help, but can u please help me in doing the same by using the Regular Expression object.

Thanks,
Aleem Mohammad.

Thanks & Regards,

Md. Abdul Aleem
NIIT technologies

Re: Regular Expression in VB 6.0

Rajesh Anuhya12-Nov-08 0:54

Rajesh Anuhya

12-Nov-08 0:54

try to implement your self

Rajesh B --> A Poor Workman Blames His Tools <--

Re: Regular Expression in VB 6.0

indian14312-Nov-08 1:03

indian143

12-Nov-08 1:03

Hi,

Can anybody please tell me the pattern to take only the integer values as numerics and decimal values not. Like "90009" should be taken as numeric and "900.09" should be taken as non numeric.
Just give me one pattern.

Thanks,
Aleem Mohammad.

Thanks & Regards,

Md. Abdul Aleem
NIIT technologies

Re: Regular Expression in VB 6.0

Simon P Stevens12-Nov-08 1:15

Simon P Stevens

12-Nov-08 1:15

No one here is going to do your job for you for free.

I will be happy to write the code for you, but you will have to pay me my standard hourly rate of £1000 per hour.

If you don't want to pay, you will have to figure it out yourself. I've guided you as much as I can, I've given you links to all the information you need. You now need to go away and read those links and understand what needs doing.

Good luck.

Simon

Re: Regular Expression in VB 6.0

indian14312-Nov-08 1:33

indian143

12-Nov-08 1:33

Hi,

Can u please help whether I have any method or preperty in RegExp class to check if our expression is matching with the pattern, am asking u this as am new to VB 6.0. And intellisense is also not working for this object in my editor.

Thanks,
Aleem Mohammad.

Thanks & Regards,

Md. Abdul Aleem
NIIT technologies

Re: Regular Expression in VB 6.0

Simon P Stevens12-Nov-08 2:54

Simon P Stevens

12-Nov-08 2:54

No, sorry. I've given you enough links and suggestions. If you can't work it out yourself then you need to go and spend some time learning properly.

These links explain regular expressions in VB6. Read them.

http://www.regular-expressions.info/vb.html[^]

http://support.microsoft.com/kb/818802[^]

Simon

Re: Regular Expression in VB 6.0

Jon_Boy12-Nov-08 3:22

Jon_Boy

12-Nov-08 3:22

And if that isn't enough, download something like Expresso to help you test the expressions.

Cheers!

Any suggestions, ideas, or 'constructive criticism' are always welcome.

"There's no such thing as a stupid question, only stupid people." - Mr. Garrison

Re: Regular Expression in VB 6.0

Paul Conrad12-Nov-08 3:42

Paul Conrad

12-Nov-08 3:42

kissdznuts wrote:
download something like Expresso

I second that. It is a great tool, I have found it helpful many of times when dealing with regular expressions.

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

Re: Regular Expression in VB 6.0

indian14312-Nov-08 4:02

indian143

12-Nov-08 4:02

Hi,

Is it free download or costs some thing and another one is, can I replace some of the characters not matching with my regular expression, with null string.
If it is then it will be of great help for me.

Thanks,
Aleem Mohammad.

Thanks & Regards,

Md. Abdul Aleem
NIIT technologies

Re: Regular Expression in VB 6.0

Paul Conrad12-Nov-08 4:07

Paul Conrad

12-Nov-08 4:07

indian143 wrote:
it free download

Ummm, yes it is. Familiarize yourself with the search textbox at the top of this forum.

Here is your assignment: type in the word Expresso and then hit the Go! button. Hint: there are two articles done by Jim Hollenhorst that are both excellent.

Re: Regular Expression in VB 6.0

Jon_Boy12-Nov-08 6:09

Jon_Boy

12-Nov-08 6:09

Paul 'FTW'!

Any suggestions, ideas, or 'constructive criticism' are always welcome.

"There's no such thing as a stupid question, only stupid people." - Mr. Garrison

Re: Regular Expression in VB 6.0

Paul Conrad12-Nov-08 6:38

Paul Conrad

12-Nov-08 6:38

My assignment for him can't be that hard. Fine quotation from Mr. Garrison. Smile | :)

Re: Regular Expression in VB 6.0

Jon_Boy12-Nov-08 4:09

Jon_Boy

12-Nov-08 4:09

Free registration to unlock Expresso.

Enjoy!

Any suggestions, ideas, or 'constructive criticism' are always welcome.

"There's no such thing as a stupid question, only stupid people." - Mr. Garrison

Re: Regular Expression in VB 6.0

indian14312-Nov-08 3:37

indian143

12-Nov-08 3:37

Ok thanks for the help I got it but only one thing in last I want to ask you in this series is : please give me a pattern to mis the special characters like "@", "#" etc.

I have done it as below its working fine for charates, float all, but giving true when I add "@" or "#" to it. Can u please help in this.

Set objRegExp = New VBScript_RegExp_10.RegExp

   With objRegExp
       .Pattern = "\d{" & iLen & "}"
       .IgnoreCase = True
       .Global = True
   End With

   If iLen > 0 Then
        If (objRegExp.Test(sTemp) = True) Then
           IsNumericOnly = True
        End If
   End If

Thanks a Lot,
Aleem Mohammad.

Thanks & Regards,

Md. Abdul Aleem
NIIT technologies

SQL query problem

sunil goyalG11-Nov-08 22:53

sunil goyalG

11-Nov-08 22:53

hi all,
i run a query which update a field , is failed when it contains single or double quote.Otherwise it is running successfully. sample query is following
update table1 set name='abcd'efg'

please suggest how can i solve this problem ?

Re: SQL query problem

nishkarsh_k11-Nov-08 23:13

nishkarsh_k

11-Nov-08 23:13

sunil goyalG wrote:
update table1 set name='abcd'efg'

try this
update table1 set name='abcd\'efg'

' and \ are excape characters so one has to put "\" before them to send as proper query

Re: SQL query problem

sunil goyalG12-Nov-08 0:17

sunil goyalG

12-Nov-08 0:17

This solution is not works for me. query is failed. I am using SQL Server Express 2005

Re: SQL query problem

Nanda_MR12-Nov-08 20:00

Nanda_MR

12-Nov-08 20:00

use the instant of ' Asc char. It will work i also tried in my system it is working properly .

Ananda

Re: SQL query problem

Rajesh Anuhya11-Nov-08 23:59

Rajesh Anuhya

11-Nov-08 23:59

Perfect Query

update table1 set name='abcd''efg'

Rajesh B --> A Poor Workman Blames His Tools <--

Re: SQL query problem

bigsagal12-Nov-08 3:15

bigsagal

12-Nov-08 3:15

Any time you are updating a column which may contain a single quote, you must scan and replace the single quote with two single quotes. If your column contains 5 single quotes, your column will contain 10 single quotes after the scan and replace. During the update, two successive single quotes will be converted back to a single quote. For example, if your column contains 'abc'd''ef' before the scan and replace, your column will contain 'abc''d''''ef' after the scan and replace. After the update, your column in the database will contain your original column value namely 'abc'd''ef'.

bigsagal, confused as all get out!

Re: SQL query problem

Dave Kreskowiak12-Nov-08 3:15

Dave Kreskowiak

12-Nov-08 3:15

THe problem is that you are using string concantenation (newString = "SomeString" & "SomeOtherString") to build your SQL statement. Don't. Use parameterized queries instead and this problem is solved for you. Read this[^] article for why you should not be doing what you're doing and how to use parameters.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Typed dataset giving problem...

praveenkumar palla11-Nov-08 22:39

praveenkumar palla

11-Nov-08 22:39

I done one vb.net application which includes typed dataset (using SQL Server)

Dragged one required database table on to the xsd(typed dataset) and right click select query then
sqlstatement and then insert method and modified the populated query as required .

And in the code i am using the method(insert) created in the xsd(typed dataset)

The application is working fine in my local machine but when i moved the application to client machine (which uses another database but table and columns names and keys all are similar) there i am getting an exception
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections."

I also changed the database name in configuaration file (connection string-autogenerated when drag a table)

Please help on this and Thanks in advance.

Re: Typed dataset giving problem...

Rajesh Anuhya12-Nov-08 0:29

Rajesh Anuhya

12-Nov-08 0:29

i think this is not a dataset problem.,
first check the database connection in your client pc

Rajesh B --> A Poor Workman Blames His Tools <--

Re: Typed dataset giving problem...

Dave Kreskowiak12-Nov-08 3:13

Dave Kreskowiak

12-Nov-08 3:13

I think you asked this already. The problem is in the setup of the SQL Server. By default, it does not allow connections from remote PC's on TCP/IP. Go into the Configuration Manager and enable remote connections.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.