[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