New to Sybase and PowerBuilder.

[mary1]

Hello,<br>I am new to sybase and powerbuilder. I have created a simple database with only one table in sybase SQL Anywhere and am using powerbuilder to run my program. i have written the code(under the click event) below to display results in the text boxes. The problem is nothing is displayed when i click the command button. I'm not sure what is wrong. Someone please provide me with some feedback.<br><br>string firstname_var<br>string surname_var<br>Integer age_var<br><br>firstname_var = sle_firstname.text<br>surname_var = sle_surname.text<br>age_var = integer(sle_age.text)<br><br>SELECT firstname, age , surname<br>INTO :firstname_var, :age_var, :surname_var<br>FROM employees WHERE surname = :surname_var;

 

[dkvin]

Hi!<br>It must be<br><FONT FACE=monospace><br>string firstname_var<br>string surname_var<br>Integer age_var<br><br>SELECT firstname, age , surname<br>INTO :firstname_var, :age_var, :surname_var<br>FROM employees WHERE surname = :surname_var; <br><br>sle_firstname.text = firstname_var <br>sle_surname.text = surname_var<br>sle_age.text = string(age_var)<br></font><br>