Pervasive Looping through Variables
Posted on 2008-10-01
I'm questioning if there is a way in Pervasive to loop through a text file of a single record. Say for instance i have ID's in a txt file that i would like updated. I guess the best way to describe it is much like how you would loop through a txt file in a Windows Batch file.
Is there something like UPDATE table SET column = 'this' WHERE id = '@txt_file_here.txt';
It would then loop through how many records i have. I know i can inject it into a dummy database and run the update that way just trying to save a few steps.