devxlogo

SQL and object reference in Fox Pro

SQL and object reference in Fox Pro

Question:
How can I can reference the value of an object to use in a select statement? My statment is being used in a Visual Fox Pro application, andso far looks like this:

select name from data where name like 'thisform.text1.value%'

This and 15 variations of it will not work. Is it even possible?

Answer:
The following works for me:

SELECT Name FROM data WHERE name LIKE ALLTRIM(thisform.text1.value)+"%" 
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist