Search results for query: *

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

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...

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

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

Hi, What I know: If 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...

Hello, I try to insert a table in 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...

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...

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

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...

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

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...

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...

Hi,<br>It's the second time I ask this, but this time I've put a more descriptive subject!<br><br>I've 2 fields : the area_ID and the Surface. They are both in the same table (tblArea).<br>So, when user enter the area, in the AfterUpdate event I write the following code to updated the field...

I have 2 fields in my form: area_ID and surface. I want when users enter the area ID in the field area_ID (of course) the field surface become updated with my DataBase.<br><br>Is this possible?<br><br>Thanks in advance and sorry for my english: I begin in Access but in English too!

I have Access data (one column) and I want to put these data in a specified field in Excel in a SPECIFIED sheet.<br><br>I know how to export from Access to Excel but how do I choose my worksheet?

Hi, <br>See this table:<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NAS NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FIRSTNAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>--------- --------------------...

Hi, I think I wounder about nothing but how do I must use the <b>ROWNUM</b> attribute? I must list only the first two elements of a table and I must use <b>ROWNUM</b> but I found nothing on that.<br><br><u>Thanx!!</u>