Adding bolt type and size via SQL

Adding bolt type and size via SQL

j.hamelin
Advocate Advocate
895 Views
21 Replies
Message 1 of 22

Adding bolt type and size via SQL

j.hamelin
Advocate
Advocate

Hi,

I tried to add some bolt types and sizes using SQL SMS, and I expected to see them in the Management Tools, but nothing appeared.

 

I'm not sure if I did something wrong. Let me show you exactly what I did:

jhamelin_0-1750685791028.png

 

But in MT :

jhamelin_1-1750685808704.png

 

jhamelin_2-1750685816248.png

 

No bolts were present, only the ones in metric sizes that I had tried to convert to SAE sizes, but they still appear as "M12" instead of the new names I used.
In short, none of the changes I made through SQL seem to appear in the Management Tool, as if I were working on a clone database.

That’s what I initially thought, so I double-checked but SQL is definitely connected to the main (and only) database I use in Advance Steel.

 

Did I forget something?

 

After that, I tried adding them directly in the Management Tools, but nothing seemed to be saved after closing and reopening it.
Could it be that my database is suddenly locked?

 

Nothing gets saved when I work directly in the Management Tools, but the data remains if I do it through SQL...
I'm a bit lost here 😢

 

Advance Steel 2025

SQL SMS v18.12.1

SQL Server Management Studio 15.0.18424.0
SQL Server Management Objects (SMO) 16.100.47021.0+7eef34a564af48c5b0cf0d617a65fd77f06c3eb1
Microsoft Analysis Services Client Tools 15.0.19750.0
Microsoft Data Access Components (MDAC) 10.0.26100.3624
Microsoft MSXML 3.0 6.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.26100

Mechanical Design Drafter

If this information was helpful, please use the Accept as Solution function, this make it easier for other users.
0 Likes
Accepted solutions (2)
896 Views
21 Replies
Replies (21)
Message 21 of 22

george1985
Collaborator
Collaborator

Hi @markhubrich ,
This is brilliant work! Thank you for sharing your program with us!

Message 22 of 22

markhubrich
Advisor
Advisor

Oh boy this should make for an interesting evening lol

I'm going to see if AS will run off MySql. or MariaDB

https://drive.google.com/file/d/19lv45seZtjQhF6wftelaETe_rXjcvYdK/view?usp=sharing

markhubrich_0-1750802275766.png

 

...and fix the kiss export issues.