adc@tardis.cl.msu.edu (Alan D. Cabrera) (06/27/91)
I'm using APT 4.0.2 and am having trouble using it find entries in my database.
The two key fields in my table are varchar(5) and typically look like:
bldg room
----- -----
035 208
Note the blank space in front of the "035". In an APT SQL proc, the following
piece of code sets flag to zero.
submit
sqlbegin
select flag = (select count(*)
from inventory
where bldg = {sqlexpr(bldg)} and
room = {sqlexpr(room)})
sqlend
I know that the entry is in there. The bldg entry field in my APT form
is set to " 035" and the room field to "208"; " 035 " does not work either.
What could I be doing wrong?
--
Alan Cabrera internet: adc@tardis.cl.msu.edu
Michigan State University phone: (517) 353-3027
514a Computer Center fax: (517) 353-9847
East Lansing, MI 48824 bitnet: CABRERA@MSU