Recent content by williamwhite

Hello, We use an oracle datebase. There are tables were the data is saved as BLOB. The data in the BLOB is only text. How can i convert this blob to a data string so i can use it for the import in MS SQL

Hello, As a Newbee I have the following question. I have a record list like: wwit ppiet rron Through the DTS I want to come to the following situation with jscript: wwit 1 name wwit 2 string1 wwit 3 prompt ppiet 1 name ppiet 2 string1 ppiet 3 prompt rron 1 name rron 2 string1 rron 3 prompt...

I am not sure but am afraid the only way is to convert all logins in Servicenter to be uppercase. That way you'll have the match. gr Willie

I thibnk that maybe the record is still locked when the macro kick in with his update of the same record. You could check whether this lock exist and them may delay your post. Dit you try it through the Document Engine?

Please think with me: Your query was: flag=true and date(tod() - '7 00:00:00')<=open.time and ( (severity.code=&quot;1&quot; and (tod() - '00:30:00')>update.time) or (severity.code=&quot;2&quot; and (tod() - '01:00:00')>update.time) or (severity.code=&quot;3&quot; and (tod() -...

Hello, From the data administration guide. There is the info available: Down here there is an extraction of this document pages 552-555 but you want to look From 549 to 561 the whole info is there 28-4 Data Administration Guide Start-up Parameters This section explains system-level start-up...

Could you please post the query? Then I will look whether I can help. gr Willie

Is your data running on P4, then you could consider to take another db like oracle or mssql and shadow your environment. Then you have acces to a database you for sure can acces the way you want

we have ce9.0. the database has no row level security. But will check the 3rd party tool. I'll look into the processing extension, although I do not know quit what it is. thx for the answers

Hi, Reply on your first question: Did you check whether both field in your environment are from the same type. Look for it in the sql mappings? Second. If you have a link it will look for the simalar name on the form. So if you need one for the contact.name search to get the data to your...

I didn't have the same problem. But maybe this helps: Go to the command prompt <db> enter for the file type <unload> enter choose <unload.script.g> enter search for PurgeAll and open it tick the radiobutton <Show Unload Buttons> Now you see the list of all that the purge will do. You can add...

You should be able to use the odbc connection to the database to access the data.

Hello, We are working with a a lot of departments. The business rules say that a user can only see the information of his own department. I can setup the structure with authorisation to see only certain reports. but that means that I have to make 300 reports doing the same thing and connect...