<div>
There's no way to do that directly in Pervasive. &nbsp;You'd need to write (or use) a program that could read the text file and fill in the variable value. &nbsp;
</div>


There's no way to do that directly in Pervasive.  You'd need to write (or use) a program that could read the text file and fill in the variable value.  

<div>
This is great thanks, yeah MySQL has a command for loading direct text files in this same way. This is great, thanks so much.
</div>


This is great thanks, yeah MySQL has a command for loading direct text files in this same way. This is great, thanks so much.

<div>
<div class="content wysiwyg-content">
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.<br />
<br />
Is there something like UPDATE table SET column = 'this' WHERE id = '@txt_file_here.txt'; <br />
<br />
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. 
</div>
</div>


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. 

Pervasive Looping through Variables

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.