-=-
.
.....
  
| messages |
 
RSS
Direkomendasikan menggunakan brower Opera/Chrome/Firefox. Resolusi minimal 1024x768 | Powered by ____ |
 
KiOSS.Com
  
| Switch to Default View |
  
Nikmati Delphi-ID dalam berbagai versi tampilan :
Basic View (LOW Bandwidth)
Default View (Full)
Mobile Edition
Main Menu
..:: onWebTools ::..
..:: onLastPosts ::..
goto Postjumlah komponen maksimal dalam sebuah project(6)
 by d4mnf1y32
 on 21.May at 12:16
goto Posttanya grayscale to biner dengan scanline(1)
 by luckynvic
 on 20.May at 20:44
goto Posttanya looping biner to matriks(1)
 by luckynvic
 on 20.May at 20:10
goto Postsql error:acces denied for user....(2)
 by nasbms
 on 19.May at 16:54
goto Postpemanggilan frame(4)
 by nasbms
 on 19.May at 16:14
goto Posttanya AvLock(0)
 by azuriza
 on 19.May at 11:24
goto PostGet TDBEdit Value Menggunakan LookUp Grid(10)
 by henry_sys
 on 18.May at 11:27
goto Postmenghitung record dalam perulangan(4)
 by idhiel
 on 16.May at 13:53
goto Posttanya ascii(4)
 by mas_kofa
 on 16.May at 12:11
goto PostRawPrint Untuk Delphi XE2(0)
 by adewijaya
 on 15.May at 22:34
goto Postdatabase error..(4)
 by idhiel
 on 15.May at 15:57
goto Postbekasi, pt arila putra mahkota(3)
 by mas_kofa
 on 15.May at 15:37
goto Postbagaimana cara membaca file *.doc dg delphi?(0)
 by ficky
 on 15.May at 06:14
goto Posttanya biner to matriks(13)
 by diandewi
 on 14.May at 20:30

..:: onLast Articles ::..
..:: New Download ::..
Pascal-id.Org
Feeds -  Popular -  Latest
RE: The Longue
8 months, 3 weeks ago
RE: belajar pascal
8 months, 3 weeks ago
RE: The Longue
8 months, 3 weeks ago
RE: belajar pascal
8 months, 3 weeks ago
RE: Perkenalan dan Absen
8 months, 3 weeks ago
RE: Alhamdulillah Buka Puasa Bersama
8 months, 4 weeks ago
RE: تَقَبَّلَ اللهُ مِنَّا وَمِنْكَ - Selamat Hari Raya Idul Fitri
8 months, 4 weeks ago
Lintas Situs
«
free web site stats and visitor tracking
•   Forum FAQ  •  Search  • 

Tipe Data MySQL
Delphi Indonesia Forum Index » Database » MySQL
Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
Author Message
J4ckR1pp3rOffline
Location:
5 Post subject: Tipe Data MySQL  PostPosted: 05/Feb/2006 15:15
onSkilled


Joined: 05-Feb-2006
Posts: 79

Status: Offline
      Quote:
satu buah table dgn 3 buah field :
1. id_field int auto_increment (primary)
2. field1 float
3. field2 double

input data:
field1 --> 123456
field2 --> 123456

hasil dari input:
field1 --> 123456
field2 --> 123456

input data:
field1 --> 1234567
field2 --> 1234567

hasil dari input:
field1 --> 1234570
field2 --> 1234567


Disitu terlihat jelas ada round up Rolling Eyes

Pertanyaan saya :
Tipe data apa yg cocok digunakan untuk menghitung uang (currency) Question
Soalnya saya butuh jumlah digit yg banyak Rolling Eyes

Ada yg pernah ngalamin ngga Rolling Eyes Rolling Eyes Rolling Eyes
 
 View user's profile Send private message Visit poster's website Yahoo Messenger  
Reply with quote Back to top
saysansay
Location:
Post subject:   PostPosted: 05/Feb/2006 16:39
onProfessional


Joined: 06-Aug-2005
Posts: 648
Wah ini sepertinya bagian mas ulil dech...tapi saran saya Field1 dan Field2 Bagus Nya Satu Type Data Dan Type tersebut harus Memiliki digit yang paling banyak...Type Data apa ya!!! yang paling banayk digitnya...wakaakakaka cari sendiri dech...

_________________
== Barudak Jambi ===
Company : http://www.mpiholding.com/
 
 View user's profile Send private message Send e-mail  
