Hi all,
Attached are a couple ODBC traces for this problem, one for a failed
insert into the view, and one for a succesful insert. My guess is that
either:
a) there's a problem converting Access' date format to Firebird that
shows up in views, but not in tables
or
b) there's a bug in the ODBC driver's handling of inserts into views.

However, I can't see from these trace logs how Access submits the data
values in either case. Does anyone have any ideas, or should I pass
this question along to the ODBC lists?

Thanks,

Eric



ellsworth_eric wrote:

>--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
>wrote:
>
>
>>>I have a table Payments, which has these fields:
>>> PaymentID (int, connected to generator PaymentID)
>>> PaymentDate (date)
>>> PaymentMethod (varchar)
>>> SaleYear (int)
>>>I can successfully link tables and add entries ot them in Access,
>>>
>>>
>using
>
>
>>>the ODBC driver from:
>>>http://www.firebirdsql.org/index.php?op=files&id=odbc
>>><http://www.firebirdsql.org/index.php?op=files&id=odbc>
>>>
>>>I also created a view:
>>>CREATE VIEW CAT_PAYMENTS AS
>>>SELECT * FROM Payments
>>>WHERE SaleYear = EXTRACT(YEAR FROM CAST('NOW' AS DATE))
>>>WITH CHECK OPTION;
>>>
>>>I would like to be able to use the view in Access so that a particular
>>>user can only make entries for SaleYear being this year.
>>>
>>>I can successfully insert items into the view using Marathon's SQL
>>>execution function, and succesfully SELECT data from this view. I can
>>>also successfully insert items into the view using a pass-thru
>>>
>>>
>query in
>
>
>>>Access. However, when I attempt to use a regular query to add data to
>>>this view, I get the error:
>>>"Single-row update/delete affected more than one row of a linked
>>>
>>>
>table.
>
>
>>>Unique index contains duplicate values."
>>>
>>>Has anybody encountered this error or know anything about it? All
>>>
>>>
>I get
>
>
>>>on the google newsgroups is stuff about checking for dupes, and I
>>>
>>>
>am not
>
>
>>>violating any unique indexes.
>>>
>>>To try to trace this problem, I would like to enable tracing in
>>>
>>>
>the ODBC
>
>
>>>driver to figure out what SQL is sent to the server. However, there
>>>don't appear to be any options in the driver dialog box for doing so.
>>>Can anyone point me to resources on tracing ODBC calls?
>>>
>>>Many thanks,
>>>
>>>Eric
>>>
>>>
>>You don't actually insert records into a view - you insert them into the
>>table. Marathon is hiding this fact from you perhaps.
>>This pass-thru query is also trying to insert into the table - not
>>
>>
>the view.
>
>
>>Your view is simple and only references one table so you may get
>>
>>
>errors in
>
>
>>future if/when your view become joins and reference more than one table.
>>In both of these successful cases, the tool is inserting a record
>>
>>
>which , I
>
>
>>suspect, omits the PK field and your trigger does not check for NULL, it
>>just creates a gen value. This will be successful.
>>If your trigger tests for NULL then you may have been able to insert one
>>record only - is your gen field a PK? perhaps not also... it will accept
>>NULLs if it is not a PK.
>>Show us your table metadata including your trigger and generator.
>>
>>Alan
>>
>>
>
>Hi Alan,
> I certainly agree that the records reside in the table, but my
>understanding is that Firebird allows records to be inserted through a
>view.
>
> Here's the SQL to create the table:
>create table PAYMENTS(
> PAYMENTID integer not null,
> PAYMENTDATE date,
> PAYMENTMETHOD varchar(50) not null,
> CCTYPE varchar(50),
> CCNAME varchar(200),
> CCEXPIREMONTH varchar(20),
> CCEXPIREYEAR varchar(10),
> AMOUNT float not null,
> CCNUMBER varchar(50),
> NOTES blob sub_type 0 segment size 80,
> PAYMENTFOR varchar(25) not null,
> INVITEEID integer not null,
> AUCTIONYEAR integer);
>
>alter table PAYMENTS add constraint CHECK_PAYMENTFOR check (PAYMENTFOR
>IN ("Item","Entrance Fee","Donation","Other"));
>
>alter table PAYMENTS add constraint CHECKK_AUCTIONYEAR CHECK
>(AUCTIONYEAR >= 2003);
>
>/* Primary Key */
>alter table PAYMENTS add constraint PK_PAYMENTS primary key (PAYMENTID);
>
>/* Foreign Key */
>alter table PAYMENTS add constraint FK1_PAYMENTS foreign key
>(INVITEEID) references GUESTS(INVITEEID);
>
>/* Triggers */
>create trigger PAYMENTID_INCREMENT for PAYMENTS active before insert
>position 0
>as
>begin
>IF (PAYMENTS.PAYMENTID IS NULL) THEN
> PAYMENTS.PAYMENTID = GEN_ID(PAYMENTID,1);
>end
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>

----------


AuctionDB-ODBC 74c-464 ENTER SQLSetConnectOption
HDBC 08121348
SQLINTEGER 102 <SQL_AUTOCOMMIT>
SQLPOINTER 0x00000000

AuctionDB-ODBC 74c-464 EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS)
HDBC 08121348
SQLINTEGER 102 <SQL_AUTOCOMMIT>
SQLPOINTER 0x00000000

AuctionDB-ODBC 74c-464 ENTER SQLAllocStmt
HDBC 08121348
HSTMT * 0013EF5C

AuctionDB-ODBC 74c-464 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 08121348
HSTMT * 0x0013EF5C ( 0x08124ca0)

AuctionDB-ODBC 74c-464 ENTER SQLGetStmtOption
HSTMT 08124CA0
UWORD 0
PTR 0x0013EA9C

AuctionDB-ODBC 74c-464 EXIT SQLGetStmtOption with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
UWORD 0
PTR 0x0013EA9C

