Re: [Programmer-VB] Begin Tran & Commit Tran

Mon, 05 Jun 2006 21:55:05 -0700


Semestinya Pendekatan sintak anda menurut saya sudah betul,
atau getMaxNUmber nya gak usah dimasukkan ke variabel, jadi lsg aja
cn.begin
 sql = "insert into namaTabel (Kode) values(getMaxNumber)"
 cn.execute sql
cn.commit
atau
solusi lain, mungkin anda bisa buat 1 table lagi yg isinya menampung nilai terakhir,Jadi pada saat mengambil
Max Number nya, anda lsg tambahkan 1 ke tabel lain tersebut,

Mudah2xan nangkep maksud saya :)


Salam
Ronald Irawan
Pt. Sanghiang Perkasa
Gd. Graha Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta


develop <[EMAIL PROTECTED]>
Sent by: [email protected]

06/06/2006 11:39 AM

Please respond to
[email protected]
To
[email protected]
cc
Subject
Re: [Programmer-VB] Begin Tran & Commit Tran





sintax saya seperti ini mas ronald,

cn.begin
 x = getMaxNumber

 sql = "insert into namaTabel (Kode) values(x)"
 cn.execute sql
cn.commit

cn menggunakan ADODB
database menggunakan Ms.Access.

apakah ada yang salah dengan sintax saya?

jika ada yang salah, saya minta tolong untuk di
koreksi...


thx.



--- Ronald Irawan <[EMAIL PROTECTED]> wrote:

> Kalau boleh tahu sintak simpan anda gimana ?
>
> Salam
> Ronald Irawan
> Pt. Sanghiang Perkasa
> Gd. Graha Kirana Lt.5
> Jl Yos Sudarso Kav.88
> Jakarta
>
>
>
> develop <[EMAIL PROTECTED]>
> Sent by: [email protected]
> 06/06/2006 09:40 AM
> Please respond to
> [email protected]
>
>
> To
> [email protected]
> cc
>
> Subject
> Re: [Programmer-VB] Begin Tran & Commit Tran
>
>
>
>
>
>
> mas johan, kalau gitu, gimana caranya ya? supaya
> data
> saya jika di save oleh beberapa user, tidak double.
>
> contohnya:
> pada saat save invoice, ada create no.invoice
> (secara
> system) bagaimana cara nya supaya no.ini gak double?
>
>
> thx.
>
>
>
> --- johan max <[EMAIL PROTECTED]> wrote:
>
> >
> > Jelas aza. Di access khan tdk ada transaksi.
> > --- develop <[EMAIL PROTECTED]> wrote:
> >
> > > teman2 ada yang bisa bantuin saya ?
> > >
> > > saya punya masalah pada saat saya pindahkan
> > program
> > > saya dari sql server2000 ke Ms.Access.
> > >
> > > saya gunakan ADODB.
> > > pada statement begin & commit tidak berjalan.
> > >
> > > sintaxnya sbb :
> > >
> > > cn.begin
> > >              batch proses
> > > cn.commit
> > >
> > >
> > > tolong di bantuin donk....urgent banget neh....
> > >
> > >
> > > thx b4!
> > >
> > >
> __________________________________________________
> > > 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
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam
> protection around
> http://mail.yahoo.com
>
>
>
> Wahana Programmer Groups Links
>
>
>
>  
> Yahoo! Groups Links
>
>
>
>  
>
>
>
>
>


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com


------------------------ Yahoo! Groups Sponsor --------------------~-->
Protect your PC from spy ware with award winning anti spy technology. It's free.
http://us.click.yahoo.com/97bhrC/LGxNAA/yQLSAA/k7folB/TM
--------------------------------------------------------------------~->

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

Yahoo! Groups Links

<*> To visit your group on the web, go to:
   http://groups.yahoo.com/group/Programmer-VB/

<*> To unsubscribe from this group, send an email to:
   [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
   http://docs.yahoo.com/info/terms/
__._,_.___

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



__,_._,___

Kirim email ke