Boleh saya kasih masukan (klo saya nggak salah tangkap lho...
ngelihat error yang terjadi berarti sintak yang anda masukkan
tidak dikenal di engine Acces.
jadi terkadang setiap perintah-perintah query tidak dapat diterapkan di
database lain.
Exp:
Perintah CONCAT saya gunakan di Acces tidak bisa tetapi di MySQL bisa.
ya maybe itu kekurangan dari acces termasuk query yang anda masukkan
juga nggak dikenal.
So klo boleh kasih solusi(Tapi agak panjang nih.... hee).
query perkondisi terus disimpan dalam variabel.
habis itu lakukan perulangan dan seterusnya sampai kondisi terakhir
klo udah lakukan update.
Sorry klo nggak nyambung. Semoga membantu
Regards
Rudy Tanaga <[EMAIL PROTECTED]> wrote:
Coba :
pdate rekening set a.debet = b.debet,
> > a.kredit=b.kredit
> > from rekening a , (Select kode,sum(debet) as
> debet,
> > sum(kredit) as kredit
> > from jurnal group by kode) b where a.kode=b.kode
Maya Agnelia <[EMAIL PROTECTED]> wrote:sorry mas lupa ngasih tau dbmsnya.
maya menggunakan access sbg databasenya.
sekali lagi makasih ya mas CaCa
> mas caca ini pesan errornya:
>
> syntax error(missing operator) in query _expression_
> b.kredit from rekening a
>
> thanks mas atas bantuanya
>
>
> regards
> maya
>
> --- thakin Caca <sudden_poniq@yahoo.com > wrote:
>
> > DBMS pake apa yah ?, saya coba pake SQL 2000,
> > running kok, dicoba aja sql di bawah ini, klo
> belum
> > berhasil kirim errornya nanti tak analisa, ok
> >
> > update rekening set debet = b.debet,
> > kredit=b.kredit
> > from rekening a , (Select kode,sum(debet) as
> debet,
> > sum(kredit) as kredit
> > from jurnal group by kode) b where a.kode=b.kode
> >
> >
> > Send instant messages to your online friends
> > http://uk.messenger.yahoo.com
>
>
> _____________________ _________ _________ _________ __
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam
> protection around
> http://mail.yahoo.com
>
_____________________ _________ _________ _________ __
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Want to be your own boss? Learn how on Yahoo! Small Business.
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail Beta. __._,_.___
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
SPONSORED LINKS
| Programmer | Indonesia | Basic programming language |
| Computer programming languages | Programming languages | Java programming language |
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
