if '[4.6.50' $ oAppObj.DbVersionI think having some boolean property will be better than repeat this condition in various methods - but I am stuck on naming the property :(
insert into i_vendor (full_name, Contact, address, address2, ; City, State, Zip, E_mail, area_code, Phone, ; check_bx1, check_bx2, check_bx3, check_bx4, check_bx5, ; number_1, number_2, number_3, number_4, number_5, ; text_1, text_2, text_3, text_4, text_5, ; date_1, datetime_1, memo_1, operator, salespoint, date_time, ExternalID) ; values (csrVendors.full_name, csrVendors.Contact, csrVendors.address, csrVendors.address2, ; csrVendors.City, csrVendors.State, csrVendors.Zip, csrVendors.Email, csrVendors.area_code, csrVendors.Phone, ; inlist(proper(csrVendors.check_bx1),'Yes','1','True','T'), ; inlist(proper(csrVendors.check_bx2),'Yes','1','True','T'), ; inlist(proper(csrVendors.check_bx3),'Yes','1','True','T'), ; inlist(proper(csrVendors.check_bx4),'Yes','1','True','T'), ; inlist(proper(csrVendors.check_bx5),'Yes','1','True','T'), ; csrVendors.number_1, csrVendors.number_2, csrVendors.number_3, csrVendors.number_4, csrVendors.number_5, ; csrVendors.text_1, csrVendors.text_2, csrVendors.text_3, csrVendors.text_4, csrVendors.text_5, ; csrVendors.date_1, csrVendors.datetime_1, csrVendors.memo_1, oAppObj.OpCode, ; oAppObj.salespoint, datetime(), csrVendors.ExternalID) thisform.nInserted = thisform.nInserted + 1Now I need to insert into multiple tables, but how would I get the autoincremented Ids without actually saving the info first? Should I probably generate SQL script here instead?