Data type correct for some records, not for others
hello~
i adding records table append query in access. column names , types same. however, when @ query results on web page (how outputting data), page displays older records present in table, not work new records append table. seems hanging on particular number field, practicetypeid, similar other fields in table come before it, , seem pulling fine! have attached error , query, big question is, why records work , others not? please help! thanks!
i adding records table append query in access. column names , types same. however, when @ query results on web page (how outputting data), page displays older records present in table, not work new records append table. seems hanging on particular number field, practicetypeid, similar other fields in table come before it, , seem pulling fine! have attached error , query, big question is, why records work , others not? please help! thanks!
semi star gazer wrote:
> have attached error , query, big question is,
> why records work , others not?
there number of potential problems queries.
1) "practicetypeid" column have value? empty or null values cause syntax error in second query.
2) column named "id" exists in both mentors , practicetype table. because using select mentors.*, (ie select columns), query results contain 2 columns same name: "id". may cause issues.
use column list instead, , eliminate duplicate column names using aliases. aliases let assign different name object within query.
select
mentors.id,
practicetype.id practicetypeid, <!--- use alias rename column "practicetypeid" --->
... other columns ...
from mentors,
internops_new,
practicetype,
practicearea
where
.... other conditions ...
3) query appears missing join conditions. there 4 (4) tables in clause 3 (3) conditions in clause. query may return many records. how tables related?
> getpracticeid
4) since retrieving "practicetypeid" in first query, purpose of "getpracticeid" query?
> have attached error , query, big question is,
> why records work , others not?
there number of potential problems queries.
1) "practicetypeid" column have value? empty or null values cause syntax error in second query.
2) column named "id" exists in both mentors , practicetype table. because using select mentors.*, (ie select columns), query results contain 2 columns same name: "id". may cause issues.
use column list instead, , eliminate duplicate column names using aliases. aliases let assign different name object within query.
select
mentors.id,
practicetype.id practicetypeid, <!--- use alias rename column "practicetypeid" --->
... other columns ...
from mentors,
internops_new,
practicetype,
practicearea
where
.... other conditions ...
3) query appears missing join conditions. there 4 (4) tables in clause 3 (3) conditions in clause. query may return many records. how tables related?
> getpracticeid
4) since retrieving "practicetypeid" in first query, purpose of "getpracticeid" query?
More discussions in Database Access
adobe
Comments
Post a Comment