AuctionDB-ODBC 74c-464 ENTER SQLSetStmtOption
HSTMT 08124CA0
UWORD 0 <SQL_QUERY_TIMEOUT>
SQLPOINTER 0x0000003C

AuctionDB-ODBC 74c-464 EXIT SQLSetStmtOption with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
UWORD 0 <SQL_QUERY_TIMEOUT>
SQLPOINTER 0x0000003C (BADMEM)

AuctionDB-ODBC 74c-464 ENTER SQLBindParameter
HSTMT 08124CA0
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD 11 <SQL_C_TIMESTAMP>
SWORD 11 <SQL_TIMESTAMP>
SQLULEN 24
SWORD 4
PTR 0x1214BE3C
SQLLEN 0
SQLLEN * 0x1214BE38

AuctionDB-ODBC 74c-464 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD 11 <SQL_C_TIMESTAMP>
SWORD 11 <SQL_TIMESTAMP>
SQLULEN 24
SWORD 4
PTR 0x1214BE3C
SQLLEN 0
SQLLEN * 0x1214BE38 (16)

AuctionDB-ODBC 74c-464 ENTER SQLBindParameter
HSTMT 08124CA0
UWORD 2
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 50
SWORD 0
PTR 0x1214BE50
SQLLEN 0
SQLLEN * 0x1214BE4C

AuctionDB-ODBC 74c-464 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
UWORD 2
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 50
SWORD 0
PTR 0x1214BE50
SQLLEN 0
SQLLEN * 0x1214BE4C (10)

AuctionDB-ODBC 74c-464 ENTER SQLBindParameter
HSTMT 08124CA0
UWORD 3
SWORD 1 <SQL_PARAM_INPUT>
SWORD 7 <SQL_C_FLOAT>
SWORD 7 <SQL_REAL>
SQLULEN 24
SWORD 0
PTR 0x1214BE5E
SQLLEN 0
SQLLEN * 0x1214BE5A

AuctionDB-ODBC 74c-464 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
UWORD 3
SWORD 1 <SQL_PARAM_INPUT>
SWORD 7 <SQL_C_FLOAT>
SWORD 7 <SQL_REAL>
SQLULEN 24
SWORD 0
PTR 0x1214BE5E
SQLLEN 0
SQLLEN * 0x1214BE5A (4)

AuctionDB-ODBC 74c-464 ENTER SQLBindParameter
HSTMT 08124CA0
UWORD 4
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 25
SWORD 0
PTR 0x1214BE66
SQLLEN 0
SQLLEN * 0x1214BE62

AuctionDB-ODBC 74c-464 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
UWORD 4
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 25
SWORD 0
PTR 0x1214BE66
SQLLEN 0
SQLLEN * 0x1214BE62 (8)

AuctionDB-ODBC 74c-464 ENTER SQLBindParameter
HSTMT 08124CA0
UWORD 5
SWORD 1 <SQL_PARAM_INPUT>
SWORD 4 <SQL_C_LONG>
SWORD 4 <SQL_INTEGER>
SQLULEN 10
SWORD 0
PTR 0x1214BE72
SQLLEN 0
SQLLEN * 0x1214BE6E

AuctionDB-ODBC 74c-464 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
UWORD 5
SWORD 1 <SQL_PARAM_INPUT>
SWORD 4 <SQL_C_LONG>
SWORD 4 <SQL_INTEGER>
SQLULEN 10
SWORD 0
PTR 0x1214BE72
SQLLEN 0
SQLLEN * 0x1214BE6E (4)

AuctionDB-ODBC 74c-464 ENTER SQLBindParameter
HSTMT 08124CA0
UWORD 6
SWORD 1 <SQL_PARAM_INPUT>
SWORD 4 <SQL_C_LONG>
SWORD 4 <SQL_INTEGER>
SQLULEN 10
SWORD 0
PTR 0x1214BE7A
SQLLEN 0
SQLLEN * 0x1214BE76

AuctionDB-ODBC 74c-464 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
UWORD 6
SWORD 1 <SQL_PARAM_INPUT>
SWORD 4 <SQL_C_LONG>
SWORD 4 <SQL_INTEGER>
SQLULEN 10
SWORD 0
PTR 0x1214BE7A
SQLLEN 0
SQLLEN * 0x1214BE76 (4)

AuctionDB-ODBC 74c-464 ENTER SQLExecDirectW
HSTMT 08124CA0
WCHAR * 0x12144138 [ -3] "INSERT INTO "PAYMENTS" ("PAYMENTDATE","PAYMENTMETHOD","AMOUNT","PAYMENTFOR","INVITEEID","AUCTIONYEAR") VALUES (?,?,?,?,?,?)\ 0"
SDWORD -3

AuctionDB-ODBC 74c-464 EXIT SQLExecDirectW with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
WCHAR * 0x12144138 [ -3] "INSERT INTO "PAYMENTS" ("PAYMENTDATE","PAYMENTMETHOD","AMOUNT","PAYMENTFOR","INVITEEID","AUCTIONYEAR") VALUES (?,?,?,?,?,?)\ 0"
SDWORD -3

AuctionDB-ODBC 74c-464 ENTER SQLFreeStmt
HSTMT 08124CA0
UWORD 3 <SQL_RESET_PARAMS>

AuctionDB-ODBC 74c-464 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
UWORD 3 <SQL_RESET_PARAMS>

AuctionDB-ODBC 74c-464 ENTER SQLRowCount
HSTMT 08124CA0
SQLLEN * 0x0013EF30

AuctionDB-ODBC 74c-464 EXIT SQLRowCount with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
SQLLEN * 0x0013EF30 (1)

AuctionDB-ODBC 74c-464 ENTER SQLFreeStmt
HSTMT 08124CA0
UWORD 1 <SQL_DROP>

AuctionDB-ODBC 74c-464 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
UWORD 1 <SQL_DROP>

