How to manage LibreOffice Base DataBases?

@Villeroy : I have had a look why so much people think there is a limit at 255 characters: The import wizard allows maximum length 255, will set back longer values but if you set Type → Automatic it will recognize there is more content needed. A little bit buggy…

1 Like

Thanks RobertG,
Where does one find the Type–Automatic setting?
As stated before, the day one fails to learn something is probably the day one should stop all together!

1 Like

Villeroy,
I am ignoring hours worth of stuff to post a very rough example of what jtm may be able to get a hold of and tune it in on their own. Give someone a fish to eat and they are fed for a day, teach them to fish and they will feed themselves. Did you expect me to come back with a finished product overnight? I don’t see where you have offered any useful help to jtm whatsoever!

1 Like

A database with column types VARCHAR(255) NULL does not help anybody. Base wizards do not help anybody (except report wizard).
I would try to connect a Base document to the backend used by the frontend “S10 Presupuesto”. This would unveil all tables, columns, relations and indices and all the data within that structure within minutes.

1 Like

unless they “protectected” access to this by password…
.
Googling a bit on the topic didn’t give much, but my top try would be MS-Sql-Server.
Edit: The assumption is confirmed when one combines "S10 Presupuesto” and “SQL-Server” for the google search.

1 Like

https://www.udemy.com/course/presupuestos-de-obras-con-s10-presupuestos/?couponCode=BFCPSALE24 is a video that shows how to log in as a user named “sa” which I would translate as “system administrator”.

1 Like