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)+"%" 
Share the Post:
data observability

Data Observability Explained

Data is the lifeblood of any successful business, as it is the driving force behind critical decision-making, insight generation, and strategic development. However, due to its intricate nature, ensuring the

Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular