sir, question.. can i get the exact len of string when quering?
because i have two format in my TransID. The one is the 10digit for the MSAccess and the another is the 11 Digits in my MySql. So if i update all in the MySql database the problm is he read the last transId from the access and add the 1 value that must be only in MySQL transaction..
how can i query the 11digit transID only and add the value.
this is my format in my TransID that i think make me more complecated...
MsAccess = RMI-000000
MySql = RMI-A000000
thxx in advance..