Re: [WebDNA] line/Row Insert

This WebDNA talk-list message is from

2017

It keeps the original formatting. numero = 113607
interpreted = N
texte = 1202--Apple-Mail=_76921699-ED5A-4562-AC32-3EC5E839705FContent-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=utf-8Using 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 resort 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 TEXT 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:>=20> Dear TalkList:>=20> Is it possible to insert a new line, that is between existing rows, =inside a db?>=20> Thanks--Apple-Mail=_76921699-ED5A-4562-AC32-3EC5E839705FContent-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=utf-8

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=99=ll have to resort 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 TEXT 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 <sgbccebu@gmail.com> wrote:

Dear TalkList:

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

Thanks

=---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna?numero=3D55Bug Reporting: support@webdna.us--Apple-Mail=_76921699-ED5A-4562-AC32-3EC5E839705F--. Associated Messages, from the most recent to the oldest:

Re: [WebDNA] line/Row Insert (Sgbc Cebu 2017) Re: [WebDNA] line/Row Insert (Brian Fries 2017) [BULK] Re: [WebDNA] line/Row Insert ("WJ Starck, DDS" 2017) [WebDNA] line/Row Insert (Sgbc Cebu 2017)

1202--Apple-Mail=_76921699-ED5A-4562-AC32-3EC5E839705FContent-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=utf-8Using 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 resort 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 TEXT 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:>=20> Dear TalkList:>=20> Is it possible to insert a new line, that is between existing rows, =inside a db?>=20> Thanks--Apple-Mail=_76921699-ED5A-4562-AC32-3EC5E839705FContent-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=utf-8

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=99=ll have to resort 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 TEXT 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 <sgbccebu@gmail.com> wrote:

Dear TalkList:

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

Thanks

=---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna?numero=3D55Bug Reporting: support@webdna.us--Apple-Mail=_76921699-ED5A-4562-AC32-3EC5E839705F--. Brian Fries

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:

[shownext max=?] armed (1997) Multiple prices (1997) Macos8.6 to X migration problems (2000) [OT] friday pics :-) (2005) The Archives? (1999) Custom WebCat Prefs ... (1997) Robert Minor duplicate mail (1997) checkbox results written to a database (1999) WC2b15 File Corruption (1997) Re:Formulas.db / Quantity Discount problem (1998) another problem (1997) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) WebDNA-Talk Digest mode broken (1997) Sku numbers (1997) en/decrypt problem (1999) Error.html (1997) Viewing Changes (1998) What am I missing (1997) select multiple (1997) RE: Loss in form (1998)