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 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/
