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:

WebCat-Typhoon-WebTen (1998) Replace context (1998) WebCat2b12 - nesting [tags] (1997) [Listfiles] vs Netfinder (1997) default value from Lookup (was Grant, please help me) (1997) Mail Server Needed. (1998) P1: How to make webcatalog more stable. - LONG (1999) [WebDNA] Searching for encrypted values (2014) Multi-processor Mac info ... (1997) Re:E-mailer application times out (1998) Another bug to squash (WebCat2b13 Mac .acgi) (1997) Appending space (1998) PCS Frames (1997) Progress !! WAS: Trouble with formula.db (1997) unclear on a simple [cart] ? (1998) [cart] not being interpreted inside [founditems] (1997) select multiple (1997) different show next (1997) File Security (1999) how to know the [LineIndex] number webcat generated during a [AddLineItem]? (2000)