<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<div class="moz-cite-prefix">On 9/1/21 9:29 AM, scooter6--- via
Filepro-list wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CADpQzqOD1k=p8R4WVJLNX6nj5STqYTdsZRM=RCV8zhRkg5_j1A@mail.gmail.com">
<pre class="moz-quote-pre" wrap="">Is there a limit how many characters can be in an import field? This is an
import of a pipe delimited file with about 80 fields, some of which can be
extremely long
</pre>
</blockquote>
<p>Extremely long - how long is that? ;-)</p>
<p>I cannot imagine a limit other than the set size on the fixed
field you are importing into. Any info on this in the fpTech
Docs?</p>
<p>As far as I know, filePro will truncate the excess characters if
you put 999 characters into a field set/defined to a length of 99.</p>
<p>What exactly are you experiencing? Are you getting an error or
truncated values?</p>
<p>In SQL, you normally get an error (if set in strict mode) if you
try to store string length beyond the define field size, not the
case in filepro, filePro drops the excess without any warnings nor
errors.</p>
<p><br>
</p>
<blockquote type="cite"
cite="mid:CADpQzqOD1k=p8R4WVJLNX6nj5STqYTdsZRM=RCV8zhRkg5_j1A@mail.gmail.com">
<pre class="moz-quote-pre" wrap="">
5.6.10R4 on CentOS for clarity
It seems I've encountered an issue with some pretty long import field
lengths - if there is a limit, what is the limit?
thanks all
Scott
PDM
<a class="moz-txt-link-rfc2396E" href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon"><https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon></a>
Virus-free.
<a class="moz-txt-link-abbreviated" href="http://www.avast.com">www.avast.com</a>
<a class="moz-txt-link-rfc2396E" href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link"><https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link></a>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <a class="moz-txt-link-rfc2396E" href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20210901/f56ebb99/attachment.html"><http://mailman.celestial.com/pipermail/filepro-list/attachments/20210901/f56ebb99/attachment.html></a>
_______________________________________________
Filepro-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>
Subscribe/Unsubscribe/Subscription Changes
<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a>
</pre>
</blockquote>
<div class="moz-signature">-- <br>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<title></title>
Jose Lerebours<br>
(954) 559-7186<br>
<theader> </theader>
<table>
<tbody>
<tr>
<td style="vertical-align: top;"><a class="moz-txt-link-freetext" href="https://www.asisuites.com">https://www.asisuites.com</a></td>
<td style="vertical-align: top;"><a class="moz-txt-link-freetext" href="http://www.shipsuites.com">http://www.shipsuites.com</a></td>
<td style="vertical-align: top;"><a class="moz-txt-link-freetext" href="https://www.cargosaas.com">https://www.cargosaas.com</a></td>
<td style="vertical-align: top;"><a class="moz-txt-link-freetext" href="https://www.helpsuites.com">https://www.helpsuites.com</a></td>
</tr>
<tr>
<th style="background-color: #3498db; color: #ffffff;
text-align: center;">ASI Suites</th>
<th style="background-color: #3498db; color: #ffffff;
text-align: center;">Ship Suites</th>
<th style="background-color: #3498db; color: #ffffff;
text-align: center;">CargoSaaS</th>
<th style="background-color: #3498db; color: #ffffff;
text-align: center;">Help Suites</th>
</tr>
</tbody><tbody>
<tr>
<td style="vertical-align: top;">A robust, scalable &
fully integrated application suitable for the most
demanding business environment!</td>
<td style="vertical-align: top;">A load board designed to
give you the flexibility to manage traffic from/to your
warehouse.
<p>B2B UX/UI to allow your trucking partners pick the day
and time they are coming in thus preventing backlog in
your yard.</p>
</td>
<td style="vertical-align: top;">TMS SaaS aimed to transform
the way you do Transportation.
<p>Designed with 3PL and Brokers in mind, this application
has it all, from RFQ to POD.</p>
<p>Need someone to handle your shipping? Give us a call,
we offer very competitive rates!</p>
</td>
<td style="vertical-align: top;">A friendly way to manage
open & closed issues or requests for assistance.</td>
</tr>
</tbody>
</table>
<table padding="0" border="0">
<tbody>
<tr>
<td> </td>
</tr>
<tr>
<td style="background-color: #566573; color: #ffffff;
padding: 12px; font-weight: bolder;">WANTED! If you are
looking for ready to roll out web based application, give
us a call and lets talk about great business opportunity
with no out of pocket investment.</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>