I'm using the data environment designer. I used the SQL builder to generate an SQL that will return a record based on user-selected input (parameter) The SQL should do the following: My program has a global string variable called gloCurrProjNum. Based on which project number selected, the SQL should return the specific record. So far I have used:

SELECT * FROM project WHERE ProjNum = [gloCurrProjNum]

The SQL does not generate any records. What am I doing wrong? Any suggestions would be appreciated. Thanks in advance.