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:

[Sum] function? (1997) Follow-Up to: Removing [showif] makes a big difference in speed (1997) Mac System Experience (1998) aaron kant add (2.x) (2000) Error:Too many nested [xxx] contexts (1997) thankyou.tmpl (1997) Re[2]: 2nd WebCatalog2 Feature Request (1996) can webcat create directories on NT? (1997) show all problem (1997) problems with 2 tags (1997) Great product and great job ! (1997) XML WebDNA (2006) Advanced WebCat Guidelines - do they exist beyond docs (1999) WebCatalog 2.0 & WebDNA docs in HTML ... (1997) Not seeing cart info on Invoice.tmpl (was PROBLEM) (1997) HELP WITH DATES (1997) [WebDNA] Dynamic vertical columns (2008) Professional WebDNA Hosting Solutions (2005) Re:Emailer tracking (1997) Protect vs Authenicate (1997)