Page 1 of 1
Posting a string with a leading zero
Posted: Tue Jun 01, 2010 12:37 pm
by wrothman@dealermagic.net
We are sending csv string with 8 digits. When the leading number is a zero, the simple database ignores the zero and posts 7 digits to the table. How can this be corrected. Our eight digit number is random.
Re: Posting a string with a leading zero
Posted: Tue Jun 01, 2010 2:55 pm
by support
Hi,
Would it be possible to generate an 8-digit number between 10000000 and 99999999?
Our simple db does not preserve leading zeroes so a number like 00001111 would drop the first four zeroes.
Another way you could work around this issue is to prepend your 8 digit number with a letter such as A00123456.
Hope this helps.
Regards,
Plum Support