AuctionDB-ODBC 74c-464 ENTER SQLTransact
HENV 081212A0
HDBC 08121348
UWORD 0 <SQL_COMMIT>

AuctionDB-ODBC 74c-464 EXIT SQLTransact with return code 0 (SQL_SUCCESS)
HENV 081212A0
HDBC 08121348
UWORD 0 <SQL_COMMIT>

AuctionDB-ODBC 74c-464 ENTER SQLSetConnectOption
HDBC 08121348
SQLINTEGER 102 <SQL_AUTOCOMMIT>
SQLPOINTER 0x00000001

AuctionDB-ODBC 74c-464 EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS)
HDBC 08121348
SQLINTEGER 102 <SQL_AUTOCOMMIT>
SQLPOINTER 0x00000001 (BADMEM)

AuctionDB-ODBC 74c-464 ENTER SQLAllocStmt
HDBC 08121348
HSTMT * 0013E0D4

AuctionDB-ODBC 74c-464 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 08121348
HSTMT * 0x0013E0D4 ( 0x08124ca0)

AuctionDB-ODBC 74c-464 ENTER SQLGetStmtOption
HSTMT 08124CA0
UWORD 0
PTR 0x0013E054

AuctionDB-ODBC 74c-464 EXIT SQLGetStmtOption with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
UWORD 0
PTR 0x0013E054

AuctionDB-ODBC 74c-464 ENTER SQLSetStmtOption
HSTMT 08124CA0
UWORD 0 <SQL_QUERY_TIMEOUT>
SQLPOINTER 0x0000003C

AuctionDB-ODBC 74c-464 EXIT SQLSetStmtOption with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
UWORD 0 <SQL_QUERY_TIMEOUT>
SQLPOINTER 0x0000003C (BADMEM)

AuctionDB-ODBC 74c-464 ENTER SQLGetStmtOption
HSTMT 08124CA0
UWORD 3
PTR 0x0013E054

AuctionDB-ODBC 74c-464 EXIT SQLGetStmtOption with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
UWORD 3
PTR 0x0013E054

AuctionDB-ODBC 74c-464 ENTER SQLSetStmtOption
HSTMT 08124CA0
UWORD 3 <SQL_MAX_LENGTH>
SQLPOINTER 0x7FFFFFFF

AuctionDB-ODBC 74c-464 EXIT SQLSetStmtOption with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
UWORD 3 <SQL_MAX_LENGTH>
SQLPOINTER 0x7FFFFFFF (BADMEM)

AuctionDB-ODBC 74c-464 ENTER SQLPrepareW
HSTMT 08124CA0
WCHAR * 0x12144138 [ -3] "SELECT "PAYMENTID","PAYMENTDATE","PAYMENTMETHOD","CCTYPE","CCNAME","CCEXPIREMONTH","CCEXPIREYEAR","AMOUNT","CCNUMBER","NOTES","PAYMENTFOR","INVITEEID","AUCTIONYEAR" FROM "PAYMENTS" WHERE "PAYMENTID" IS NULL\ 0"
SDWORD -3

AuctionDB-ODBC 74c-464 EXIT SQLPrepareW with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
WCHAR * 0x12144138 [ -3] "SELECT "PAYMENTID","PAYMENTDATE","PAYMENTMETHOD","CCTYPE","CCNAME","CCEXPIREMONTH","CCEXPIREYEAR","AMOUNT","CCNUMBER","NOTES","PAYMENTFOR","INVITEEID","AUCTIONYEAR" FROM "PAYMENTS" WHERE "PAYMENTID" IS NULL\ 0"
SDWORD -3

AuctionDB-ODBC 74c-464 ENTER SQLExecute
HSTMT 08124CA0

AuctionDB-ODBC 74c-464 EXIT SQLExecute with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0

AuctionDB-ODBC 74c-464 ENTER SQLFetch
HSTMT 08124CA0

AuctionDB-ODBC 74c-464 EXIT SQLFetch with return code 100 (SQL_NO_DATA_FOUND)
HSTMT 08124CA0

AuctionDB-ODBC 74c-464 ENTER SQLFreeStmt
HSTMT 08124CA0
UWORD 0 <SQL_CLOSE>

AuctionDB-ODBC 74c-464 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
UWORD 0 <SQL_CLOSE>

AuctionDB-ODBC 74c-464 ENTER SQLFreeStmt
HSTMT 08124CA0
UWORD 1 <SQL_DROP>

AuctionDB-ODBC 74c-464 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
UWORD 1 <SQL_DROP>

AuctionDB-ODBC 74c-464 ENTER SQLAllocStmt
HDBC 08121348
HSTMT * 0013E0EC

AuctionDB-ODBC 74c-464 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 08121348
HSTMT * 0x0013E0EC ( 0x08124ca0)

AuctionDB-ODBC 74c-464 ENTER SQLGetStmtOption
HSTMT 08124CA0
UWORD 0
PTR 0x0013DF84

AuctionDB-ODBC 74c-464 EXIT SQLGetStmtOption with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
UWORD 0
PTR 0x0013DF84

AuctionDB-ODBC 74c-464 ENTER SQLSetStmtOption
HSTMT 08124CA0
UWORD 0 <SQL_QUERY_TIMEOUT>
SQLPOINTER 0x0000003C

AuctionDB-ODBC 74c-464 EXIT SQLSetStmtOption with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
UWORD 0 <SQL_QUERY_TIMEOUT>
SQLPOINTER 0x0000003C (BADMEM)

AuctionDB-ODBC 74c-464 ENTER SQLBindParameter
HSTMT 08124CA0
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD 11 <SQL_C_TIMESTAMP>
SWORD 11 <SQL_TIMESTAMP>
SQLULEN 24
SWORD 4
PTR 0x1214BE82
SQLLEN 0
SQLLEN * 0x1214BE7E

AuctionDB-ODBC 74c-464 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD 11 <SQL_C_TIMESTAMP>
SWORD 11 <SQL_TIMESTAMP>
SQLULEN 24
SWORD 4
PTR 0x1214BE82
SQLLEN 0
SQLLEN * 0x1214BE7E (16)

