Hello, Is the following code supposed to work? I believe there is something wrong with strings binding. Please note then commented AAAA section is due to I do...
The problem, as usual, is that stupid SQL server does not support SQLPutData()/SQLGetData() for columns in any order. This means you cannot use variable length...
... Thank you for your quick response. I have already almost rearranged my code not to use bound strings' expressions. But I cannot do without blobs and they...
... I have made the tests and here is the result. The following test case: //////////////// #include <dbaccess/dtl/dtl.h> class TestParmBCA { public: void...
Oops. You're right. You don't need MoreResults() here. The output parameters are returned right away because this procedure does not return a result set. CJ...
Hi Corwin, I am using a select_iterator on a view that has about 2000 entries. Just iterating over the view with an empty loop takes at least 5 seconds. Can...
If you are reading that many records I would recommend you use the ODBC bulk fetch operations as these are much faster than regular ODBC fetches. Take a look ...
Hi Corwin, Can you suggest a faster way to get the size of the view besides using distance? If I use bulk_copy with distance, it takes longer than it did with...
If you just want to get the number of records I can suggest two ways: Method 1: Run a select count(field_name) on a copy of your join conditions and tables to...
Hello, I believe addminutes and addyears functions are missing in DTL. They were propably considered to be trivially achievable through addsecs and addmonths...
Hi! I'm writing an application wich needs to skip some first rows in resultset before real fetching. I want to get, for example, rows 10-20 from the results of...
Hello, is it possible to make DTL to use column binding (SQLBindCol) for blobs in select queries? We used not to bother ourselves with making Blobs to be the...
If you want to do this you should be able to just bind directly to a char array. E.g. struct my_row { char my_blob[500]; } And (optionally) when you bind you...
... (rowbuf.my_blob); ... by above ... Thank you for your help. I fail to mention each time that I cannot use boundIOs["BLOB_VALUE"] == … expressions because...
... Yes, it is not too hard to change DTL to use SQLBindCol for blobs. (We used to actually bind blobs this way). I will take a look at what it would take to...
I cannot see my reply for a very long time so I will try to repeat it as close as I can. ... am ... (my ... Thanks!!! It would be very kind of you. And please,...
Hello, can anyone show me the working sp_helplogins MS SQL Server stored procedure call with DTL? The only thing I need to know is that if it return records or...
Hello, DTL uses std::exception to signal about errors. In many cases it is OK but more flexible approach, IMO, would be to signal about errors through...
... am ... (my ... Thanks!!! And please, give it a test that blobs buffers up to 6MB are reasonably fast. They are not usable (IMO) in the current SQLGetData ...
Hello, I have problems with inserting/updating large blobs. Here is the code that illustrates the problem. Thank you in advance, -- Michael Kochetkov. #include...
... Thank you. As far as I can see the documentation emphasizes DB_iterator operations. And it will not work for DBConnection or DBStmt, will it? -- Michael...
... Yes, this handler is really for errors in DB_iterator operations. Mike has been talking for some time about upgrading the exception hierarchy but I am not...
This comes down to another defect of SQL server. In SQL server, when you bind a parameter you must tell it in advance the maximum length it might be (Oracle...
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.
