Could it be the value for the [DOCTOR_NAME] and/or the [DOCTOR_PRINT_NAME] fields, as they seem to contain the ‘comma’ character, and the code seems to also be using the ‘comma’ character as a field delimiter.
Wendell Turner ------------------------------------------------ p:= +44(0)7403 524010 e: [email protected] "There is a profound difference between doing things right and doing the right things." ------------------------------------------------ > On 5 Jul 2017, at 17:13, Robert McKeever via 4D_Tech <[email protected]> > wrote: > > 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] > ********************************************************************** ********************************************************************** 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] **********************************************************************
