Search found 7 matches

by PatySaito
23.10.2007, 15:25
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Column with name "Extra" was not found
Replies: 17
Views: 4683

Hi Mark, I don't forget the 'key' field... It's really not included in loop. As I said, the test was done in my home and I can't re-due it here, but I will try to build a "more complet log" and try to post it in this week yet... Is there a sequence in mysql.dll 'search' loading process? Tks,
by PatySaito
23.10.2007, 13:11
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Column with name "Extra" was not found
Replies: 17
Views: 4683

Hi Guys, I was little busy this days... I did some "tracking" and get this: There are 6 columns: Field, Type, Null, Key, Default, Extra When the loop start, the FindColumn function runs over the fields 'Field','Type','Null','Default' and 'Extra', but as I said, the 'GetColumnCount' functio...
by PatySaito
10.10.2007, 21:42
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Column with name "Extra" was not found
Replies: 17
Views: 4683

Hi there, I tried the code suggested, but the code bellow still raise the exception, because the return value is "zero". function TZAbstractResultSet.GetColumnIndex(const ColumnName: string): Integer; begin Result := FindColumn(ColumnName); if Result < 1 then raise EZSQLException.Create(Fo...
by PatySaito
10.10.2007, 11:33
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Column with name "Extra" was not found
Replies: 17
Views: 4683

Hi there, Mdaems I try what you said, and discovery that: When we get columns from the table: SHOW COLUMNS FROM members LIKE '%' We get six fields: Field, Type, Null, Key, Default, Extra But in the GetColumnCount says that are only five: //ZDbcResultSetMetadata function TZAbstractResultSetMetadata.G...
by PatySaito
08.10.2007, 21:34
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Column with name "Extra" was not found
Replies: 17
Views: 4683

Hi mdaems, Here is the result from the monitor: 2007-10-08 17:23:02 cat: Execute, proto: mysql-5, msg: SELECT * FROM MEMBERS E; 2007-10-08 17:23:02 cat: Execute, proto: mysql-5, msg: SHOW COLUMNS FROM my_db_design.members LIKE '%' When I run this query (SHOW COLUMNS FROM my_db_design.members LIKE '%...
by PatySaito
06.10.2007, 15:25
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Column with name "Extra" was not found
Replies: 17
Views: 4683

Hi GTO, thank you for the quick answer... I already tried other versions, DBO 5.x and MySQL5.x too... but with the same error... So, this is why I stop in this versions after this try/error loop :roll: My main skills are in HCI/CG programing... I just tring to do a simple file managemant system for ...
by PatySaito
05.10.2007, 22:39
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Column with name "Extra" was not found
Replies: 17
Views: 4683

Column with name "Extra" was not found

Hi there, I got the error "Column with name "Extra" was not found" when I try to active any sql. I double check all my field names. I starting to "trace" and discovery that the metadata was a field called Extra, but I am "stocked" in how to solve this issue. T...