ok..so from what am seeing here you are referring to a list of all the tables you have created. how do i actually get that list to show in dreamweaver? the connection to the database was tested successfully but yet still i get none of the tables created...

>how do i actually get that list to show in dreamweaver?
Perhaps you should post this question at a DreamWeaver forum.

good day all,
ok...so i think i see where the problem is with the tables not showing in Dreamweaver. When i installed Oracle , i didnt not create a new profile but i did all my create and insert statements as well as building my forms using "system" as the user name. i thought came to mind to create a new user and create a sample table to see if it would show up in Dreamweaver...it actually showed..which is good but my question is..must i recreate all the statements and forms or is there a way to transfer the tables i want to the new user i created. your assistance would be greatly appreciated. thanks in advance

What is your connect string that you are using in ODBC to connect to the oracle database.

hey there,please see connection string below
"Provider=OraOledb.Oracle.1;User Id=my_username;Password=my_password;"

I was hinting on what is the "my_username", is it the same schema where the data tables are placed?

the user name is system..and yes this is where the data tables were created...however.. i seem to have found a solution to the problem...i created a new user..created a sample table and that table showed in Dreamweaver..this prompted me to recreate all the tables..change the credentials in the connection string and it worked fine...

That was a VERY bad idea in the first place. Do not use SYS nor SYSTEM for your own amusement. Ever.

yea..i learnt that the hard way..am new at this so i guess things like that will happen..but i know what to do next time..thats how we learn!! thanks again for your help.

hey guys..i have another question..well i know its possible to create an SQL statement to find a range of values.
example
SELECT * FROM EMPLOYEE
WHERE EMPAGE
BETWEEN 21 AND 50;
my question is..how can i create a form that allows me to enter the two values and return the respective results? assistance would be greatly appreciated. if anything needs clarification feel free to ask.
Best Regards
W.K

How are you connecting to the database through ODBC? if your tables are in the JUNK schema, then you have to connect to the JUNK schema to use them.

As of the last question (posted in a message #25): Forms already has that functionality - you just have to learn how to use it.

• enter query mode
• go to "empage" item
• type ":a" in there (without double quotes, simply colon (:) + a)
• press <Execute query>
• a new window will open
• in there, enter
  Code:

  :a between 21 and 50

• push the <OK> button

Otherwise, you'd have to create two items (let's call them "empage_from" and "empage_to") and dynamically create block's WHERE condition using SET_BLOCK_PROPERTY with its DEFAULT_WHERE (or ONETIME_WHERE) properties.

From my point of view, I'd teach my users to use what's offered instead of reinventing the wheel.