Field List Sort Order

In PHPRunner, the order of the fields in the Field List can sometimes differ from the order defined in the SQL query, especially after making changes to the database structure or the PHPRunner project. Unfortunately, there isn't a direct way to manually reorder the Field List in PHPRunner's interface. However, here are a few tips that might help you achieve the desired order without losing your work:

1. Field Order in SQL Table: Ensure that the fields in your SQL table are in the desired order. This can sometimes influence how they appear in PHPRunner, although it primarily depends on the query settings.

   
   

2. Recreate the Query: Instead of unlinking and relinking the entire table, you can create a new query in PHPRunner with the fields in the desired order. Once you have the new query set up, you can modify your forms to use this query instead.

   
   

3. Modify the Existing Query: In the Query Fields dialog, ensure that you have the fields in the order you want and save the changes. This may help align the Field List to some extent, although it may not fully reflect the order you desire.

   
   

4. Backup Your Project: Before making any significant changes, always back up your PHPRunner project. This way, if anything goes wrong, you can restore your work easily.

   
   

5. Contact Support: If the ordering of fields is critical for your project, consider reaching out to PHPRunner support. They may have insights or updates regarding field ordering in the latest versions.

   
   

6. Future Versions: Keep an eye out for updates or newer versions of PHPRunner that may address this issue more directly, as user feedback often drives improvements in software features.

   
   

While these suggestions might not provide a direct solution to reorder the Field List, they could help you manage your project effectively without risking your existing work.