Corwin, Thanks for the reply. For some reason, on VC 7.0 (.Net) I cannot stop getting many linker errors. I have the library directory set properly, and the...
The only thing I can think of here is to make sure that you defined UNICODE, _UNICODE both when you built the library (DTL.lib) and when you built your...
Corwin, You were correct, I had _UNICODE defined in the project but did not have it defined during the lib build. Everything works fine now - thanks!...
... not ... This kind of thing is why I switched to using makefiles with Visual Studio. In the visual environment it is just too easy to set a flag in one...
Does anyone use a sql_iterator and a BCA to read more than 2 columns from a stored procedure's result set? I can read 2 but never more. For example, // THIS...
There is not any built in limit on the number of columns so I don't know why you would see this. There is nothing in the code that should not allow 3 columns ...
1) Sybase Adaptive Server Anywhere Network Server Version 8.0.2.3601 2) LINE: 1546 boundio.cpp -> applyMoveReadOrdered[bio.GetColNo()] = &bio; produces an out...
OK. That is definitely a bug. Evidently we did not test the sql_iterators with DynamicDBViews enough. Line 518 should read: if (!TableFields.empty( ) &&...
Corwin,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /> Thanks for the reply. I really appreciate your work on this library. For...
Corwin, While we are looking into the sql_iterator, please keep in mind that I can still reproduce this error even after fixing the dummy assignment / forced...
In terms of this old bug where the iterator execute logic would in this example not get correctly invoked, I thought we had fixed it in our DTL 3.5 release....
OK, just tried out a 3 column stored procedure and I think I see what the problem is here. The issue is that for some ODBC drivers if you are reading a column...
Corwin, I am trying the DBView examples and seem to have hit a snag on example 2. My objects are defined as below: class CustTable { public: int iCustomerId; ...
As per the compiler message you need to provide a default constructor for your class. So, if you say e.g.; CustTable A, B, C; This will not compile because...
Corwin, For some reason I'm getting an exception shown below when i try to bind SQl parameters to a data object. Exception type: DBException Method:...
The query you wrote has only one ODBC parameter. DTL is telling you that when you try to bind a second parameter this is illegal since your query only has one...
Corwin, 1) Sorry, I was using the last version. I have upgrading to version 3.5 and that has not fixed the problem. With the sql_iterator declared outside the...
I think your logic here is wrong. You write inside your loop: // set the parameters write_read_it.Params() = (**it); This is wrong for several reasons: 1. You...
Corwin, Am trying the DBViewUpdate example in the DBViewUpdate.htm found in the document folder, and seem to get a SQL error that Access gives back to me that...
Pardon my ignorance on SQL, ODBC, and everything else database- related, but I'm trying to use DTL for my first project involving databases. I'm just wanting...
Hi, I am having problem getting date related data from the DB. I am able to get the data from DB but the data is wrong. Here is the situation. Say, I have...
John, I looked at this over the weekend and ran it. The problem is that the where clause you provided has a bad column name and Microsoft Access gives an...
You will need to set up a data source name. Go to the control panel->administrative tools->odbc and create a name for your database source - here is where you...
Here is what I think is happening. In ODBC if you have NULL data what you will get is just the value from the previous row. So, in rows 3 and 4 you have NULL...
Thanks for your reply. In the meantime, I've actually gotten my original code to work. I was working on it from home, on my dialup connection, and it appears...
... You're welcome! I just hope the library can help others as much as it helped us to make code easier to maintain. (And who knows - if the C++ powers that...
Hi everyone, I've recently started to play with the DTL, and absolutely love it. I have SQL queries working great with mySQL, but now have been told that it...
Hi group, my query is that i have a program that connect to oracle database.I am using OTL(Oracle Template Library). I want to use DTL to manage records...