NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: osquiabro on November 29, 2012, 04:13:28 AM

Title: SQL and Identitys
Post by: osquiabro 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.

Title: Re: SQL and Identitys
Post by: Bruce 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

Title: Re: SQL and Identitys
Post by: osquiabro 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.