I will try this stuff and let you know. Note, the extra semi-colon was from a cut and paste error on my part and not actually in the actual SQL that gets...
Here is the latest in this saga. We have move the code to a stored procedure that takes no parameters. But I cannot for the life of me get it to compile. ...
Another question that may give some insight to this compiler error. Why does sql_iterator::EqualCompare have a line bool same_view = (*(i1.pDBview) ==...
Brian, You're right, this sounds like a bug. sql_iterator should just compare the pointers not the DBView objects themselves like what select_iterator does. I...
I have a stored proc that returns a recordset. It is essentially just a select from a view. The recordset seems to bind fine, but it is really slow since I...
Brian, It should not be that slow. Here are some things you can do in order of increasing difficulty. 1. By default we use server side cursors. Many stored...
Hi, I was wondering if anyone has tried using the dtl with swig (www.swig.org). I need to call my code written with the DTL in Python (www.python.org) and swig...
I've never used swig but just glancing at the docs, it seems clear that to call whatever C++ methods you need you will need to reduce the methods to a simple...
In addition to what Corwin mentioned, I would recommend trying to determine which part of the code is taking a long time before you start making changes. One...
Hello everyone, I'm having trouble getting a working unicode build of my project. I've included a small test application that illustrates the problem. The app ...
O.K. I will try to take a look later today. I assume you set the unicode flags _UNICODE,UNICODE in your compile define flags as well? Corwin ... From:...
Has anyone had any luck calling a stored proc (on Sql Server 2000) with the select_iterator using BuildSpecialQry? I am successfully calling the stored...
Hi Roger, I started looking at this last night, but made the mistake of trying to upgrade my SQL Server installation and got my machine all tangled up. I'll...
Hi Corwin, I greatly appreciate any help you can give. I didn't pay for support, after all. I realized earlier that I probably don't need variants, but I ...
Sorry. I meant to say tcstring<50> str; This is just a template to define a std::string type interface for a fixed length array of characters (tchar[N]). You...
Hi, I'm new to DTL and I'm wondering if there is a simple way to just read a portion of a table. For example if I have five cols and I want to perform this...
Fatima, Just create a new BCA to read only those columns. I usually do this kind of thing with a "local BCA" e.g. my_type dummy; DBView<my_type> view("TABLE",...
Paul your a star, I just hit this problem on a 2 month old laptop running XP SP2. Calling release on just the connection didn't fix it but calling release on...
... Thanks Kevin! Made my day :) ... That should be ok, the danger with DLLs is that you can't specify initialisation/destruction ordering, and DLLs often...
Hi, I have just hit a problem when I call GetDefaultConnection.Connect from my exe and then call a function in my dynamically linked dll which expects a...
I'm one of the people who said that. The reason I said it is that using the default connection means that you have a static/global connection object which is...
Here's another reason why the default connection is confusing. People don't realize that they have a separate default connection for each DLL and the...
... Yeah. Having seen some of these I'm kind of torn as to whether it might not be better to pull out the default connection object. It makes for convenient ...
I agree, however I bet for most apps, a global DB connection is all that is needed. We should just work towards creating a pattern that forces people to...
... I don't agree with this. Its true IF the static variable were defined in the header files, but the static vars are not. They are defined in a .cpp file,...
Hi Paul, I have a simlpe exe that calls getdefaultconnection.connect. The exe then calls a dll. The Dll calls getdefaultconnection.SetAutoCommit(true); program...