List:MySQL ODBC« Previous MessageNext Message »
From:Peter Harvey Date:June 6 1999 2:03pm
Subject:unixODBC - SQL_BEST_ROWID
View as plain text  
Monty,

Here is my trace file (only has DM logging... see previous post).

This was generated from the use of unixODBC-DataManager. I basically
drilled down to Tables and then Columns and then Special Columns. I
ended up with two Special columns called 2.

I have not looked further inot it yet.

Peter Harvey

BTW: The table was something like this...

create table tbTest ( vcFirstName varchar(100), vcLastName varchar(100)
)

...no indexs etc



[ODBC][14059][SQLConnect.c][1092]
		Exit:[SQL_SUCCESS]
[ODBC][14059][SQLAllocHandle.c][232]
		Entry:
			Handle Type = 3
			Input Handle = 0x80888b8
[ODBC][14059][SQLAllocHandle.c][556]
		Exit:[SQL_SUCCESS]
			Output Handle = 0x8096138
[ODBC][14059][SQLTables.c][78]
		Entry:        
			Statement = 0x8096138        
			Catalog Name = [NULL]        
			Schema Name = [NULL]        
			Table Name = [NULL]        
			Table Type = [NULL]
[ODBC][14059][SQLTables.c][224]
		Exit:[SQL_SUCCESS]
[ODBC][14059][SQLBindCol.c][76]
		Entry:        
			Statement = 0x8096138        
			Column Number = 3        
			Target Type = 1 SQL_CHAR        
			Target Value = 0xbffff5e0        
			Buffer Length = 101        
			StrLen Or Ind = 0xbffff5c8
[ODBC][14059][SQLBindCol.c][157]
		Exit:[SQL_SUCCESS]
[ODBC][14059][SQLFetch.c][67]
		Entry:        
			Statement = 0x8096138
[ODBC][14059][SQLFetch.c][200]
		Exit:[SQL_SUCCESS]
[ODBC][14059][SQLFetch.c][67]
		Entry:        
			Statement = 0x8096138
[ODBC][14059][SQLFetch.c][200]
		Exit:[SQL_NO_DATA]
[ODBC][14059][SQLFreeStmt.c][62]
		Entry:        
			Statement = 0x8096138        
			Option = 1
[ODBC][14059][SQLFreeHandle.c][197]
		Entry:
			Handle Type = 3
			Input Handle = 0x8096138
[ODBC][14059][SQLFreeHandle.c][280]
		Exit:[SQL_SUCCESS]
[ODBC][14059][SQLAllocHandle.c][232]
		Entry:
			Handle Type = 3
			Input Handle = 0x80888b8
[ODBC][14059][SQLAllocHandle.c][556]
		Exit:[SQL_SUCCESS]
			Output Handle = 0x8096138
[ODBC][14059][SQLColumns.c][78]
		Entry:        
			Statement = 0x8096138        
			Catalog Name = [NULL]        
			Schema Name = [NULL]        
			Table Name = [tbTest][length = 6 (SQL_NTS)]        
			Column Type = [NULL]
[ODBC][14059][SQLColumns.c][202]
		Exit:[SQL_SUCCESS]
[ODBC][14059][SQLFetch.c][67]
		Entry:        
			Statement = 0x8096138
[ODBC][14059][SQLFetch.c][200]
		Exit:[SQL_SUCCESS]
[ODBC][14059][SQLGetData.c][77]
		Entry:        
			Statement = 0x8096138        
			Column Number = 4        
			Target Type = 1 SQL_CHAR        
			Buffer Length = 101        
			StrLen Or Ind = (nil)
[ODBC][14059][SQLGetData.c][237]
		Exit:[SQL_SUCCESS]            
			Buffer = [vcFirstName]            
			Strlen Or Ind = NULLPTR
[ODBC][14059][SQLFetch.c][67]
		Entry:        
			Statement = 0x8096138
