Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

VCS 4.0.34: When a Table is deleted from the database, a *.SQL file remains in the source folder #536

Open
arpm-awv opened this issue Oct 4, 2024 · 3 comments

Comments

@arpm-awv
Copy link

arpm-awv commented Oct 4, 2024

After a table is deleted, and the database is exported, the *.XML file is removed from the tbldefs folder, but the *.SQL file remains.
I'm finding orphaned *.SQL files in my source code.
image
image

@joyfullservice
Copy link
Owner

Thanks for reporting this! I can reproduce the issue as well.

joyfullservice added a commit that referenced this issue Oct 4, 2024
Include *.sql in the list of extensions related to TableDef objects. Fixes #536
@joyfullservice
Copy link
Owner

This should be fixed in the next update. You can build from the dev branch, or hotfix your version to resolve this in your project. Thanks again for the bug report!

josef-poetzl added a commit to josef-poetzl/msaccess-vcs-addin that referenced this issue Oct 8, 2024
* Avoid redundant scans for legacy source files

 These calls only need to be run during a full export. Definitely not repeated for each object exported. We may do some further cleanup later as some of these legacy files are far enough removed from the current version that the checks are probably no longer needed. See joyfullservice#527

* Improve performance on get relations QuickCount

When working over a VPN on a database with linked tables, DCount was significantly faster in quickly getting a count of relationships, cutting down overall export (scan) time significantly.

* Fix incompatible Access SQL data type

Fixes joyfullservice#533

* Remove orphaned TableDef *.sql files

Include *.sql in the list of extensions related to TableDef objects. Fixes joyfullservice#536

---------

Co-authored-by: joyfullservice <[email protected]>
@hecon5
Copy link
Contributor

hecon5 commented Oct 10, 2024

Related to #366 (leftover crud).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants