Revisions to Creating stable user Interface in MapBasic?

added 1 character in body

Source Link

edited Aug 24, 2014 at 8:13

Add this to your code instead your 'Select' line

Dim sqlcom as string

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

Add this to your code instead your 'Select' line

Dim sqlcom as string

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

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

added missing quotes in statement

Source Link

edited Aug 22, 2014 at 6:18

Add this to your code instead your 'Select' line

Dim sqlcom as string

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

Add this to your code instead your 'Select' line

Dim sqlcom as string

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

Add this to your code instead your 'Select' line

Dim sqlcom as string

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

added 27 characters in body

Source Link

edited Aug 21, 2014 at 19:56

Add this to your code instead your 'Select' line

Dim sqlcom as string

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

Add this to your code

Dim sqlcom as string

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

Add this to your code instead your 'Select' line

Dim sqlcom as string

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

Source Link

created Aug 21, 2014 at 19:46

Loading

Return to Answer