Sorunuzu Sorun

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

2021-01-09 10:01:14 +0100 soruya yorum yazıldı How to Import Python scropt into LibreOffice Calc and run with a macro

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

2021-01-09 09:58:59 +0100 soruya yorum yazıldı How to Import Python scropt into LibreOffice Calc and run with a macro

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

2021-01-09 09:57:53 +0100 soruya yorum yazıldı How to Import Python scropt into LibreOffice Calc and run with a macro

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

2021-01-09 09:57:24 +0100 cevap düzeltilmiş How to Import Python scropt into LibreOffice Calc and run with a macro

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

2021-01-09 09:53:06 +0100 bir soru cevapladı How to Import Python scropt into LibreOffice Calc and run with a macro

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

2021-01-09 09:41:37 +0100 soruya yorum yazıldı How to Import Python scropt into LibreOffice Calc and run with a macro

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

2021-01-09 09:38:01 +0100 soruya yorum yazıldı How to Import Python scropt into LibreOffice Calc and run with a macro

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

2021-01-02 17:22:13 +0100 bir soru cevapladı How to automatically start a slideshow

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

2020-12-29 21:31:44 +0100 rozet alındı  Ünlü Soru (kaynak)
2020-12-29 08:49:08 +0100 soruya yorum yazıldı Decimalen van calc naar writer

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

2020-12-22 10:06:33 +0100 soruya yorum yazıldı how do make List's and then get all possible combinations from 2 or 3 list's containing 3 or 4 items

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

2020-12-21 22:07:41 +0100 soruya yorum yazıldı how do make List's and then get all possible combinations from 2 or 3 list's containing 3 or 4 items

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

2020-12-21 22:03:01 +0100 soruya yorum yazıldı how do make List's and then get all possible combinations from 2 or 3 list's containing 3 or 4 items

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

2020-12-21 22:01:47 +0100 soruya yorum yazıldı how do make List's and then get all possible combinations from 2 or 3 list's containing 3 or 4 items

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

2020-12-21 21:58:39 +0100 soruya yorum yazıldı how do make List's and then get all possible combinations from 2 or 3 list's containing 3 or 4 items

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

2020-12-21 21:58:14 +0100 soruya yorum yazıldı how do make List's and then get all possible combinations from 2 or 3 list's containing 3 or 4 items

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

2020-12-21 21:56:26 +0100 soruya yorum yazıldı how do make List's and then get all possible combinations from 2 or 3 list's containing 3 or 4 items

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

2020-12-21 21:55:34 +0100 soruya yorum yazıldı how do make List's and then get all possible combinations from 2 or 3 list's containing 3 or 4 items

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

2020-12-20 23:40:18 +0100 cevap düzeltilmiş Receipt or order form consecutive numbering plus barcode.

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

2020-12-20 23:34:26 +0100 cevap düzeltilmiş Receipt or order form consecutive numbering plus barcode.

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

2020-12-20 14:03:15 +0100 cevap düzeltilmiş Receipt or order form consecutive numbering plus barcode.

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

2020-12-20 13:50:35 +0100 rozet alındı  Organizatör (kaynak)
2020-12-20 13:49:49 +0100 soru düzeltilmiş how to split a firebird embedded database

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

2020-12-20 13:46:12 +0100 en iyi cevap olarak işaretlenmiş how to split a firebird embedded database

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"
 
The autonumbering field can be updated With

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?

2020-12-20 13:40:51 +0100 cevaba yorum yazıldı how to split a firebird embedded database

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

2020-12-20 13:40:02 +0100 cevaba yorum yazıldı how to split a firebird embedded database

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

2020-12-20 13:39:12 +0100 cevaba yorum yazıldı how to split a firebird embedded database

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

2020-12-20 13:38:58 +0100 cevaba yorum yazıldı how to split a firebird embedded database

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

2020-12-20 13:36:31 +0100 cevaba yorum yazıldı how to split a firebird embedded database

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

2020-12-20 11:10:05 +0100 rozet alındı  Önemli Soru (kaynak)
2020-12-19 23:10:28 +0100 rozet alındı  Popüler Soru (kaynak)
2020-12-19 09:51:09 +0100 soru düzeltilmiş how to split a firebird embedded database

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

2020-12-19 09:47:07 +0100 bir soru sordu how to split a firebird embedded database

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

2020-12-17 21:08:58 +0100 cevap düzeltilmiş Receipt or order form consecutive numbering plus barcode.

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

2020-12-17 14:19:26 +0100 rozet alındı  Önemli Soru (kaynak)
2020-12-17 10:50:44 +0100 cevap düzeltilmiş Receipt or order form consecutive numbering plus barcode.

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

2020-12-17 10:47:56 +0100 cevap düzeltilmiş Receipt or order form consecutive numbering plus barcode.

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

2020-12-17 10:45:13 +0100 cevap düzeltilmiş Receipt or order form consecutive numbering plus barcode.

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

2020-12-17 10:41:42 +0100 cevap düzeltilmiş Receipt or order form consecutive numbering plus barcode.

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

2020-12-16 21:52:28 +0100 soruya yorum yazıldı Create barcodes in calc

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

2020-12-16 16:14:39 +0100 soru düzeltilmiş how to load an image as bitmap in a writer document with a macro

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

2020-12-16 13:11:51 +0100 soruya yorum yazıldı how to load an image as bitmap in a writer document with a macro

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

2020-12-16 12:49:15 +0100 cevap düzeltilmiş Receipt or order form consecutive numbering plus barcode.

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