- Messages
- 189
- Reaction score
- 0
- Points
- 26
eto po yung picture,, SQL po toView attachment 139563
Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.
All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!
eto po yung picture,, SQL po toView attachment 802208
eto po yung picture,, SQL po toView attachment 802208
eto po yung picture,, SQL po toView attachment 802208
Private Sub Command1_Click()
connect
sql = "tblreturn"
Set rs = New ADODB.Recordset
rs.Open sql, cn, adOpenDynamic, adLockOptimistic
With rs
.AddNew
!Return_Id = txtreturnid.Text
!Video_ID = Label6.Caption
!Customer_Id = Label4.Caption
!Penalty = Label14.Caption
!Date_Returned = Label1.Caption
.Update
End With
MsgBox "Video successfully returned..", vbInformation, "Success"
Text1.Text = ""
Set rs = New ADODB.Recordset
sql = "SELECT * FROM tblrent WHERE Clng (Rent_id)='" & CLng(txtrentid.Text) & "'"
rs.Open sql, cn, adOpenDynamic, adLockOptimistic
If Not rs.EOF Then
With rs
.Delete
End With
'Set rs = New ADODB.Recordset
' sql = select * from vc where Clng (NoOfCopies)='" & CLng(txtrentid.Text) & "'"
Call GetRentVideos
lblTotalAmount.Caption = "0.00"
Label14.Caption = "0.00"
Label10.Caption = "0.00"
Label12.Caption = ""
Label4.Caption = ""
Label6.Caption = ""
Label8.Caption = ""
End If
Set rs = New ADODB.Recordset
sql = "SELECT Return_Id FROM tblreturn"
rs.Open sql, cn, adOpenDynamic, adLockOptimistic
If Not rs.EOF Then
With rs
.MoveLast
txtreturnid.Text = !Return_Id + Val(1)
.CLose
End With
End If
End Sub
pa help po odbc driver not suported dun sa my clng ung eror
Help po sa
MSHFLEXGRID...
yung kapag click mo sa row ng Mhflexgrid lalabas yung info sa Txtbox
http://www.symbianize.com/showthread.php?t=1062476
You sure about this code?:
sql = "tblreturn"
Set rs = New ADODB.Recordset
rs.Open sql, cn, adOpenDynamic, adLockOptimistic
Or do you mean?:
sql = "SELECT * FROM tblreturn"
Tapos ung sa may clng, wag u na gamitin ung clng. Naguluhan lng me d2:
sql = "SELECT * FROM tblrent WHERE Clng (Rent_id)='" & CLng(txtrentid.Text) & "'"
Text ba ung Rent_id kaya gumamit u ng quotes? Kc kung string un, hindi u na need i-convert sa long. Pero kung long na un, hindi na kailangan ng clng. Diretso ganito na (pag long ung data type):
sql = "SELECT * FROM tblrent WHERE Rent_id=" & txtrentid.Text
Pag string naman, ganito:
sql = "SELECT * FROM tblrent WHERE Rent_id='" & txtrentid.Text & "'"
pa help po pwede ba ung mangyayari kapag nag rent ng video ang isang customer tpos humiram ng limang piraso (same title bali quantitiy ung hiniram nya ) tpos pag isososli nya na pipili sya kung ilan ang isososli nya kapag 3 sinoli nya di mabubura sa db rent ung name nya pero mag maminus ung quantity ni sinoli nya then ung 3 mag-aadd ulit sa video quantity no.
Pwedeng-pwede un bro. Sa ganitong kaso, maraming pwedeng approach. Pwedeng i-track u ung quantity ng item, meaning nire-record u ung quantity ng nahiram na item (video in this case). Parang ganito:
Video Table:
ID Title Total_Quantity Rented_Quantity
1 The Avengers 10 3
Ang problem sa ganitong approach e mabusisi pa ung pag-track ng quantity ng bawat item.
Or kung ako ang gagawa ng system, ang gagawin ko e iti-treat ko ang bawat item as individual item, meaning hindi ko ita-track or lalagyan ng quantity ung mga items. So regardless na kahit pare-parehas or kahit iba-iba ung item na ni-rent, alam ko lagi kung ilan ang nasa hiraman pa at ilan ung naisoli na. Parang ganito:
Video Table:
VideoID Title Status
1 The Avengers Rented/Available
2 The Avengers Rented/Available
User Table:
UserID Name
1 Juan Dela Cruz
Rent Table:
RentID VideoID UserID RentStatus
1 1 1 Active/Returned
2 2 1 Active/Returned
Kaya pag nag-query ako, pwede ko alamin kung ilang The Avengers pa na ang status e Rented. Tapos pwede kong i-query kung anu-anong items ang na-rent ng specific user na Active pa (or hindi pa naisosoli). Para sa akin, ganitong approach ang madali.
my sample code po kau khit simple lng mysql database po xampp software
Nag-attach me ng very simple sample project. Paki-palitan na lng ung database kc ginawa ko sa ms access (madalian kc).
nagawa q na po to bali po ang kulang sa akin kapag kinilick ung return boton ung quantity ng dvd mag-aadd ulit sa database
ganto po example: tablevideo dito nakalagay ung mga video title at kung ilan example may limang the conjuring tpos pag nag rent si costumer ng isa mag mamaminus po ung quantity then pag isossoli nya na magiging lima po ulit
Hindi ko alam kung anong approach ang ginamit u. Pwedeng pa-post na lang ng project u? Baka matulungan ka na idebug ung project u.
Sa tingin ko e mukhang ung mas mabusising approach ang ginamit u base dun sa sinabi u na nakalagay sa video table ung title at quantity.