AuctionDB-ODBC 74c-464 ENTER SQLBindParameter
HSTMT 08124CA0
UWORD 2
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 50
SWORD 0
PTR 0x1214BE96
SQLLEN 0
SQLLEN * 0x1214BE92

AuctionDB-ODBC 74c-464 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
UWORD 2
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 50
SWORD 0
PTR 0x1214BE96
SQLLEN 0
SQLLEN * 0x1214BE92 (10)

AuctionDB-ODBC 74c-464 ENTER SQLBindParameter
HSTMT 08124CA0
UWORD 3
SWORD 1 <SQL_PARAM_INPUT>
SWORD 7 <SQL_C_FLOAT>
SWORD 7 <SQL_REAL>
SQLULEN 24
SWORD 0
PTR 0x1214BEA4
SQLLEN 0
SQLLEN * 0x1214BEA0

AuctionDB-ODBC 74c-464 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
UWORD 3
SWORD 1 <SQL_PARAM_INPUT>
SWORD 7 <SQL_C_FLOAT>
SWORD 7 <SQL_REAL>
SQLULEN 24
SWORD 0
PTR 0x1214BEA4
SQLLEN 0
SQLLEN * 0x1214BEA0 (4)

AuctionDB-ODBC 74c-464 ENTER SQLBindParameter
HSTMT 08124CA0
UWORD 4
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 25
SWORD 0
PTR 0x1214BEAC
SQLLEN 0
SQLLEN * 0x1214BEA8

AuctionDB-ODBC 74c-464 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
UWORD 4
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 25
SWORD 0
PTR 0x1214BEAC
SQLLEN 0
SQLLEN * 0x1214BEA8 (8)

AuctionDB-ODBC 74c-464 ENTER SQLBindParameter
HSTMT 08124CA0
UWORD 5
SWORD 1 <SQL_PARAM_INPUT>
SWORD 4 <SQL_C_LONG>
SWORD 4 <SQL_INTEGER>
SQLULEN 10
SWORD 0
PTR 0x1214BEB8
SQLLEN 0
SQLLEN * 0x1214BEB4

AuctionDB-ODBC 74c-464 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
UWORD 5
SWORD 1 <SQL_PARAM_INPUT>
SWORD 4 <SQL_C_LONG>
SWORD 4 <SQL_INTEGER>
SQLULEN 10
SWORD 0
PTR 0x1214BEB8
SQLLEN 0
SQLLEN * 0x1214BEB4 (4)

AuctionDB-ODBC 74c-464 ENTER SQLBindParameter
HSTMT 08124CA0
UWORD 6
SWORD 1 <SQL_PARAM_INPUT>
SWORD 4 <SQL_C_LONG>
SWORD 4 <SQL_INTEGER>
SQLULEN 10
SWORD 0
PTR 0x1214BEC0
SQLLEN 0
SQLLEN * 0x1214BEBC

AuctionDB-ODBC 74c-464 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
UWORD 6
SWORD 1 <SQL_PARAM_INPUT>
SWORD 4 <SQL_C_LONG>
SWORD 4 <SQL_INTEGER>
SQLULEN 10
SWORD 0
PTR 0x1214BEC0
SQLLEN 0
SQLLEN * 0x1214BEBC (4)

AuctionDB-ODBC 74c-464 ENTER SQLExecDirectW
HSTMT 08124CA0
WCHAR * 0x12144138 [ -3] "SELECT "PAYMENTS"."PAYMENTID" FROM "PAYMENTS" WHERE "PAYMENTDATE" = ? AND "PAYMENTMETHOD" = ? AND "AMOUNT" = ? AND "PAYMENTFOR" = ? AND "INVITEEID" = ? AND "AUCTIONYEAR" = ?\ 0"
SDWORD -3

AuctionDB-ODBC 74c-464 EXIT SQLExecDirectW with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
WCHAR * 0x12144138 [ -3] "SELECT "PAYMENTS"."PAYMENTID" FROM "PAYMENTS" WHERE "PAYMENTDATE" = ? AND "PAYMENTMETHOD" = ? AND "AMOUNT" = ? AND "PAYMENTFOR" = ? AND "INVITEEID" = ? AND "AUCTIONYEAR" = ?\ 0"
SDWORD -3

AuctionDB-ODBC 74c-464 ENTER SQLFetch
HSTMT 08124CA0

AuctionDB-ODBC 74c-464 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0

AuctionDB-ODBC 74c-464 ENTER SQLGetData
HSTMT 08124CA0
UWORD 1
SWORD 99 <SQL_C_DEFAULT>
PTR <unknown type>
SQLLEN 252
SQLLEN * 0x0013DFCC

AuctionDB-ODBC 74c-464 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
UWORD 1
SWORD 99 <SQL_C_DEFAULT>
PTR <unknown type>
SQLLEN 252
SQLLEN * 0x0013DFCC (4)

AuctionDB-ODBC 74c-464 ENTER SQLFetch
HSTMT 08124CA0

AuctionDB-ODBC 74c-464 EXIT SQLFetch with return code 100 (SQL_NO_DATA_FOUND)
HSTMT 08124CA0

AuctionDB-ODBC 74c-464 ENTER SQLFreeStmt
HSTMT 08124CA0
UWORD 0 <SQL_CLOSE>

AuctionDB-ODBC 74c-464 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
UWORD 0 <SQL_CLOSE>

AuctionDB-ODBC 74c-464 ENTER SQLFreeStmt
HSTMT 08124CA0
UWORD 1 <SQL_DROP>

AuctionDB-ODBC 74c-464 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 08124CA0
UWORD 1 <SQL_DROP>

