Error on export: Multi-valued field cannot be used in ORDER BY clause #61
Comments
|
I also had this issue and have implemented a change to support this. Essentially using the XML import/export approach. Changes are on https://github.com/hangie/msaccess-vcs-integration/tree/feature/import_data_update Have a look and if you like it, then I can go through the pull requests to get it integrated. |
|
I'll assume the merged change fixed this, let us know if it didn't! |
|
No, this one isn't closed until I send it back. The merge was on my repository - sorry. I'll add a pull request for this one shortly. |
effjot
added a commit
to effjot/msaccess-vcs-integration
that referenced
this issue
Sep 17, 2020
Should fix “all fields have short text data type” in issue msaccess-vcs-integration#61.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
It looks like it isn't exporting the multi-valued field data correctly.
I'm getting the error in
VCS_ExportTableDataon this line:Set rs = CurrentDb.OpenRecordset(TableExportSql(tbl_name))Stepping through, it looks like it is building the SQL query, but you can't order by a multi-value field.
The issue is specifically a value list - as in each option is just typed in row source.
Anyone know how to fix this?
The text was updated successfully, but these errors were encountered: