Search results for query: *

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...

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...

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...

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...

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.