The site is running v11, and communicates with the other system by SQL. Been working this way for over 5 years.
All SQL activity happens on a Mac Server via the triggers. The error: SQL Error 9900 USE Medflow; UPDATE [dbo].[MF_DOCTORS] SET [DOCTOR_NAME] = 'Grada, Atel ', [DOCTOR_ADDRESS1] = 'Po Box 2005', [DOCTOR_ADDRESS2] = '', [DOCTOR_CITY] = 'Corner Brook', [DOCTOR_STATE] = 'NL', [DOCTOR_ZIP] = 'A2H 6J7', [DOCTOR_PHONE] = ' 709 637-5000 ext 5524', [DOCTOR_TYPE] = '', [DOCTOR_PRINT_NAME] = 'Atel Grada, MD', [DOCTOR_FAXNO] = ' 709 637-5124', [DOCTOR_EMAIL] = '', [DOCTOR_SPECIALTY] = '', [STATUS] = 'A' WHERE [DOCTOR_CODE] = '10289’; I’m wondering if it is the phone number with ‘ext’ in it. I’ll login later tonight and remove it and see what happens. > On Jul 5, 2017, at 1:39 AM, Pat Bensky via 4D_Tech <[email protected]> > wrote: > > Robert, > I remember seeing that when I was working on a SQL project a while back, > but can't remember the details :) If you can describe what you are doing > when you get the error, perhaps that will jog my memory ... > > Pat > > On 5 July 2017 at 06:22, Robert McKeever via 4D_Tech <[email protected]> > wrote: > >> Anybody know what an error 9900 is when dealing with SQL? >> >> _________________________________________ >> Bob McKeever http://www.mswl.com < >> http://www.mswl.com/> >> McKeever's Software Wizardry >> Port Coquitlam, B.C. >> [email protected] >> >> >> >> >> ********************************************************************** >> 4D Internet Users Group (4D iNUG) >> FAQ: http://lists.4d.com/faqnug.html >> Archive: http://lists.4d.com/archives.html >> Options: http://lists.4d.com/mailman/options/4d_tech >> Unsub: mailto:[email protected] >> ********************************************************************** > > > > > -- > ************************************************* > CatBase - Top Dog in Data Publishing > tel: +44 (0) 207 118 7889 > w: http://www.catbase.com > skype: pat.bensky > ************************************************* > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** _________________________________________ Bob McKeever http://www.mswl.com <http://www.mswl.com/> McKeever's Software Wizardry Port Coquitlam, B.C. [email protected] ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
