Reputation: 3 Apprentice
- Active Members
- Active Posts:
- 132 (0.05 per day)
- 19-November 08
- Profile Views:
- Last Active:
- Aug 18 2015 01:03 AM
- Dream Kudos:
Posts I've Made
Posted 11 Aug 2015Thanks Cal-cium and andrewsw for reply very much appreciated.
I will look into it for enhancement. What I did is that I create the design through code a lot of it and seems working as expected right now.
Posted 11 Dec 2014thanks for the reply,
I figured it out, seems working now. I just remove this code:
Dim Trans = con.BeginTransaction 'and Trans to sql statement. Trans.Dispose()
Here's the code:
Dim con As New MySqlConnection("server=" & server & ";database=" & database & ";user id=" & username & ";password=" & userpass & ";port=3306") con.Open() IdDate = MD5("01-0056" & crdate) Dim Cmd = New MySqlCommand("INSERT INTO local_attendance.employee_time_log (employee_id, log_date, keylog) SELECT * FROM (SELECT '01-0056' as empid, '" & crdate & "' as curdate, '" & IdDate & "' as keylogid) as tmp WHERE NOT EXISTS (SELECT keylog,employee_id,log_date FROM local_attendance.employee_time_log WHERE keylog = keylogid AND employee_id = empid AND log_date = curdate) LIMIT 1", con) Cmd.ExecuteNonQuery() Cmd.Dispose() con.Close()
Posted 8 Jun 2014Thanks for the reply guys..
Its working now...
Posted 28 Apr 2014yes,
error: Run-time error '3021' Either BOF or EOF is True, or the current record has beed deleted.
Request operation requires a current record.
Point to a = Empty
Posted 28 Apr 2014sorry for not discuss my problem more.
I have a comboBox with the fullname(firstname & lastname) value and I want to search using the data in my comboBox into my database. However, I don't have fullname datafield instead firstname and lastname datafield.
Now, my problem is how can search that?
I'm using MySQL database. I just trying to CONCAT it but not working.
- Member Title:
- D.I.C Head
- Age Unknown
- Birthday Unknown
kiad_198 hasn't added any friends yet.