This is probably a really stupid question . Mainly because I know NOTHING about SQL
I'm trying to determine exactly what forms are available in a sql database. I dont know how to open the database, but some programing has been written that recovers some records from the database. Is there a way I can modify the s= statement below, that will list out all forms in the database.
s = "SELECT unit.unt_tagnum, ""group"".grp_meanavg, ""group"".grp_stdavg, " & _
"unit.unt_x, unit.unt_y, unit.unt_zz, ""group"".grp_stopdt, ""group"".grp_npieces, material.mtl_name " & _
"FROM unit, ""group"", ""load"", material WHERE material.mtl_pk = ""group"".grp_mtlfk AND " & _
"unit.unt_grpfk = ""group"".grp_pk AND ""group"".grp_lodfk = ""load"".lod_grpfk " & _
"AND ""load"".lod_num = '" & loadname & "' AND ""load"".lod_date = " & loddate & _
" AND ""load"".lod_pk = '" & loadPK & "'ORDER BY unit.unt_tagnum"
I'm trying to determine exactly what forms are available in a sql database. I dont know how to open the database, but some programing has been written that recovers some records from the database. Is there a way I can modify the s= statement below, that will list out all forms in the database.
s = "SELECT unit.unt_tagnum, ""group"".grp_meanavg, ""group"".grp_stdavg, " & _
"unit.unt_x, unit.unt_y, unit.unt_zz, ""group"".grp_stopdt, ""group"".grp_npieces, material.mtl_name " & _
"FROM unit, ""group"", ""load"", material WHERE material.mtl_pk = ""group"".grp_mtlfk AND " & _
"unit.unt_grpfk = ""group"".grp_pk AND ""group"".grp_lodfk = ""load"".lod_grpfk " & _
"AND ""load"".lod_num = '" & loadname & "' AND ""load"".lod_date = " & loddate & _
" AND ""load"".lod_pk = '" & loadPK & "'ORDER BY unit.unt_tagnum"