Search results for query: *

Thank you for your replies... While I was doing my testing I was using the <Query Builder> and <Execute Query> buttons in the Configure Table Adapter window. I would type in my :password string and it would return the result of my query (the hash value) for me to veiw in the query builder...

If my TableAdapter is: SELECT ora_hash('hrss3k', 1257981, ss.SALT) AS HASH FROM HR.SEC_SUPPORT ss WHERE (ss.USER_ID = 'ibt10') of if my TableAdapter is: SELECT ora_hash(:password, 1257981, ss.SALT) AS HASH FROM HR.SEC_SUPPORT ss WHERE (ss.USER_ID = 'ibt10') Even if I pass in...

When I create a tableadapter in VS2008 which calls the ora_hash function (oracle 10g db) AND if I pass the password string as a parameter (:password) rather than passing the password as a string ('hrss3k') I get a different hash value than if I execute the same hash statement in oracle. I get...

When I create a tableadapter in VS2008 which calls the ora_hash function AND if I pass the password string as a parameter (:password) rather than hardcoding the password as a string ('hrss3k') I get a different hash value than if I execute the same hash statement in oracle. I get the same hash...

Just FYI for anybody wanting to know this... I was able to find some of the information I was looking for in the sysman.mgmt_job and sysman.mgmt_job_parameter tables.

Thanks for your quick responce. The problem I'm having with the grid is when I set up an export and save it to run as a job... I can't then go back to the job's and see stuff like the name of the export file and the parameters I used like 'don't fail on warnings'... that sort of stuff. I'm...

Our office is in the process of moving to 10g and I am having trouble reviewing job details after I have setup an export to run through a job. Does anyone know how you review the parameters - there is a tab for parameters when you view definition, but it only ever says there are no parameters...

I am hoping someone can help point me in the right direction. I have developed a web service that is pulling/returning a datatable from an Access database located on the c: drive of the IIS server machine. But when I change the web service to look at an Access database located out on the...

I created it in a module as public. Where should it be created and how do you then set the vb.net windows application to start via that main() sub? Thanks for replying! (p.s. do you know of any downloadable examples?)

I am learning the ropes in VB.Net and want to learn how to implement a global error routine in my VB.NET Windows Application. I have found many textual examples of this, most talking about adding the controls to the main() sub. But I am just not getting it to work. I can create a main() but...

I want to have a base form where I define a button (btnExit) through the code and the base form contains an event handler to execute me.close I have the base form created. I can create the button through code and I used the Public WithEvents BtnExit as system.windows.forms.button I created a...

I have recently installed Visual Studio on my machine and of course Crystal is packaged with that. But I support Crystal users and need to edit reports that have nothing to do with Visual Studio. Does anybody out there have Crystal running on a machine that also has Visual Studio on that same...

Thanks for your post synapsevampire It's XI Enterprise Release 2. The report is being called through an ASP page using some Java Code. However, if anyone knows how to make a parameter box wider in any version of Crystal please let me know because it might help me track down how to do it in...

Does anyone know of how to make a parameter box wider? The default box that comes up isn't wide enough to show all the text.

Does anyone know how to capture the DateModified for a form in Access. I can right-click on the form name in the database window and get the correct date from the properties option. But referencing the MSysobjects table's DateUpdate field isn't always correct.

Thanks for your post, satinsilhouette. I'm using XI, but I don't think I made my problem plan. I want a text box entry for last name - drop downs are a bit clumky when you are dealing with thousands and thousands of possibilities. Plus XI's drop downs don't allow for the user to type a word -...

Can you have the user type a person's last name in a field and then use that value to populate a dynamic prompt of 'case numbers' that are available for that name. I can create two drop-downs that do this: drop-down of last names and then a drop down of case numbers. But doing this is clumsy...

I have an evaluation copy of Crystal XI and have found that the dynamic prompt (parameter) is showing only around 1000 records. There appears to be all kinds of setting changes suggested to the registry but I can't get anything to affect the number of records returned. Same problem exists...

I am working on someone's database that has a column called: Serial Number When I try to reference that column in a function like DLookup: DLookup("Social Number", ...) I get an error message saying my expression is not valid... When I try the same statement with a field that is not named...

I wrote a function called isbarren() that takes a variable and checks isnull, isempty, = &quot;&quot;, and = 0 and returns TRUE or FALSE. I've used it happily until yesterday when I noticed that when I pass a string value of &quot;2000D-473&quot; it returned TRUE. Upon examination, I...