dberror.log

关于 ZFC 框架的自述文件 2003.6.18 ======================================================================

对数据库提交的操作没有被成功执行，发生 -195 号错误。

1) 出错对象/位置: 
数据窗口/数据存储“dw_spda”的数据对象“dw_spda_f”；
位于数据窗口/数据存储主缓冲区的第 2 行纪录。

2) DBMS 错误消息: 
SQLSTATE = 23000
[Sybase][ODBC Driver][Adaptive Server Anywhere]Integrity constraint violation: Column 'spsj' in table 'SPDA' cannot be NULL

No changes made to database.

INSERT INTO spda ( sid, spmc, dlm, spsj, spjj, dpsl, jdrq, g_id, spgg, spdw, sphyj, fhhh, thfs, thtj, spzdj, memo, sppp, spmcpy ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

3) SQL 语句: 
INSERT INTO spda ( sid, spmc, dlm, spsj, spjj, dpsl, jdrq, g_id, spgg, spdw, sphyj, fhhh, thfs, thtj, spzdj, memo, sppp, spmcpy ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

此段纪录于: 2004-11-13 11:23

----------------------------------------

对数据库提交的操作没有被成功执行，发生 -195 号错误。

1) 出错对象/位置: 
数据窗口/数据存储“dw_spda”的数据对象“dw_spda_f”；
位于数据窗口/数据存储主缓冲区的第 2 行纪录。

2) DBMS 错误消息: 
SQLSTATE = 23000
[Sybase][ODBC Driver][Adaptive Server Anywhere]Integrity constraint violation: Column 'spsj' in table 'SPDA' cannot be NULL

No changes made to database.

INSERT INTO spda ( sid, spmc, dlm, spsj, spjj, dpsl, jdrq, g_id, spgg, spdw, sphyj, fhhh, thfs, thtj, spzdj, memo, sppp, spmcpy ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

3) SQL 语句: 
INSERT INTO spda ( sid, spmc, dlm, spsj, spjj, dpsl, jdrq, g_id, spgg, spdw, sphyj, fhhh, thfs, thtj, spzdj, memo, sppp, spmcpy ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

此段纪录于: 2004-11-13 11:23

----------------------------------------

对数据库提交的操作没有被成功执行，发生 -195 号错误。

1) 出错对象/位置: 
数据窗口/数据存储“dw_spda”的数据对象“dw_spda_f”；
位于数据窗口/数据存储主缓冲区的第 11 行纪录。

2) DBMS 错误消息: 
SQLSTATE = 23000
[Sybase][ODBC Driver][Adaptive Server Anywhere]Integrity constraint violation: Column 'sid' in table 'SPDA' cannot be NULL

No changes made to database.

INSERT INTO spda ( sid, spmc, dlm, spsj, spjj, dpsl, jdrq, g_id, spgg, spdw, sphyj, fhhh, thfs, thtj, spzdj, memo, sppp, spmcpy ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

3) SQL 语句: 
INSERT INTO spda ( sid, spmc, dlm, spsj, spjj, dpsl, jdrq, g_id, spgg, spdw, sphyj, fhhh, thfs, thtj, spzdj, memo, sppp, spmcpy ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

此段纪录于: 2004-11-13 11:38

----------------------------------------

对数据库提交的操作没有被成功执行，发生 -195 号错误。

1) 出错对象/位置: 
数据窗口/数据存储“dw_spda”的数据对象“dw_spda_f”；
位于数据窗口/数据存储主缓冲区的第 19 行纪录。

2) DBMS 错误消息: 
SQLSTATE = 23000
[Sybase][ODBC Driver][Adaptive Server Anywhere]Integrity constraint violation: Column 'spmc' in table 'SPDA' cannot be NULL

No changes made to database.

INSERT INTO spda ( sid, spmc, dlm, spsj, spjj, dpsl, jdrq, g_id, spgg, spdw, sphyj, fhhh, thfs, thtj, spzdj, memo, sppp, spmcpy ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

3) SQL 语句: 
INSERT INTO spda ( sid, spmc, dlm, spsj, spjj, dpsl, jdrq, g_id, spgg, spdw, sphyj, fhhh, thfs, thtj, spzdj, memo, sppp, spmcpy ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

此段纪录于: 2004-11-13 12:21

----------------------------------------

对数据库提交的操作没有被成功执行，发生 -195 号错误。

1) 出错对象/位置: 
数据窗口/数据存储“dw_spda”的数据对象“dw_spda_f”；
位于数据窗口/数据存储主缓冲区的第 38 行纪录。

