Search results for query: *

Thanks carp that worked a treat!

Here is a clearer example of what I'm looking for: SELECT INSTR('MRFL', 'RF') REV_SRCH FROM dual; This returns 2. SELECT INSTR('LFRM', 'RF') REV_SRCH FROM dual; This returns 0. I'm looking for a function to reverse this variable (LFRM) so that it matches the first example.

Hi, Is there a PL/SQL equvalent to the strReverse function in VB? I'm tring to check a string for the existance of a substring and i need to check it forwards and in reverse order. e.g: Here is the code I have for checking if r_map.surface_code exists in psurfacecode, but what I am asking is...

VB6.0 SQL Server2000 Hi, I am trying to add data to a calculated field in a disconnected recordset and i am getting the following error: "Multiple-step operation generated errors. Check each status value." Here is the query for the recordset: SELECT table1.amount_charged, table1.deductible...

OK I've figured it out: OPEN c1 While (@@FETCH_STATUS = 0) BEGIN FETCH c1 INTO @StageDesc set @Treatment = @Treatment + @StageDesc + char(13) END

Hi, I am trying to convert an oracle database function into a SQL Server function and i am stuck on a particular line of code. Here is the PL/SQL: OPEN c1; LOOP FETCH c1 INTO StageDesc; EXIT WHEN c1%NOTFOUND; Treatment := Treatment || StageDesc ||chr(13; END LOOP; Here is what i have...

That did the trick thanks a million!

Thanks this seems to be heading in the right direction. However now i'm getting error "ORA-01779 cannot modify a cloumn which maps to a non key-preserved table" any idea what this means?

Hi, I have 2 tables and i need to update data in the first table with data from the second table. The following statement will not work but it will give you an idea of what i am trying to do. UPDATE table1 SET table1.code_id = table2.system_id WHERE table1.code_id = table2.code_id I am...

Argh! Thats the answer I didn't want to hear! Thanks for your help.

Hi, I have a database which is stored in Oracle8i and all the client machines are running Oracle9. My problem is that i do not have access to the server and must use one of the client machines to export the database using the "exp" command. I am getting the following error...

Thanks for the advice. This error is actually a windows error which is why I had so much difficulty finding any info on it when searching Wise related help. See this for help: http://support.microsoft.com/default.aspx?scid=kb;en-us;282183 Its related to mapped network drives, my problem was...

Has anyone come across this error? This does not come up on all PC's and I've no idea where it is getting a drive n:/ from! Any info much appreciated.