Editing Databases in Delphi - Inserting a new record

Поделиться
HTML-код
  • Опубликовано: 9 фев 2025
  • If you need to insert a NEW record into a database table via a Delphi program, them we make use of the INSERT and POST methods from the ADO table component. In the video we use the locate function to find one record. If you need to locate one record without using the locate function then go watch the following video: Searching for ONE record - • Databases in Delphi - ...
    Databases in Delphi Series
    Connecting to a database and data modules - • Databases in Delphi - ...
    Sorting a database table from Delphi - • Databases in Delphi - ... ​
    Extracting data from a database table - • Databases in Delphi - ...
    Searching for multiple records in a database table - • Databases in Delphi - ...
    ​Determining the Maximum and Minimum of of a field - • Databases in Delphi - ...
    Searching for ONE record - • Databases in Delphi - ...
    Connecting to database using code - • Databases in Delphi - ...
    Editing Databases in Delphi Series
    Inserting a new record - • Editing Databases in D...
    Editing a current record - • Editing Databases in D...
    Deleting a record - • Editing Databases in D...
    #MrLongEducation #Programming #Databases

Комментарии • 26

  • @philipbosman4647
    @philipbosman4647 4 года назад +35

    man I am doing a practical tomorrow 🤣 this was so helpful

  • @kamogelok5315
    @kamogelok5315 3 года назад +9

    My passion for IT died ,you brought it back !Thank you !

  • @ashtonramparsad
    @ashtonramparsad 3 месяца назад +1

    THE GOAT

  • @Obohlokoa-yf2hp
    @Obohlokoa-yf2hp 3 месяца назад

    Mr Long, can you do a tutorial for a login form? Using a database

    • @MrLongITandCAT
      @MrLongITandCAT  3 месяца назад

      I have just the video. Here it is:
      ruclips.net/video/5kqUQYiC5Sc/видео.html
      If you need more examples for other concepts then check out the PAT Guide. I have lots of examples of different elements you can include in your program.
      tinyurl.com/mrlongpatguideit

  • @bonguyisehlabisa9358
    @bonguyisehlabisa9358 4 года назад +2

    It Works!!!! , Thank you

  • @abdullahwazar4987
    @abdullahwazar4987 Год назад

    How do you make the database on insert mode

  • @Nico-lv2ey
    @Nico-lv2ey 2 года назад

    Mr Long my record does insert into my database, but it keeps the previous record's primary key and changes all the fields of the previous record to the new record's information. So I'm always left with 1 record with just the new record's primary key and a new record with the previous record's primary key but the new records fields, how can I fix this?

  • @Obohlokoa-yf2hp
    @Obohlokoa-yf2hp 3 месяца назад

    What would I need to do if I want the dbGrid to appear in another form instead of the same form as my buttons?

    • @MrLongITandCAT
      @MrLongITandCAT  3 месяца назад

      Then you need to create a multi form application. You can watch this video to help ruclips.net/video/DHYI4fqJu0g/видео.html
      And then you will need to setup your database in a data module.

  • @dillonward9033
    @dillonward9033 3 года назад +2

    can you help to display any of the data into a richedit

    • @MrLongITandCAT
      @MrLongITandCAT  3 года назад +1

      Have you tried the following video:
      ruclips.net/video/yD-PfGmToRo/видео.html
      Links to more videos are in the description of the video.

    • @dillonward9033
      @dillonward9033 3 года назад

      @@MrLongITandCAT thank you

  • @tshsclasheswithtriston9713
    @tshsclasheswithtriston9713 5 лет назад +3

    Beautiful

  • @Thamri_Saddam_Hussein
    @Thamri_Saddam_Hussein 2 года назад

    thank u

  • @skiddy529
    @skiddy529 3 года назад +6

    pog

  • @ANKITYADAV-le2kc
    @ANKITYADAV-le2kc 5 лет назад +2

    thank you sir

  • @alexgora7530
    @alexgora7530 2 года назад

    thanks for video, but your approach works only on one table, i.e. without relationship one-to-many, i mean the automatic primary key will be wrong...

    • @MrLongITandCAT
      @MrLongITandCAT  2 года назад +1

      Here is a video when inserting a record with multiple tables involved and relationships: ruclips.net/video/uftBuKj9zS0/видео.html

  • @incognitomode5945
    @incognitomode5945 Год назад

    My man has Linkin Park in his Database

  • @blueticked9789
    @blueticked9789 2 года назад

    Cheatsheet plz...

    • @MrLongITandCAT
      @MrLongITandCAT  2 года назад +3

      drive.google.com/file/d/1qoxeEFPtrtsCK0BSWCdWTYYwOZuEXVcn/view?usp=sharing
      Hope this can help. Pages 4 to 9 are the essential parts.

  • @jameelhartman887
    @jameelhartman887 2 года назад +2

    Damn g you really know coding, i am a IT prodigdy myself youve probably heard of me before ill give some advice kid to get on my level
    youre schooling got me to where i am now my g if you want to make some bunda bucks like this comment and ill contact you we could really use skill like yours in this field of mine
    you get me my g?
    This is probably the single biggest decicion of your life my g so take this very serouisly
    I am based in the uk if you are wondering at WONG DING enterprises and ia am top of my class, understand this carefully this is how good i am
    Once again if you want to rise to the top like this comment