Jump to content
Sign in to follow this  
jroths

FM--SQL Integration...The CR/LF problem

Recommended Posts

The Carriage Return/Line Feed character that may be embedded in a field by the user, or as a FM text calculation are not represented "as intended" when FM data is "pushed" to a SQL server. In examining the "pushed" data using Ms Access, all the original CR/LFs are represented by "boxes", and no CR/LF actually occurs, so the text is a continuous string. This occurs whether developed on Macs or Windows and whether the client is on a Mac or Windows box.

Does the solution to this problem lie entirely on the SQL side? In other words, does the IT guy the runs the SQL server have to invent his own parser/translater in order to represent the data correctly to their users? Or is their a way to do it on the FM side (without creating an intermediate exported text file)?

Any help would be appreciated,

John Roths

Texas A&M Univ.

jroths@cvm.tamu.edu

Share this post


Link to post
Share on other sites

Well it is really just an issue of replacing the character. This can either be done on the SQL backend or on the Filemaker end. Grab the proper SQL Server and store it in the clipboard, then go into Filemaker and make calculated versions of the fields that this problem is occuring in and use the following calculation in them: Substitute ( FieldName, "

Share this post


Link to post
Share on other sites

This previous calculation tip is also very useful, if you have to store field in JavaScript variable.

Obviously the JS is interpreting the "

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.