- Messages
- 206
- Reaction score
- 0
- Points
- 26
mga sir pahelp sa pos system ko. vb6+ access sya dati tpos nag transfer ako sa sql. my konting error sa ordering form. nag manual insert ako ng 1 data sa bawat table para my mabasa sya pero current data deleted padin. baka po pwede pahelp
sa access database is okay naman po. d2 lang sa mysql nageerror
error po ung naka commentDo While Not rs.EOF
.ListItems.Add , , rs![productID]
Set rs1 = New Recordset
rs1.Open "select * from tblcategory where categoryID=" & rs!categoryID, con, adOpenStatic, adLockOptimistic
.ListItems.Item(.ListItems.Count).ListSubItems.Add , , rs1![category]
.ListItems.Item(.ListItems.Count).ListSubItems.Add , , rs![ProductName]
Set rs2 = New Recordset
rs2.Open "select * from tblprice where price=" & rs!sellingprice, con, adOpenStatic, adLockOptimistic
' .ListItems.Item(.ListItems.Count).ListSubItems.Add , , rs2![price]
rs.MoveNext
Loop
sa access database is okay naman po. d2 lang sa mysql nageerror
Last edited: