I'm having an odd problem with long memo fields in MS Access with DTL. I've created a BCA as described in the documentation, bound the string to the...
Luke,
Thanks for reporting this, sorry it took so long for me to reply, for some reason Yahoo did not forward your mail.
Anyway, the problem turns out to be...
Corwin, Thanks. I've made those mods and everything is working great now. Luke ... for some ... about how many ... caused ... the ... check ... bufferSize); ...
Hello, I would appreciate any help with MS SQL Server 2000 system stored procedures calling. The ideal variant would be to make dtl::DynamicDBView<>...
Suppose we have DynamicDBView<> view("exec sp_columns db_example", ""); DynamicDBView<>::sql_iterator it = view; it.GetStmt().ClearStmtAttrs(); variant_row vr;...
... Hm... I am dead sure I have had this: dtl::DynamicDBView<> view("exec sp_columns tobject", ""); dtl::DynamicDBView<>::sql_iterator it = view.begin(); ...
In fact, you are correct, std::copy() was broken for sql_iterator. The problem was that sql_iterator did not copy the statement attributes in the copy...
... Ooops, it has taken me a weekend. But never mind. ... attributes ... this, ... Thank you. ... A kind of RW replacement, sigh… It is a pretty long and sad...
... Well.. on the plus side you are definitely giving our library a good workout. It seems that you are digging out the tough cases from SQL Server :-). CJ...
... was ... remember. ... good workout. ... ). Heh, they are not that tough and mainly not from SQL Server. You may want to consider another plus (I believe it...
... No doubt that your version works. In my example select returns result set with some fields with the same names because of objected is the foreign key. You...
OK. Now I see. The problem was that the duplicate field names were
throwing off the dynamic view. Attached find a solution that fixes this
problem by...
Michael ,
Thanks for this, it is another good test case. If we look at the following
example
dtl::DynamicDBView<> view("select 1,2 from DB_EXAMPLE", "");...
... the ... Thank you. Amazing support. I will take a risk to claim the best I have ever seen. It is a pity your project is not commercial one -- I would...
... Thanks! If you want to send me a bunch of money I am sure I can get you a coffee mug ;-> ... I am not sure what you are looking for here? Perhaps a class...
... addresses ... I ... No problems, just make your project commercial. ... idea ... abstract ... adding it. I believe I do understand your motives. But I...
... OK. Truly duplicate column names are still not resolved uniquely. I will send you a new version of bind_basics that forces uniqueness even in this case. ...
... OK. It might not be all that hard to add this if I ever get the time. Here is a way to do it if you want to have a go: The easiest way would be to just...
... I don't really think of it as an opinion here. It doesn't really matter what the ODBC application is, if I am calling a stored procedure, e.g. badone, I...
Hello, I believe I have encountered the major problem with running dtl from a dll. All my database related staff is encapsulated in a dll that is compiled as...
Hello, I proceeded to the testing of dtl multiple result sets handling facility and failed from the very beginning. The following code does not work for me: ...
... matter The opinion that dtl shall not drop a curtsey to the MS SQL Server. […] ... error ... procedure so I ... second ... is ... I absolutely agree with...
Take a look at the DTL documentation on sql_iterator and MoreResults(). The call to MoreResults works fine to retrieve multiple status sets from stored ...
To really replicate this it would help to have a sample VC 6.0 project from you. However, my guess is that the default environment is not being released in...
... The short answer here is that if you are running a statement batch which may return multiple result set codes then you need to have a do...while to check...
Michael, I will send you a zip of enhancements to DTL. Here I have added support for: 1. Batches of statements. 2. The ODBC catalog functions SQLColumns and...