Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. fredericvandenplas

    insert row into existing table

    I agree with imstillatwork that the table(s) or are wrongly linked or the tables are wrongly designed
  2. fredericvandenplas

    sql problem

    Well i managed it on my own ( only today i succeeded) with this sql. I even had to add some more joins thank you for the reply SELECT main.Idnumber, `Referentie`, `Omschrijving1`As Omschrijving, `Prijs`, `Pk`, `Type`, `Bouwjaar`, `Uren`, `Banden_voor`, `Banden_achter`, ja_neen1.ja_neen1 As...
  3. fredericvandenplas

    insert row into existing table

    if you take care of your ID's yourself, you just could move the the Id's up by adding the number of rows that you want to insert to the Id: UPDATE set newId=ID+NumberOfrowsToInsert Of course if it is a linked table it would give you problems as you would have to update it also to the sub-tables...
  4. fredericvandenplas

    sql problem

    Hello there. I have a form with 5 yes/no dropdown fields. I want to display col1 (yes/no in dutch) or col2(yes/no in french) col3(yes/no in english) my main table has as fields Airco, hydraulics etc... The yes_no has to come from a table as depending on the language choosen i gets col1,col2 or...

Part and Inventory Search

Back
Top