I can't get to my notes now, but there were 3 or 4 tables. Req. Detail was one, Order Master was another. Basically they give you the procedures, but don't tell you which ones to use and in which sequence. If you get it going I would be interested. Maybe I missed something or can help you with...
We were using it for order entry. I could get it to update the SO Detail and SO Master, but it wouldn't touch any of the other tables required unless I specifically knew which ones to update. When they sold us on the module they said UPDATE would take care of all the details behind the scenes...
Thank you Mirtheil.
It has been frustrating trying to restore my links.
I would get the error sometimes and other times I would not.
I am changing my rebuild program to create a plain Jane "dummy" table with one field, delete the table to let Pervasive remove all the extra entries, then create...
I am 100 % sure they updated the files.ddf.
That is the only file I checked before I tried to add the tables.
I do not know about the FIELD.DDF or INDEX.DDF
I will have to put the original DDFs back and check to see. I know my add-on program could not find any of the tables after they...
I found a method create the table.
1. create table with PBID as INTEGER
2. delete table
3. create table with PBID as IDENTITY
Can anyone explain the reason.
When the MRP was updated, is it possible they left info in the index and field tables pointing to my added tables but did not have any...
The table does not exist yet. I'm creating the table now. The problem arises from the MRP database program. Every time they release an update, they issue new DFF files, which do not include the tables I have added for our addon programs we have written.
So I rebuild the DFF's to include my...
I am just starting to get into our company Pervasive DB. I've got VB6 experience, but my SQL knowledge is very basic.
The following SQL code worked 6 months ago when I had to add a couple of tables to our DB app after we did an update.
sql = "CREATE TABLE SalesShipInfo USING...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.