debasisdas

the team is glad to have you here.

what the project is all about ?

Hi Philip, welcome aboard.

I get paid for every line of code by my company . So no chance of supplying free coding to any one . BTW how do you expect someone else doing your home work / assignment for free in a open forum like this.

how both the tables are related ? please post the structure of both the tables.

that depends on what is stored in the database table . Are you storing both data and time in the database ? Data data type can store both data and time into a single field. You need not store them separately. But if you are storing only date not time …

A bit more information will be really helpful.

That product is de-supported by MS ,so you may not find a link to download that. Now VB6 is like Oracle 8/8i , hard to find a link not even in the parent site. Try find a copy from someone who has one. Since the product is de-supported you need …

but where is the loop in your code ?

From your post i am not sure what exactly you are looking for . Why you need to store the codes in database . What is the database that you are using ?

You need not download and install sql developer software separately, that is integrated with oracle 11g. You need to download and install the version as per your OS and system configurations. You need not install any other software to have your database running. Using sql developer software is optional as …

Try the following sample code. [code]SELECT code,substr(code,instr(code,'-',1)+1,2) from table_name;[/code]

What is the error code/ message ? Power Builder is not a good alternative to Form Builder.

Power builder is a RAD tool.

is it not available in the list ?

is that a control or a component ?

try to use [B]list1.list(list1.listindex)[/B] in pace of [B]list1.text[/B]

is there any relation between those two tables ?

you need to check the status of the checkbox and change your code accordingly

i don't see and disadvantages.

You need to code the function in database and call the same from vb 6.0 as part of your sql code, but if it is a procedure you need to create command object (adodb) in vb .

Just change the style property to graphical.

Why you need a command object or a recordset for an insert statement ? simply try this [code=vb] con.begintrans 'con ----adodb connection object. con.execute sqlstring 'sqlstring ----your insert statement con.committrans [/code]

you nee to create a table with check constraint and default values. try this [code=sql]create TABLE table1 (ID INT, status varchar2(10) DEFAULT 'Available', CONSTRAINT con_chk1 CHECK (status IN ('Available','Unavailable','CheckedOut') )) [/code]

Welcome to Daniweb, Hope you have a nice time here as well.

you need to decide the topic and do post back if you face any difficulties in technical section of the forum.

Hi Maina, Welcome to Daniweb.

Welcome to Daniweb. Any technical experties ?

waiting for your questions.

Hello Seth, Welcome to Daniweb.

check if oracle is installed properly and if you are able to log in to database

What you have tried ? How you restore that from command prompt or directly in mysql ?

you can either take backup of the tables or prepare script for all the new tables and the containing data.

what is the source of your data ? if it is in a flat file you can use sql loader also try to use INSERT ALL statement.

you need to change NLS setting for that and have a different keyboard with all the languages that you want .

you want an e-book ?

You need to decide based on your organizational needs.

Welcome to Daniweb

Nothing is clear from your question . Please post your question clearly, properly specify what is the requirement and where you are struck.

SELAMAT BERKENALAN same here as well

Hi Arun, You can be sure of that.

Welcome to Daniweb. Once you start contributing with all your knowledge the forum will be even better.

My friend Google is your best friend in such matters, use that.

for that you need to design your database accordingly. and designing tables at run time and working on them only sounds good only if you do not know how that works.

Welcome Anna, hope you have a nice time here.

1. create user user1 identified by password1 2. grant previlags / roles to user1. 3. select * from tab. 4. select * from all_users. 5. there are many , we can do it here at daniweb. all the above answers are for oracle database. I am not sure you are …

What about using a hidden text box ? Have you ever thought about that ?

why you have posted all that lengthy code here ?

Hi Doubleh, Welcome to Daniweb.

Hi Rishi, Welcome to Daniweb.