I'm not sure without testing, but I believe the problem with your stored procedure is that it returns multiple result sets (see the related discussion here; ...
Hi again. Mystery solved :) The problem was that my stored procedure was displaying "* row affected" messages after insert (it wasn't insert error but it's...
Rodrigo, After some more thought, here is an outline of how this might work: 1. You would need a field class with a constructor like field(ODBC sql type,...
Corwin ... I needed a generalized form of ParseCommaDelimitedList() that could separate a list of tokens separated by any delimiters (not just comma) ... so I...
Rodrigo, After some more thought, here is an outline of how this might work: 1. You would need a field class with a constructor like field(ODBC sql type,...
Mike, This is a good opportunity for you to learn CVS. It is really very easy. Just open your cygwin console. Create a directory in D: called dtl_cvs and type...
Hi, I'd like to build "complex" WHERE expressions, i.e. no hard-coded "WHERE ..." strings. Something like: query subq("T_MAP"); condition subcond("NAME"); ...
I'd just like to point out that sub-queries aren't supported in MySQL (v3 for sure), and they tend to be much less efficient than a pure join. eg, a better...
Just use a sql_iterator. Then you can dynamically build and execute whatever kind of statement you want even if it has nested subqueries. Corwin ... From:...
Hello to all. I just came back from my vacation. Anyways, how can I help to make all this possible? I'm fluent in C++ but no ODBC experience whatsoever. ...
Well, if you want to have a go, the first four items 1-4 should be fairly simple and will get you to the point where you have a DynamicDBView as constructed...
... I believe that we should have both facilities. Since the DTL still doesn't have any table creation methods, the drop&create approach looks the best. The...
Soon I'll be requiring features to help create and alter tables through ODBC. I only really know the MySQL dialect of SQL, so I'd be interested in using tools...
Hi. What is the best prefered way to work with identity columns in MS SQL Server using DTL ? What I want to do is to look for a record in database. If record ...
I just want to clean out the database without knowing what is already in it. The only way I am able to do it now is to completely read the database and store...
Hi there. Look here: http://dtemplatelib.sourceforge.net/DBStmt.htm DBStmt("DELETE FROM DB_EXAMPLE").Execute(); Regards Maciej Gasiorowski prcarp wrote: I just...
I am using the DynamicIndexDBView for my application and have no problems with selecting the data. However, when I want to write changes back to the database...
Just to let everyone know, I ran DTL on a AMD running Fedora Core 4, MySQL 4.1 and it failed to complie. Seems like the LONG LONG used for ODBCINT64 gets...
Hi all, Sometimes the database gets a little corrupted, and instead of 1 or 0 in a boolean field, I get -72 or something like that. Not entirely invalid...
Paul, I'm not sure I really like this change for two reasons: 1. How do you know that is it only 1 that is getting corrupted. What if something is happening to...
Hi Corwin, ... yeah I thought there would be some resistance, I'm not even sure its a great idea ... ... good question, i'm not sure where the -72's are coming...
I noticed that when starting up DTL, it does not check the property SQL_NEED_LONG_DATA_LEN via SQLGetInfo. This is for drivers that need the size of blob data...
Paul, I think that adding this as a #define is a reasonable way to go. Let's keep the default as the old version like you suggest below. Other than that,...
After some tweaking of the SQLite3 ODBC driver, I'm happy to report that blobs, strings and everything else works flawlessly. And fast ;) Thanks all for DTL....
Thanks for the compliment. And thanks for letting us know about this! Corwin ... From: Robert Bielik <robert.bielik@...> Date: Wednesday, January 25,...
Hello group. I've just started using DTL with SQL Server and i've got a question regarding performance. I've wrote a simple program, that inserts 10 000...
I'll just throw out a couple of ideas. I'm not sure which are most applicable. It's not that SQL Server "sucks" compared to MySQL - what they are doing is...
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.
