Creating stable user Interface in MapBasic?

Question

I am trying to have a user enter values via an interface and continue to run the program but the following line (Select...) fails to work most of the time as part of the program (although it works fine when you entered in a MapBasic window).

Dim Lat As Float
Dim Lon As Float
Dim sIDENT As String
Dim sValue As String

Control StaticText
  Position 150,50
  Title "Enter ID ?"

Control EditText
  Position 150,70
  Width 50 Height 15
  ID 99
  Value " " ' default value
  Into sValue

Select Lon, Lat from TableA where sIDENT = sValue into Querry

Answer 1

You appear to have two float variables named Lon and Lat as well as selecting the same names as columns in your SQL select. Change your variable names and that should resolve the problem.

Answer 2

Add this to your code instead your 'Select' line

Dim sqlcom as string

sqlcom = "Select Lon, Lat from TableA where sIDENT = """ + sValue + """ into Query"
run command sqlcom

Answer 3

Actually I realize that the programme was causing me problems because I needed to define the svalue variable as a fixed length variable string.

Dim sValue As String *5 (for example a length 5 string)

Otherwise the selection process in the Table would not grant me a value all the time roughly only 1 out of 10 times.