Table() returns null

Hi,

I managed to solve my problem with the libraries not building properly by adding in some additional includes into my program. So, now at least I can connect to my database.

But now I'm having a new problem. One of the things I need to be able to do for my program is get metadata on the table that I'm pulling information from.

So I added in this code, based on some of the examples:

Query query = con.query();
String QueryString = "select * from diagnostics";

query << QueryString.cString();

Result res = query.store();
// Query::store() executes the query and returns the results

lprintf("Records Found: %d\n", res.size() );

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

std::string TableName = res.table();

lprintf("%s:\n", TableName);

for (unsigned int i = 0; i < res.names().size(); i++) {
String FieldName = res.names(i).c_str(); String SQLType = res.types(i).sql_name(); int Length = res.types(i).length();

lprintf(" Field Name: %s\n", FieldName);
lprintf(" SQL Type: %s\n", SQLType);
lprintf(" Max Length: %d\n\n", Length);

return 0;

This works for the most part. Except that I always get (Null) returned for the Table Name and 0 for the length of the field.

Here's the output:
Records Found: 889
(null):
Field Name: system
SQL Type: VARCHAR NOT NULL
Max Length: 0

Field Name: plane
SQL Type: VARCHAR NOT NULL
Max Length: 0

Field Name: date
SQL Type: DATE NOT NULL
Max Length: 0

Do you need more help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

Field Name: problem
SQL Type: CHAR NOT NULL
Max Length: 0

I haven't found anything in the documentation that really helps me here.

Any ideas?

Thanks!

David Received on Thu Sep 27 13:08:25 2007