Subject: [Programmer-VB] Select Query PostGresSQL
From: "Sodik Ihwan" <[email-masked]>
To: [email-masked]
Date: Fri, 21 Dec 2007 23:46:02 +0700
List-Id: <Programmer-VB.yahoogroups.com>

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

<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
    http://wahanaprogrammer.net

<*> Untuk menghubungi owner milis ini, kirim email ke:
    [email-masked]

<*> 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-masked] 
    mailto:[email-masked]

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

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