[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kexi
Subject:    Re: How to change the number of characters allowed in a cell without erasing all the data in the tab
From:       Jaroslaw Staniek <staniek () kde ! org>
Date:       2019-05-27 20:48:26
Message-ID: CAOj7QQ3RS=nZ6PORZWsJdZqXFkkMeofViLxDgh42shZ8gm0auA () mail ! gmail ! com
[Download RAW message or body]

On Mon, 27 May 2019 at 22:35, Swarup <dinbandhu@sprynet.com> wrote:

> Hello Jaroslaw,
> I was so happy to hear your good news. I opened my Kexi table, went into
> design view, and increased the maximum number of allowed characters for
> each of my fields of type "text", from 200 to 1000. Went again clicked on
> the tab to switch back to data view, I got the below message. On the basis
> of the below, I had to discard the changes I had made, by clicking on
> "Discard design". You wrote below that this problem was fixed a long time
> ago. Are you sure about that? Or if there is another way to do this aside
> from what I did, please let me know.
>

Swarup,
I double checked and I see I had no data in my test table, that's why I
observe different message. I also confused the property with the "Default
value" property.
It would be best if you add a bug report to bugs.kde.org then, thanks.
In the report I will be can recommend a warkaround for you for changing the
property without removing data.



>
> On 5/27/19 2:32 PM, Jaroslaw Staniek wrote:
>
>
>
> On Fri, 24 May 2019 at 00:40, Swarup <dinbandhu@sprynet.com> wrote:
>
>> I am using Kexi Version 3.1.0. In earlier versions it was the case that
>> if one were to go into design view and change the settings, such as the
>> setting for the number of characters allowed in each cell, the program
>> would delete all the data in the table. Is that still the case?
>>
>
> Hello Swarup
> Thanks for the question. For quite long time already (3.0?) KEXI does not
> require removal or recreation of the table if modified property is of such
> non-fundamental kind. So no worries here.
>
>
>> I would very much like to increase the number of characters allowed in
>> each cell, or remove the limit altogether. But cannot afford to lose my
>> data.
>>
>>
> Also no worries here. If removal or recreation of the table is required
> KEXI _always_ tells you that and asks for confirmation prior to the change.
> You then have the opportunity to abandon changes made to the project
> recently.
>
> PS: Sorry, I've been away from keyboard for several days.
>
> --
> regards, Jaroslaw Staniek
>
> KDE:
> : A world-wide network of software engineers, artists, writers, translators
> : and facilitators committed to Free Software development - kde.org
> KEXI:
> : A visual database apps builder - kexi-project.org calligra.org/kexi
>   twitter.com/kexi_project facebook.com/kexi.project t.me/kexi_project
> Qt Certified Specialist:
> : linkedin.com/in/jstaniek <http://www.linkedin.com/in/jstaniek>
>
>
>

-- 
regards, Jaroslaw Staniek

KDE:
: A world-wide network of software engineers, artists, writers, translators
: and facilitators committed to Free Software development - kde.org
KEXI:
: A visual database apps builder - kexi-project.org calligra.org/kexi
  twitter.com/kexi_project facebook.com/kexi.project t.me/kexi_project
Qt Certified Specialist:
: linkedin.com/in/jstaniek <http://www.linkedin.com/in/jstaniek>

[Attachment #3 (text/html)]

<div dir="ltr"><div dir="ltr"><div class="gmail_default" \
style="font-family:monospace,monospace;font-size:small"><br></div><div \
class="gmail_default" \
style="font-family:monospace,monospace;font-size:small"><br></div></div><br><div \
class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, 27 May 2019 \
at 22:35, Swarup &lt;<a href="mailto:dinbandhu@sprynet.com" \
target="_blank">dinbandhu@sprynet.com</a>&gt; wrote:<br></div><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex">  
    
  
  <div bgcolor="#FFFFFF">
    Hello Jaroslaw, <br>
    I was so happy to hear your good news. I opened my Kexi table, went
    into design view, and increased the maximum number of allowed
    characters for each of my fields of type &quot;text&quot;, from 200 to \
1000.  Went again clicked on the tab to switch back to data view, I got the
    below message. On the basis of the below, I had to discard the
    changes I had made, by clicking on &quot;Discard design&quot;. You \
wrote below  that this problem was fixed a long time ago. Are you sure \
about  that? Or if there is another way to do this aside from what I did,
    please let me know.<br></div></blockquote><div><br></div><div \
class="gmail_default" \
style="font-family:monospace,monospace;font-size:small">Swarup,</div><div \
class="gmail_default" \
style="font-family:monospace,monospace;font-size:small">I double checked \
and I see I had no data in my test table, that&#39;s why I observe \
different message. I also confused the property with the &quot;Default \
value&quot; property.  </div><div class="gmail_default" \
style="font-family:monospace,monospace;font-size:small">It would be best if \
you add a bug report to <a href="http://bugs.kde.org" \
target="_blank">bugs.kde.org</a> then, thanks.</div><div \
class="gmail_default" \
style="font-family:monospace,monospace;font-size:small">In the report I \
will be can recommend a warkaround for you for changing the property \
without removing data.</div><div class="gmail_default" \
style="font-family:monospace,monospace;font-size:small"><br></div><div \
class="gmail_default" \
style="font-family:monospace,monospace;font-size:small"><br></div><div \
class="gmail_default" \
style="font-family:monospace,monospace;font-size:small"></div><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div bgcolor="#FFFFFF">  <br>
    <br>
    On 5/27/19 2:32 PM, Jaroslaw Staniek
      wrote:<br>
    <blockquote type="cite">
      
      <div dir="ltr">
        <div dir="ltr">
          <div style="font-family:monospace,monospace;font-size:small"><br>
          </div>
        </div>
        <br>
        <div class="gmail_quote">
          <div dir="ltr" class="gmail_attr">On Fri, 24 May 2019 at
            00:40, Swarup &lt;<a href="mailto:dinbandhu@sprynet.com" \
target="_blank">dinbandhu@sprynet.com</a>&gt;  wrote:<br>
          </div>
          <blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">  <div \
bgcolor="#FFFFFF"> I am using Kexi Version 3.1.0. In  earlier versions it \
was the case that if one were to go  into design view and change the \
settings, such as the  setting for the number of characters allowed in each \
cell,  the program would delete all the data in the table. Is
              that still the case? </div>
          </blockquote>
          <div><br>
          </div>
          <div>
            <div style="font-family:monospace,monospace;font-size:small">Hello
  Swarup</div>
            <div style="font-family:monospace,monospace">Thanks for the
              question. For quite long time already (3.0?) KEXI does not
              require removal or recreation of the table if modified
              property is of such non-fundamental kind. So no worries
              here.</div>
            <div style="font-family:monospace,monospace;font-size:small"><span \
style="font-family:Arial,Helvetica,sans-serif">  </span><br>  </div>
          </div>
          <blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">  <div \
bgcolor="#FFFFFF">I would very much like to increase  the number of \
characters allowed in each cell, or remove  the limit altogether. But \
cannot afford to lose my data.<br>  <br>
            </div>
          </blockquote>
          <div>
            <div style="font-family:monospace,monospace;font-size:small"><br>
  </div>
            <div style="font-family:monospace,monospace;font-size:small">Also
  no worries here. If removal or recreation of the table is
              required KEXI _always_ tells you that and asks for
              confirmation prior to the change. You then have the
              opportunity to abandon changes made to the project
              recently.</div>
            <div style="font-family:monospace,monospace;font-size:small"><br>
  </div>
            <div style="font-family:monospace,monospace;font-size:small">PS:
                
              Sorry, I&#39;ve been away from keyboard for several \
days.</div>  <br>
          </div>
          <div style="font-family:monospace,monospace;font-size:small"><span \
style="font-family:Arial,Helvetica,sans-serif">--  </span><br>  </div>
        </div>
        <div dir="ltr" \
class="m_4716488177933307967m_-4117538462499053891gmail-m_-140820029163781171gmail_signature">
  <div dir="ltr">
            <div>
              <div dir="ltr">
                <div>
                  <div dir="ltr">
                    <div>
                      <div dir="ltr">
                        <div>regards, Jaroslaw Staniek<br>
                          <br>
                          KDE:<br>
                          : A world-wide network of software engineers,
                          artists, writers, translators<br>
                          : and facilitators committed to Free Software
                          development - <a href="http://kde.org" \
target="_blank">kde.org</a><br>  KEXI:<br>
                          : A visual database apps builder -  <a \
href="http://kexi-project.org/" target="_blank">kexi-project.org</a>  <a \
href="http://calligra.org/kexi" target="_blank">calligra.org/kexi</a></div> \
<div>    <a href="https://twitter.com/kexi_project" \
target="_blank">twitter.com/kexi_project</a>  <a \
href="https://facebook.com/kexi.project" \
target="_blank">facebook.com/kexi.project</a>  <a \
href="https://t.me/kexi_project" target="_blank">t.me/kexi_project</a><br>  \
                Qt Certified Specialist:<br>
                          : <a href="http://www.linkedin.com/in/jstaniek" \
target="_blank">linkedin.com/in/jstaniek</a></div>  </div>
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </div>
        </div>
      </div>
    </blockquote>
    <br>
  </div>

</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" \
class="m_4716488177933307967m_-4117538462499053891gmail_signature"><div \
dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div \
dir="ltr"><div>regards, Jaroslaw Staniek<br><br>KDE:<br>: A world-wide \
network of software engineers, artists, writers, translators<br>: and \
facilitators committed to Free Software development - <a \
href="http://kde.org" target="_blank">kde.org</a><br>KEXI:<br>: A visual \
database apps builder -  <a href="http://kexi-project.org/" \
target="_blank">kexi-project.org</a>  <a href="http://calligra.org/kexi" \
target="_blank">calligra.org/kexi</a></div><div>    <a \
href="https://twitter.com/kexi_project" \
target="_blank">twitter.com/kexi_project</a>  <a \
href="https://facebook.com/kexi.project" \
target="_blank">facebook.com/kexi.project</a>  <a \
href="https://t.me/kexi_project" \
target="_blank">t.me/kexi_project</a><br>Qt Certified Specialist:<br>: <a \
href="http://www.linkedin.com/in/jstaniek" \
target="_blank">linkedin.com/in/jstaniek</a></div></div></div></div></div></div></div></div></div></div>




[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic