Re: Text Utility

[David Adams via 4D_Tech]

On Fri, Jul 7, 2017 at 10:44 AM, John DeSoi via 4D_Tech <
4d_tech@lists.4d.com> wrote:
>I'm still using the LCS code you published years ago. Thanks very much for
that.

My pleasure. I really love fuzzy matching...it makes it hard to sleep just
thinking about it...currently diving into some other stuff that may lead to
better tools and techniques. Not sure how well they'll work in 4D given
it's lack of a whole bunch of math tools...but 4D is *fantastic* for
pulling in data, tweaking it, and then spitting it out in whatever format
you need. It's my go-to tool for that, for sure.

> If anything useful comes out of my exploration of trigrams, I'll try to
do the same.

That would be great! The research on it is solid so I know it _should_ work
well. I just never got it wired in correctly in 4D.
**
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:4d_tech-unsubscr...@lists.4d.com
**

Re: Text Utility

[John DeSoi via 4D_Tech]

Hi David,

Funny you mention this as I was working on it today. I have been using 
PostgreSQL's pg_trigram for years and had the interest to implement this in 4D. 
The code to create n-grams is pretty simple. Putting trigrams in a keyword 
indexed text field makes it super fast to find matches. The main problem seems 
to be finding too many matches. Scoring the results is a lot less efficient 
than finding the candidates. Still looking into it.

I'm still using the LCS code you published years ago. Thanks very much for 
that. If anything useful comes out of my exploration of trigrams, I'll try to 
do the same.

John DeSoi, Ph.D.



> On Jul 6, 2017, at 6:17 PM, David Adams via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Next up the complexity chain is n-gram comparison (sometimes called q-gram
> comparison, for no clear reason.) N-gram is a confusing term now because
> historically it meant "strings of a certain length", like take a word and
> break it into 3-character strings. n=3. 3 is a good length, based on
> research. It's confusing now because Google's public n-gram data sets and
> tools are based on proximate words, not strings. Anyway, n-gram analyses is
> very powerful and proven tech...but I've failed to get great results in 4D.
> It could very well be me...I haven't had enough time/attention to ever
> really dive into this in recent years.

**
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:4d_tech-unsubscr...@lists.4d.com
**

Re: Text Utility

[David Adams via 4D_Tech]

Robert,

Thanks for posting full code for a cool algorithm, a good example for the
rest of us on the list. Levenshtein distance (aka "edit distance") is
great! The short definition is that it measure the total number of
substitutions required to convert one string into another. There are some
subtle differences in final implementation, but it doesn't make a huge
difference in output.  If you like this sort of stuff, there are at least
three tech notes from 2004 (or around then that include background
information and native 4D code for Levenshtein distance, Longest Common
Substring, Soundex, Metaphone and some other stuff, if I remember correctly:

Optimizing Fuzzy Searching
http://kb.4d.com/assetid=46210

Fuzzy Tools Component
http://kb.4d.com/assetid=43020

Fuzzy Matching in 4th Dimension
http://kb.4d.com/assetid=42939

Note: The WordList experiment in there just didn't work. Ignore it.

More recently, I think there was a presentation on calling PHP with LAUNCH
EXTERNAL PROCESS to leverage PHP fuzzy matching libraries.

I also think Miyako has implemented several related algorithms as a
plug-in. Can someone offer a link?

But back to your question about Levenshtein and alternatives. First off,
there are some very advanced ways to convert strings to points to vectors
that can then be analyzed with vector math. I know enough to say that, but
that's where I stop. For very large corpus analysis, there are a lot of
full text tools - that world has exploded, but it's not really anything
like the traditional record linkage universe.

There are a few ways to slice up simpler tools like Levenshtein.
Levenshtein is fantastic and it is often exactly what is used in
spell-checkers. This is how they can come up with suggestions for novel
words that it can't possibly have cataloged. And, as we've all probably
noticed, the suggestions may not share common first letters or stems. It's
magic. The edit distance is a mathematical relationship between two
strings, it isn't biased by the contents of the strings - any two strings
can be compared.

With Levenshtein, you're always comparing two strings, which means there's
no way to take a string and store its Levenshtein "score". Score against
what? It's a comparison. This is in contrast to something like Soundex
where a string is recoded into a kind of abbreviation. That you can
pre-calculate, store, and index. Soundex and every other trivial phonemic
translation "algorithm" (cough-cough) I've ever seen basically suck...but
also seem to do a remarkably good job. If you've got a lot of data, they
can be helpful for doing a quick cut ("blocking") on the data. Soundex was
pretty state-of-the art when it was invented by the US Census Bureau...for
the 1900 census (if I remember correctly.) Speaking of the US Census,
that's a very prestigious place for a statistician to work and they're
serious people. The Jaro-Winkler set of comparison algorithms were
developed and tuned there specifically for matching surnames. Similarity is
scored as a percentage expressed in a value in the range 0-1. These
algorithms are first-letter biased, so they aren't as good at matching
random strings. But for last names? They're kind of amazing. (See the tech
notes above for code and more background.)

Longest Common Subsequence is another great one. I adapted an example from
one of the tech notes above (dang, I forgot how long they were...months of
work...loved it)

A third strategy for comparing two strings, or streams of bytes, is called
Longest Common Subsequence, or LCS. This technique is commonly used to
compare DNA sequences. This approach is somewhat similar to finding the
longest matching substring. For example, imagine these two strings:

John Anderson
Jon Anderrsen

If you are finding the longest matching substring, you end up with  "Ander"
- the longest string of perfectly matching characters. That's 5 characters
out of 13, which doesn't look like much of a match. Converted to a
percentage, that's a similarity of a bit over 38%. Just from looking at the
strings, the score seems too low. The LCS algorithm, implemented in
FuzzyTools's Fuzzy_GetLCSLength routine, finds the longest common
*subsequence* instead of the longest substring. The difference is that a
subsequence ignores non-matching intervening characters. So, in comparing
"Jon Anderrsen" to " John Anderson", the pattern highlighted below
registers as a match

John Anderson Jon Anderrsen
Notice that Jon and John match because the characters J-o-n appear, in
order, within J-o-h-n. The h in John is simply ignored as a junk character.
The longest matching subsequence, then, is 11 characters long (Jon
Andersn), giving us a similarity percentage of roughly 85%. This score
agrees much more closely with how a human would rank the two strings.

...there's a bunch of formatting in the note which makes the example easier
to understand.

The downside with all of the approaches above is that they require live
comparisons and can't normally be 

Re: revelation! - Choose

[Sujit Shah via 4D_Tech]

I swear I was the first one to invent this...

:-))

Good one!

On Fri, Jul 7, 2017 at 2:45 AM, Chip Scheide via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Thanks to code from Robert Livingston
> I found out about a command I had not known about
> Choose
>
> I love this command
> if anyone does not know about it - read it is so nice to do in  one
> line of code what other wee takes at least5
>
> Chip
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing
> **
> 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:4d_tech-unsubscr...@lists.4d.com
> **




-- 

xxx
"There must be ingenuity as well as intention, strategy as well as
strength. "
**
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:4d_tech-unsubscr...@lists.4d.com
**

Re: Request : Text utilities

[Alan Chan via 4D_Tech]

Thanks. It's good to know.

Alan Chan

4D iNug Technical <4d_tech@lists.4d.com> writes:
>Well observed. Aussies can be *way* to polite to tell someone when they're
>being rude, so, yeah, they might not complain about a little thing that
>they can live with.

**
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:4d_tech-unsubscr...@lists.4d.com
**

Re: Request : Text utilities

[David Adams via 4D_Tech]

> Are these acceptable by Australian?
Better ask a life-long native that was around when these formats came into
play.

> So far, we haven't got any complaint (may be they're too nice to say
anything).

Well observed. Aussies can be *way* to polite to tell someone when they're
being rude, so, yeah, they might not complain about a little thing that
they can live with.


On Fri, Jul 7, 2017 at 2:05 AM, Alan Chan via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> We have been formatting Australia phone number like
>
> (2) 3456 7899
> 434 567 899
>
> Are these acceptable by Australian? So far, we haven't got any complaint
> (may be they're too nice to say anything).
>
> TIA
>
> Alan Chan
>
> 4D iNug Technical <4d_tech@lists.4d.com> writes:
> >Note that local custom varies. For example, Australia has two digit area
> >codes, like 02, 03, 04 and so on. But 04 is special...all mobile phones
> >start with 04. Land lines are normally written like this:
> >
> >02 3456 7899
> >
> >Mobiles are normally (but not invariably) written like this:
> >
> >0434 567 899
>
> **
> 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:4d_tech-unsubscr...@lists.4d.com
> **
>
**
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:4d_tech-unsubscr...@lists.4d.com
**

Re: revelation! - Choose

[Chip Scheide via 4D_Tech]

I only memorized the command from v1 after all who needs all those new 
fangled add ons   :)

On Thu, 6 Jul 2017 14:56:43 -0400, Chuck Miller via 4D_Tech wrote:
> You mean you have not memorized all the commands. I am depressed and 
> disappointed in you. 
> 
> Chuck
> 
> Sent from my iPhone
> 
>> On Jul 6, 2017, at 12:45 PM, Chip Scheide via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> Thanks to code from Robert Livingston
>> I found out about a command I had not known about
>> Choose
> 
> **
> 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:4d_tech-unsubscr...@lists.4d.com
> **
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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:4d_tech-unsubscr...@lists.4d.com
**

Re: revelation! - Choose

[Chuck Miller via 4D_Tech]

You mean you have not memorized all the commands. I am depressed and 
disappointed in you. 

Chuck

Sent from my iPhone

> On Jul 6, 2017, at 12:45 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Thanks to code from Robert Livingston
> I found out about a command I had not known about
> Choose

**
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:4d_tech-unsubscr...@lists.4d.com
**

Re: revelation! - Choose

[Jeremy Roussak via 4D_Tech]

Yes, Choose is a very useful command. I’d been using it for some time before I 
realised that the first argument need not be boolean but can be integer, 
allowing selection from a list. 

Jeremy


Jeremy Roussak
j...@mac.com



> On 6 Jul 2017, at 17:45, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Thanks to code from Robert Livingston
> I found out about a command I had not known about
> Choose
> 
> I love this command
> if anyone does not know about it - read it is so nice to do in  one 
> line of code what other wee takes at least5
> 
> Chip
**
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:4d_tech-unsubscr...@lists.4d.com
**

Emails sent from 4DIC showing garbage in Mac Outlook

[Tony Ringsmuth via 4D_Tech]

Since upgrading a 4D system from v15 to v16, some automated emails that I send 
out of that 4D system are showing garbage characters in Mac Outlook - after the 
first couple of lines.

