Hi Robert
Can it be the [DOCTOR_CODE] ? '10289’ seems odd, should prob. be '10289'
or 10289 depending on field type.
On Jul 5, 2017, at 12:13 PM, 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.
Have a nice weekend //
J Stenberg
Clue AB
**********************************************************************
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]
**********************************************************************