2) DBMS 错误消息: 
SQLSTATE = 23000
[Sybase][ODBC Driver][Adaptive Server Anywhere]Integrity constraint violation: Column 'sid' in table 'SPDA' cannot be NULL

No changes made to database.

INSERT INTO spda ( sid, spmc, dlm, spsj, spjj, dpsl, jdrq, g_id, spgg, spdw, sphyj, fhhh, thfs, thtj, spzdj, memo, sppp, spmcpy ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

3) SQL 语句: 
INSERT INTO spda ( sid, spmc, dlm, spsj, spjj, dpsl, jdrq, g_id, spgg, spdw, sphyj, fhhh, thfs, thtj, spzdj, memo, sppp, spmcpy ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

此段纪录于: 2004-11-13 13:51

----------------------------------------

对数据库提交的操作没有被成功执行，发生 -3 号错误。

1) 出错对象/位置: 
数据窗口/数据存储“n_cst_ds_lv”的数据对象“d_employee_list”；
位于数据窗口/数据存储主缓冲区的第 3 行纪录。

2) DBMS 错误消息: 
Row changed between retrieve and update.

No changes made to database.

UPDATE employee SET name = ? WHERE name = ? AND isstop = ? AND id IS NULL AND sex = ? AND title IS NULL AND birthdate IS NULL AND hiredate IS NULL AND address IS NULL AND city IS NULL AND region IS NULL AND homephone IS NULL AND postalcode IS NULL AND email IS NULL AND notes IS NULL 

3) SQL 语句: 
UPDATE employee SET name = ? WHERE name = ? AND isstop = ? AND id IS NULL AND sex = ? AND title IS NULL AND birthdate IS NULL AND hiredate IS NULL AND address IS NULL AND city IS NULL AND region IS NULL AND homephone IS NULL AND postalcode IS NULL AND email IS NULL AND notes IS NULL 

此段纪录于: 2004-11-13 20:00

----------------------------------------

对数据库提交的操作没有被成功执行，发生 -3 号错误。

1) 出错对象/位置: 
数据窗口/数据存储“n_cst_ds_lv”的数据对象“d_employee_list”；
位于数据窗口/数据存储主缓冲区的第 3 行纪录。

2) DBMS 错误消息: 
Row changed between retrieve and update.

No changes made to database.

UPDATE employee SET name = ?, birthdate = ?, hiredate = ? WHERE name = ? AND isstop = ? AND id IS NULL AND sex = ? AND title IS NULL AND birthdate IS NULL AND hiredate IS NULL AND address IS NULL AND city IS NULL AND region IS NULL AND homephone IS NULL AND postalcode IS NULL AND email IS NULL AND notes IS NULL 

3) SQL 语句: 
UPDATE employee SET name = ?, birthdate = ?, hiredate = ? WHERE name = ? AND isstop = ? AND id IS NULL AND sex = ? AND title IS NULL AND birthdate IS NULL AND hiredate IS NULL AND address IS NULL AND city IS NULL AND region IS NULL AND homephone IS NULL AND postalcode IS NULL AND email IS NULL AND notes IS NULL 

此段纪录于: 2004-11-13 20:01

----------------------------------------

对数据库提交的操作没有被成功执行，发生 -3 号错误。

1) 出错对象/位置: 
数据窗口/数据存储“n_cst_ds_lv”的数据对象“d_employee_list”；
位于数据窗口/数据存储主缓冲区的第 3 行纪录。

2) DBMS 错误消息: 
Row changed between retrieve and update.

No changes made to database.

UPDATE employee SET name = ?, birthdate = ?, hiredate = ? WHERE name = ? AND isstop = ? AND id IS NULL AND sex = ? AND title IS NULL AND birthdate IS NULL AND hiredate IS NULL AND address IS NULL AND city IS NULL AND region IS NULL AND homephone IS NULL AND postalcode IS NULL AND email IS NULL AND notes IS NULL 

3) SQL 语句: 
UPDATE employee SET name = ?, birthdate = ?, hiredate = ? WHERE name = ? AND isstop = ? AND id IS NULL AND sex = ? AND title IS NULL AND birthdate IS NULL AND hiredate IS NULL AND address IS NULL AND city IS NULL AND region IS NULL AND homephone IS NULL AND postalcode IS NULL AND email IS NULL AND notes IS NULL 

此段纪录于: 2004-11-13 20:01

