|
일본에서 만들어진 라이브러리 입니다. 원본의 Readme 파일을 첨부합니다. 참고하시기 바랍니다.
원본 출처 : http%3A%2F%2Fwww.vector.co.jp%2Fsoft%2Fwinnt%2Fprog%2Fse201375.html
hanmir 등등의 일한 번역 프로그램을 이용하여 보시면 편리하겠죠.
====================================================================
PostgreSQL Easy Access Tool Visual Basic Interface 1.0.1R
( ibpgvb.dll )
SOGA Project Group
http://hp.vector.co.jp/authors/VA023283/
mailto:sogapj@fb.freeserve.ne.jp
====================================================================
[Outline]
It is DLL which did PostgreSQL so that it could access it directly
and simply with VB, VBA from Windows, the client.
It can be used easily without using ODBC.
Complicated operation is a result because a target was narrowed
to the fundamental way of using it and made.
Instead of not here, it thinks that it can be programmed easily.
[Environment]
Movement with WindowsNT4, Windows2000 is confirmed.
Development environment is Windows-NT4-SP6a.
Office97, Office2000 or VisualBasic must be installed separately.
PostgreSQL Version is 7.1.3.
[Precaution]
Put this DLL on the place where path passed.
It doesn't care even about the place of EXE to move when it is
being used only with VB.갃
It doesn't care even under Program Files\Microsoft Ofiice\Office
when it is being used only with the Office tool.
The bottom of Winnt\System32 is probably the best when it wants
to use it without being conscious.
[How to use it]
<Interface> VB, VBA commonness
*Refer to sample coding for the details.
(VisualBasic Source Code =PGtest.vbp , Excel Macro Source Code =PGDBget.xls)
1.Login
VBPGlogin(ByVal Palam As String) As Long
[Return value] 0:Normality 9:Wrong point
It is given to it like "host=xxx user=xxx password=xxx" in the textbook.
*It is based on the interface of PGconnect.
2.SQL practice
VBPGexec(ByVal Palam As String, ByVal Rtn As String) As Long
[Return value] 0:Normality 9:Wrong point
A SQL command is delivered in the textbook.
Be careful of the result because 81920 bytes become MAXs.
3.Cursor practice
VBPGcursor(ByVal Palam As String) As Long
[Return value] 0:Normality 9:Wrong point
A SQL command is delivered in the textbook.
4.Fetch Next
VBPGfetch(ByVal Rtn As String) As Long
[Return value] 0:Normality 1:EOF 9:Wrong point
Be careful of the result because 81920 bytes become MAXs.
5.The list of the field name toward
the SQL extraction right before the front is acquired.
VBPGfnames(ByVal Rtn As String) As Long
[Return value] 0:Normality 9:Wrong point
The stop of the field name is TAB (0x09).The final is CRLF (0x0d0a).
6.A designated position field name toward
the SQL extraction right before the front is acquired.
VBPGfname(ByVal Palam As Long, ByVal Rtn As String) As Long
[Return value] 0:Normality 9:Wrong point
7.The value of the designated position toward
the SQL extraction right before the front is acquired.
VBPGvalue(ByVal Palam As Long, ByVal Rtn As String) As Long
[Return value] 0:Normality 9:Wrong point
8.The acquisition of the error message of
the SQL practice right before the front is done.
VBPGmsgget(ByVal Rtn As String) As Long
[Return value] 0:Normality
9.Close of the connection is done.
VBPGclose() As Long
[Return value] 0:Normality
10.The status of the SQL command right before the front
is acquired.
VBPGstatus() As Long
[Return value] Status value
11.Field stop character is set up. a (change)
VBPGdlim(ByVal Palam As Byte) As Long
[Return value] 0:Normality 9:Wrong point
[Revision personal history]
2001.07.09 The first edition (1.0.0) release
2001.07.11 The explanation of VBPGdlim() is added.
2001.08.20 Version 7.1.3 released.
[Others]
Server (postgres) for the Windows-Native development
is introduced to the public, too.
Use it for this opportunity by all means.
http://hp.vector.co.jp/authors/VA023283/
====================================================================
Copyright(C) 1999-2001 SOGA Telecom Project Group
H.saito(sogapj@fb.freeserve.ne.jp)
I.Fukuhara(ichiro@ichiro.org)
|
