I am using pb9 + oracle8, use PB online oracle test is normal, but it is written in the SQL statements in the PB code data, take not to come out is not an error, don't know if it has to do with some of the operating system service, I am using XP - professional
Please advice!

CodePudding user response:

See the sqlcode value!
The connection properties of owner set?

CodePudding user response:

Write SQL statements that take not to come out in PB code data, nor an error
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
SQL article posted to see

CodePudding user response:

//Profile CET61
The SQLCA. DBMS="O90 Oracle9i (9.0.1)"
The SQLCA. LogPass=& lt; * * * * * & gt;
The SQLCA. ServerName="jhoracle"
The SQLCA. LogId="cet61"
The SQLCA. The AutoCommit=False
The SQLCA. DBParm=""


Execute SQL, watch the value of the sqlcode.

CodePudding user response:

I like you are connect to ok! Is not cut in when insert into table data,
Which ace to help me see,
http://topic.csdn.net/u/20080226/14/c2f57915-3eed-47d4-a150-06a03859c542.html

CodePudding user response:

Have a commit?

CodePudding user response:

Did not commit, your program must be lack of tolerance, after each perform database operations, the state, to view the sqlcode judgment of execution of SQL statements

CodePudding user response:

Well, first of all, to look at the data type of insert is consistent,
If you read can be judged according to the return value of the sqlcode,

CodePudding user response:

IF the SQLCA. SQLCODE<> 0 THEN
Processing......

CodePudding user response:

reference 5 floor HNHHCJ reply:

have commit?

The connect is right,

CodePudding user response:

I also want to know, is looking for this information ~ ~ ~ ~ ~

CodePudding user response:

Lz want?