Search results for query: *

Thank you jkotan

markrem , I'm new in oracle , I went to oracle website and I found in the download section some development tools, such as designer 9i , is it a free tool?

SO YOU MEAN I HAVE TO PUT IN EACH FUNCTION/ SUB THIS CODE: ON ERROR GOTO LINE DO SOMETHING HERE LINE: CALL MY_PUBLIC_FUNCTION() I WISH THERE IS A WAY WHERE I DON'T HAVE TO DO THIS IN ALL MY SUBS OR FUNCTIONS . . . :( = = = THANKS BOGDANMBM

I know how to use: ON ERROR GOTO LINE DO SOMETHING LINE: DEAL WITH ERROR But this works in the current sub or function. What if I want to use ( ON ERROR GOTO LINE ) to watch errors anywhere in the whole project for all the forms in the project ? is there like a global error handling ? how...

Hi , How can someone , through SQL , or any other methods, identifies the relationships between tables in a database? In other words, how do I know that a specific field is a forigen key in a nother table? I need to know , because I'm suppose to work on a database that was created by...

hmckillop , Thanks for your reply I'm using a connection string to connect to Oracle The strange thing , if I go and install Visual Basic on that machine , it works fine!

I used adodc in my application. It works fine when I'm running the application on my computer. When I use the package wizard , and I copy the files to a new computer and open the instlation file it stops and displays a message saying one of the files is outdated or so and then it asks me to...

If I have this line : 3233 Washington D.C and I want to get only the string in that line which is "Washington D.C" How do I do that?

How do I tell ASP to execute a SELECT statement only once a month and keep the results presented to the visitors until the end of the month? I don't want each user to execute this select statement because he/she will get the same exact information like the rest of the visitors for the whole...

wait , could this be because something wrong with my connection string? This is my connection string by the way conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Computers_DD.mdb;Persist Security Info=False"

Thanks again , When I use the semicolon at the end of the SQL statement I get an error message saying ( Expected: List separator or ). . ) ID= is not a number , it's variant like A123BE TABLE is not the real name , the actual name of the table is COMPUTERS . . still can't get it to work...

Thanks for your reply, But I can't find the part which is not Access (Jet) in this statement: conn.execute ("INSERT INTO TABLE (FIELD1) VALUES ('NAME') WHERE ID LIKE '"&VarName&"' ") and where ever I add a semicolon at the end of the statement I get an error . .

This SQL statement will work fine: conn.execute ("INSERT INTO TABLE (FIELD1) VALUES ('NAME')") However, if I add the where clause I will get an error message saying ( Missing semicolon at end of SQL statement! EXAMPLE: conn.execute ("INSERT INTO TABLE (FIELD1) VALUES ('NAME') WHERE ID LIKE...

Thanks SonOfEmidec1100 , but when I use the DIR function: list1.additem dir("c:\*.*") I only get one file added . . johnwm , I didn't know that I had to mark the answers. But now I know , so thanks.

Does anyone know How get the names of all files in specific directory using VB6.0 ?

How to format this number : 100343E21 to a normal number in ASP ? Thank you

I'm using a NUMBER as a primary Key in my table. But the Primary key that I want to add now is more than 10 degits. AND whenever I try to add more than 10 degits , Access won't allow me :( I can't change the Data type of the primary key to MEMO because of the relationship between this table...

Thank you guys , I used the Join method and it worked.

I will use the following example as a question: This is a recordset set rs=cn.execute("SELECT * from TABLE_1") Now I want to select records from another table but where the ID matches. set rs2=cn.exuecute("SELECT * from TABLE_2 where ID=") HERE IS WHERE I AM STUCK! I...

tikual , I don't have unix usige , I tried what you suggested and I got the same file with no extension :(