Messages

1

General Board / How to generate Table version in generated DDL?

« on: April 12, 2019, 11:34:21 pm »

This should be a simple problem for the Sparx experts.

I want to record the Table version in a comment in the DDL. I've modified the DDL generation template but cant find the appropriate property to inject the table version.

Code: [Select]

$start = "/*"
$end = "*/"
$start  Table Owner : %tableProperty:"Owner"%  $end
$start  Table Version : %tableProperty:"Version"%  $end
Could someone give me the magic name to get the Table version out in the DDL generation.

Many thanks - Gareth

2

Bugs and Issues / Re: New MariaDB error when setting up a new Repo.

« on: May 11, 2018, 04:00:39 pm »

Many thanks yes I ended up using 5.3.10 (mysql-connector-odbc-5.3.10-win32.msi) as that was what I could download and that worked a treat.

I've not tried 8 (Connector/ODBC 8.0.11), but I'll update the community with the results for completeness.

3

Bugs and Issues / New MariaDB error when setting up a new Repo.

« on: May 09, 2018, 09:12:02 pm »

Looking for some guidance as this is the first time I've attempted to setup a remote DB for sharing a project. I've got:

- MariaDB instance (10.1.32) - Loaded with EASchema_1220_MySQL.sql - updated the zero timestamps with NOW()
- MariaDB 32 bit driver 3.0.3 - Set "Enable automatic Reconnect" & "Return matched rows instead of affected rows"
- Sparx 14.0.1418 - Corporate Edition

When attempting to transfer a project (passes the integrity check) there is an SQL syntax error on t_xref. I couldnt figure out how to attach a screenshot, so below is my transcribed version of the error

[ma-3.03][10.1.32-MariaDB] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Partition,Description,Client,Supplier) VALUES (?,?,?,?,?,?,?,?)' at line 1
[Select * from t_xref]
Field: link

Press OK to continue to next row (this record will be lost), Cancel to abort

---
Although logging for the transfer was on some additional details are below:

2018-05-09 10:49:34  Copying project information for: t_constrainttypes
  ERROR: An error has occurred:
Microsoft OLE DB Provider for ODBC Drivers [-2147217900]

[ma-3.0.3][10.1.32-MariaDB]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Constraint,Description,Notes) VALUES (?,?,?)' at line 1
  ERROR: An error has occurred:
Microsoft OLE DB Provider for ODBC Drivers [-2147217900]

[ma-3.0.3][10.1.32-MariaDB]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Constraint,Description,Notes) VALUES (?,?,?)' at line 1
  ERROR: An error has occurred:
Microsoft OLE DB Provider for ODBC Drivers [-2147217900]

[ma-3.0.3][10.1.32-MariaDB]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Constraint,Description,Notes) VALUES (?,?,?)' at line 1

--
Any guidance would be greatly appreciated,

Gareth