AuctionDB-ODBC 74c-464 ENTER SQLBindParameter
HSTMT 08123840
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD 99 <SQL_C_DEFAULT>
SWORD 4 <SQL_INTEGER>
SQLULEN 10
SWORD 0
PTR 0x0013E91C
SQLLEN 0
SQLLEN * 0x0013E918

AuctionDB-ODBC 74c-464 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 08123840
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD 99 <SQL_C_DEFAULT>
SWORD 4 <SQL_INTEGER>
SQLULEN 10
SWORD 0
PTR 0x0013E91C
SQLLEN 0
SQLLEN * 0x0013E918 (4)

AuctionDB-ODBC 74c-464 ENTER SQLExecute
HSTMT 08123840

AuctionDB-ODBC 74c-464 EXIT SQLExecute with return code 0 (SQL_SUCCESS)
HSTMT 08123840

AuctionDB-ODBC 74c-464 ENTER SQLFetch
HSTMT 08123840

AuctionDB-ODBC 74c-464 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 08123840

AuctionDB-ODBC 74c-464 ENTER SQLGetData
HSTMT 08123840
UWORD 1
SWORD 4 <SQL_C_LONG>
PTR <unknown type>
SQLLEN 32000
SQLLEN * 0x0013E08C

AuctionDB-ODBC 74c-464 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 08123840
UWORD 1
SWORD 4 <SQL_C_LONG>
PTR <unknown type>
SQLLEN 32000
SQLLEN * 0x0013E08C (4)

AuctionDB-ODBC 74c-464 ENTER SQLGetData
HSTMT 08123840
UWORD 2
SWORD 11 <SQL_C_TIMESTAMP>
PTR <unknown type>
SQLLEN 32000
SQLLEN * 0x0013E08C

AuctionDB-ODBC 74c-464 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 08123840
UWORD 2
SWORD 11 <SQL_C_TIMESTAMP>
PTR <unknown type>
SQLLEN 32000
SQLLEN * 0x0013E08C (16)

AuctionDB-ODBC 74c-464 ENTER SQLGetData
HSTMT 08123840
UWORD 3
SWORD -8 <SQL_C_WCHAR>
PTR 0x12144138
SQLLEN 32000
SQLLEN * 0x0013E08C

AuctionDB-ODBC 74c-464 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 08123840
UWORD 3
SWORD -8 <SQL_C_WCHAR>
PTR 0x12144138 [ 10] "Check"
SQLLEN 32000
SQLLEN * 0x0013E08C (10)

AuctionDB-ODBC 74c-464 ENTER SQLGetData
HSTMT 08123840
UWORD 4
SWORD -8 <SQL_C_WCHAR>
PTR 0x12144138
SQLLEN 32000
SQLLEN * 0x0013E08C

AuctionDB-ODBC 74c-464 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 08123840
UWORD 4
SWORD -8 <SQL_C_WCHAR>
PTR 0x12144138
SQLLEN 32000
SQLLEN * 0x0013E08C (-1)

AuctionDB-ODBC 74c-464 ENTER SQLGetData
HSTMT 08123840
UWORD 5
SWORD -8 <SQL_C_WCHAR>
PTR 0x12144138
SQLLEN 32000
SQLLEN * 0x0013E08C

AuctionDB-ODBC 74c-464 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 08123840
UWORD 5
SWORD -8 <SQL_C_WCHAR>
PTR 0x12144138
SQLLEN 32000
SQLLEN * 0x0013E08C (-1)

AuctionDB-ODBC 74c-464 ENTER SQLGetData
HSTMT 08123840
UWORD 6
SWORD -8 <SQL_C_WCHAR>
PTR 0x12144138
SQLLEN 32000
SQLLEN * 0x0013E08C

AuctionDB-ODBC 74c-464 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 08123840
UWORD 6
SWORD -8 <SQL_C_WCHAR>
PTR 0x12144138
SQLLEN 32000
SQLLEN * 0x0013E08C (-1)

AuctionDB-ODBC 74c-464 ENTER SQLGetData
HSTMT 08123840
UWORD 7
SWORD -8 <SQL_C_WCHAR>
PTR 0x12144138
SQLLEN 32000
SQLLEN * 0x0013E08C

AuctionDB-ODBC 74c-464 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 08123840
UWORD 7
SWORD -8 <SQL_C_WCHAR>
PTR 0x12144138
SQLLEN 32000
SQLLEN * 0x0013E08C (-1)

AuctionDB-ODBC 74c-464 ENTER SQLGetData
HSTMT 08123840
UWORD 8
SWORD 7 <SQL_C_FLOAT>
PTR <unknown type>
SQLLEN 32000
SQLLEN * 0x0013E08C

AuctionDB-ODBC 74c-464 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 08123840
UWORD 8
SWORD 7 <SQL_C_FLOAT>
PTR <unknown type>
SQLLEN 32000
SQLLEN * 0x0013E08C (4)

AuctionDB-ODBC 74c-464 ENTER SQLGetData
HSTMT 08123840
UWORD 9
SWORD -8 <SQL_C_WCHAR>
PTR 0x12144138
SQLLEN 32000
SQLLEN * 0x0013E08C

AuctionDB-ODBC 74c-464 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 08123840
UWORD 9
SWORD -8 <SQL_C_WCHAR>
PTR 0x12144138
SQLLEN 32000
SQLLEN * 0x0013E08C (-1)

AuctionDB-ODBC 74c-464 ENTER SQLGetData
HSTMT 08123840
UWORD 10
SWORD -2 <SQL_C_BINARY>
PTR <unknown type>
SQLLEN 32000
SQLLEN * 0x0013E08C

AuctionDB-ODBC 74c-464 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 08123840
UWORD 10
SWORD -2 <SQL_C_BINARY>
PTR <unknown type>
SQLLEN 32000
SQLLEN * 0x0013E08C (-1)

AuctionDB-ODBC 74c-464 ENTER SQLGetData
HSTMT 08123840
UWORD 11
SWORD -8 <SQL_C_WCHAR>
PTR 0x12144138
SQLLEN 32000
SQLLEN * 0x0013E08C

