Re: [WebDNA] line/Row Insert

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113608
interpreted = N
texte = 1203 --001a113f7ca28385170550612873 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable maybe to have it REWRITTEN is where to go, but I'm thinking of altering the Unique Sequential ID or index by simulating an up/down movement of rows from the users viewpoint... On Mon, May 22, 2017 at 10:34 AM, Brian Fries wrote: > Using WebDNA=E2=80=99s database contexts - REPLACE and APPEND - every new= record > you add is added at the end of the .db file. > > Typically, if you care about the order of the records, that is handled by > the sort options in your SEARCH context. > > If you truly need a row in between two others for some reason (I can=E2= =80=99t > think of why, but maybe you have a good case), you=E2=80=99ll have to res= ort to > other means, such as manually editing the .db file in a spreadsheet or a > text editor, or using WebDNA=E2=80=99s INCLUDE to read the file into a TE= XT > variable, manipulate the text to add the line where you want it, then use > WRITEFILE to write it back to disk (makeing sure WebDNA does not have the > database open in the meantime, or it may overwrite your changes). > > - Brian > > On May 21, 2017, at 2:30 PM, Sgbc Cebu wrote: > > Dear TalkList: > > Is it possible to insert a new line, that is between existing rows, insid= e > a db? > > Thanks > > > --------------------------------------------------------- This message is > sent to you because you are subscribed to the mailing list talk@webdna.us > To unsubscribe, E-mail to: talk-leave@webdna.us archives: > http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.u= s > --001a113f7ca28385170550612873 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
maybe to have it REWRITTEN is where to go, but I'm thi= nking of altering the Unique Sequential ID or index by simulating an up/dow= n movement of rows from the users viewpoint...

On Mon, May 22, 2017 at 10:34 AM, Br= ian Fries <iphonzie@gmail.com> wrote:
Using WebDNA=E2=80=99s database contexts - REPLACE and APPEND - = every new record you add is added at the end of the .db file.

Typically, if you care about the order of the records, that is handle= d by the sort options in your SEARCH context.

If y= ou truly need a row in between two others for some reason (I can=E2=80=99t = think of why, but maybe you have a good case), you=E2=80=99ll have to resor= t to other means, such as manually editing the .db file in a spreadsheet or= a text editor, or using WebDNA=E2=80=99s INCLUDE to read the file into a T= EXT variable, manipulate the text to add the line where you want it, then u= se WRITEFILE to write it back to disk (makeing sure WebDNA does not have th= e database open in the meantime, or it may overwrite your changes).

- Brian

On May 21, 2017, at 2:30 PM, Sgbc Cebu <sgbccebu@gmail.com> wrote:
Dear TalkList:

Is it possible to insert a new l= ine, that is between existing rows, inside a db?

Thanks

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us --001a113f7ca28385170550612873-- . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] line/Row Insert (Sgbc Cebu 2017)
  2. Re: [WebDNA] line/Row Insert (Brian Fries 2017)
  3. [BULK] Re: [WebDNA] line/Row Insert ("WJ Starck, DDS" 2017)
  4. [WebDNA] line/Row Insert (Sgbc Cebu 2017)
1203 --001a113f7ca28385170550612873 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable maybe to have it REWRITTEN is where to go, but I'm thinking of altering the Unique Sequential ID or index by simulating an up/down movement of rows from the users viewpoint... On Mon, May 22, 2017 at 10:34 AM, Brian Fries wrote: > Using WebDNA=E2=80=99s database contexts - REPLACE and APPEND - every new= record > you add is added at the end of the .db file. > > Typically, if you care about the order of the records, that is handled by > the sort options in your SEARCH context. > > If you truly need a row in between two others for some reason (I can=E2= =80=99t > think of why, but maybe you have a good case), you=E2=80=99ll have to res= ort to > other means, such as manually editing the .db file in a spreadsheet or a > text editor, or using WebDNA=E2=80=99s INCLUDE to read the file into a TE= XT > variable, manipulate the text to add the line where you want it, then use > WRITEFILE to write it back to disk (makeing sure WebDNA does not have the > database open in the meantime, or it may overwrite your changes). > > - Brian > > On May 21, 2017, at 2:30 PM, Sgbc Cebu wrote: > > Dear TalkList: > > Is it possible to insert a new line, that is between existing rows, insid= e > a db? > > Thanks > > > --------------------------------------------------------- This message is > sent to you because you are subscribed to the mailing list talk@webdna.us > To unsubscribe, E-mail to: talk-leave@webdna.us archives: > http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.u= s > --001a113f7ca28385170550612873 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
maybe to have it REWRITTEN is where to go, but I'm thi= nking of altering the Unique Sequential ID or index by simulating an up/dow= n movement of rows from the users viewpoint...

On Mon, May 22, 2017 at 10:34 AM, Br= ian Fries <iphonzie@gmail.com> wrote:
Using WebDNA=E2=80=99s database contexts - REPLACE and APPEND - = every new record you add is added at the end of the .db file.

Typically, if you care about the order of the records, that is handle= d by the sort options in your SEARCH context.

If y= ou truly need a row in between two others for some reason (I can=E2=80=99t = think of why, but maybe you have a good case), you=E2=80=99ll have to resor= t to other means, such as manually editing the .db file in a spreadsheet or= a text editor, or using WebDNA=E2=80=99s INCLUDE to read the file into a T= EXT variable, manipulate the text to add the line where you want it, then u= se WRITEFILE to write it back to disk (makeing sure WebDNA does not have th= e database open in the meantime, or it may overwrite your changes).

- Brian

On May 21, 2017, at 2:30 PM, Sgbc Cebu <sgbccebu@gmail.com> wrote:
Dear TalkList:

Is it possible to insert a new l= ine, that is between existing rows, inside a db?

Thanks

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us --001a113f7ca28385170550612873-- . Sgbc Cebu

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

template security preferences????? (1998) RequiredFields and MacOS X Server? (2000) Performance: deafening silence (1999) Quit revisited (1997) Apache processes (2003) textarea input- nevermind (2002) [append] (1997) WebCat2b13MacPlugin - nested [xxx] contexts (1997) OT - quiet on the list today - here's something (2004) default error on NT? (1997) pop up menu's (1998) searchable list archive (1997) Sorting Numbers (1997) Add a field to the error log? (1997) Search in 2 or more catalogs (1997) [WebDNA] A note about the WebDNA Server 8.0.2 installer and Admin on Ubuntu (2015) building / customizing stores (2000) Extended [ConvertChars] (1997) Search for 20 finds 2000, 200 Why? (1997) Updating product information (2002)