Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Cantor
  • Order by date
  1. Cantor

    Delete file on FTP site with Oracle

    The second direction seems interesting. How can you do that? Let's say we have toto.zip to delete form this ftp server : Host name : ftp.sitename.com directory : /data/zipfile Are you saying it's possible to "see" toto.zip with SQL*Plus, and then remove it? Cantor
  2. Cantor

    Delete file on FTP site with Oracle

    Sorry to be so unclear. Nothing has been done yet. We are at the "is it possible?" stage. The plan is to execute a DB package who will delete a zip file from a ftp server. So the "tool" would be a PL/SQL procedure store in this package. I hope this will help us to help me, Thanks, Cantor
  3. Cantor

    Delete file on FTP site with Oracle

    Hi, we need to delete a file who is on a ftp site. Is there any PL/SQL commands to do that? Does the package UTL_TCP can delete a file? I saw functions like "put" and "get" but no "delete". Thanks for your help, Cantor
  4. Cantor

    About Web.Show_Document() method

    Hello, I use the Web.Show_document('My_URL', '_TARGET') in a form to call some reports located on a web server. I always use the target '_BLANK' to open my documents in a new web browser and it works well. My problem is when I want to open more than one document in a row. I call...
  5. Cantor

    Printing a Server Model Diagram in PDF

    Hi, Does someone know how to convert/export a Designer Server Model Diagram in a PDF format? Is it possible? Tanks, Cantor
  6. Cantor

    "ORDER BY" question

    Hi, Let suppose a single table NAMES First_name VARCHAR2 Last_name VARCHAR2 Is it possible to do a query to show this table ordered by First_name first and, secondly, ordered by descending order of the Last_name in the same query? thanks
  7. Cantor

    Find caracters in a field with long type

    Obviously, I try it before to post my question. When I use this syntax (the same as you), I have a inconsistent datatypes error (ORA-00932). The only solution I see is to write a PL/SQL program. I'm trying this way. Thanks
  8. Cantor

    Find caracters in a field with long type

    ...you want to find all records of the table PERSONS where the FIRSTNAME begins with 'Joh' (FIRSTNAME is a VARCHAR2 type column), you do that: SELECT * FROM PERSONS WHERE FIRSTNAME LIKE 'Joh%'; What I ask: How do you do that if the column is defined LONG type instead of VARCHAR2? Is it...
  9. Cantor

    misuse of LONG datatype in an INSERT command

    ...another table (two tables are exactly the same) but the type of one field of those tables is LONG datatype. So I do: INSERT INTO table1 SELECT * FROM table2@DB_LINK; It gives the alert: ORA-00997: illegal use of LONG datatype How could I solve this problem? Should I insert one field at...
  10. Cantor

    Easy one (I hope)

    Sorry for the normalization, I forgot to Preview Post before submit it. The same sample of my table, normalized: Game # winningTeam losingTeam winScore lostScore 1 Tigers Flames 4 3 2 Canucks Tiger 5 2 3...
  11. Cantor

    Easy one (I hope)

    Hi, There is a sample of my table: Game # winningTeam losingTeam winScore lostScore 1 Tigers Flames 4 3 2 Canucks Tiger 5 2 3 Pens Canucks 6 2 4 Tigers Av's 2 1 My question is simple. I would like to request the sum of winScore and the sum of lostScore for...
  12. Cantor

    Restore backed up file

    Thank you I found this article who is exactly what I need : Q155979
  13. Cantor

    Restore backed up file

    I'll try to give you a better picture, but sorry, i'm not too good in english. I've formatted my hard drive but before this, I partionned him like this c: -> HD_1 and the new one d: -> HD_2. I've made a backup of some files (mydoc.qic) with MS Backup and save it on HD_2. So I formatted the HD_1...
  14. Cantor

    Restore backed up file

    When I want to restore the file, I must import the qic file and then the error message occurs : "The file is not runnable. Erase the file or choose another one." I hope the file is not corrupted or stuff like that. Thanks for response, Cantor
  15. Cantor

    Restore backed up file

    Hi, I have QIC Files from Win 98, now I have Windows 2000 and I can't restore them. How I can made it?. Please help me, I have a lot of important information. Thanks, Cantor
  16. Cantor

    MsgBox or How to avoid adding a second time

    I know how to remove the selected item from list1 but I don't want because datas from list1 come from my main table and I need them for other things. I could create another table for only datas who are in list1, but I don't want because, I've many list box and I would be overloaded by the number...
  17. Cantor

    MsgBox or How to avoid adding a second time

    Hi,<br>I've two list box, list1 and list2. When a user selects an item from list1 and click on a command button, the item is added to list2, without be delete from list1. No problem with that. <br>What I want to do now is when the user will tries to add item from list1 a second time, a message...
  18. Cantor

    How to select field name

    Hello,short question: Is it possible to select only the fiel name?shorter question: How?Thanx,Cantor
  19. Cantor

    Listbox to another listbox

    Hi,In my form I've 2 listbox: ListBox1 and ListBox2. ListBox1 is full and ListBox2 is empty. What I want dto do is when I double click on an item in ListBox1, the item is sent in ListBox2.Antoher way I think to do that was a command button who put the item selected in ListBox1 and put it in...
  20. Cantor

    put SQL code in VB code

    Hello,I know how to do SQL request. However, I need to do this on a form in access. I have to put the result of my request in a field of a form and I have trouble with that. See the beginning of the code:<b>Dim strSQL As stringstrSQL = &quot;SELECT Sum(FORMCOD.SUPER_COMP)AS SumOfSUPER_COMP FROM...

Part and Inventory Search

Back
Top