ANSWER.DB and Windows 10

We had to update to Windows 10 which required us to update from Paradox 8 to Paradox 11. There are a number of issues that seem to have surfaced. I am new to Paradox but understand programming. I have 2 questions at this point.

1) The program is unable to dynamically create the Answer.db from a query. The following query will only populate the Answer.DB table. It will not create it. From what I understand, when executing a query that stores it in the Answer.DB, it will recreate the Answer.db table. What am I missing?

qq=Query
ANSWER: :PRIV:ANSWER.DB

Invoice Line Items.DB | Invoice # | Type | Billing Attorney |
| | | |
| _join1 | _join2 | _join3 |

Invoice Line Items.DB | Payments |
| changeto 0 |
| changeto _paid |

:PRIV:Payment Summary by Line Item.DB | Invoice # | Type |
| _join1 | _join2 |

:PRIV:Payment Summary by Line Item.DB | Billing Attorney |
| _join3 |

:PRIV:Payment Summary by Line Item.DB | Previously Paid |
| _paid |

EndQuery

2) In Paradox 8 it would ask the user to validate the table structure and produce the necessary info. Now, if will work that once but fails to work after that. It generates a .val file and keeps the table from being updated. If I delete the .val file it will work one time. I can code deleting the .val file but this does not seem correct. Do you have any suggestions? What am I missing.

Thanks 

GT

1) this is a "changeto" query.. it is designed to modify a table, not create a table.. a simple query that does not insert, delete, or changeto, will create an answer table, or other designated table

2) the val file holds certain "validity check" information.. field formatting, lookup table, etc.. that's not ordinarily something you do on the fly.. if you are maing changes of that nature, you need to be sure you SHOULD be making changes of that nature

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

Steven.G, thanks for the reply.

While looking through the code there are various times that the program creates a new PRIV:Answer.DB. Most of them are just a query that produces data. But a few of them are like the "changeto" that I provided. 

Not sure how it all works if they are able to run one event that creates the Answer.DB from a standard query and then run another event that is looking for an Answer.DB with an established Table structure.

I am sure I am missing something on this but it seems like Paradox 9/10/11 has a few changes to how Tables work from version 8.

And of course, reviewing someone's old code that worked on an old version has it's own limitations and challenges. 

yes, separate processes could create, then modify, an Answer table.. but honestly, if the app is written that poorly, you'll go around in circles trying to understand it

as for your "changes in how tables work" comment.. no, absolutely not.. over the years, field types have been added, and index functionality has been enhanced.. but the basic functions go all the way back to the beginning

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN