-=-
.
.....
  
| 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, 3 weeks ago
RE: تَقَبَّلَ اللهُ مِنَّا وَمِنْكَ - Selamat Hari Raya Idul Fitri
8 months, 3 weeks ago
Lintas Situs
«
free web site stats and visitor tracking
•   Forum FAQ  •  Search  • 

Specified key was too long. Max key length is 500
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
ZeALOffline
Location:
Post subject: Specified key was too long. Max key length is 500  PostPosted: 21/Apr/2005 07:51
onProfessional


Joined: 07-Apr-2005
Posts: 763

Status: Offline
Salah dimana ya..?? Key-nya terlalu panjang...???

      Quote:

DROP TABLE tbSubSegmen
Unknown table 'tbsubsegmen'
CREATE TABLE tbSubSegmen (`KODE_PROYEK` CHAR (200) , `KODE_SEGMEN` CHAR (200) , `KODE_SUBSEGMEN` CHAR (200) , `NAMA_SEGMEN` CHAR (200) , `PENLAP` CHAR (200) , `TGL` DATE , PRIMARY KEY (`KODE_PROYEK` , `KODE_SEGMEN` , `KODE_SUBSEGMEN`) )
Specified key was too long. Max key length is 500
INSERT INTO `tbSubSegmen` VALUES( "01" , "S01" , "SS01" , "KIRI - KANAN" , "MAHMUD" , "2005-10-20" )
Table 'test.tbsubsegmen' doesn't exist

_________________
do i know you?

[ My Blog : http://www.monyetpinter.com ] [ My RPG Project : http://einarc.wordpress.com ] [ FJBex : http://www.fjbex.com ]
 
 View user's profile Send private message  
Reply with quote Back to top
kifmesoftOffline
Location:
Post subject: RE: Specified key was too long. Max key length is 500  PostPosted: 21/Apr/2005 08:03
onKnowledgeable


Joined: 02-Apr-2005
Posts: 176

Status: Offline
mungkin karena `KODE_PROYEK` , `KODE_SEGMEN` , `KODE_SUBSEGMEN` yang digunakan sebagai PRIMARY KEY jika dijumlahkan tipe datatanya jadi 600

coba aja tipe data tsb diganti, siapa tau jadi bisa :
`KODE_PROYEK` CHAR (50) , `KODE_SEGMEN` CHAR (50) , `KODE_SUBSEGMEN` CHAR (50)
 
 View user's profile Send private message Send e-mail Visit poster's website  
Reply with quote Back to top
mas_kofa
Location: New York Arto
Post subject:   PostPosted: 27/Nov/2006 17:16
onElite


Joined: 18-Mar-2006
Posts: 1753
Location: New York Arto
aku juga pernah punya kasus..spt itu..............

waktu itu aku pake sqlstring :

select * from evaprodi.mastermhs order by nim;

dan aku pake tabel DSQLQuery, waktu aku update dan insert....

selalu muncul error filed nim not in filed list....(aneh khan)....samapai aku pusing 7x keliling.... Evil or Very Mad
padal sudah aku lihat pake bermacam-macam mysql designer...disitu terlihat jelas bahwa field nim itu ada................
sampe sekarang aku blm tau apa permasalahannya Exclamation Question .....

akhirnya komponen DSQLQuery aku ganti dengan DSQLTable dengan meng-update dan insert dengan sqlstring yang sama (waktu aku pake DSQLQuery)...tidak ada yang masalah...??

teman2 .. apakah ada yang ngalami spt yang aku alamai???

dan kira-penyebabnya apa ya????
 
 View user's profile Send private message  
Reply with quote Back to top
waterbommOffline
Location:
Post subject:   PostPosted: 08/Nov/2007 14:59
onBeginner


Joined: 14-Dec-2006
Posts: 6

Status: Offline
hualloo..
buat mas ZeAL thx banget soal masalahnya.. hihi.. jadi napsu ma SQL nich. Mr. Green
mungkin basi kali ya Mr. Green aku coba create table yang sesuai dengan mas ZeAL bikin diatas, malah errornya "Specified key was too long; max key length is 1000 bytes" Mr. Green jadi bingung hihi.., ternyata itu karena maximum key length dari ketiga keynya lebih dari 1000 bytes (ntah perhitungan darimana ) Mr. Green trus saya ganti tipe datanya jadi 100 semua mao berhasil. hihi.. btw thx ya.. jadi tau nich Mr. Green
 
 View user's profile Send private message Visit poster's website Yahoo Messenger MSN Messenger  
Reply with quote Back to top
DelphiExpert
Location:
Post subject:   PostPosted: 08/Nov/2007 15:28
onMage


Joined: 06-Feb-2006
Posts: 2401
hihihi... jadi pingin ikutan nyengir... hihihi... Mr. Green

_________________
Dude, if you don't understand the basics and just want to get someone else write the code for you, it means you really shouldn't study computer science. Find a different field.
http://delphiexpert.wordpress.com
 
 View user's profile Send private message Visit poster's website  
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 ? |