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
att1.eml
Description: Binary data
Toni Rahayu PT. Omedata Electronics IT Department Hunting : (62-22) 6030805 Ext 121 Faxs : (62-22) 6030896 Homepage : http://www.toni-rahayu.co.cc
