insert records

hai can anybody help me? Table A --- name date a2000/12/12 b2000/12/12 c2000/12/12 d2000/12/12 now i want to take first 2 records from Table A and insert back to Table A with different date. The result should be:- Table A --- n

Re: integer&char problem

table test - +---+--+--+-+-+---+ | Field| Type| Null | Key | Default | Extra | +---+--+--+-+-+---+ | id_1 | char(3) | | | | | | id_2

integer&char problem

hai , i have a problem in query. My field type is integer. The table is empty and i want to select max number from the field but it display error message.Then i try to change the type to char ,it's can but, the max is until 9 only.is there anyone can help me. thanks in advance

DBASE query question.

hai In mysql it can be done but do anyone know how to join table in DBASE? The situation :- table 1 - EM_id EM_gender table 2 - EN_id EN_name The question is how to select all field from table1 and EN_name from table2 at one query? .The EM_id and EN_id is same.Is tha

integer & char

hai , i have a problem in query. My field type is integer. The table is empty and i want to select max number from the field but it display error message.Then i try to change the type to char ,it's can but, the max is until 9 only.is there anyone can help me. thanks in advance

DBASE question.

hai do anyone know how to join table in DBASE? The situation :- table 1 - EM_id EM_gender table 2 - EN_id EN_name The question is how to select all field from table1 and EN_name from table2 at one query? .The EM_id and EN_id is same.Is that any idea. please help me.