nilagay ko ung jo_backup ibinase ko po sa sample w3schools.com
nagdisplay na sya ng record sa listview. pero customer lang ang andun sa listview wala ang proj_date
solve na po itong problem na ito.
pag-aralan ko na lang ang ibang codes para dito
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!
nilagay ko ung jo_backup ibinase ko po sa sample w3schools.com
nagdisplay na sya ng record sa listview. pero customer lang ang andun sa listview wala ang proj_date
sSQL = "SELECT tblJO.Proj_ID,tblJO.proj_date,tblCustomers.Customer_Name from tblJO INNER JOIN tblCustomers on tblJO.Customer_ID=tblCustomers.Customer_ID order by tbljo.proj_date"
mga bossing ngayon ko lang ginamit ang code na ito. possible bang sa isang query dalawa ang INNER JOIN?
SALAMAT
sir pahelp naman po ulit bakit po ganito ung lumalabas na prompt error sakin pag niclick ko na po ung add button.. Empty row cannot be inserted. Row must have at least one column value set. ito po yung code ko..
sir help naman po ulit dami kong tanong hehe sana po hindi kayo magsawang sumagot salamat po..about po dito sa SS ko kasi pag hindi ako nagtype ng date den click ko na yun Add button yan yung lumalabas na error po pano po ba iresolve yan. in advance
mga sir pa help naman may error po ako na encounter dito sa codes. im using sql INNER JOIN TO DISPLAY RECORD IN LISTVIEW.
Private Sub Form_Load()
sSQL = "SELECT tblJO.proj_date,tblcustomers.customer_name into jo_backup from tbljo INNER JOIN tblcustomers on tblJO.Customer_ID=tblCustomers.Customer_ID"
Call PopulateListView(Me, sSQL)
End Sub
Sub PopulateListView(frm As Form, sSQL As String)
Dim sConn As New ADODB.Connection
Dim rsADO As New ADODB.Recordset
Dim xList As ListItem
Dim iCol As Long
sConn.Open gstrConnectionString
frm.lvwViewer.ListItems.Clear
If sConn.State = adStateOpen Then
rsADO.Open sSQL, sConn, adOpenForwardOnly
*** rsADO.MoveFirst - DITO PO ANG ERROR NYA
frm.lvwViewer.ColumnHeaders.Clear
'For iCol = 0 To rsADO.Fields.Count - 1
'frm.lvwViewer.ColumnHeaders.Add , , "", 0
frm.lvwViewer.ColumnHeaders.Add , , rsADO.Fields(1).Name, 3000
'Next
Do While Not rsADO.EOF
Set xList = frm.lvwViewer.ListItems.Add(, , rsADO.Fields(1))
'xList.SubItems(1) = rsADO.Fields(1)
xList.Tag = rsADO.Fields(0)
rsADO.MoveNext
' DoEvents
Loop
Else
'Err.Raise vbObjectError + 513, ERR_CAN_NOT_OPEN_CONNECTION
End If
Set rsADO = Nothing
sConn.Close
Set sConn = Nothing
End Sub
*** RUN-TIME ERROR "3704" OPERATION IS NOT ALLOWED WHEN THE OBJECT IS CLOSED.
wala ka kasing
Set rsADO as New ADODB.Recordset
lagay mo ito bago ka mag:
rsADO.Open sSQL, sConn
pwede yan pero bakit di mo i-try i-run ?
ito ibig kong sabihin pero may error dito sa code ko na ito
sSql = "SELECT tblJO.Proj_ID,tblJO.proj_date,tblCustomers.Customer_Name,tbljo.jo_no from tblJO INNER JOIN tblCustomers on tblJO.Customer_ID=tblCustomers.Customer_ID,tbljo.proc_ID from tblJO INNER JOIN tblproc on tblJO.proc_ID=tblproc.proc_ID order by tbljo.proj_date"
tinatry ko ang possibilities kung gagana ang code na mga naiisip ko.
paano nga po. ang tanong ko po kung pwede sa isang query dalawang inner join...
paano ang code. sana kung magcocomment ung tiyak kang makakatulong ang comment mo, hindi po iyong try mo or pwede yan.
salamat
di kasi malinaw post mo eh, di mo sinabi kung saan mo nira run, sa sql server ba or sa access. may pinagkaiba ang select statement ng access sa sql server. saka wala ka naman na-mention sa una mong tanong na nage-error pala yung query mo. sige heto na wag ka na umiyak
"SELECT A.Proj_ID,A.proj_date,B.Customer_Name,A.jo_no from ((tblJO as A INNER JOIN tblCustomers as B on A.Customer_ID=B.Customer_ID,A.proc_ID) INNER JOIN tblproc as C on A.proc_ID=C.proc_ID) order by A.proj_date"
hahaha. salamat
wala ka kasing
Set rsADO as New ADODB.Recordset
lagay mo ito bago ka mag:
rsADO.Open sSQL, sConn
Run-time error -2147217900. Syntax error in JOIN operation bossing ung query mo. sa Access po ito.
Nested INNER JOINS, yup pwede, nandito and mga samples....
http://office.microsoft.com/en-us/access-help/inner-join-operation-HA001231487.aspx
Remove AS keywords
"SELECT A.Proj_ID,A.proj_date,B.Customer_Name,A.jo_no from ((tblJO A INNER JOIN tblCustomers B on A.Customer_ID=B.Customer_ID,A.proc_ID) INNER JOIN tblproc C on A.proc_ID=C.proc_ID) order by A.proj_date DESC"
dun sa PupulateListView na Procedure, isang fields lang po ang ipapakita nun sa ListView.
So, need mo mag-create nang new procedure
para i-populate ang listview with all the fields and records.
nakuha ko na din kung paano iyong code. nakakita lang ako sa internet. then iniapply ko
here's the code
sSql = "SELECT tbljo.proj_id,tbljo.proj_date,tblcustomers.customer_name,tbljo.jo_no,tblproc.proc_code FROM ((tbljo INNER JOIN tblcustomers ON tbljo.customer_ID=tblcustomers.customer_id) INNER JOIN tblproc ON tbljo.proc_ID=tblproc.proc_id) ORDER BY tbljo.proj_date"
nakuha ko na din kung paano iyong code. nakakita lang ako sa internet. then iniapply ko
here's the code
sSql = "SELECT tbljo.proj_id,tbljo.proj_date,tblcustomers.customer_name,tbljo.jo_no,tblproc.proc_code FROM ((tbljo INNER JOIN tblcustomers ON tbljo.customer_ID=tblcustomers.customer_id) INNER JOIN tblproc ON tbljo.proc_ID=tblproc.proc_id) ORDER BY tbljo.proj_date"