Ask Your Question

Pavel_47's profile - activity

2019-02-13 17:34:51 +0100 received badge  Popular Question (source)
2019-02-13 12:55:05 +0100 commented answer How to fill BLOB field with image data

In operating mode the only option (when right-clicking) is "Copy".

2019-02-13 12:20:35 +0100 asked a question How to fill BLOB field with image data

How to fill BLOB field with image data Hello, How to embedd small image (e.g. jpeg) into a field of type BLOB. Thanks

2019-02-06 14:51:12 +0100 marked best answer Edit Form - insert missing column

Hello, After creating a Form associated with a table, I discovered that one column is missing. How to add a missing column into Form. Thanks.

2019-02-06 14:51:09 +0100 commented answer Edit Form - insert missing column

Well, the interface in my version (6.1.3.2) is different from that exposed in user's guide, but finally I have found how

2019-02-05 10:56:06 +0100 received badge  Popular Question (source)
2019-02-04 12:02:47 +0100 asked a question Edit Form - insert missing column

Edit Form - insert missing column Hello, After creating a Form associated with a table, I discovered that one column is

2019-02-02 10:34:10 +0100 received badge  Popular Question (source)
2019-02-01 01:05:25 +0100 marked best answer How to increase size of Form

Hello, The default size of form is quite small. How to increase it (i.e. stretch in directions pointed by arrows on the image below) ? link text

2019-02-01 01:05:19 +0100 commented answer How to increase size of Form

Thanks a lot !

2019-02-01 01:02:57 +0100 received badge  Enthusiast
2019-01-31 20:24:19 +0100 marked best answer How to change the order of columns in table ?

Hello, In MS Access it's quite easily to change the order o columns. Surprisingly LibreOffice doesn't provide such basic functionnality. Does exist some work-around ? Thanks

2019-01-31 20:23:56 +0100 marked best answer Can't add primary key into table

Hello,

It seems that nothing works with FireBird database. I try to insert PRIMARY KEY according to examples I've fond on the web, but SQL fails. Here is my SQL request ALTER TABLE table1 ADD PRIMARY KEY (ID)

... and here is result:

Error1: Statut SQL: HY000 Code d'erreur: 1000 Erreur de syntaxe dans l'expression SQL

Error2: Statut SQL: HY000 Code d'erreur: 1000

Error3: Statut SQL: HY000 Code d'erreur: 1000 syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE

Any comments ?

2019-01-31 20:23:24 +0100 asked a question How to increase size of Form

How to increase size of Form Hello, The default size of form is quite small. How to increase it (i.e. stretch in directi

2019-01-31 20:15:27 +0100 commented answer Strange phenomena while filling table using Form

ok, thanks

2019-01-31 20:15:07 +0100 marked best answer Strange phenomena while filling table using Form

Hello, I've met strange phenomena using Form: when I try to add a record, I'm required to fill the fields that aren't required to be filled. Where is the problem ? Thanks.

2019-01-31 20:15:07 +0100 received badge  Scholar (source)
2019-01-31 18:42:39 +0100 commented answer How to change the order of columns in table ?

In my case without quotes SQL command fails

2019-01-31 18:34:04 +0100 received badge  Popular Question (source)
2019-01-31 16:23:29 +0100 commented answer Strange phenomena while filling table using Form

Thanks. Can I also change the geometry of table in Form. The default size it too small

2019-01-31 12:32:36 +0100 asked a question Strange phenomena while filling table using Form

Strange phenomena while filling table using Form Hello, I've met strange phenomena using Form: when I try to add a recor

2019-01-31 12:01:32 +0100 commented answer Multiline text fields in database table

Thanks. Works for Form. Concerning Table, I didn't find Memo [TEXT] option. One more question: is it possible to format

2019-01-31 12:00:55 +0100 commented answer Multiline text fields in database table

Thanks. Works for Form. Concerning Table, I didn't find Memo [TEXT] option. One more question: is it possible to format

2019-01-31 11:03:09 +0100 commented answer How to change the order of columns in table ?

Works !!! Although table_name and column_name must be enclosed in quotation marks

2019-01-31 10:55:25 +0100 commented answer Can't add primary key into table

It seems I understood the cause of error: if a table isn't empty, any modification of the primary key properties is impo

2019-01-31 10:43:12 +0100 commented answer Can't add primary key into table

Well ... it worked. Then I tried some manipulations with primary key in edit mode (e.g. applying "autogeneration" option

2019-01-31 10:29:57 +0100 commented answer Can't add primary key into table

Finally it worked. Thanks. But some misunderstandig persists nevertheless. It seems that it's impossible to change the p

2019-01-30 12:44:36 +0100 commented answer Can't add primary key into table

Moreover, when I open table2, there is no any options for adding new records: link text

2019-01-30 12:41:15 +0100 commented answer Can't add primary key into table

It seems that it finally worked: first I added the new column and then applied the constraint. But when I open the table

2019-01-30 12:30:17 +0100 commented answer Can't add primary key into table

Well, I've just created a new table table2 with only two columns "aaa" and "bbb" and have tried to add a primary key. He

2019-01-30 08:30:44 +0100 commented question Can't add primary key into table

The LO version is: 6.1.3.2 (x64)

2019-01-30 08:29:55 +0100 commented answer Can't add primary key into table

Thanks Ratslinger. This solution doesn't work either: link text

2019-01-30 08:29:55 +0100 received badge  Commentator
2019-01-30 08:18:46 +0100 commented answer How to change the order of columns in table ?

Thank you Ratslinger. I'm sorry for "Jan". I've tried this command in the location you suggested. Also doesn't work. Her

2019-01-29 22:30:07 +0100 received badge  Notable Question (source)
2019-01-29 15:16:07 +0100 commented question Can't add primary key into table

I've just tried executing of the command ALTER TABLE table1 ADD PRIMARY KEY (ID) with "Optional features" set to ON, but

2019-01-29 15:13:05 +0100 commented question Can't add primary key into table

No, for the moment this option is OFF. I'll try putting it to "ON". My OS: Windows 10 PRO. Concerning LO, I don't know h

2019-01-29 14:54:57 +0100 commented question Can't add primary key into table

On the link you provided an expert suspects that there are problems with Java. I checked my system: Java 8 is installed.

2019-01-29 14:46:10 +0100 received badge  Popular Question (source)
2019-01-29 10:27:57 +0100 asked a question Can't add primary key into table

Can't add primary key into tableb Hello, It seems that nothing works with FireBird database. I try to insert PRIMARY KE

2019-01-29 09:54:05 +0100 commented answer How to change the order of columns in table ?

Hello, The suggestion of Jan doesn't work: link text

2019-01-28 20:26:49 +0100 received badge  Notable Question (source)
2019-01-19 06:43:26 +0100 received badge  Popular Question (source)
2019-01-18 19:14:31 +0100 commented question Multiline text fields in database table

Windows-10, HSQLDB

2019-01-18 18:22:34 +0100 asked a question Multiline text fields in database table

Multiline text fields in database table Hello, Does LibreOffice base allow putting multiple lines in cells. If YES, whic

2019-01-12 10:36:48 +0100 received badge  Notable Question (source)
2019-01-11 19:29:25 +0100 received badge  Popular Question (source)
2019-01-11 12:31:04 +0100 commented question Can't save table

Yes, it was the case: I misinterpreted the error message. The issue is resolved: I accidentally add a record and didn't

2019-01-11 12:24:14 +0100 commented question Can't save table

Thanks Mike, Here is what happens when I try to do something. image description Indeed the 1st recording has no value i