I’m trying to extract data from a Fox pro database files, but this files have different names according the quarter of the year…., so I need to built a dynamic query to change the table(file) name depending of the current date.
I make some test using place holders in the table name in the query, using like a place holder the value of an string type tag (calculated) containing the table name , but the interface or the foxpro , I don’t know, take just the first character of the string, the same happens if I put the tables name In the tag descriptor and make the place holder to point to tag descriptor.
I feel that it is possible but I’m missing something in order to have the 8 characters of tables names.
This is an example of the query
“Select * from _1001007order by date_time asc;”
The exdesc would be
/SQL=“Select * from ? order by date_time asc;” P1=’calculated string tag’/VL
The error that I have is
“The table _.dbf doesn’t exist”
I assume that interface or foxpro is taking just the first character of the place holder
As far as your question is related to the RDBMS interface, I would like to invite you to contact our regular Tech Support to see if the interface is capable of supporting dynamic parameters. We would be happy to help you with your programming questions on vCampus
On a related note what direction your data is flowing? What are you trying to do?