-=-
.
.....
  
| 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  • 

Tnya : insert ke table
Delphi Indonesia Forum Index » Database » Paradox
Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
Author Message
jontiloesmodOffline
Location:
Post subject: Tnya : insert ke table  PostPosted: 28/Jul/2009 15:10
onBeginner


Joined: 28-Jul-2009
Posts: 4

Status: Offline
maaf nie mas2 nd mbak2,
saya maw nya dikit nie...

kalo mis kita punya 3 tabel :

1. Tabel Kelas :
|Kode|Kelas|
=========
|K01 | 1 |
|K02 | 2 |
|k03 | 3 |


2. Tabel Ruang :
|Kode|Ruang|
=========
|R01 | A |
|R02 | B |
|R03 | C |

pertanyaan : gmn cara ya agar field Kelas dan Ruang di input ke satu field pada tabel lain, misal nya jadi seperti ini

|kode|Kelas |
==========
|S01 | 1 - A |
|S02 | 2 - B |
|S03 | 3 - C |



Mohon pencerahan.(hrp mklum NewBie...) Embarassed Embarassed
MaturSuhun...
 
 View user's profile Send private message  
Reply with quote Back to top
n3o_cybertech
Location: NgAyUkYoKarTo
Post subject: RE: Tnya : insert ke table  PostPosted: 28/Jul/2009 15:34
onProfessional


Joined: 10-Feb-2007
Posts: 993
Location: NgAyUkYoKarTo
pake sintak SQL : 
code : pascal
  1. concat(kelas.kode,'-',ruang.kode)
Parsed in 0.001 seconds, using GeSHi

_________________

Delphi Rock!

Blog : MyBlog | Facebook : Add Me :)
 
 View user's profile Send private message Send e-mail Visit poster's website Yahoo Messenger  
Reply with quote Back to top
jontiloesmodOffline
Location:
Post subject: Re: RE: Tnya : insert ke table  PostPosted: 28/Jul/2009 18:22
onBeginner


Joined: 28-Jul-2009
Posts: 4

Status: Offline
      n3o_cybertech wrote:
pake sintak SQL : 
code : pascal
  1. concat(kelas.kode,'-',ruang.kode)
Parsed in 0.001 seconds, using GeSHi


makasih ya mas..tak cobain dulu
 
 View user's profile Send private message  
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 »  Paradox





Powered by PNphpBB2 © 2003-2009 The Zafenio Team
Credits


| Register | Lost Password ? |