Re: Call to SQLForeignKeys truncates Table Name, doesn't include null terminator

Jason D. wrote:
> I have a table called JayTable2 which contains a Foreign Key to
> JayTable1
>
> When I make a call to SQLForeignKeys though my C++ application for
> JayTable2, nothing is returned:
>
> retcode = SQLForeignKeys(hstmt,
> NULL, 0,
> NULL, 0,
> NULL, 0,
> NULL, 0,
> NULL, 0,
> szTable, SQL_NTS);
>
> szTable is of type SQLCHAR containing the string "JayTable2"
>
> When I ran an ODBC Trace, I found the following:
>
> ODBCTest d44-af0 ENTER SQLForeignKeysW
> HSTMT 00A32058
> WCHAR * 0x00000000
> SWORD 0
> WCHAR * 0x00000000
> SWORD 0
> WCHAR * 0x00000000
> SWORD 0
> WCHAR * 0x00000000
> SWORD 0
> WCHAR * 0x00000000
> SWORD 0
> WCHAR * 0x00A31920 [ -3] "JayTa"
> SWORD -3
>
> ODBCTest d44-af0 EXIT SQLForeignKeysW with return code 0 (SQL_SUCCESS)
> HSTMT 00A32058
> WCHAR * 0x00000000
> SWORD 0
> WCHAR * 0x00000000
> SWORD 0
> WCHAR * 0x00000000
> SWORD 0
> WCHAR * 0x00000000
> SWORD 0
> WCHAR * 0x00000000
> SWORD 0
> WCHAR * 0x00A31920 [ -3] "JayTa"
> SWORD -3
>
>
> As you can see, it looks as though all that is getting passed is
> "JayTa", it is getting truncated which may be while it isn't returning
> any ForeignKeys. Just for fun, I created a table called JayTa with a
> Foreign Key constraint, but nothing was till returned. I think this
> may be due to the missing null terminator. For example, in a call to
> SQLPrimaryKeys, I see this:
>
> ODBCTest d44-af0 ENTER SQLPrimaryKeysW
> HSTMT 00A32058
> WCHAR * 0x00000000
> SWORD 0
> WCHAR * 0x00000000
> SWORD 0
> WCHAR * 0x00A31920 [ -3] "JayTable2\ 0"
> SWORD -3
>
> ODBCTest d44-af0 EXIT SQLPrimaryKeysW with return code 0 (SQL_SUCCESS)
> HSTMT 00A32058
> WCHAR * 0x00000000
> SWORD 0
> WCHAR * 0x00000000
> SWORD 0
> WCHAR * 0x00A31920 [ -3] "JayTable2\ 0"
> SWORD -3
>
>
> The entire table name is there as well as a string terminator. SQL_NTS
> is being cited as the length in both calls. When I tried to specify a
> length of 9, it was truncated at "JayT" I had to set it to 18 to get
> it to pass "JayTable2"....but there were still no results, and no
> \ 0 in the trace call.
>
>
> Finally, I specifically included the Null character in the string, and
> ran it. I finally got:
>
> ODBCTest 918-650 ENTER SQLForeignKeysW
> HSTMT 00A31DF8
> WCHAR * 0x00000000
> SWORD 0
> WCHAR * 0x00000000
> SWORD 0
> WCHAR * 0x00000000
> SWORD 0
> WCHAR * 0x00000000
> SWORD 0
> WCHAR * 0x00000000
> SWORD 0
> WCHAR * 0x00A32230 [ 20] "JayTable2\ 0"
> SWORD 20
>
> ODBCTest 918-650 EXIT SQLForeignKeysW with return code 0 (SQL_SUCCESS)
> HSTMT 00A31DF8
> WCHAR * 0x00000000
> SWORD 0
> WCHAR * 0x00000000
> SWORD 0
> WCHAR * 0x00000000
> SWORD 0
> WCHAR * 0x00000000
> SWORD 0
> WCHAR * 0x00000000
> SWORD 0
> WCHAR * 0x00A32230 [ 20] "JayTable2\ 0"
> SWORD 20
>
>
> With the string terminator....but no values were returned. And ideas
> or advice? Is this a bug somewhere?
>
> Thanks!

What product are you using? What version? What does any of this have to do with Oracle?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org