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:

emailer settings and control questions (1997) WebCatalog2 Feature Feedback (1996) Tool of Use to Unix WebCat Admins (2000) 'page impression' techniques for banner ads (1999) RequiredFields notes ... (1997) Emailer setup (1997) Bug Report, maybe (1997) WCS Newbie question (1997) Bug Report, maybe (1997) Running _every_ page through WebCat ? (1997) logging in a user (1999) Stumped on ShowNext -using variables (1997) OT: .biz and .info (2001) RE: I have observed and I am gone. (1998) Virtual Postcards (1998) It just Does't add up!!! (1997) Some Questions (1997) Database Options (1997) More on the email templates (1997) Comments in db? (1997)