Reply with quote Back to top
J4ckR1pp3rOffline
Location:
Post subject:   PostPosted: 05/Feb/2006 18:03
onSkilled


Joined: 05-Feb-2006
Posts: 79

Status: Offline
      saysansay wrote:
tapi saran saya Field1 dan Field2 Bagus Nya Satu Type Data


Itu cuma kronolog aja om Very Happy saya bingung milih harus pake type yg mana....sementara ini sih saya pake double karena alasan akurasinya...
tapi.......masalahnya currency kan punya decimal Sad
btw, waktu di form sih itu digit normal2 aja ngga neko-neko ....aku pake TsCurrencyEdit dari Alpha Controls buat I/O-nya Rolling Eyes

help me.....bentar lagi deadline nih Confused Sad
 
 View user's profile Send private message Visit poster's website Yahoo Messenger  
Reply with quote Back to top
saysansay
Location:
Post subject:   PostPosted: 05/Feb/2006 19:11
onProfessional


Joined: 06-Aug-2005
Posts: 648
      Quote:

Itu cuma kronolog aja om Sad

Kok Om Sech....Nah klu CUrrencynya Punya Nilai Decimal...Pake Type Data Currency 8 50+ significant digits, fixed 4 decimal places
...Nah Ini solusinya...yang terbaik..Jangan Pake double...
Double 8 15 significant digits, exponent -308 to +308

_________________
== Barudak Jambi ===
Company : http://www.mpiholding.com/
 
 View user's profile Send private message Send e-mail  
Reply with quote Back to top
J4ckR1pp3rOffline
Location:
Post subject:   PostPosted: 05/Feb/2006 19:28
onSkilled


Joined: 05-Feb-2006
Posts: 79

Status: Offline
type data currency pake komponen apa / MySQL versi brp Rolling Eyes
aku bikin db nya pake DBDesigner 4 sama MySQL Front
tapi aku ngga nemu tipe data currency tuh Rolling Eyes

mohon pencerahan-nya dunkz Very Happy
 
 View user's profile Send private message Visit poster's website Yahoo Messenger  
Reply with quote Back to top
saysansay
Location:
Post subject:   PostPosted: 05/Feb/2006 19:36
onProfessional


Joined: 06-Aug-2005
Posts: 648
      Quote:
type data currency pake komponen apa / MySQL versi brp

Ralat : Wah Type Datanya Float Atuh....Bukan Currency, Wakakakaka maaf Ya saya Terlalu Banyak BErmain DiADO...ENtar Tinggal bikin Display Formatnya Aja
Pake MYSQL V 3 Ke atas..... Oh iya Mas Kesulitannya Dibagian apa...Klu cuma pake decimal Ya Pake yg type data Float aja......
Never Give Erorr

_________________
== Barudak Jambi ===
Company : http://www.mpiholding.com/
 
 View user's profile Send private message Send e-mail  
Reply with quote Back to top
J4ckR1pp3rOffline
Location:
Post subject:   PostPosted: 05/Feb/2006 19:51
onSkilled


Joined: 05-Feb-2006
Posts: 79

Status: Offline
huehuehue bikin kaget aja Laughing

aku bingung milih Tipe Data nya....
soalnya klo pake Float dari 7 digit ke atas dia malah round up Crying or Very sad
skarang sih aku pake double....tapi apa ntar ngga ada trouble ya Rolling Eyes
waktu aku check di TsCurrencyEdit...dia pake Float juga Confused

bingung Rolling Eyes
 
 View user's profile Send private message Visit poster's website Yahoo Messenger  
Reply with quote Back to top
saysansay
Location:
Post subject:   PostPosted: 05/Feb/2006 20:02
onProfessional


Joined: 06-Aug-2005
Posts: 648
Kok Bisa Round Up sech....Type Data Float {Float: This is a floating point decimal number. It will keep a maximum of 24 digits of accuracy. } Nah bukannya sampe 24 digit tingkat keakurasinya...Huh....Bole liat File EXE nya atau sekalian semua filenya wakakakakakakak Klu bole sech...
NB : Kenapa Nga ganti Database aja Yg support Untuk Type Data Tersebut..Cuma saran doank

_________________
== Barudak Jambi ===
Company : http://www.mpiholding.com/
 
 View user's profile Send private message Send e-mail  
Reply with quote Back to top
Display posts from previous:     
Jump to:  
All times are GMT - 12 Hours
Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
 Delphi Indonesia Forum Index » Database »  MySQL





Powered by PNphpBB2 © 2003-2009 The Zafenio Team
Credits


| Register | Lost Password ? |