NetTalk Central

Author Topic: SQL and Identitys  (Read 2926 times)

osquiabro

  • Hero Member
  • *****
  • Posts: 687
    • View Profile
    • Email
SQL and Identitys
« on: November 29, 2012, 04:13:28 AM »
which is the best approach for management  Parent/Child with Nettalk and SQL Server.

I needed a form with parent data and childs data but i don't have the parent id, for desktop application i have Super Invoice.

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11244
    • View Profile
Re: SQL and Identitys
« Reply #1 on: November 29, 2012, 06:30:24 AM »
Hi O,

you can use which ever id scheme you prefer for SQL.
Personally I use the "random string" approach - ie I don't auto-number at all. But this is just Clarion code so you can do server-side auto numbering, or client-side auto numbering - there are arguments to be made for both approaches.

cheers
Bruce

osquiabro

  • Hero Member
  • *****
  • Posts: 687
    • View Profile
    • Email
Re: SQL and Identitys
« Reply #2 on: November 29, 2012, 08:30:28 AM »
Bruce, i always use Identity with Sql Server and use superInvoice when need a childs in a form without know the parent id, then after parent inserted the superinvoive capture id and then save a childs, how i can create similar approaches with NTWB.