Posts by debasisdas

Is that a web application and designed to run using a Browser ?

1st one is conventional style SQL.
2nd is as per ANSI SQL.

Timestamp will capture the exact time when the record was changed for each record.

You need to store the password in the connection string itself.

Please find more on connectionstring.

try something like this

select e.first_name
from employees e, goods g, orders o
where e.id = o.employee_id
and g.id = o.item_id

you need to modify this to suit your requirement.

Why not try using JOIN .

Join all the three tables and retrieve the data

no, i was asking about the table structures and their relations.

It is better to write a procedural block.

what is the relation between the tables ?

what exactly you are trying to do ?

CASE executes faster.

DECODE works with expressions which are scalar values.

CASE can work with predicates and subqueries in searchable form:

CASE handles NULL values differently

Seems you have to specify values when using RANGE. If one uses HASH then you don't need to specify values.

Exactly, that is how partition works.

Things becomes more challenging once you decide to you composite partition.
i.e.-- different types of partition logic on a single table.

client server inventory management system

client server inventory control system

after wards you need to divide the number by 1024 to get in Kilo Bytes and again by 1024 to get in MB.
continue the same for GB as well.

the following is a sample of range partition.

CREATE TABLE test_range (
  test_id INT AUTO_INCREMENT PRIMARY KEY,
  test_date DATE
) ENGINE = MYISAM
  PARTITION BY RANGE(test_id) (
    PARTITION p0 VALUES LESS THAN(10000),
    PARTITION p1 VALUES LESS THAN(20000),
    PARTITION p2 VALUES LESS THAN(30000),
    PARTITION p3 VALUES LESS THAN(40000),
    PARTITION p4 VALUES LESS THAN(50000)
);

Please read more about table partition here, here and here.

On which event you are calling EnableChoice ?

I think i have already provided that in the previous thread.

Just check my 2nd post on that thread. :)

ohh.....

if you do not understand the question itself how will you get the solution ?

and you should not try to offend those who try to help you.

You have been supplied with enough logic by way of sample code.

Now its time for you to show effort.

Try to code the logic that you want to implement and post the code here.

try this .

If GetServerDateTime() < (Format(Now.AddMinutes(-2), "MM/dd/yyyy hh:mm:ss tt")) Then
msgbox ("Invalid datetime")
end if

You may need to format it a bit.

i didn't get that. :confused:

You need to follow this discussion.

You need to subtract 2 minutes from the time and then compare.

You want to display an entire PDF file in a picture box ?

Yes it is.

please try this sample.

SaveSetting Your_Application_name.EXE, "textboxes", "text1", text1.Text
or
SaveSetting(App.EXEName, "Textboxes\frmMain", "Text1", frmMain.Text1.Text)

1. Why not change the function signature and make it to return DECIMAL.
or
2. Convert the value (after all your calculation) into string before returning.

Please read more here.

Hi Jito.

Welcome to Daniweb.

We all learn here.

No need to store data in HH, MM, SS columns.

These can be calculated at run time using the previous solution.

Lets see your code .

1. Need to ensure there is INDEX on search columns
2. Need to disable INDEX during data loading operation, and enable later on.
3. Need to check the SQL, may need to tuned.
4. Need to check for Hardware.
5. Need to check how loaded is your network.
6. May need to use caching from application side.

and few more...

try this sample SQL

INSERT INTO tbl_temp2 (fld_id)
  SELECT tbl_temp1.fld_order_id
  FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100;

try this

SELECT f.FranchiseName INTO @FranciseName 
FROM franchise f , mytable m 
WHERE f.username=@username
and f.franchiseid = m.franchiseid

CheckState.Unchecked is not about the individual items.

what is your table name ?

franchise
or
MyTable

@saddas
if you use rs.MoveLast

you will always get only one (the last) record.

Yes i know for sure.

try the following

SELECT FranchiseName INTO @FranciseId FROM franchise WHERE username=@username

have you added composite key on column A and B ?

Just to test try using.

iif() or Switch() functions.

For that you need to know how to code in both PHP and MySQL.

Please find more about connection string .

What about using a grid instead.

try this

If dr(DbaseExpiryDate) > Format(Now, "MM/DD/YYYYyyyy") Then

Is it because of the single quote.

Just frame and print the query before executing, it will be easy to trace the error.

Happy to learn that your problem is sorted out.

Happy Coding :)

1. You need to pass more information.
2. Yes.

So you mean to say what ever you enter in text boxes needs to be added into list view, right ?

and i think after 80 posts, you should understand that you need to show some effort to get any help here.

You do not know the difference between VB 6 and dot net code and claim this code is yours.

@Debasidas, its the code of AndreRet man!

Now see the attitude.

Im using Visual Basic not VB.net. well whats the difference by the way lol?......and already an assignment...

Ohh,

may be i took too long to type the previous post.

and see what the OP has.

he nicely made the expert do his assignment

and the 1st line of code confirms he has copied it from some where is not his own code.