Recent content by syi129

I gave up looking into this issue of the RefreshRecord method not working 100% of the time, I found that if I had refreshBeforeEdit switched on and I did and edit and then cancel. That refreshed the records correctly so that work around was good enough for me to to investigate it further

thanks that seems to be working now. I didn't think it would be a session level privilege. I guess I missed one when I was looking through the code

Hi I seem to have a problem retrieving and inserting a space character into oracle. DOA 4.0.7 seems to change any whitespace character to NULL. I am not sure why DOA does this. The DOA source code seems to do something like if (DataSet.TrimString(Field.Value) = '')then Field = NULL; Does...

well what I could see was that the FCurRec had a value of 0 rather than a value of 1 in the unit OracleData. However this only occured prior to the commit of the 2 record record. However when you were had inserted the 3rd record FCurRec had a value of 2 which was correct. I will try and go a...

Hi I am using DOA 4.0.7.1 with oracle 10g. I have come accross a very strange error. I have a dataset that has commit on post as false. I then call post. I can see from oracle monitor that the insert statement is correct and a new rowid is returned. However if I call refresh record to get the...

ok, say I have 2 queries with Query1 do begin SQL.Add('SELECT FirstName, LastName from table1......') Execute; end; I want Query2 to select all of the records where the firstname and lastname where returned from Query1. i.e with Query2 do begin SQL.Add('SELECT * from table2 where...

Hi I have got a question; I have a few datasets that return the same fields just with different criteria in the SQL. I want to do a link from those dataset to a new dataset that contains a select statement. However the only thing I can see is a master detail relationship which goes off one...

ok, thanks. An upgrade to 11g will not be possible across the entire estate but we are looking at replacing the MAPI calls with Extended MAPI. It is strange that the MAPIAddress method stopped working as soon as the OCIEnvCreate method was called. Do you know what the OCIEnvCreate method does...

Nope, Oracle Connector for Outlook wasn't installed on any of the machines. We just have the basic runtime install from the oracle 10g client but the method below keeps on giving out an error code of 2. MAPIAddress(0, 0, 'Select', 4, '', 0, lpRecip, 0, 0, @intRecips, lpRecips)

Hi we recently upgraded our systems to use oracle 10g and noticed that calls to MAPIAddress were giving an undefined error. After doing a bit of debugging we found that the calls to MAPIAddress (in the mapi unit) stopped working was after the line OCICall(OCIEnvCreate(..)) in the method...