Search results for query: *

Hi, I am new in perl programming. I have a problem on cookie. I need to retrieve a page from a website, but the website require cookie enabled. I used the LWP:Simple and get($url), and the content I got was something like "Your web browser is not currently configured to accept...

what is the SQL command to view all the tables? Thanks.

In our class projects, we screwed up the tables last time in Oracle8, so we tried to drop all of them and regenerate tables. However, because they are interconnected, we couldn't drop them one by one. Is there any command to drop all the tables in your space? thanks.

Yes, got it. Thank you guys.

Hi, mhadden. I tried your method but it doesn't work. I think this property is suitable for those fields which can have value, say one line or many lines, so the fields can shrink vertically to fit the values. However, in my report, many fields can be "null", so the blank is still...

It is kinda complicate, and I just learn it in the class this week. Hope you can understand what I will say: 1. First make sure that you define the tables and relationship without error. 2. In the menu, choose database->generate. In the pop-up form, click the checkbox of "generate new...

Sorry, this is from an old thread. But I got new question on it, so I repost the question again: --------------------------- I got two tables. One is "employee", storing the information of employees, with "EmployeeID" as the primary key, and the other...

Got it. Thanks Bnpmike

Hello, Guys. I made the report I wanted almostly with your helps. However, There is another small problem. Now I put all Employee's information into employee header and left the information of dependents in the details, but in my table, there are some employees who do not have dependent, so in...

Thanks guys. Jacksonmacd, I used your method and made it. Thank you. But have another problem to ask you. The lab is close now so I got to rush out. Post my question tomorrow. Thanks again.

I am using a ACCESS 97 book, and it said that we can use a debug windows and run sub in module, which has "debug.print" command, to test our code. However, I am using ACCESS 2000 and I did not find the debug windows mentioned in the book. How can I test my sub now? Sample sub: sub...

Hi, Erik2. The "Sorting and Grouping" works fine if I only group the dependents without the employee, but when I group dependents under the name of each employee, the name of employee repeat again and again. Is the query wrong?

I got two tables. One is "employee", storing the information of employees, with "EmployeeID" as the primary key, and the other is"dependents", storing information of dependents of employees, with the "employeeID" as foreign Key, I made a query to join the...

Oh, man. That is exactly what we did. I misread the table. However, the problem still there: I don't display the "address type" in the form. When all the required fields are filled in in the "Billing address" subform, the value of "address type" field in the table...

Thanks. Maquis. Another question: When I have two subforms, I want to achieve this: I don't display the "address type" in the form. When all the required fields are filled in in the "Billing address" subform, the value of "address type" field in the table will be...

Thank you guys. One of our teammate suggest to add only one set of address(including street, city, zip, and something like that) in the table, and add an address type- "0" indicates "billing address" and "1" indicates "shipping address". If a person fills...

I am a newbie in database. Our course project is to make a online book store. We created a table called "Customer". As required, there should be "Shipping address, including city, state, zip" and "Billing Address,including city, state, zip". If we add all those...

Hey, Sokeh. Thanks a lot for your responses.

Hello. I am a newer with Oracle. Could anybody teach me how to use or convert ACCESS database in Oracle 8.Thanks