Re: how to do data type conversions in access

From: Dmitri Ivanov (di2va4nov_at_0_digits_for_spammers_0.aha.ru)
Date: 04/01/04 

Date: Thu, 1 Apr 2004 15:09:29 +0400

Hello Rance,
"Rance" <ntg-rhall@nctc.net> wrote:

R> I have a column in a database called case_count, when the database
R> was setup it was formatted as a charfield with 8 spaces, but the
R> values should have been integers. so, what ever the number of cases
R> the number is padded with enough extra zeros to make 8 chars (eg.
R> '00000034' as opposed to 34)
R> what I need is the result of "SELECT sum(CASE_COUNT) FROM
R> order_detal WHERE order_number='whatever'"

Have you tried the following:

 "SELECT sum(CLng(CASE_COUNT))
  FROM order_detal
  WHERE order_number='whatever'" ? 

--
Sincerely,
Dmitri Ivanov
Common Lisp ODBC interface - www.ystok.ru

Relevant Pages

  • Re: SetUp functions for multiple test cases
    ... couldn't find out how to implement a setup function, ... new database in-memory and fill it with example data for every single ... The True Unit Test Zealots will argue that all tests should be 100% ... SUnit from Smalltalk to Python: SUnit takes full advantage of ...
    (comp.lang.python)
  • [NEWS] Lawson Financials RDBMS Insecurity
    ... Beyond Security would like to welcome Tiscali World Online ... the database itself) to easily compromise the Lawson Financials' database. ... Setup #1 tends to be the preferred configuration method by Lawson ...
    (Securiteam)
  • Re: SetUp functions for multiple test cases
    ... couldn't find out how to implement a setup function, ... new database in-memory and fill it with example data for every single ... The True Unit Test Zealots will argue that all tests should be 100% ... should not interface with external resources like databases. ...
    (comp.lang.python)
  • Re: Word 2007
    ... I saved that database in each clients directory. ... forms setup to be merge documents. ... I had many choices setup for "if and if ...
    (microsoft.public.word.docmanagement)
  • Re: Self Contained SQL Database
    ... Can i use the setup project of the Visual Studio 8 to install my application ... I've decided that it cannot be done in one setup. ... merge module that combined your database and app with MSDE, ... attach our database and copy the utilities onto the server (using custom ...
    (microsoft.public.sqlserver.msde)
Loading