Hi All I'm trying to build the DTL with g++ and make. My make file looks like this: # Compiler/Linker CC = g++ LD = g++ # Archiver and indexer AR = ar RANLIB =...
Actually, we already have a gnu makefile that is setup to work across multiple compilers/platforms including gcc (multiple platforms), aCC, Solaris. It does...
Hi All I've finally got the DTL to build and link against a client on Linux, but I can't connect to my SQL Server. In the windows version I use the following...
Trying to figure out what it should be, just getting caught up in the code. -sal __________________________________ Do you Yahoo!? Exclusive Video Premiere -...
What I would recommend you do is set up a DSN using the odbc.ini settings as recommended for that driver in unixODBC. You can then test the unixODBC...
Offhand, I don't think there should be a C_BLOB case. In general a blob could be any binary object which may have nulls in it that does not translate cleanly...
For some UNKNOWN reason, the people before me used a 16 byte binary as the key into everything. I need to generate this in my code when I insert into tables....
Why is it when I have a unique key and I do an insert, the key comes out as null. This is a key that I generate and it is NOT an identity. It is just unique....
Honestly, I'm not sure what you are trying to do here. If it were me, I might consider building a simple class for your key if you don't already have one so ...
Are you using a DynamicDBView where the fields are retrieved from the DB or a DBView where you list the fields. In a DynamicDBView the ROWID field is not...
... I use GUIDS as keys in an app that must be reasonably DB neutral(SQL server, MySQL), so I have to use a 16 byte binary as a key. Your best bet is to write...
I am using a DynamicDBView Is it as easy as doing (which seems to work) DynamicDBView<> view1(args1.tables(table) .fields("*") .key_mode(USE_ALL_FIELDS)); The...
thanks again, I guess I was just trying to use a c_blob (which is really a string<BYTE> in dtl) to handle a sql_binary because that is what bind_basics.cpp...
OK. I think that what was happening with AUTOKEY is that is was adding e.g. ROWID to the list of fields as a primary key. Then when you did an insert, this...
The question is SHOULD it add it to the list if it is not autogenerated? In SQL Serer (not sure if this is all of SQL), you can check the syscolumns table and...
No, it SHOULD NOT add it to the list if it is autogenerated. In fact, I take back what I said earlier, we have special code in there already that removes any...
Andrew, The way you use bulk_insert_helper is pretty much the way you are calling it: dtl::bulk_insert_helper(mlcs.begin(), mlcs.end(), buffer_size, write_it);...
If you know the table name then I think it is better to use a DBView than a DynamicDBView since the DBView is faster. Having said that, I don't know why a...
One more comment on this, you might want to think twice before you jump to using Oracle sequences since this is a database specific solution. One alternative...
There is a bunch of junk in the attached files, the main logic for sequences is just this. Suppose you have a table like this: PST_IDS ( TABLENAME as VARCHAR2,...
Can't seem to located anything saying that they are cached, so I am assuming that they are not. so this will do two calls to the db? indexed_view.find("dog"); ...
In fact, and IndexedDBView loads the entire table into memory into a multiset or hash_multiset where the index for lookup is automatically generated from the...
Thanks for that info. I am looking up in a HUGE table. I only used a limited number of them a day (but they vary from day to day), but the ones I do use are...
Oops, I sent this from Sally's account. We were talking and found out we work for the same company (and the same building). It is nice to have someone to...
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.
