[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

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

Adding to Dwain's suggestion- 
 
Also do a show statement on the values coming out of the flat file, and  take 
those values and the SQL from the program and do an insert into the  database 
directly.  I ahve found a couple of times that the data may have  an extra 
comma in it (like a comma in a name) or the data is in the wrong order  I am 
expecting it.  Doing this helps track down where the issue is.  
 
Also, it may not be the entire file you are having trouble with, but maybe  
just one line?  If you put the show statement as part of an on-error  command 
you will see the data that is actually causing the error.
 
Denise

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