Thanks
On Thu, 25 Jul 2019 14:09:46 -0600, Guy Algot wrote: > Chip, I just noticed recently that when the SQL option is off on the > server and I try to connect with SQL LOGIN that I get an error -1 vs > a 9918. If you call the following in the IN ERR CALL method ; > > GET LAST ERROR STACK(codesArray;intCompArray;textArray) > > you will see the error you are expecting listed. > > I’m not sure why the difference. > >> On Jul 25, 2019, at 1:16 PM, Chip Scheide via 4D_Tech >> <4d_tech@lists.4d.com> wrote: >> >> I am working up a method to set the primary key property on a field. >> I am using SQL to do this, as it seems the only way. >> >> I have working code, but - I noticed if I try to apply the primary key >> property a second time I get a runtime error either 43 or 44 with the >> message : Failed to execute ALTER TABLE command. >> >> So... naturally I setup an ON ERR CALL method to catch and report the >> problem. However, the error call routine does NOT get either error 43 >> nor 44, it gets error -1!. >> >> If I remove the ON ERR CALL and generate the error, I get a 4D runtime >> error dialog with error 43 or 44, install ON ERR CALL and get error -1. >> >> Any insights? > > > Later, > Guy > > -- > Guy Algot, Solutions Specialist > Edmonton, Alberta > (780) 974-8538 > > hardware, installation, training, support, programming, internet > specializing in 4th Dimension > =-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > "Microsoft is a cross between the Borg and the Ferengi. Unfortunately, > they use Borg to do their marketing and Ferengi to do their programming." > -- Simon Slavin > > > --------------- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************