Received: from diligence.com (acm-131.in-tch.com [216.166.138.131] (may be forged)) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id e9V0Qtl10641 for ; Mon, 30 Oct 2000 19:26:56 -0500 (EST) (envelope-from tim@diligence.com) Received: (qmail 32592 invoked from network); 31 Oct 2000 00:27:15 -0000 Received: from ns2.diligence.com (HELO al) (192.168.0.1) by pdc.diligence.com with SMTP; 31 Oct 2000 00:27:15 -0000 Message-Id: <4.2.0.58.20001030172047.00a4e260@mail.diligence.com> X-Sender: tuckun@mail.diligence.com X-Mailer: QUALCOMM Windows Eudora Pro Version 4.2.0.58 Date: Mon, 30 Oct 2000 17:28:03 -0700 To: pgsql-interfaces@postgresql.org From: Tim Uckun Subject: Attaching views to access. Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200010/13 X-Sequence-Number: 13 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.