AuctionDB-ODBC 74c-464 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 08123840
UWORD 11
SWORD -8 <SQL_C_WCHAR>
PTR 0x12144138 [ 8] "Item"
SQLLEN 32000
SQLLEN * 0x0013E08C (8)

AuctionDB-ODBC 74c-464 ENTER SQLGetData
HSTMT 08123840
UWORD 12
SWORD 4 <SQL_C_LONG>
PTR <unknown type>
SQLLEN 32000
SQLLEN * 0x0013E08C

AuctionDB-ODBC 74c-464 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 08123840
UWORD 12
SWORD 4 <SQL_C_LONG>
PTR <unknown type>
SQLLEN 32000
SQLLEN * 0x0013E08C (4)

AuctionDB-ODBC 74c-464 ENTER SQLGetData
HSTMT 08123840
UWORD 13
SWORD 4 <SQL_C_LONG>
PTR <unknown type>
SQLLEN 32000
SQLLEN * 0x0013E08C

AuctionDB-ODBC 74c-464 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 08123840
UWORD 13
SWORD 4 <SQL_C_LONG>
PTR <unknown type>
SQLLEN 32000
SQLLEN * 0x0013E08C (4)

AuctionDB-ODBC 74c-464 ENTER SQLFreeStmt
HSTMT 08123840
UWORD 0 <SQL_CLOSE>

AuctionDB-ODBC 74c-464 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 08123840
UWORD 0 <SQL_CLOSE>

AuctionDB-ODBC 74c-464 ENTER SQLBindParameter
HSTMT 08123840
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD 99 <SQL_C_DEFAULT>
SWORD 4 <SQL_INTEGER>
SQLULEN 10
SWORD 0
PTR 0x0013CD9C
SQLLEN 0
SQLLEN * 0x0013CD98

AuctionDB-ODBC 74c-464 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 08123840
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD 99 <SQL_C_DEFAULT>
SWORD 4 <SQL_INTEGER>
SQLULEN 10
SWORD 0
PTR 0x0013CD9C
SQLLEN 0
SQLLEN * 0x0013CD98 (4)

AuctionDB-ODBC 74c-464 ENTER SQLExecute
HSTMT 08123840

AuctionDB-ODBC 74c-464 EXIT SQLExecute with return code 0 (SQL_SUCCESS)
HSTMT 08123840

AuctionDB-ODBC 74c-464 ENTER SQLFetch
HSTMT 08123840

AuctionDB-ODBC 74c-464 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 08123840

AuctionDB-ODBC 74c-464 ENTER SQLGetData
HSTMT 08123840
UWORD 1
SWORD 4 <SQL_C_LONG>
PTR <unknown type>
SQLLEN 32000
SQLLEN * 0x0013CD0C

AuctionDB-ODBC 74c-464 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 08123840
UWORD 1
SWORD 4 <SQL_C_LONG>
PTR <unknown type>
SQLLEN 32000
SQLLEN * 0x0013CD0C (4)

AuctionDB-ODBC 74c-464 ENTER SQLGetData
HSTMT 08123840
UWORD 2
SWORD 11 <SQL_C_TIMESTAMP>
PTR <unknown type>
SQLLEN 32000
SQLLEN * 0x0013CD0C

AuctionDB-ODBC 74c-464 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 08123840
UWORD 2
SWORD 11 <SQL_C_TIMESTAMP>
PTR <unknown type>
SQLLEN 32000
SQLLEN * 0x0013CD0C (16)

AuctionDB-ODBC 74c-464 ENTER SQLGetData
HSTMT 08123840
UWORD 3
SWORD -8 <SQL_C_WCHAR>
PTR 0x12144138
SQLLEN 32000
SQLLEN * 0x0013CD0C

AuctionDB-ODBC 74c-464 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 08123840
UWORD 3
SWORD -8 <SQL_C_WCHAR>
PTR 0x12144138 [ 10] "Check"
SQLLEN 32000
SQLLEN * 0x0013CD0C (10)

AuctionDB-ODBC 74c-464 ENTER SQLGetData
HSTMT 08123840
UWORD 4
SWORD -8 <SQL_C_WCHAR>
PTR 0x12144138
SQLLEN 32000
SQLLEN * 0x0013CD0C

AuctionDB-ODBC 74c-464 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 08123840
UWORD 4
SWORD -8 <SQL_C_WCHAR>
PTR 0x12144138
SQLLEN 32000
SQLLEN * 0x0013CD0C (-1)

AuctionDB-ODBC 74c-464 ENTER SQLGetData
HSTMT 08123840
UWORD 5
SWORD -8 <SQL_C_WCHAR>
PTR 0x12144138
SQLLEN 32000
SQLLEN * 0x0013CD0C

AuctionDB-ODBC 74c-464 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 08123840
UWORD 5
SWORD -8 <SQL_C_WCHAR>
PTR 0x12144138
SQLLEN 32000
SQLLEN * 0x0013CD0C (-1)

AuctionDB-ODBC 74c-464 ENTER SQLGetData
HSTMT 08123840
UWORD 6
SWORD -8 <SQL_C_WCHAR>
PTR 0x12144138
SQLLEN 32000
SQLLEN * 0x0013CD0C

AuctionDB-ODBC 74c-464 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 08123840
UWORD 6
SWORD -8 <SQL_C_WCHAR>
PTR 0x12144138
SQLLEN 32000
SQLLEN * 0x0013CD0C (-1)

AuctionDB-ODBC 74c-464 ENTER SQLGetData
HSTMT 08123840
UWORD 7
SWORD -8 <SQL_C_WCHAR>
PTR 0x12144138
SQLLEN 32000
SQLLEN * 0x0013CD0C

AuctionDB-ODBC 74c-464 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 08123840
UWORD 7
SWORD -8 <SQL_C_WCHAR>
PTR 0x12144138
SQLLEN 32000
SQLLEN * 0x0013CD0C (-1)

