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:

Security (2000) Re:No Data (1997) Remove Command not working (2000) Webcat/Webmerchant part II (1998) [WebDNA] WebDNA vs. php war ;-) (2010) strange result? (2003) Purchased cart being overwritten - still !?? (1997) WebCatalog for guestbook ? (1997) Sendmail Question (2001) Almost a there but..bye bye NetCloak (1997) To Err or Not Custom Error (1999) Snake Bites (1997) Possible Bug in 2.0b15.acgi (1997) Simple way to create unique SKU (1997) BBEdit WedDNA Codeless Language Module (2004) Add message to Order (1997) [OT] Democratic Code (2002) Help!!!! Purchases not going through! (1997) Help name our technology! I found it (1997) limitation found on group searching (1997)