RE: [sqr-users] Data truncated during update from flat file

[kristy.engelkes@rsmi.com]

We have had this happen a few times.  It was due to the mdac being 
incorrect, out-of-sync, or some type of problem.  After updating the mdac, 
it then worked correctly.  This definitely sounds like the same type of 
problem.




"Amber S" <amber_sqr@yahoo.co.uk>
Sent by: 
sqr-users-bounces+kristy.engelkes=rsmi.com@sqrug.org
10/12/2004 11:54 AM

Please respond to "This list is for discussion about the SQR database 
reporting language from Hyperion Solutions." 

 
        To:     "This list is for discussion about the SQR database reporting 
language 
from Hyperion Solutions." <sqr-users@sqrug.org>
        cc: 
        Subject:        RE: [sqr-users] Data truncated during update from flat 
file


I have tried the same with '~' as well, still the same
problem

 --- "Lynds,Rick" <rlynds@mwdh2o.com> wrote: 
> UNSTRING is a very literal command.  It will split
> on the specified
> delimiter character regardless of where quote marks
> make occur in the input
> string.  If any of your input fields have the
> remotest possibility of
> containing commas, you may want to use a more
> sophisticated method of
> parsing your flat-file input data.
> 
> Rick
> 
> -----Original Message-----
> From: sqr-users-bounces+rlynds=mwdh2o.com@sqrug.org
>
[mailto:sqr-users-bounces+rlynds=mwdh2o.com@sqrug.org]On
> Behalf Of Amber
> S
> Sent: Tuesday, October 12, 2004 9:19 AM
> To: This list is for discussion about the SQR
> database reporting
> language from Hyperion Solutions.
> Subject: RE: [sqr-users] Data truncated during
> update from flat file
> 
> 
> Yes, I am using a csv file and also assigning to
> variables using the unstring command, there is
> nothing
> in the csv file that should cause this, as I
> mentioned
> earlier, the Show command displays the complete
> variable
> 
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 


 
 
 
___________________________________________________________ALL-NEW Yahoo! 
Messenger - all new features - even more fun!  http://uk.messenger.yahoo.com

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users