AuctionDB-ODBC 74c-464 ENTER SQLGetData
HSTMT 08123840
UWORD 8
SWORD 7 <SQL_C_FLOAT>
PTR <unknown type>
SQLLEN 32000
SQLLEN * 0x0013CD0C

AuctionDB-ODBC 74c-464 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 08123840
UWORD 8
SWORD 7 <SQL_C_FLOAT>
PTR <unknown type>
SQLLEN 32000
SQLLEN * 0x0013CD0C (4)

AuctionDB-ODBC 74c-464 ENTER SQLGetData
HSTMT 08123840
UWORD 9
SWORD -8 <SQL_C_WCHAR>
PTR 0x12144138
SQLLEN 32000
SQLLEN * 0x0013CD0C

AuctionDB-ODBC 74c-464 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 08123840
UWORD 9
SWORD -8 <SQL_C_WCHAR>
PTR 0x12144138
SQLLEN 32000
SQLLEN * 0x0013CD0C (-1)

AuctionDB-ODBC 74c-464 ENTER SQLGetData
HSTMT 08123840
UWORD 10
SWORD -2 <SQL_C_BINARY>
PTR <unknown type>
SQLLEN 32000
SQLLEN * 0x0013CD0C

AuctionDB-ODBC 74c-464 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 08123840
UWORD 10
SWORD -2 <SQL_C_BINARY>
PTR <unknown type>
SQLLEN 32000
SQLLEN * 0x0013CD0C (-1)

AuctionDB-ODBC 74c-464 ENTER SQLGetData
HSTMT 08123840
UWORD 11
SWORD -8 <SQL_C_WCHAR>
PTR 0x12144138
SQLLEN 32000
SQLLEN * 0x0013CD0C

AuctionDB-ODBC 74c-464 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 08123840
UWORD 11
SWORD -8 <SQL_C_WCHAR>
PTR 0x12144138 [ 8] "Item"
SQLLEN 32000
SQLLEN * 0x0013CD0C (8)

AuctionDB-ODBC 74c-464 ENTER SQLGetData
HSTMT 08123840
UWORD 12
SWORD 4 <SQL_C_LONG>
PTR <unknown type>
SQLLEN 32000
SQLLEN * 0x0013CD0C

AuctionDB-ODBC 74c-464 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 08123840
UWORD 12
SWORD 4 <SQL_C_LONG>
PTR <unknown type>
SQLLEN 32000
SQLLEN * 0x0013CD0C (4)

AuctionDB-ODBC 74c-464 ENTER SQLGetData
HSTMT 08123840
UWORD 13
SWORD 4 <SQL_C_LONG>
PTR <unknown type>
SQLLEN 32000
SQLLEN * 0x0013CD0C

AuctionDB-ODBC 74c-464 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
HSTMT 08123840
UWORD 13
SWORD 4 <SQL_C_LONG>
PTR <unknown type>
SQLLEN 32000
SQLLEN * 0x0013CD0C (4)

AuctionDB-ODBC 74c-464 ENTER SQLFreeStmt
HSTMT 08123840
UWORD 0 <SQL_CLOSE>

AuctionDB-ODBC 74c-464 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 08123840
UWORD 0 <SQL_CLOSE>

----------


AuctionDB-ODBC 74c-464 ENTER SQLSetConnectOption
HDBC 08121348
SQLINTEGER 102 <SQL_AUTOCOMMIT>
SQLPOINTER 0x00000000

AuctionDB-ODBC 74c-464 EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS)
HDBC 08121348
SQLINTEGER 102 <SQL_AUTOCOMMIT>
SQLPOINTER 0x00000000

AuctionDB-ODBC 74c-464 ENTER SQLAllocStmt
HDBC 08121348
HSTMT * 0013EF5C

AuctionDB-ODBC 74c-464 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 08121348
HSTMT * 0x0013EF5C ( 0x08122e90)

AuctionDB-ODBC 74c-464 ENTER SQLGetStmtOption
HSTMT 08122E90
UWORD 0
PTR 0x0013EA9C

AuctionDB-ODBC 74c-464 EXIT SQLGetStmtOption with return code 0 (SQL_SUCCESS)
HSTMT 08122E90
UWORD 0
PTR 0x0013EA9C

AuctionDB-ODBC 74c-464 ENTER SQLSetStmtOption
HSTMT 08122E90
UWORD 0 <SQL_QUERY_TIMEOUT>
SQLPOINTER 0x0000003C

AuctionDB-ODBC 74c-464 EXIT SQLSetStmtOption with return code 0 (SQL_SUCCESS)
HSTMT 08122E90
UWORD 0 <SQL_QUERY_TIMEOUT>
SQLPOINTER 0x0000003C (BADMEM)

AuctionDB-ODBC 74c-464 ENTER SQLBindParameter
HSTMT 08122E90
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD 11 <SQL_C_TIMESTAMP>
SWORD 11 <SQL_TIMESTAMP>
SQLULEN 24
SWORD 4
PTR 0x09C4BF94
SQLLEN 0
SQLLEN * 0x09C4BF90

AuctionDB-ODBC 74c-464 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 08122E90
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD 11 <SQL_C_TIMESTAMP>
SWORD 11 <SQL_TIMESTAMP>
SQLULEN 24
SWORD 4
PTR 0x09C4BF94
SQLLEN 0
SQLLEN * 0x09C4BF90 (16)

AuctionDB-ODBC 74c-464 ENTER SQLBindParameter
HSTMT 08122E90
UWORD 2
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 50
SWORD 0
PTR 0x09C4BFA8
SQLLEN 0
SQLLEN * 0x09C4BFA4

AuctionDB-ODBC 74c-464 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 08122E90
UWORD 2
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 50
SWORD 0
PTR 0x09C4BFA8
SQLLEN 0
SQLLEN * 0x09C4BFA4 (10)

