It seems that I can't call a stored procedure that doesn't have a ref- cursor. The DTL code has a 'if (this->boundIOs.NumColumns() < 1)' check in method...
You can call a sql_iterator that doesn't return a cursor. Just assign to the iterator or increment it to force an execution. (The skipped statment there is...
Since this is a C++ crowd list, I thought people might be interested to learn about a great C++ general purpose library that just went free (under Boost...
Hello, I hope this is a trivial question to answer - but it's driving me nuts! I have the small example program quoted below. It does what it is supposed to do...
Hi, I can think of a few things to try here. 1. Add a Commit() call after your inserts. By default DTL does not force a commit to let you control exceptions....
Hmm. Maybe I wasn't clear enough. You would need to have something like typedef DBView<variant_row, variant_row> View; View view("{CALL my_package.my_proc(?,...
ODBC has some issues with variable length strings in that they have to be the last arguments passed as parameters. Two ways to fix this: 1. Use fixed length...
Hi, First of all thanks for the answer. I think I didn't explained my self clearly enough, The problem is not with strings, but with numbers. For example,...
Hi Corwin, thanks for the quick reply. 1.) I've added a dtl::DBConnection::GetDefaultConnection().CommitAll(); after the loop. No luck. I also tried ...
Hi Soren, I think the problem here is that you are just dereferencing the iterator which is what gets done for a fetch and not assigning to it which may not...
Hi, In addition to previos description I've also tried to not give anything to the first parameter: i.e. just set the second not default null parameter. ...
Hey Corwin, Your explanation sounds reasonable - I'll try it out as soon as I get access to the second machine again. If that was the problem though I wonder...
Hi Julia, Looking at your question more carefully, I need a more complete code example of what you are doing. First of all, take a look at our docs on how to...
Hi I want to support databases with a ODBC Driver. Users who use my programm can only give my application his own dsn string. My problem is: How can I create...
Hi Corwin, Thanks for your answer. But I don't work with DynamicDBView<>. I'll try to descibe the code in more details: C++ code ... static const string...
Hmm. It should be just the case that you can say iter.Params()[0] = NullField(); // or params[0] = NullField(); One simple check to see if this might be...
hi I've the same problem and I would like to solve it with this solution. But the attachment DBQUery.cpp is not stored. Does someone still have this file? cu...
Hi I have the following code which doesn't work. If I create a database "db_example", then the first time the loop will go ok, the second time it enters it...
please join my group : http://groups.yahoo.com/group/myspacelayout __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo!...
Hi, Tried it and as expected the problem is not in the store procedure Julia ... stored procedure ... type ... copied ... NULL, ... to ... parameter ... know ...
Hello, I have been using the dtl for about a month now and i have been trying to use a DynamicDbView to run a stored procedure (sql server 2000) I am getting...
Hi, Since you are doing this under sql server there are a few of possibilities that spring to mind. 1. Try using MoreResults(). If you are returning a...