[ODBC][14059][SQLFetch.c][200]
		Exit:[SQL_SUCCESS]
[ODBC][14059][SQLGetData.c][77]
		Entry:        
			Statement = 0x8096138        
			Column Number = 4        
			Target Type = 1 SQL_CHAR        
			Buffer Length = 101        
			StrLen Or Ind = (nil)
[ODBC][14059][SQLGetData.c][237]
		Exit:[SQL_SUCCESS]            
			Buffer = [vcLastName]            
			Strlen Or Ind = NULLPTR
[ODBC][14059][SQLFetch.c][67]
		Entry:        
			Statement = 0x8096138
[ODBC][14059][SQLFetch.c][200]
		Exit:[SQL_NO_DATA]
[ODBC][14059][SQLFreeStmt.c][62]
		Entry:        
			Statement = 0x8096138        
			Option = 1
[ODBC][14059][SQLFreeHandle.c][197]
		Entry:
			Handle Type = 3
			Input Handle = 0x8096138
[ODBC][14059][SQLFreeHandle.c][280]
		Exit:[SQL_SUCCESS]
[ODBC][14059][SQLAllocHandle.c][232]
		Entry:
			Handle Type = 3
			Input Handle = 0x80888b8
[ODBC][14059][SQLAllocHandle.c][556]
		Exit:[SQL_SUCCESS]
			Output Handle = 0x8096138
[ODBC][14059][SQLSpecialColumns.c][79]
		Entry:        
			Statement = 0x8096138        
			Catalog Name = [NULL]        
			Schema Name = [NULL]        
			Table Name = [tbTest][length = 6 (SQL_NTS)]        
			Scope = 2        
			Nullable = 1
[ODBC][14059][SQLSpecialColumns.c][263]
		Exit:[SQL_SUCCESS]
[ODBC][14059][SQLFetch.c][67]
		Entry:        
			Statement = 0x8096138
[ODBC][14059][SQLFetch.c][200]
		Exit:[SQL_SUCCESS]
[ODBC][14059][SQLGetData.c][77]
		Entry:        
			Statement = 0x8096138        
			Column Number = 1        
			Target Type = 1 SQL_CHAR        
			Buffer Length = 101        
			StrLen Or Ind = (nil)
[ODBC][14059][SQLGetData.c][237]
		Exit:[SQL_SUCCESS]            
			Buffer = [2]            
			Strlen Or Ind = NULLPTR
[ODBC][14059][SQLFetch.c][67]
		Entry:        
			Statement = 0x8096138
[ODBC][14059][SQLFetch.c][200]
		Exit:[SQL_SUCCESS]
[ODBC][14059][SQLGetData.c][77]
		Entry:        
			Statement = 0x8096138        
			Column Number = 1        
			Target Type = 1 SQL_CHAR        
			Buffer Length = 101        
			StrLen Or Ind = (nil)
[ODBC][14059][SQLGetData.c][237]
		Exit:[SQL_SUCCESS]            
			Buffer = [2]            
			Strlen Or Ind = NULLPTR
[ODBC][14059][SQLFetch.c][67]
		Entry:        
			Statement = 0x8096138
[ODBC][14059][SQLFetch.c][200]
		Exit:[SQL_NO_DATA]
[ODBC][14059][SQLFreeStmt.c][62]
		Entry:        
			Statement = 0x8096138        
			Option = 1
[ODBC][14059][SQLFreeHandle.c][197]
		Entry:
			Handle Type = 3
			Input Handle = 0x8096138
[ODBC][14059][SQLFreeHandle.c][280]
		Exit:[SQL_SUCCESS]

Thread
unixODBC - SQL_BEST_ROWIDPeter Harvey6 Jun
  • unixODBC - SQL_BEST_ROWIDMichael Widenius6 Jun
  • Re: unixODBC - SQL_BEST_ROWIDPeter Harvey7 Jun
    • Re: unixODBC - SQL_BEST_ROWIDMichael Widenius7 Jun