----------------------------------------

对数据库提交的操作没有被成功执行，发生 -3 号错误。

1) 出错对象/位置: 
数据窗口/数据存储“n_cst_ds_lv”的数据对象“d_employee_list”；
位于数据窗口/数据存储主缓冲区的第 3 行纪录。

2) DBMS 错误消息: 
Row changed between retrieve and update.

No changes made to database.

UPDATE employee SET name = ?, birthdate = ?, hiredate = ? WHERE name = ? AND isstop = ? AND id IS NULL AND sex = ? AND title IS NULL AND birthdate IS NULL AND hiredate IS NULL AND address IS NULL AND city IS NULL AND region IS NULL AND homephone IS NULL AND postalcode IS NULL AND email IS NULL AND notes IS NULL 

3) SQL 语句: 
UPDATE employee SET name = ?, birthdate = ?, hiredate = ? WHERE name = ? AND isstop = ? AND id IS NULL AND sex = ? AND title IS NULL AND birthdate IS NULL AND hiredate IS NULL AND address IS NULL AND city IS NULL AND region IS NULL AND homephone IS NULL AND postalcode IS NULL AND email IS NULL AND notes IS NULL 

此段纪录于: 2004-11-13 20:01

----------------------------------------

对数据库提交的操作没有被成功执行，发生 -195 号错误。

1) 出错对象/位置: 
数据窗口/数据存储“dw_spda”的数据对象“dw_spda_f”；
位于数据窗口/数据存储主缓冲区的第 39 行纪录。

2) DBMS 错误消息: 
SQLSTATE = 23000
[Sybase][ODBC Driver][Adaptive Server Anywhere]Integrity constraint violation: Column 'spmc' in table 'SPDA' cannot be NULL

No changes made to database.

INSERT INTO spda ( sid, spmc, dlm, spsj, spjj, dpsl, jdrq, g_id, spgg, spdw, sphyj, fhhh, thfs, thtj, spzdj, memo, sppp, spmcpy ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

3) SQL 语句: 
INSERT INTO spda ( sid, spmc, dlm, spsj, spjj, dpsl, jdrq, g_id, spgg, spdw, sphyj, fhhh, thfs, thtj, spzdj, memo, sppp, spmcpy ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

此段纪录于: 2005-03-16 23:50

----------------------------------------

对数据库提交的操作没有被成功执行，发生 -141 号错误。

1) 出错对象/位置: 
数据窗口/数据存储“dw_store”的数据对象“dw_store_g”；
位于数据窗口/数据存储主缓冲区的第 0 行纪录。

2) DBMS 错误消息: 
Select error: SQLSTATE = S0002
[Sybase][ODBC Driver][Adaptive Server Anywhere]Table or view not found: Table 'spstore' not found

3) SQL 语句: 
  SELECT  "spstore"."sid" ,           "spstore"."zgkcl" ,           "spstore"."dgrq" ,           "spstore"."zjdhrq" ,           "spstore"."zjdhsl" ,           "spstore"."zxkcl" ,           "spstore"."xssl" ,           "spda"."fhhh" ,           "spda"."spmc"     FROM "spstore" ,           "spda"     WHERE ( "spstore"."sid" = "spda"."sid" )  ORDER BY "spstore"."sid"          ASC  

此段纪录于: 2005-03-17 23:47

----------------------------------------

对数据库提交的操作没有被成功执行，发生 -141 号错误。

1) 出错对象/位置: 
数据窗口/数据存储“dw_spda”的数据对象“dw_spda_f”；
位于数据窗口/数据存储主缓冲区的第 0 行纪录。

2) DBMS 错误消息: 
Select error: SQLSTATE = S0002
[Sybase][ODBC Driver][Adaptive Server Anywhere]Table or view not found: Table 'spda' not found

3) SQL 语句: 
  SELECT  "spda"."sid" ,           "spda"."spmc" ,           "spda"."dlm" ,           "spda"."spsj" ,           "spda"."spjj" ,           "spda"."dpsl" ,           "spda"."jdrq" ,           "spda"."g_id" ,           "spda"."spgg" ,           "spda"."spdw" ,           "spda"."sphyj" ,           "spda"."fhhh" ,           "spda"."thfs" ,           "spda"."thtj" ,           "spda"."spzdj" ,           "spda"."memo" ,           "spda"."sppp" ,           "spda"."spmcpy"     FROM "spda"    

此段纪录于: 2005-03-17 23:47

----------------------------------------