Thanks again Corwin. I agree with you. The first way is a little too much of a pain. The second way is NOT an option either since I do not have control over...
... try { DBStmt("drop table XXX").Execute(); } catch (std::exception &ex) { // ignore error if table does not exist } ... The problem is that each database...
Hmm... I don't know - I have not seen this before. Have you checked the ODBC library paths as per our Linux note? When you run the executable for the first...
... These are things that I agree could be better as runtime settings. I thing it was mostly a matter of laziness in not wanting to add members and methods to...
Hi Corwin, The reason for the request to allow case forcing to be changed at runtime is that I am presently working with a case sensitive ODBC driver for a...
Actually, to me it sounds like you want to define neither DTL_UC nor DTL_LC. The default behavior for DTL if you do not define these is to simply pass through...
Actually that is exactly what I've done (i.e. not define DTL_UC or DTL_LC). So, I guess in reality leaving it like this should work fine in all cases. If I...
... Take a look at the docs for sql_iterator. This iterator works well for stored procedures. In the example project we give two Oracle stored procedure...
Hi everyone, Here is my problem: I need to call a function with my own DB connection and already assembled select SQL statement string in order to get the...
The easiest way to do what you describe is to use a DynamicDBView with a sql_iterator. The result is pretty close to what you had written void someFunc(const...
Corwin, Thanks. I have to give you guys a praise. More I use DTL, more I like it. Like in this case, often things turn out to be so simple that the most...
Hi again, Well, I've ran into some trouble when I tried to execute something like this: args.tables("select some_field from some_table").conn(dbConn) I have...
Corwin, Now I see that you've put sql_iterator there. I was using select_iterator. Sorry for jumping into conclusions too fast (I'm still fresh with DTL) ...
Actually, this came up on the mailing list about two weeks ago. Currently I plan to change this if statement to: // N.B. we need to let the SQL parser...
Actually, we don't care if ODBC garbles the name it gives us in the case of sql_iterator since we run exactly the query given to us by the user. (And for...
"Select count(foo)" will indeed have a 'garbled' name, but if the user is ok with it why would it bother you? User can easily take care of this problem with...
Hi, I decided to change from using DynamicDBView to DBView since I know all the fields are that I want to use, but I am now unable to compile. Have I missed...
Oops, I figured it out. The contstructor of DBView does not take the field names as it's second parameter as DynamicDBView does. Sorry about the unneeded...
Corwin, I did implement the change you've posted (I came up with something close to it myself). Here's what I've been able to figure out so far. This does not...
The problem here is that I was a bit too glib with my example (I should have read it more carefully and actually ran the example!) What I meant to say for the...
Hi, This is my final question :) I want to copy some table from Pervasive SQL 2000i to PostgreSQL on win32 (work with dev-cpp mingw32 gcc). For this i use...
I have some kind of DTL-Oracle ODBC driver interaction problem: What I was able to figure out so far is that if there is a numeric field after a string one,...
In connection with my previous post (Oracle ODBC sql with numeric/string columns fails when there is numeric column after the string one), here's what I've...
The rule in ODBC is that any string columns which you retrieve with SQLGetData should come last in the set of columns. (This is driver dependent, some drivers...
Just found out from Oracle support: This problem goes away if SQLGetData() extensions check box is checked on the ODBC driver configuration screen. But,...
Honestly, I did not know that there is such a rule. For a long time I have been using SQLGetData() with same queries and same ODBC driver that won't work with...
... I ... driver ... For details on the SQLGetData restriction see http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odch10pr_11.asp ...
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.
