Recent content by rmathur

Can u email me a SQL for creating the data? It does not work for the table I have! ------------------

I dunno, I have a table where one of the columns has "FAMILY " as its value and it trims the space. All I do is to copy the field to a string variable, sTempStr := FieldAsString('COLUMN'). What was your query that u ran, can u send me a sample script? ------------------

I know, I am tried TOracleDataset also, you can test this very simply, just do a select * from a table and look at any column that has a space as the last character. Even when you turn off TrimFields, it takes the space out. ------------------

Hi Marco, TrimStringFields in the OraSession Preferences does not work. This is killing me. I am exporting some string data into XML and using the TOracleDataset or TOracleQuery and it trims the string, so I am getting wrong values. Is there a quick fix for this? I am essentially writing the...

Hi Marco, It's been a while since I bothered you. I was wondering, is there an equivalent of UseMessageTable & EnforceConstraints in TOracleQuery? I need to trap the constraint violations from a Query & map them to the message table so I don't have to strip the message & figure out the...

Hi Marco, I recently reviewed their product. The Net option is an excellent option for me, because I have an ASP app that I will now be able to sell to anyone with no prerequisite software needed. I wish you had an option like this, because I love your product and support, but am in a bind. I...

Hi Marco, Is there anyway to parse TNSNAMES.ORA for the Address, Port and Service of an entry? I noticed that OracleCI unit enumerates the AliasList but does not give this other info. I am trying to write a parser for it but its a pain when things are not exactly entered they way u parse. Is it...

Is there an example somewhere of passing a TOraSession to a DLL? I have a main program and I would like to share my Oracle Session with a bunch of DLL modules. Thanx, Raj Mathur ------------------

No, I'm not. Its bizarre, but if any of you try dropping a TOracleSession and connecting it, u will see the memory usage jump.

I brought this up before but did not get a good answer. Why is the memory usage so high when using DOA components? If I drop just a TOracleSession and connect to Oracle, the memory usage of the program jumps from nothing to over 10Mb. I have no other components and am not doing anything else...

I think this would be a great enhancement to DOA!

Hi Marco, Why do the DOA objects take up so much memory? If I only have the OraSession object and & before I set Connected := TRUE the memory used by this program is 1956K. After I set Connected := TRUE the memory used is 8548K. I have no query running at this point & there is no other object...

Is there any way to find out the last SQL string run through a OraSession? I have a bunch of DataSet components, & in case of an exception, I want to find out what the last SQL string was so I can trap it. I want to have only one exception handler in the Application and write the SQL to a log...