Hi, I'm succesful using DTL with Oracle fore a while, but now I have to change to MS SQLServer. My problem is that some table columns named BEGIN or KEY are...
I think that putting quote marks around reserved words is a good idea. We might want to generalize this so that it could work across multiple database types...
Hi! I have problem to run a program that use both the Berkeley database and DTL. I made some testing to find out why a program of mine systematically produced...
Hi! I have problem to run a program that uses both the Berkeley database and DTL. I made some testing to find out why a program of mine systematically produced...
Hi All: I am using DTL with NCR's Teradata DBMS and Oracle 9i. I have a problem with the function GetFieldInfo(...) in bind_basics.cpp, which will return a...
The idea behind calling GetFieldInfo(...) was to try and be clever and find out what the primary key column(s) are for a table. If those columns are not ...
Hi Corwin: The call to GetFieldInfo(...) in this instance is from the constructor call to DynamicDBView when it tries to initialize it's parent. As I...
Jeffery, As you point out, the problem is that when we compare the key columns to the table columns, we are using the original TableFieldsList which does not...
Hi Corwin: That will do the same thing, I just did not want to change your logic too much. I will make your change and let you know if I run into anything that...
Hi, For some weird reason, one of my boolean (tinyint(1)) columns had a value of -72 instead of 1. Because of this, the DTL would refuse to update the value...
Hi Corwin/All: My application requires that I interoperate with both Oracle and Teradata. I am testing with Oracle ODBC driver version 9.02, Teradata version...
Hi All: I have a sample program that obtains the column metadata for the DB_Example table and attempts to print out the metadata twice using a sql_iterator...
I would have to run tests to be sure, but this probably has to do with how we have "optimized" assignment for select_iterator. If you look at the assignment...
Paul, That sounds like a reasonable change there. On the other hand, you might want to add an assert() in your class to test for values outside of {0, 1} since...
Hi Corwin: I researched the problem more and it is related your exception safe assignment in sql_iterator.h When we reassign the iterator it = view.begin(),...
Hi Corwin: What would be the issues with adding the bulk_copy method to the sql_iterator? I would like to use this feature for some custom DB specific queries...
Hi Jeff, I think if you just copy the bulk_copy code to sql_iterator it should go through fine. sql_iterator is very similar to select_iterator, about the only...
Jeff, Thanks for looking into this. What I have done in CVS is just directly fix the DBStmt::Reset() function to handle catalog calls. This should fix...
Hi again... I'm trying to use DTL on an AMD64 with Gentoo Linux (64bit), and running in some problems. I have tried my program with unixODBC and both mysql and...
Stephan, I haven't tried it on AMD64, but we don't do anything CPU specific, so my first guess would be that the ODBC drivers may be behaving irregularly. ...
Hi Corwin, I know, there are so many variables (my program, dtl, unixOdbc, the driver...). I tried both defines, but every time the same thing. I have debugged...
Hello! Get a quick glance of Computing News and Resources here http://www.allinonedirectory.info/ComputingNews/ Take care, Kathy "Love is just like life, it's...
Hello all, I need some sort of concurrency control in my application and I was thinking about using optimistic locking. The application is currently using...
I'm about to go on vacation so I don't have much time to explain. See the docs in DTL on exceptions and transactions. Just wrap your operation in a transaction...
OK... If I understood you correctly, you're telling me that I can implement pessimistic locking by using transactions. The document you mentioned does tell me...
Hi Corwin, sorry, but I think I'm lost... I tried both defines, but no luck. I tried to debug it, but at some point, the DataObj seems not properly ...
... mysql, but ... I got that too. fedora 3, postgresql-odbc-7.3, postgres 7.4.8, unixODBC 2.2.9 I assumed that the postgres odbc drivers 'packaged' with...
By default, the select...update iterator uses an update of the form update tablename set value = new_value where primary_key = x; Whether this lock is...
I am trying to use the nullable<> template class to define a member in a DTL_TABLEn()-defined row class, and am getting compiler errors. I am using MS Visual...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
