Then you need to try this (http://www.toadsoft.com/lic_agree.html).

TOAD does not come in that price range.

you need to copy the activex component also to the system and register that using REGSVR32 command.

How much you are ready to invest for the tool ?

What happens when you call the function / event in Form_Resize event ?

Is that not getting executed ?

Relational modeling is the logical representation of the physical relation of the DB tables.

if you are ready to pay use TOAD or PLSQL DEVELOPER, the best possible tools in market.

try the following code, make changes as desired


Dim CN As New ADODB.Connection
Dim RS As ADODB.Recordset
Dim DataFile As Integer, Fl As Long, Chunks As Integer
Dim Fragment As Integer,...

that has nothing to do with database connection . check your other code.

you should get correct output with your code. there is nothing wrong with it.

You can't disable the windows key.

what is the source of data in the control ? is it getting populated from database ?

* is not required in delete statement. use this

strSQL = "DELETE FROM Product WHERE Expiry_Date = '" & Text1.Text & "'"

Try the following sample code.

SELECT code,substr(code,instr(code,'-',1)+1,2) from table_name;

but where is the loop in your code ?

i don't see and disadvantages.

you nee to create a table with check constraint and default values.

try this

create TABLE table1
(ID INT,
status varchar2(10) DEFAULT 'Available',
CONSTRAINT con_chk1 CHECK (status IN...

the syntax that you are using is not Oracle syntax.

You need to pass more information.

What do you mean by when an exe is ended ?

There are many applications that can be finished in your time frame. Now it depends on you what you decide to develop.

If you are looking for the connection string find it here (http://www.connectionstrings.com/).

from vb 6.0 you need to use ADO.

you do not need an intermediate table only defining the relationship by PK and FK will do that for you. But from your post i am not use what exactly you are looking for. I think you need to pass more...

try this sample function for the job.



Code:
Public Function NumToWord(numstr As Variant) As String

Dim newstr As String

numstr = CDec(numstr)

You need to work with CDO.

i didn't understand your question .

What is a forum window ?
What do you mean by update without saving ?

From your post i became a bit curious and tried to trace back my old days here.

My first post was in community introduction section here (http://www.daniweb.com/forums/thread80215.html), as i was...

comment Unload Me in your code and i hope the rest wills tart working. use Me.Hide instead of unload Me.

You need to format the date to proper format before pasing the same to database.

what is that CON in your code ?

What type of object is that ?

Are you using ADO to connect to the database ?

then you need to populate records from the source to a staging (intermediate) table before actually inserting them to your main table.

so with each load you need to truncate your table and load...

i don't think that is VB 6.0 code.

if vb 6.0 then try this
Dim Sql As String = "insert into Customer_tbl (Custsql )values '" & txtFirstName.Text & "','" & txtLastName.Text & "')"
con.begintrans ...

The simplest method will be create a view based on the table with last five days record. That will be always refreshed every time you run any query on the view.

then you need to push the power button on your computer.

you need to convert the date and time to proper format before passing the same to database for processing through SQL statement.

you need to use the function REPLACE.

what exactly you mean by over internet ?

are you in the same network as the server ?

try the simple code

con.begintrans 'con-----adodb connection object.
con.execute "your DML statement here"
con.committrans

you must be connected to the database.

if you are using oracle as database then can use external table for the best solution,but you need to extract the zip first.