StoryErpStoryErp

가끔 작업을 하다 보면 불가피(?)하게 2개의 디비에 접속을 해야할 경우가 생깁니다.

특히 sms 보내기 등 할때 말이죠.. ㅠㅠ

파빌 9.0 + ms sql2000 기준입니다.. 다른 디비는 접속 스크립트를 변경하시면..되겠죠..

배포시에는.. 해당 디비의 접속 dll 이 들어가야 한답니다..--;;

//글로벌 변수

TRANSACTION SQLCA, SQLCA_sms //사용할 트랜젝션 선언해줍니다..

//어플리케이션 오픈 이벤트

// 1번디비
SQLCA = Create Transaction // 트랜젝션 생성합니다..

SQLCA.DBMS = "MSS Microsoft SQL Server"
SQLCA.Database = "디비명"
SQLCA.LogPass = "페스워드"
SQLCA.ServerName = "서버주소"
SQLCA.LogId = "로그인아뒤"
SQLCA.AutoCommit = False
SQLCA.DBParm = ""

connect using sqlca;

if sqlca.sqlcode <> 0 then
 messagebox('error', sqlca.sqlerrtext)
 return
end if

//sms디비
sqlca_sms  = Create Transaction

sqlca_sms.DBMS = "MSS Microsoft SQL Server"
sqlca_sms.Database = "디비명"
sqlca_sms.LogPass = "페스워드"
sqlca_sms.ServerName = "서버주소"
sqlca_sms.LogId = "로그인아뒤"
sqlca_sms.AutoCommit = False
sqlca_sms.DBParm = ""

connect using sqlca_sms;

if sqlca_sms.sqlcode <> 0 then
 messagebox('error', sqlca_sms.sqlerrtext)
 return
end if

open(w_main) //오픈윈도우..

// 사용할 페이지에서..변수 선언 제외했음..

select count(*) into :변수 from 테이블 using sqlca;  //1번 디비 연결이용

select count(*) into :변수 from 테이블 using sqlca_sms;  //sms 디비 연결 이용..

오라클 SQL 기초 강좌 입니다.

Oracle 초급매뉴얼 -> Oracle 강좌 -> SQL 기초강의

순서로 보시면 됩니다.

oracle강좌.zip

oracle초급매뉴얼.zip

sql기초강의.zip

ContextKeyword lcxk_base
string ls_Path
string ls_values[]

this.GetContextService("Keyword", lcxk_base)
lcxk_base.GetContextKeywords("OS", ls_values)

IF Upperbound(ls_values) > 0 THEN  
   ls_Path = ls_values[1]
ELSE  
   ls_Path = "*UNDEFINED*"

END IF

messagebox('1',ls_path)

 
//XP 적용된 환경 정보
ALLUSERSPROFILE      location of the All Users Profile.
APPDATA              location where applications store data by default.
CD                   current directory string.
CLIENTNAME           client's NETBIOS name when connected to terminal server session.
CMDCMDLINE           ncommand line used to start the current cmd.exe.
CMDEXTVERSION        version number of the current Command Processor Extensions.
CommonProgramFiles   path to the Common Files folder.
COMPUTERNAME         name of the computer.
COMSPEC              path to the command shell executable.
DATE                 current date.
ERRORLEVEL           error code of the most recently used command.
HOMEDRIVE            drive letter is connected to the user's home directory.
HOMEPATH             full path of the user's home directory.
HOMESHARE            network path to the user's shared home directory.
LOGONSEVER           name of the domain controller that validated the current logon session.
NUMBER_OF_PROCESSORS   number of processors installed on the computer.
OS                   name of the operating system.
                      (Windows XP and Windows 2000 list the operating system as Windows_NT.)
Path                 search path for executable files.
PATHEXT              file extensions that the operating system considers to be executable.
PROCESSOR_ARCHITECTURE   processor's chip architecture.
PROCESSOR_IDENTFIER  description of the processor.
PROCESSOR_LEVEL      model number of the computer's processor.
PROCESSOR_REVISION   revision number of the processor.
ProgramFiles         path to the Program Files folder.
PROMPT               command-prompt settings for the current interpreter.
RANDOM               random decimal number between 0 and 32767.
SESSIONNAME          connection and session names when connected to terminal server session.
SYSTEMDRIVE          drive containing the Windows root directory.
SYSTEMROOT           location of the Windows root directory.
TEMP and TMP         default temporary directories for applications that are available to                     users who are currently logged on.
TIME                 current time.
USERDOMAIN           name of the domain that contains the user's account.
USERNAME             name of the user currently logged on.
USERPROFILE          location of the profile for the current user.
WINDIR               location of the OS directory.