Right and dbCreate doesn't complain!
Serge
"Workarea not in use" Error
Moderator: Rathinagiri
- serge_girard
- Posts: 3176
- Joined: Sun Nov 25, 2012 2:44 pm
- DBs Used: 1 MySQL - MariaDB
2 DBF - Location: Belgium
- Contact:
Re: "Workarea not in use" Error
There's nothing you can do that can't be done...
Re: "Workarea not in use" Error
The idea of a corrupt DBF file is possible I think. Also I may have been trying to open it as NEW more than once. The LIBRARY database was created from another database file and then some fields removed as unnecessary for this new application. I'll try and create the LIBRARY.dbf file using a program instead of "hacking " into it manually. Then I'll run the REINDEX option to create the 5 Indexes that I need.
Back to the drawing board!
Thanks again guys.
Alan
Back to the drawing board!
Thanks again guys.
Alan
- serge_girard
- Posts: 3176
- Joined: Sun Nov 25, 2012 2:44 pm
- DBs Used: 1 MySQL - MariaDB
2 DBF - Location: Belgium
- Contact:
Re: "Workarea not in use" Error
Thanks for all your help on this one everyone. I recreated the database structure and copied the relevant tracks from another database into this one. I'm pleased with myself that it was successful! I am not receiving the workarea error any more.
Alan
Alan
Re: "Workarea not in use" Error
Hi friends,
now I am retired.
My app is functionally working, and I am adding some "service-progs" like "change of year", "saving data", "deleting or adding records", "reports" and on and on.
Today I was faced with the runtime error "workarea not in use".
From the main menu I call a prg-file and my first command was "use" to close all open files, then "OpenDbs" because of the RTE, but to no avail.
So I changed the command "use" to "close databases" and everything was ok.
So there is a difference between "use" and "close databases"? I did not know that (took me about one hour to solve the problem )
Maybe helpful for other newbies?
Robert
now I am retired.
My app is functionally working, and I am adding some "service-progs" like "change of year", "saving data", "deleting or adding records", "reports" and on and on.
Today I was faced with the runtime error "workarea not in use".
From the main menu I call a prg-file and my first command was "use" to close all open files, then "OpenDbs" because of the RTE, but to no avail.
So I changed the command "use" to "close databases" and everything was ok.
So there is a difference between "use" and "close databases"? I did not know that (took me about one hour to solve the problem )
Maybe helpful for other newbies?
Robert
Re: "Workarea not in use" Error
Hi Robros,
I think "use" close only the last used dbf
I think "use" close only the last used dbf
Best Regards,
Nikos.
os: Windows Server 2019 - 64
Nikos.
os: Windows Server 2019 - 64
Re: "Workarea not in use" Error
Hi Nikos,
That is what I found:
https://www.itlnet.net/programming/prog ... 41e96.html
So, you are right
Best Regards
Robert
That is what I found:
https://www.itlnet.net/programming/prog ... 41e96.html
So, you are right
Best Regards
Robert