Questions in 2006
english version for 2006
Page 2 out of 3 Pages
- How to investigate the reason if face deadlock problem? (From DBMR1703, version: DBMaker 4.1.2, OS: Windows XP Embedded SP1)
(405 views)
- In Oracle, user can write the following statement to implement the conversion from date type to char type, how can I do that in DBMaker?
select * from QMDVFCMDBS where
sts_tkystr = to_char(sysdate,'yyyymmdd')
(238 views)
- The SQL manual says: Use two consecutive single-quotes to include a single-quote character in a quoted string. It means that if we want to insert a data included single quote, we should use another quote as the escape character, but in the following statement which is in a my ESQL program, why do not I need single quote as escape sequence but I can still execute the program successfully? (From DBMR1702, version: DBMaker 4.1.6)
sprintf(sChnkbn, "'A");
(64 views)
- Why does the error occur sometimes when using cursor update in the ESQL application?
(431 views)
- How does DBMaker deal with the delete command?
(63 views)
- When execute an update command that the new data is large than the previous data, how does the DBMaker do?
(271 views)
- How does the DBMaker find free page if the present page is full when an insert command is executed?
(659 views)
- What can I do if the number of the command handles in my application over the limitation?
(213 views)
- What is the limitation to the number of the command handles when using JDBC data source to connect to DBMaker?
(221 views)
- How to confirm deamon of auto update statistics working(is there anything shown on process)?What is the trigger to let update statistics work(like how many records insert into table)?
(332 views)