I have two simple tables with int3 and varchar fields. I created a view
linking the two tables one to one (one is just a lookup) and attached them
to access. When I attempt to view the data I get a dialog box saying odbc
call failed and all the fields values show up as "#Name?".
Here is the end of the odbc log file..
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while
executing the query' ------------------------------------------------------------
hdbc=157757728,stmt=157764064, result=0 manual_result=0, prepare=1, internal=0
bindings=0,bindings_allocated=0 parameters=157523200, parameters_allocated=10
statement_type=0,statement='SELECT
"keyfield","courtid","docketnumber","courtdivision","arrestdate","filedate",
"charge1","charge2","charge3","charge4","charge5","charge6","warrantstatus",
"filingmanner","trialtype","counseltype","dispcharge1","dispcharge2","dispch
arge3","dispcharge4","dispcharge5","dispcharge6","finelevied","restitution",
"offendertype","lisencesusp","publicservhrs","dispdate","probparole","timeto
serve","transfertodcp","childsexoff","vicunder18","race","sex","dobyear","do
bmonth","dobday","deflastname","deffirstname","defmiddlename","defattorney",
"arresttracknum","stateidnum","socsecnum","driverslicnum","description","xmi
n" FROM "qry_ar" WHERE "keyfield" = ? OR "keyfield" = ? OR "keyfield" = ?
OR "keyfield" = ? OR "keyfield" = ? OR "keyfield" = ? OR "keyfield" = ? OR
"keyfield" = ? OR "keyfield" = ? OR "keyfield" = ?' stmt_with_params='declare SQL_CUR096749E0 cursor
for
SELECT
"keyfield","courtid","docketnumber","courtdivision","arrestdate","filedate",
"charge1","charge2","charge3","charge4","charge5","charge6","warrantstatus",
"filingmanner","trialtype","counseltype","dispcharge1","dispcharge2","dispch
arge3","dispcharge4","dispcharge5","dispcharge6","finelevied","restitution",
"offendertype","lisencesusp","publicservhrs","dispdate","probparole","timeto
serve","transfertodcp","childsexoff","vicunder18","race","sex","dobyear","do
bmonth","dobday","deflastname","deffirstname","defmiddlename","defattorney",
"arresttracknum","stateidnum","socsecnum","driverslicnum","description","xmi
n" FROM "qry_ar" WHERE "keyfield" = 2 OR "keyfield" = 4 OR "keyfield" = 8
OR "keyfield" = 16 OR "keyfield" = 32 OR "keyfield" = 64 OR "keyfield" =
128 OR "keyfield" = 256 OR "keyfield" = 512 OR "keyfield" = 1024' data_at_exec=-1,
current_exec_param=-1,put_data=0 currTuple=-1, current_col=-1, lobj_fd=-1 maxRows=0,
rowset_size=1,keyset_size=0, cursor_type=0,
scroll_concurrency=1 cursor_name='SQL_CUR096749E0' ----------------QResult Info
-------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: system
column xmin not available - qry_ar is a view' ------------------------------------------------------------
henv=157490960, conn=157757728, status=1, num_stmts=16 sock=157491896, stmts=157686056,
lobj_type=-999 ---------------- Socket Info ------------------------------- socket=652, reverse=0,
errornumber=0,errormsg='(null)' buffer_in=157886608, buffer_out=157890712 buffer_filled_in=3,
buffer_filled_out=0,buffer_read_in=2
conn=157497328, query='close SQL_CUR09663050'
conn=157497328, query='END'
conn=157757728, query='BEGIN'
conn=157757728, query='declare SQL_CUR096749E0 cursor for SELECT
"qry_ar"."keyfield" FROM "qry_ar" '
conn=157757728, query='fetch 100 in SQL_CUR096749E0' [ fetched 100 rows ]
conn=157757728, query='fetch 100 in SQL_CUR096749E0' [ fetched 100 rows ]
conn=157757728, query='fetch 100 in SQL_CUR096749E0' [ fetched 100 rows ]
conn=157497328, query='BEGIN'
conn=157497328, query='declare SQL_CUR096948A0 cursor for SELECT
"keyfield","courtid","docketnumber","courtdivision","arrestdate","filedate",
"charge1","charge2","charge3","charge4","charge5","charge6","warrantstatus",
"filingmanner","trialtype","counseltype","dispcharge1","dispcharge2","dispch
arge3","dispcharge4","dispcharge5","dispcharge6","finelevied","restitution",
"offendertype","lisencesusp","publicservhrs","dispdate","probparole","timeto
serve","transfertodcp","childsexoff","vicunder18","race","sex","dobyear","do
bmonth","dobday","deflastname","deffirstname","defmiddlename","defattorney",
"arresttracknum","stateidnum","socsecnum","driverslicnum","description","xmi
n" FROM "qry_ar" WHERE "keyfield" = 2 OR "keyfield" = 4 OR "keyfield" = 8
OR "keyfield" = 16 OR "keyfield" = 32 OR "keyfield" = 64 OR "keyfield" =
128 OR "keyfield" = 256 OR "keyfield" = 512 OR "keyfield" = 1024'
ERROR from backend during send_query: 'ERROR: system column xmin not
available - qry_ar is a view'
conn=157497328, query='ABORT'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while
executing the query' ------------------------------------------------------------
hdbc=157497328,stmt=157894816, result=0 manual_result=0, prepare=1, internal=0
bindings=0,bindings_allocated=0 parameters=157523200, parameters_allocated=10
statement_type=0,statement='SELECT
"keyfield","courtid","docketnumber","courtdivision","arrestdate","filedate",
"charge1","charge2","charge3","charge4","charge5","charge6","warrantstatus",
"filingmanner","trialtype","counseltype","dispcharge1","dispcharge2","dispch
arge3","dispcharge4","dispcharge5","dispcharge6","finelevied","restitution",
"offendertype","lisencesusp","publicservhrs","dispdate","probparole","timeto
serve","transfertodcp","childsexoff","vicunder18","race","sex","dobyear","do
bmonth","dobday","deflastname","deffirstname","defmiddlename","defattorney",
"arresttracknum","stateidnum","socsecnum","driverslicnum","description","xmi
n" FROM "qry_ar" WHERE "keyfield" = ? OR "keyfield" = ? OR "keyfield" = ?
OR "keyfield" = ? OR "keyfield" = ? OR "keyfield" = ? OR "keyfield" = ? OR
"keyfield" = ? OR "keyfield" = ? OR "keyfield" = ?' stmt_with_params='declare SQL_CUR096948A0 cursor
for
SELECT
"keyfield","courtid","docketnumber","courtdivision","arrestdate","filedate",
"charge1","charge2","charge3","charge4","charge5","charge6","warrantstatus",
"filingmanner","trialtype","counseltype","dispcharge1","dispcharge2","dispch
arge3","dispcharge4","dispcharge5","dispcharge6","finelevied","restitution",
"offendertype","lisencesusp","publicservhrs","dispdate","probparole","timeto
serve","transfertodcp","childsexoff","vicunder18","race","sex","dobyear","do
bmonth","dobday","deflastname","deffirstname","defmiddlename","defattorney",
"arresttracknum","stateidnum","socsecnum","driverslicnum","description","xmi
n" FROM "qry_ar" WHERE "keyfield" = 2 OR "keyfield" = 4 OR "keyfield" = 8
OR "keyfield" = 16 OR "keyfield" = 32 OR "keyfield" = 64 OR "keyfield" =
128 OR "keyfield" = 256 OR "keyfield" = 512 OR "keyfield" = 1024' data_at_exec=-1,
current_exec_param=-1,put_data=0 currTuple=-1, current_col=-1, lobj_fd=-1 maxRows=0,
rowset_size=1,keyset_size=0, cursor_type=0,
scroll_concurrency=1 cursor_name='SQL_CUR096948A0' ----------------QResult Info
-------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: system
column xmin not available - qry_ar is a view' ------------------------------------------------------------
henv=157490960, conn=157497328, status=1, num_stmts=16 sock=157490976, stmts=157491024,
lobj_type=-999 ---------------- Socket Info ------------------------------- socket=624, reverse=0,
errornumber=0,errormsg='(null)' buffer_in=157503664, buffer_out=157507768 buffer_filled_in=3,
buffer_filled_out=0,buffer_read_in=2
conn=157757728, query='close SQL_CUR096749E0'
conn=157757728, query='END'
:wq
Tim Uckun
Due Diligence Inc. http://www.diligence.com/ Americas Background
Investigation Expert.
If your company isn't doing background checks, maybe you haven't considered
the risks of a bad hire.