-
Feb 26th, 2018, 10:55 AM
#1
Thread Starter
Member
error when save to mysql data
i am build finger print scanner aplication that already have sample code in vb 6 and database msaccess , field to save finger template is "long text" type
command to save is :
DIM RegTemplate AS STRING
RS2.Open "Select * from TABLE", Conn, adOpenDynamic, adLockOptimistic
RS2.AddNew
RS2.Fields("Finger") = RegTemplate
RS2.Update
its work fine
but when i migrate database to mysql and trying use field as "long text" type too when trying save data with same command its says error mysql error multiple....
my sql connection is no problem with my application, only this field have problem
this is my msaccess data display,i dont know why this data type is only shown data in column only when i click the column, if my mouse leave focus fcolumn, its just show first character
any solution how to save this data type y friend?i believe this is incompatible data field type in mysql
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|