FYI for others trying the same thing...
I found another way to skip the first row for a file loaded via sql*loader: add the following line prior to the
LOAD DATA line:
OPTIONS (SKIP=1)
LOAD DATA
...
Hi! I have another question about file manipulation on unix. I have a Korn shell script which uses sqlloader to load a .csv file. There is a header on the file which I do not want to load. How can I either strip the first line from the file prior to loading, or does sqlloader have a way to...
Hi! I was hoping someone could help me with this. I'm working in Korn shell and am trying to pass a variable to a tail command and am having problems doing this.
tail -"$var" > out.txt
The quoted part is where I'm having problems. Ideas would be appreciated! Thanks!
Juls
Hi All!
The company I consult for has determined that they are going to replace their current batch-oriented system with the real-time Tibco software. As far as I can tell, the main driver for this is "it's newer and it's cooler" than what they currently have. I am a developer who has worked...
I tried your suggestions and it appears that the event is firing regardless of the return value of the javascript function. I set the javascript function to return false no matter what, then created a button with the delete event:
this.MyTestDeleteButton.Click += new...
I tried that and it still deletes whether true or false. Here is the code for this item, which may shed more light on the problem. I'm afraid it could be the way the CommandEvent Handler is calling the Delete function. Even if ConfirmDel is false, the Event Handler is still firing. How can I...
I'm trying to create a popup message to prompt a user Y/N whether they really want to delete a user before proceeding. The MessageBox class has the functionality I need, but my application is a web app. The MessageBox class resides within the System.windows.form.dll assembly however. Is there...
I am trying to set up a textbox within a datagrid and I'm not sure how to do it. Here is the code I'm working on. I would like these cells to be textboxes that the user can modify the values and hit a save button for processing. Right now, I can set the cell text, but am unable to figure out...
After beating my head against the wall more than a few times and wasting a couple of hours, I realized I put P_PCT in the ADO function instead of p_accr_adj_pct which is the Oracle variable name.
***DOH!!!!***
Thanks all!
I've commented out the percentage parameter and it executes fine - the percentage parameter has a default set up as 100. I want to be able to pass something other than that, however, which is where the problem arises.
This runs fine with only 4 parameters set and calculates using the default...
Actually, I'm modifying already existing code where the p_edate was not declared. The p_edate is defaulted in Oracle, so it should be ok not having a parameter passed to it (it was OK prior to my tinkering with it). I've tried adding the following:
new...
I am experiencing problems using ADO to run my Oracle function within a C# program. I am able to run the function just fine in oracle, but when running it via ADO, I consistently get the following msg:
Error MSG:
ORA-06550: line 1, column 18:\nPLS-00306: wrong number or types of arguments in...
HTML export to excel - losing leading zeros and date format
Hi! I'm hoping someone can help me - I've searched the archives and haven't found this exact issue.
I have an application that I've inherited where a dataset is exporting via an html table to an excel spreadsheet. This process is...
Hi All! I'm a newbie regarding Visual Studio.net and am in the process of interviewing a developer for a project that is 3/4 complete. I need someone up to speed very quick, and am interested if anyone can help me with some good questions that will weed out the applicants that are BSing. I've...
I didn't find that post previously or I would have added mine to that thread.
I have made progress, however, since my post. Perhaps others may benefit from my stumbling around VS. Previously, I tried deleting the obj directory with the debug information (there was a symbol file here even...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.