Like this:
First line of Body
Second line of Body
Th`���٥��́ѥ���51���Mх}
�ѕ|���ܴ�ش�""�����G�@��7E

Anyone else seeing this?

TIA,







**
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:4d_tech-unsubscr...@lists.4d.com
**

revelation! - Choose

[Chip Scheide via 4D_Tech]

Thanks to code from Robert Livingston
I found out about a command I had not known about
Choose

I love this command
if anyone does not know about it - read it is so nice to do in  one 
line of code what other wee takes at least5

Chip
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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:4d_tech-unsubscr...@lists.4d.com
**

Re: Request : Text utilities

[Alan Chan via 4D_Tech]

We have been formatting Australia phone number like

(2) 3456 7899
434 567 899

Are these acceptable by Australian? So far, we haven't got any complaint (may 
be they're too nice to say anything).

TIA

Alan Chan

4D iNug Technical <4d_tech@lists.4d.com> writes:
>Note that local custom varies. For example, Australia has two digit area
>codes, like 02, 03, 04 and so on. But 04 is special...all mobile phones
>start with 04. Land lines are normally written like this:
>
>02 3456 7899
>
>Mobiles are normally (but not invariably) written like this:
>
>0434 567 899

**
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:4d_tech-unsubscr...@lists.4d.com
**

Re: SQL

[Charles Miller via 4D_Tech]

great eyes. I think you have it as the apostrophes are different. One is
different than the other.
regards

chuck

On Thu, Jul 6, 2017 at 3:34 AM, Jerker Stenberg via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> 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 <
>> 4d_tech@lists.4d.com> 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:4d_tech-unsubscr...@lists.4d.com
> **




-- 
-
 Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064
 Informed Solutions, Inc.
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D, Sybase & SQL Sever connectivity
  http://www.informed-solutions.com
-
This message and any attached documents contain information which may be
confidential, subject to privilege or exempt from disclosure under
applicable law.  These materials are intended only for the use of the
intended recipient. If you are not the intended recipient of this
transmission, you are hereby notified that any distribution, disclosure,
printing, copying, storage, modification or the taking of any action in
reliance upon this transmission is strictly prohibited.  Delivery of this
message to any person other than the intended recipient shall not
compromise or waive such confidentiality, privilege or exemption
from disclosure as to this communication.
**
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:4d_tech-unsubscr...@lists.4d.com
**

Re: Request : Text utilities

[Chip Scheide via 4D_Tech]

it could be useful.  I have used renamer (or something similar - don't 
remember the name) on occasion.
I don t know that I want to get as involved as that app, but a simple 
file renamed utility could be done.


Which feature(s)? I think:
allow
- Drag n drop a selection of files or folders
or
-open/select dialog to select 1 or more files or folders

-add an extension to all (changing the existing one if there dis one)
-add a '_- plus a number
-replace an existing (filename portion) string with something else 
(including "")
-replace filename with a base string + number
-add a date
-upper/lower case file name
-variations on CamelCase file names
-insert specified character(s) at specified location


On Wed, 5 Jul 2017 19:44:59 -0400, David Eddy via 4D_Tech wrote:
> Chip -
> 
> On Jul 05, 2017, at 3:00 PM,  Chip Scheide <4d_o...@pghrepository.org 
> > wrote:
> 
>> I am looking for ideas/code for text utilities that you might be using.
> 
> 
> I found Renamer from http://incrediblebee.com 
>  to be very useful.
> 
> Price was right… able to use it on the fly.  Good experience.  Did 
> exactly what I needed.
> 
> 
> Might be useful inside a 4D app.
> 
> 
> David Eddy
> Babson Park, MA
> 
> de...@davideddy.com
> 
> **
> 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:4d_tech-unsubscr...@lists.4d.com
> **
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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:4d_tech-unsubscr...@lists.4d.com
**

Re: Request : Text utilities

[Chip Scheide via 4D_Tech]

really?
I thought the special needs of Auzzies was related to ALCOHOL INTAKE  :)

On Thu, 6 Jul 2017 09:44:40 +1000, Wayne Stewart via 4D_Tech wrote:
>> Note that local custom varies. For example, Australia
> 
> Australian's have special needs, it's due to our convict past.
> 
> 
> Regards,
> 
> Wayne
> 
> 
> [image: --]
> Wayne Stewart
> [image: http://]about.me/waynestewart
> 
> 
> 
> On 6 July 2017 at 07:23, David Adams via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> 
>> On Thu, Jul 6, 2017 at 1:28 AM, Chip Scheide via 4D_Tech <
>> 4d_tech@lists.4d.com> wrote:
>> 
>>> 
>>> Things I know I need :
>>> - Phone # formatting, to include various (non-US) formats -- most of
>> which
>>> I do not know
>>> 
>> 
>> That's a huge subject, and there are services out there for it. A couple of
>> quick links if you want to start from scratch:
>> 
>> https://support.twilio.com/hc/en-us/articles/223183008-
>> Formatting-International-Phone-Numbers
>> https://en.wikipedia.org/wiki/National_conventions_for_
>> writing_telephone_numbers
>> 
>> Note that local custom varies. For example, Australia has two digit area
>> codes, like 02, 03, 04 and so on. But 04 is special...all mobile phones
>> start with 04. Land lines are normally written like this:
>> 
>> 02 3456 7899
>> 
>> Mobiles are normally (but not invariably) written like this:
>> 
>> 0434 567 899
>> 
>> So, 2-4-4 versus 4-3-3.Or not.
>> **
>> 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:4d_tech-unsubscr...@lists.4d.com
>> **
>> 
> **
> 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:4d_tech-unsubscr...@lists.4d.com
> **
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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:4d_tech-unsubscr...@lists.4d.com
**

Re: Request : Text utilities

[Chip Scheide via 4D_Tech]

Thanks for the links and info

On Thu, 6 Jul 2017 07:23:51 +1000, David Adams via 4D_Tech wrote:
> On Thu, Jul 6, 2017 at 1:28 AM, Chip Scheide via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> 
>> Things I know I need :
>> - Phone # formatting, to include various (non-US) formats -- most of which
>> I do not know
>> 
> 
> That's a huge subject, and there are services out there for it. A couple of
> quick links if you want to start from scratch:
> 
> 
https://support.twilio.com/hc/en-us/articles/223183008-Formatting-International-Phone-Numbers
> 
https://en.wikipedia.org/wiki/National_conventions_for_writing_telephone_numbers
> 
> Note that local custom varies. For example, Australia has two digit area
> codes, like 02, 03, 04 and so on. But 04 is special...all mobile phones
> start with 04. Land lines are normally written like this:
> 
> 02 3456 7899
> 
> Mobiles are normally (but not invariably) written like this:
> 
> 0434 567 899
> 
> So, 2-4-4 versus 4-3-3.Or not.
> **
> 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:4d_tech-unsubscr...@lists.4d.com
> **
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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:4d_tech-unsubscr...@lists.4d.com
**

Re: SQL

[Jerker Stenberg via 4D_Tech]

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 
<4d_tech@lists.4d.com> 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:4d_tech-unsubscr...@lists.4d.com
**