Finding Age (Year, Month, Day) with Microsoft Excel

To find the age quickly with Microsoft Excel
DATEDIF can use the function (), for example:

the date format in English:

A5=05/20/1970
B5=DATEDIF(A5,TODAY(),"y")&" years "&DATEDIF(A5,TODAY(),"ym")&" months "&DATEDIF(A5,TODAY(),"md")&" days"

Result: (if today=10/30/2008)
38 years 5 months 10 days

Make a Connection function the MySQL database with Visual FoxPro (vfp001)

First create a table to save the settings to connect the MySQL database.

CREATE table setmysql.sys free ;
 (port c(4), server c(50),uid c(50), psw c(50), database c(50))

Notes:
port -> port to connection
server -> Server MySQL
uid -> User ID
psw -> password
database -> nama database

then fill the table with the following :

INSERT INTO setmysql ;
  (port,server,uid,psw,database) VALUES ;
  ("3306","localhost","root","123","coba")

The charging of data servers, uid, psw and the database can be adjusted with mysql database settings on your computer.

to make the step connections are:

*=====================
FUNCTION mysql_connect
*=====================
LOCAL aport,aserver,auid,apsw,adatabase
LOCAL cstr,aconnect

IF USED("setmysql")
   use in setmysql
ENDIF
USE setmysql.sys in 0 alias setmysql shared

aport=alltrim(setmysql.port)
aserver=alltrim(setmysql.server)
auid=alltrim(setmysql.uid)
apsw=alltrim(setmysql.psw)
adatabase=alltrim(setmysql.database)

cstr="DATABASE="+adatabase+";"+;
     "SERVER="+aserver+";"+;
     "port="+aport+";"+;
     "UID="+auid+";"+;
     "pwd="+apsw+";"+;
     "provider=MSDASQLR;DRIVER={MySQL ODBC 3.51 Driver};"
STORE SQLSTRINGCONNECT(cstr) TO aconnect

use in setmysql
RETURN aconnect

* main
if mysql_connect()<=0
   =messagebox("Connection Failed..!",16,"Error Detection")
else
   =messagebox("Connection Success..!",64,"Information")
endif

UNDO / REDO (Case Security and Recovery Database)

there are tree tables.

master_stock(stockcode {pk}, name, qty, sprice, bprice);

master_tran(trannum {pk}, trdate, note);

master_list(trannum {pk}, stockcode {fk}, qty, sprice);

TRANNUM field in the table used as MASTER_TRAN code transactions that occur in accordance with the date and serial transaction example: 20081014001, 20081014002 ... etc. (charging TRANNUM so here are affected in date of the occurrence of the transaction, the transaction serial number on the day)

(parent transaction information)

master_list while the table is used to record details transactions that occur in accordance with the transaction number (TRANNUM) MASTER_TRAN on the table.

Logically:

- A number based on the transaction MASTER_TRAN table (take appropriate filter records last date) then add the number 1) example: if the last record is 20081014050 (OLD), so that a new course record 20081014051 (NEW).

- And write new data MASTER_LIST based on the code.

=========================

The process in computer A

=========================

T1: create a number of Transaction (completed / commit) time required T1, T2, T3 (the number is obtained 20081014050)

T2: record list of goods, the time needed T4, T5, t6, t7, t8, T9, t10, t11, t12, t13, t14

==========================

The Proces in computer B

==========================

T1: create a transaction number (completed / commit) time needed T4, T5, t6 (a number that is obtained 20081014051)

T2: record list of goods, the time needed is t7, t8 (commit)

From the two processes occur if the computer T_crashes or T_checkpoint in t9 time which must UNDO and Redo?

PHP & MySQL Free hosting and subdomain (really free)

Information that you want to create a free site (PHP and MySQL) you can use the following address http://www.10gbfreehost.com/.It also provides access to FTP. Free Web Hosting Features
- 20GB Bandwidth!
- 10GB Space!
- PHP / MYSQL Support
- FTP Access!
- Free Signup!
better to try.

Wellcome to Software Engineering Course

This blog aims to discuss issues surrounding the software engineering and Information Technology.Microsoft Visual Foxpro, Microsoft Visual Basic, PHP and MySQL, Data Warehouse, Data Mining, Oracle and a variety of programming languages core discussion in this blog. You will also get a short course on some programming languages starting from primary level up to the advanced level.Of course, I hope your involvement to enter or to share knowledge Asked about this software engineering. Some articles and the main criticism I take from the various sources from the internet or the library. If you are interested in the development plan of this blog, please contact or email to me.