Hi,
I receive a data service via subscription that is comprised of FoxPro databases so I have no capability to natively do anything with FoxPro to work with these databases but want to be able to interrogate the data in different ways than what the interface provides for me with the subscription.
Hence, I have ended up with Servoy as the possible solution for meeting my requirements.
There are a number of databases in the subscription and I have no knowledge of the data model so am needing to step through this slowly.
I have been able to connect to any of the databases ok but there is no PK in any of the dbs.
I have read that I need to establish one and Servoy has also thrown up the message saying the PK is missing.
As best as I can determine from the doco, google and some video tutorials I have come across I need to set the PK in the Row Ident column but when I click on that column I do not get an option for PK, only for row_indent ?
I thought I read somewhere else that you set the Row Ident column as Row Ident but if I do that then I get a message advising Row Identifiers should always not be null but the checkbox against that option will not let me check it off ?
Any help appreciated.
Peter