Posts by debasisdas

That simply means you did not understand how NVL works.

1. store all the dates and other details (suppose birth day of all friend with there name , ph and email) in a database.
2. on start of your application it should connect to database and check if todays date matches with any of the dates in the database.
3. If it matches display a pop up in the system tray.

You need to run you application on a scheduled time once a day.

That will depend on the model of the device and the device responds to what commands.

Data base needs to be in centralized server and all branches needs to access the same.

If the device is switched of how it will respond to your program ?

You need to read this.

You need to fix the other joins as well.

Are you trying to switch on / off (the power supply) the device ?

I really do not understand what is that convert

Lets see your working code.

your join looks weird.

you are saying 6 tables but actually using 9

as per your code

select * from table1
inner join table2 on table1.id = table3.id

may i know why table1 is joined with table2 on table3.id ?

NOTE:-- There should be at least n-1 number of joins for joining n number of tables.

but to come with any solution, one need to know

1. what is the table structure
2. which all tables are joined in your left outer join
3. what are you doing with the cursor.
4. how many records you are processing ....etc

don't expect others to guess and solve your problem.

which database you are using ?

You only know what you are writing .

i am not sure if that property is available in the version you are using.

try using both textbox and a combo.

type in textbox and populate the combo.

Use change event of the textbox.

lets see the code that you are working on.

Database is bundled as part of application. It must be deployed separately ( unless it is MS Access database file )

why are you using Unload Me ?

learn what ever you can find.

what you are doing ?

which database you are using and what exactly you mean by linking ?

Try using DATE ADD()----add 7 days

and then use %W for mat to extract the day o use DAYNAME(date)

SELECT OrderId,DATE_ADD(OrderDate,INTERVAL 45 DAY) AS OrderPayDate
FROM Orders

Is it 32 bit or 64bit Oracle 11g r2 installed on the machine ?

Please more here , here, here and here.

1. clear the control.
2. refresh the recordset from database.
3. populate the control.

Is there any column on which both the tables can be joined (account_id may be).

This my be helpful to you.

I am really to eager to know, how you

add control or make changes in code at runtime

I really do not understand your code.

Why are you using 3 different logic for the same condition
If Booksremaining > 0 Then and that to in independent IF blocks ???

run the command in backend and check if that works for you.

for that you need to store all your suggestions in database and fetch from there to display in the control.

Media player won't do that for you.

query only

SELECT * FROM NLS_DATABASE_PARAMETERS

Hi Dan,

Welcome to Daniweb.

try with some data of length < 255 and check if it works.

have you looked into NLS settings ?

I don't understand this.

<<because excel can only accommodate 255 nvarchar right?>>

Increasing the data type size in database side should solve your problem.

Use CLOB.

run the query in access.

Hi BrendaM,

Welcome to Daniweb.

You need to run one Update query after successful login.

you need to check if data in source is compatible with destination tables structure.

I am not sure if MM Control supports FLV files.

try to run the sql query with the dates that you are passing in the back end and check if you are getting any records.

simply, by writing some code that works for you.

How are you importing ?

and ensure to pass the date of DateTimePicker2 less than that of DateTimePicker1

also you need to parse the date into proper format.

which component you have used ?

Media Player or MM control ?

Hello Charles,

Welcome to Daniweb.

Hope you have a nice time earning new technology here.

This is related to Database Design ?

This may help.