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 <[email protected]> > 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 ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
