Mas Toni, Tks a lot, that's work. salam, sodik On Wed, 26 Dec 2007 08:07:10 +0700, Toni Rahayu <[EMAIL PROTECTED]> wrote:
> > > Hallo Kang Sodik, > coba pake tanda kutipnya dua kali, contoh: > > select ""field1"",""field2"" from ""table"" > > Rgds > > > > > > "Sodik Ihwan" <[EMAIL PROTECTED]> on 12/21/2007 04:46:02 PM > > Please respond to [email protected] > > To: [email protected] > cc: (bcc: Toni Rahayu/IT/domino_srv) > > Subject: [Programmer-VB] Select Query PostGresSQL > > > > Dear All, > di PostGreSQL saya coba bikin database namanya Test, disitu saya buat > tabel namanya Tabel1, dengan field TglTran dan NoTran > so far koneksi nya sudah Ok (pake ADO OleDb) > Dim Con1 As New ADODB.Connection > Con1.ConnectionString = "Provider=PostgreSQL OLE DB Provider;" & _ > "Password=aaaaa;" & _ > "User ID=postgres;" & _ > "Data Source=127.0.0.1;" & _ > "Location=Test" > Con1.Open > Con1.CursorLocation = adUseClient > > cuma pas select ane bingung karena kalo nurutin select query nya kan > begini: > SELECT > public."Tabel1"."TglTran", > public."Tabel1"."NoTran" > FROM > public."Tabel1" > ORDER BY > public."Tabel1"."NoTran" > sementara di VB tanda " tidak boleh digunakan. > > ane coba pake syntak ini tapi ga jalan > Dim rcsNew As New ADODB.Recordset > rcsNew.Open "Select * From Tabel1", & _ > Con1, adOpenForwardOnly, adLockReadOnly > > mohon pencerahannya > terimakasih > > salam > sodik > -- > Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ > > Send instant messages to your online friends > http://asia.messenger.yahoo.com > > > Wahana Programmer Groups Links > > Yahoo! Groups Links > > > -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ Send instant messages to your online friends http://asia.messenger.yahoo.com 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/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/Programmer-VB/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> 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/
