Search results for query: *

johnherman, Thanks for your reply. I kind of assumed that, but procedures have to be called, right? In other words, if I have many procedures/functions in my package, and they do certain functionality, that isn't performed until the procedure/function is called, right? If that's the case...

...IS PROCEDURE STUDENT_LOAD_MAINLINE; g_last_name VARCHAR2(25) := 'SMITH'; PROCEDURE STUDENT_LOAD_MAINLINE IS CURSOR STUDENTS_C IS SELECT * FROM STUDENTS WHERE LAST_NAME = g_last_name; ABNORMAL_END exception; BEGIN...

By the way, I should have mentioned that we have edited existing reports with Oracle Reports 6i. If there's anything else I can provide to get suggestions, I'd be happy to do so. Thanks. Steve

Ok, I'm a real newbie here, so please be gentle. :) We're in the middle of an implementation of Oracle 9i and Oracle Application 11i. There are a few reports such as Invoices, Purchase Orders, AP Checks, etc. that we'd like to do a bit of customization to. We have made small changes using...

Thanks so much! I almost am there. The only problem is: There's two "Suppress" boxes. I assume I click one. One is labeled "Suppress (No Drill-Down)" and one is "Suppress Blank Section". I assume it's the first, but when I click the "x+2" button for my formula, I'm not sure what to put in...

...Detail3 Notice the extra spacing between my detail records. Is there a way I can add data without increasing the space for my detail area? *On a side note, does anyone know how I can prompt for my Select Expert criteria? I run this report individually for specific account numbers, but...

Riverguy, You're 100% right. I apologize. I plan to be a bit more focused later today. :) As far as the PrintReport sub, it's just a sub that was used with an older version of Crystal Reports to actually just print the results... Anyway, sorry for the bad post. I was going to be out...

Rob, Thanks for the tips. I guess my main concern is: I want to do this right, and using DAO is now dead. I have other another module I did that uses DataTables and works great, but that's a form. This is primarily just computing a few things to populate a database table. The real problem I...

...ComputePlaces PrintReport End Sub Private Sub ComputePoints(strt1 As String) Dim strt3 As String strt3 = "SELECT * " _ & "FROM Results WHERE " _ & "CompNum = " & "'" & txtCompNum2 _ & "' AND ScoreA1 > 0 " _...

...database if someone would be kind enough to help me out. I'm just looking for a few tips on what I'm doing wrong, where I could improve, etc. I'm *NOT* looking for someone to write it for me, but hoping for a guiding hand. I'll guarantee a Christmas card to anyone who'd be so cool! :)...

Brian, Thanks a bunch! Unfortunately, I'm not using a DataGrid, but I got this working yesterday: Private Sub txtCompetitor_Leave(ByVal sender As Object, ByVal e As System.EventArgs) Handles txtCompetitor.Leave txtName.Text = dr.GetString(0) & ", " & dr.GetString(1) Dim...

Sorry for my ignorance, but I can't find anywhere in my books or elsewhere how to do that. Any pointers on where I could look?

Thanks for your reply! Both fair questions - :) To explain better: I'm dealing with 10 text boxes. However, this is NOT a datagrid, just a traditional application form. I don't have any need for navigation between records because the first two textboxes are for a competition number and a...

You can't go wrong with: Micorosft ADO.NET Core Reference by David Sceppa ISBN: 0735614237 Seems to be the favorite of most, and I use it constantly.

I'm looking for opinions/suggestions. Please help! :) I'm a newbie, so please be gentle. I have a simple windows application that has ten text boxes. They are: txtCompetition, txtCompetitor, and eight scores: txtScore1...txtScore8, etc. There's also a save button. The first two text boxes...

Hoping someone can help me out: I have a fairly simple windows application that uses an Access database. I'd like to bind textboxes to my dataset, but am unsure where I'm going wrong... The problem is, upon "GotFocus" of a certain textbox, I want to open a dataset and keep it open...

Well, this option seemed great, but it seems that the file is still in use by the first object whilst trying to copy the second. So now I get a message saying "The process cannot access the file 'c:\...' because it is being used by another process." Grrr... I guess I'll have to go...

intrex, Thanks alot. The system.threading.thread.sleep method worked great. I had to fiddle with the number of ms, but 400 seems to work. Weird, huh? I noticed that it doesn't matter what order I do the copying in - the first destination can be zero bytes if the sleep isn't used. The...

Hi. I have a function that fires on the creation of a file in a directory. What I want to do is make two copies of the file, copying one to one directory on a remote machine and another copy to a directory on the local machine, and then I want to delete the original. Here's a small snippet of...

I'm in *desperate* need for help. I'm a bit of a newbie, so please be gentle. :) I'm trying write a vb.net program as a service. Essentially, all I want to do is have the FileSystemWatcher wait for files to be copied into a directory. As they are, any that have a .bmp, a .pcl, or a .inv...