AuctionDB-ODBC 74c-464 ENTER SQLBindParameter
HSTMT 08122E90
UWORD 3
SWORD 1 <SQL_PARAM_INPUT>
SWORD 7 <SQL_C_FLOAT>
SWORD 7 <SQL_REAL>
SQLULEN 24
SWORD 0
PTR 0x09C4BFB6
SQLLEN 0
SQLLEN * 0x09C4BFB2

AuctionDB-ODBC 74c-464 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 08122E90
UWORD 3
SWORD 1 <SQL_PARAM_INPUT>
SWORD 7 <SQL_C_FLOAT>
SWORD 7 <SQL_REAL>
SQLULEN 24
SWORD 0
PTR 0x09C4BFB6
SQLLEN 0
SQLLEN * 0x09C4BFB2 (4)

AuctionDB-ODBC 74c-464 ENTER SQLBindParameter
HSTMT 08122E90
UWORD 4
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 25
SWORD 0
PTR 0x09C4BFBE
SQLLEN 0
SQLLEN * 0x09C4BFBA

AuctionDB-ODBC 74c-464 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 08122E90
UWORD 4
SWORD 1 <SQL_PARAM_INPUT>
SWORD -8 <SQL_C_WCHAR>
SWORD 12 <SQL_VARCHAR>
SQLULEN 25
SWORD 0
PTR 0x09C4BFBE
SQLLEN 0
SQLLEN * 0x09C4BFBA (8)

AuctionDB-ODBC 74c-464 ENTER SQLBindParameter
HSTMT 08122E90
UWORD 5
SWORD 1 <SQL_PARAM_INPUT>
SWORD 4 <SQL_C_LONG>
SWORD 4 <SQL_INTEGER>
SQLULEN 10
SWORD 0
PTR 0x09C4BFCA
SQLLEN 0
SQLLEN * 0x09C4BFC6

AuctionDB-ODBC 74c-464 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 08122E90
UWORD 5
SWORD 1 <SQL_PARAM_INPUT>
SWORD 4 <SQL_C_LONG>
SWORD 4 <SQL_INTEGER>
SQLULEN 10
SWORD 0
PTR 0x09C4BFCA
SQLLEN 0
SQLLEN * 0x09C4BFC6 (4)

AuctionDB-ODBC 74c-464 ENTER SQLBindParameter
HSTMT 08122E90
UWORD 6
SWORD 1 <SQL_PARAM_INPUT>
SWORD 4 <SQL_C_LONG>
SWORD 4 <SQL_INTEGER>
SQLULEN 10
SWORD 0
PTR 0x09C4BFD2
SQLLEN 0
SQLLEN * 0x09C4BFCE

AuctionDB-ODBC 74c-464 EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 08122E90
UWORD 6
SWORD 1 <SQL_PARAM_INPUT>
SWORD 4 <SQL_C_LONG>
SWORD 4 <SQL_INTEGER>
SQLULEN 10
SWORD 0
PTR 0x09C4BFD2
SQLLEN 0
SQLLEN * 0x09C4BFCE (4)

AuctionDB-ODBC 74c-464 ENTER SQLExecDirectW
HSTMT 08122E90
WCHAR * 0x09C44290 [ -3] "INSERT INTO "CURRENT_YEAR_PAYMENTS" ("PAYMENTDATE","PAYMENTMETHOD","AMOUNT","PAYMENTFOR","INVITEEID","AUCTIONYEAR") VALUES (?,?,?,?,?,?)\ 0"
SDWORD -3

AuctionDB-ODBC 74c-464 EXIT SQLExecDirectW with return code 0 (SQL_SUCCESS)
HSTMT 08122E90
WCHAR * 0x09C44290 [ -3] "INSERT INTO "CURRENT_YEAR_PAYMENTS" ("PAYMENTDATE","PAYMENTMETHOD","AMOUNT","PAYMENTFOR","INVITEEID","AUCTIONYEAR") VALUES (?,?,?,?,?,?)\ 0"
SDWORD -3

AuctionDB-ODBC 74c-464 ENTER SQLFreeStmt
HSTMT 08122E90
UWORD 3 <SQL_RESET_PARAMS>

AuctionDB-ODBC 74c-464 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 08122E90
UWORD 3 <SQL_RESET_PARAMS>

AuctionDB-ODBC 74c-464 ENTER SQLRowCount
HSTMT 08122E90
SQLLEN * 0x0013EF30

AuctionDB-ODBC 74c-464 EXIT SQLRowCount with return code 0 (SQL_SUCCESS)
HSTMT 08122E90
SQLLEN * 0x0013EF30 (2)

AuctionDB-ODBC 74c-464 ENTER SQLCancel
HSTMT 08122E90

AuctionDB-ODBC 74c-464 EXIT SQLCancel with return code 0 (SQL_SUCCESS)
HSTMT 08122E90

AuctionDB-ODBC 74c-464 ENTER SQLFreeStmt
HSTMT 08122E90
UWORD 1 <SQL_DROP>

AuctionDB-ODBC 74c-464 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 08122E90
UWORD 1 <SQL_DROP>

AuctionDB-ODBC 74c-464 ENTER SQLTransact
HENV 081212A0
HDBC 08121348
UWORD 1 <SQL_ROLLBACK>

AuctionDB-ODBC 74c-464 EXIT SQLTransact with return code 0 (SQL_SUCCESS)
HENV 081212A0
HDBC 08121348
UWORD 1 <SQL_ROLLBACK>

AuctionDB-ODBC 74c-464 ENTER SQLSetConnectOption
HDBC 08121348
SQLINTEGER 102 <SQL_AUTOCOMMIT>
SQLPOINTER 0x00000001

AuctionDB-ODBC 74c-464 EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS)
HDBC 08121348
SQLINTEGER 102 <SQL_AUTOCOMMIT>
SQLPOINTER 0x00000001 (BADMEM)


[Non-text portions of this message have been removed]