topic-26609

Posts: 1303

Joined: Tue Jul 21, 2009 08:12 AM

campos numericos Access para ADO/SQL
Posted: Fri Jun 21, 2013 01:05 PM

Hola,

Me gustaría preguntaros para los campos decimales qué tipo de campo en Access utilizáis.

Muchas gracias.

Muchas gracias. Many thanks.

Un saludo, Best regards,

Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producción]

Implementando MSVC 2010, FWH64 y ADO.

Abandonando uso xHarbour y SQLRDD.

Rick Lipkin

Posts: 2706

Joined: Fri Oct 07, 2005 01:50 PM

Re: campos numericos Access para ADO/SQL
Posted: Fri Jun 21, 2013 03:16 PM

Lucas

You can define an Access field as Number\Decimal or Currency and specify your decimals.

Rick Lipkin

lucasdebeltran

Posts: 1303

Joined: Tue Jul 21, 2009 08:12 AM

Re: campos numericos Access para ADO/SQL
Posted: Fri Jun 21, 2013 09:01 PM

Thank you Rick, but I need please the SQL SENTENCE to compare with my code.

Thanks.

Muchas gracias. Many thanks.

Un saludo, Best regards,

Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producción]

Implementando MSVC 2010, FWH64 y ADO.

Abandonando uso xHarbour y SQLRDD.

Rick Lipkin

Posts: 2706

Joined: Fri Oct 07, 2005 01:50 PM

Re: campos numericos Access para ADO/SQL
Posted: Sat Jun 22, 2013 01:56 PM

Lucas

Here is a script to create the table "Labor" which has a mix of different attributes for Currency, Integer and Decimals, and creating a primary key.. Hope this is what you are looking for ?

Rick Lipkin

Code (fw): Select all Collapse

   cSQL := "CREATE TABLE Labor"
   cSQL += "( "
   cSQL += "[LaborEid]         COUNTER NOT NULL, "
   cSql += "[Repair Number]    INTEGER DEFAULT 0, "
   cSQL += "[Employee Number]  SMALLINT DEFAULT 0, "
   cSQL += "[Tech Name]        Char(25) NULL, "
   cSQL += "[Actual Rate]      DECIMAL(7, 2) DEFAULT 0, "
   cSQL += "[Flat Rate]        DECIMAL(7, 2) DEFAULT 0, "
   cSQL += "[Description]      Char(100) NULL, "
   cSQL += "[Total]            DECIMAL(9, 2) DEFAULT 0, "
   cSql += "[Key]              INTEGER DEFAULT 0, "
   cSQL += "CONSTRAINT PK_LABOR PRIMARY KEY ( LABOREID )"
   cSQL += " )"

   // not part of table script but how to create a numeric Currency field
   //  cSql += "[Fee]             Money    Default 0, "

FiveTech Support Forums

Continue the discussion