Re: SQL syntax error

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

hi,

yanto wrote:
and I got an error.
curPrice is textbox control
The regional setting is using comma instead of point (US decimal
format)
Aha, how should the string (text) know that it is a currency value?

You have to convert it first:

".. SET UnitPrice = " & CCur(curPrice.Text) & " .."

And take a look at the Replace() function.


mfG
--> stefan <--
.

Relevant Pages

  • Re: CDBL Function truncates decimals
    ... Is there a way to format a number into US ... Public Function ConvertNumberforSQL (ByVal sValue As String, ... Since the Spanish formatting has a comma, the SQL statement seems to have ...
    (microsoft.public.vb.general.discussion)
  • Re: Handling floating point with decimal comma separator to filter a form
    ... Lets say the user wants to filter values between 1,1 and 1,9 (note that the user wiil enter the number with a comma sparator, not with a dot - and the Standard format will be of no help here). ... Dim strWhere As String ...
    (microsoft.public.access.formscoding)
  • Re: How to convert International number strings to their number va
    ... format uses a comma, then the Number format should honor that. ... >>The JavaScript Numberfunction does not work correctly. ... >>convert a string that contains a comma to a number. ...
    (microsoft.public.scripting.jscript)
  • Re: Concatenated numerical literals
    ... commas and currency symbol and hacked it a little to make ... import types, string ... This function will take the number passed to it and format it as US ... comma separators and two decimal places ...
    (comp.lang.python)
  • Re: Date format detection
    ... Specifies the locale for which the date string is to be formatted. ... date format for this locale. ... the system default-date format for the specified locale. ... be enclosed within single quotation marks in the date format picture. ...
    (borland.public.delphi.thirdpartytools.general)