Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Reported for Version 3.25 » View Incident Report |
Serious |
Reported By: Donat Hebert Reported On: 9/18/2003 For: Version 3.25 Build 1 |
DROP TABLE IF EXISTS "CkRound"; CREATE TABLE IF NOT EXISTS "CkRound" ( "SField" CHARACTER(10), "F1" FLOAT, "F2" FLOAT, PRIMARY KEY ("SField") COMPRESS NONE LANGUAGE "ANSI Standard" SORT "Default Order" USER MAJOR VERSION 1 ); INSERT INTO "CkRound" VALUES ( "A" , 3 , 15) NOAUTOINC; INSERT INTO "CkRound" VALUES ( "B" , 3 , 14) NOAUTOINC; INSERT INTO "CkRound" VALUES ( "C" , 3 , 13) NOAUTOINC; Select SField, F1, F2, Round(f1/f2*100 to 2) as F3, Round(f1/f2*100 to 0) as F4 from CkRound;
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |