Omgili, forum search, forums search, search forums, discussion search,discussions search, search discussions, board search, boards search, search boards
  Advanced Search

RE: Nobody can answer! Problem with commas and dots

On Sun, 10 May 2009 22:40:01 -0700, Poppe <...@discussions.microsoft.com

Hello

It seems my fridays reply did not post here at all.

Anyways, i tried your code and we are close to the answer.

This code basically removes commas. I was thinking about the situation, and
concluded that what we need to accomplish is to convert all commas into dots,
and all dots into commas. This would result in perfectly working code, and it
wouldn't matter where the commas/dots are, as it changes every one of them.

For example:

100.000.000,50 -
222,222,222.50 -
I was trying to make the code work in this manner:

----------

1) Convert value to string.
2) Go the string through char by char.

If comma is detected -If dot is detected -
3) Keep track of changes, and in the end save changed value

----------

I'm having some trouble getting the code work, as it has to remember what
character has been checked already.

BR,
Poppe



On Mon, 11 May 2009 09:36:38 +0100, "Peter T" <peter_t@discussions

Did you see my reply to your Friday's post...

Regards,
Peter T

"Poppe" <...@microsoft.com...


On Tue, 12 May 2009 01:23:03 -0700, Poppe <...@discussions.microsoft.com

Hi

Thanks for your reply.

I was now able to find a permanent solution how to send the underlying data
to database. There is no longer need to manipulate data with strings, as it
sends variables like Double as real Double values.

The solution is accomplished by using ADO Command object events. Previously
i was only using ADO Connection events.

The data is now sent as it should, in "raw" mode and database accepts them
perfectly.

Thanks for everybody their help. I was able to learn more from your help.

BR,
Poppe