Recent content by im2kul

Hi All, I had been using Borland C++ 5 for last 5 yrs and now decided that I need to upgrade it to the latest version of Delphi & Borland (i.e. 2009). When I opened the project (from 2005) into the new 2009 version, it asked me to upgrade the project and I said yes. Now when I open any...

Yes thats correct...at the time of setting the variable, I need to know what is the value of vArrayElm[i]. Trust me it does sound easy, but it is not really at least for me. When you put the variable &vArrayElm[i] in the Watch window, it shows up as an object and it has so many variables in it...

Hi All, I have a variant array where I keep on filling the variables that needs to be set for the Query: for (int i = 0; i < DataSet->FieldCount; i++) { Query->SetVariable(vPList->Strings[i], vArrayElm[i]); } Query->ExecuteArray(0, ArrayCount)...

Hi All, Never mind...I figured out a better way to solve the problem rather then adding a NULL value. The way I did it was never to add a value to the Variant Array if the Value is NULL or the Text value is NULL. Thanks

Hi Devil, Thanks for your quick reply. However, that does not really answer my question. I have tried assigning NULL directly (FYI: I am using Borland C++ 5.0 with Direct Oracle Access) while assigning Values to teh Variables => Query->SetVariable(MY_COLNAME1, NULL) and it still gives me an...

Hi All, This might be a stupid question for some of you, but I have been battling with this for a while. I have a Variant Array where I keep on adding the elements and then execute the Query by setting the values in the Query with the ones in the Variant Array: Below is the sample code: #...

Hi Marco, thanks for the quick response. I do understand that translation will be done by the NLS_LANG defined in the registry, but this will definately double convert the already UTF8 converted strings (from ISO DB) and thus it will produce garbled strings. Is there a way or do you know...

Hi, I have an ISO DB in which my client tool goes and fetches the data, however, my destination DB in which my client tool has to writ ethe data to is a UTF8 DB. How can I do this? I have a bunch of UTF8 strings stuffed in to my ISO DB and I have extract those strings and insert them into a...

Hi, Will it have support for UTF8 chars and Unicode Chars? Currently, DOA does not have a support for WideString when inserting the VARCHAR2 (i.e. it only works with AnsiString) in the DB. Will the new version of DOA have support for that? Will the new DOA be able to be used with Borland...

Hi, Thanks for the reply. I am not sure what is the Character Set of the AnsiString. I am just storing or trying to store Unicode characters in the AnsiString. For Unicode chars in an AnsiString, what should be my NLS_LANG? Below is the info that you might need for detailed explanation...

Hi Macro, Thank you for your quick reply. I have a couple of questions: 1. Is there a way using DOA that I can have an AnsiString contain Unicode characters? This is whats currently happening: When I try to assign a WideString to an AnsiString (something like this AnsiString myString =...

Hi All, I just need to find out if there is a way to insert a WideString or wchar_t into the DB using DOA? I am using the ExecuteArray method to bulk insert rows into a UTF8 DB. Thanks