parsely isimli kullanıcının profili - etkinlik

HI, your macro.py file should be stored in /OSdependent/.config/libreoffice/4/user/Scripts/python/ create python folder

HI, your macro.py file should be stored in /OSdependent/.config/libreoffice/4/user/Scripts/python/ create python folder

HI, your mcaro.py file should be stored in /OSdependent/.config/libreoffice/4/user/Scripts/python/ create python folder

import uno #copy>pasted, not checked for 'smaller' errors import os def study() : D = writer_print() D.wri

import uno #code copy>pasted, can containg 'small' errors import os def study(): D = writer_print() D.writ

HI, your mcaro.py file should be stored in /OSdependent/.config/libreoffice/4/user/Scripts/python/ create python folder

HI, your mcaro.py file should be stored in /OSdependent/.config/libreoffice/4/user/Scripts/python/ You can benefit from

do you mean:after opening impress and loading the presentation, how to start show from first to last slide? In that case

mij lukt het weer niet getallen op te tellen, geen ervaring mee, maar wel om de opmaak te wijzigen: kolom selecteren (v

It will make things clearer if you indicate, with two limited lists, what the desired output is. In the meantime python

It will make things clearer if you indicate, with two limited lists, what the desired output is. In the meantime python

It will make things clearer if you indicate, with two limited lists, what the desired output is. In the meantime python

It will make things clearer if you indicate, with two limited lists, what the desired output is. In the meantime python

It will make things clearer if you indicate, with two limited lists, what the desired output is. In the meantime python

It will make things clearer if you indicate, with two limited lists, what the desired output is. In the meantime python

It will make things clearer if you indicate, with two limited list, what the desired output is. In the meantime python o

It will make things clearer if you suggest, with two limited list, what the desired output is. In the meantime python of

Thanks to Lupp (how to load an image as bitmap) this question could now be answered. This is specific autoincrement, ch

Thanks to Lupp (how to load an image as bitmap) this question could now be answered. This is specific autoincrement, ch

This is specific autoincrement, check extensions to see if today extensions are present for this or other needs, an exte

how to split a firebird embedded database There are technical considerations to separate the data from all other things

There are technical considerations to separate the data from all other things to manipulate the data (forms-query-macro-reports). A practical considerations arises when f.i. you run the financial administration for some legal identities.
In the past splitting of HSQLDB bases has been recommended. Auto migration to firebird leaves you with an embedded FB database.To split that i followed the scheme:

new database > connect to existing > create new ! > enter a dbBackEnd name > register Yes > save as dbFrontend name. ( this creates a dbBackEnd.fdb and a registered dbFrontEnd.odb file )
open the embedded and new dbFrontEnd side by side
drop and drag all tables to the dbFrontEnd

this gives rise to the known issue "identity violation", because during drop and drag of filled tables the autonumbering field is not updated.
with Create Query in SQL View a list of tables and names can be obtained,

SELECT "RDB$RELATION_FIELDS"."RDB$RELATION_NAME", "RDB$RELATION_FIELDS"."RDB$FIELD_NAME", "RDB$RELATION_FIELDS"."RDB$GENERATOR_NAME" FROM "RDB$RELATION_FIELDS" JOIN "RDB$RELATIONS" ON "RDB$RELATION_FIELDS"."RDB$RELATION_NAME" = "RDB$RELATIONS"."RDB$RELATION_NAME" AND "RDB$RELATIONS"."RDB$VIEW_BLR" IS NULL AND ( "RDB$RELATIONS"."RDB$SYSTEM_FLAG" IS NULL OR "RDB$RELATIONS"."RDB$SYSTEM_FLAG" = 0 ) AND NOT ( "RDB$GENERATOR_NAME" IS NULL ) ORDER BY "RDB$GENERATOR_NAME"
 

SELECT MAX("ID") FROM "TABLENAME"
Observe NUMBER in output field. 
ALTER TABLE "TABLENAME" ALTER "ID" RESTART WITH NUMBER 

( I could not get this going in a macro only in the TOOLS>SQL window )

Following code can be used to connect to another BackEnd.fdb data content base

Sub linkToOtherBackEnd()

        Dim  sName as string
    Dim filePicker As Object
    Dim FPtype(0) As Integer

    FilePicker = CreateUnoService("com.sun.star.ui.dialogs.FilePicker")
    FPtype(0)=com.sun.star.ui.dialogs.TemplateDescription.FILEOPEN_LINK_PREVIEW_IMAGE_TEMPLATE 'FILEOPEN_SIMPLE
    FilePicker.initialize(FPtype())

    If FilePicker.execute() Then
       sName =  "sdbc:firebird:" & ConvertToURL(FilePicker.Files(0))
    EndIf

    ThisDatabaseDocument.DataSource.URL = sName

End Sub

Are there easier methods to split an embedded base?

thanks Ratslinger. I did see the other post, but it was a bit unrecognizable to me due to the term portable and server,

thanks Ratslinger. I did see the other post, but it was a bit unrecognizable to me due to the term portable and server,

thanks Ratslinger. I did see the other post, but it was a bit unrecognizable to me due to the term portable and server,

thanks Ratslinger. I did see the other post, but it was a bit unrecognizable to me due to the term portable and server,

thanks Ratslinger. I did see the other post, but it was a bit unrecognizable to me due to the term portable and server,

how to split a firebird embedded database There are technical considerations to separate the data from all other things

how to split a firebird embedded database There are technical considerations to separate the data from all other things

This is specific autoincrement, check extensions to see if today extensions are present for this or other needs, an exte

This is specific autoincrement, check extensions to see if today extensions are present for this or other needs, an exte

This is specific autoincrement, check extensions to see if today extensions are present for this or other needs, an exte

This is specific autoincrement, check extensions to see if today extensions are present for this or other needs, an exte

preparations:- do the required pip installs according to pypi website - create a file bartemplate.odt containing a fra

what is clac? Barcodes can also be generated with python macro language, for an example see link text

how to load an image as bitmap in a writer document with a macro With the GUI i can load an image as a bitmap and assign

Thanks for the API link, i was looking for that. Sorry to caused confusion, there is a difference in skills between us

preparations:- do the required pip installs according to pypi website - create a file bartemplate.odt containing a fra