Here's my thoughts around this subject: 1. Borland are updating their C/C++ compiler at the moment with a release expected around the 3rd quarter of the year....
Hi guys, since I changed my (working) code to use SQL_BIGINT: ODBCINT64 test = 12; dbStmt.BindCol(0, SQL_BIGINT, &test, sizeof(ODBCINT64), NULL); On...
In general I would recommend using LocalBCA and an iterator rather than mucking with lower level DBStmt calls since this is easier to get wrong. So, e.g....
Hi! I am trying to read in a predefined structure a query of the type select id, concat(title, text) as content from DBTEXT I took the example "A Second...
I don't really understand your question. So, I think you want to run the query select id, concat(title, text) as content from DBTEXT into a structure that has...
I would have thought that the code example should be: DBView<std::pair<long, string> > view("DBTEXT", BCA(rowbuf, COLS["id"] >> rowbuf.first && COLS["content"]...
Thanks Corwin, I suspected that SQLGetData was involved due to the std::string, so I changed to dtl::tcstring<80> as the opt page suggested. Plus using the ...
I have asked this before, and never really got to much further. I am trying to link against the newest DTL sources. I have from what I can tell met the needs....
Ok I appreciate you displaying that. Here is a shot of the same screen you are showing me from the examples. I am compiling it against the correct lib. I...
First off all let me appolgize. I did not for some reason catch that*DLL* part of what you were indicating, or in your case not inficating, I had my lib set to...
Hello everyone, I've just had rather a frustrating day trying to call a Stored Procedure on SQL Server from DTL... I think I'm very close to making it work...
I'm sorry this gave you grief. SQL Server is tricky in that you have to call SQLMoreResults before it will return the values of any parameters from a stored...
Thomas, Thanks for sending this in. I will try to incorporate these changes into a database specific setting for DB2. One more piece of information that would...
Hello Corwin, Thank you for your reply and thank you for DTL. It seems like The Right Way (TM) to do things :) I'm sorry, I fudged up the copy/paste. I have a...
Hi all, Thought I'd share this with you. I have 4 database columns called: value_0, value_1, value_2, value_3. I wanted to retrieve those into an array, so I...
O.K. If you look at the sql_iterator docs you will see the phrase: "Please also note that if your statement reads/writes std::string or dtl::blob columns then...
Corwin, Here's some additional information on the problem I'm having with running an SP on SQL Server. I ran a trace on the server. When I use the following: ...
Corwin, I completely missed that part! Would you like me to send a modified example for SQL Server, where there are multiple input and outputs and where that...
Just change your BCA to use fixed length strings. So, e.g. class TestParmBCA { public: void operator()(BoundIOs &cols, variant_row &row) { cols[0] >>...
This might be a good example for us to include in the documentation for binding of "user-defined" data types ... in this case of boost::array ... Couldn't...
Hi, I'm trying to talk to Oracle from a Linux box without success. Trying to use free ODBC driver from http://home.fnal.gov/~dbox/oracle/odbc/, I get link...
Hi Michael, ... Assumption: I believe binding is just done on the first sample row? Corwin, this is right? Its not done for every row thats created, right? ...
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.
