SQL Status: 22001 Error code: -124

[fendy012]

Dear All Need help, im new in this program but im try to learn. i already create one form. but there have problem. when i try to test run. i fill in the form, after that i save error message appears, sorry I'm not good in speaking english, i use goole translate.

SQL Status: 22001
Error code: -124

Value too long in statement [INSERT INTO "PROMOTER PERSONAL PARTICULARS" ( "Birth Date","Brand Name","CA Handphone","CA House Phone","CA Postcode","CA State","Company Name","Counter Name","Current Address","Department Name","Employment Status","Full Name as per IC / Passport ","Gender","Marital Status","NRIC No.","PA Postcode","PA State","Permanent Address") VALUES ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]

Green Tick removed. That icon means 'Solved' and would reduce the chances of a helpful reply. (TheGurkha, Moderator)

[Charlie Young]

I think this thread belongs in the Base forum.

That aside, when you design your table, you have length constraints on the fields (default is 50), which you can see at the bottom of the screen in design view. You will get a "Value too long" error from INSERT INTO if an entry in your VALUES list is too long for the corresponding field.

[fendy012]

oh.. thank you..

I really do not know these things, After I received new information from you I try make new one and it run well but i can not link that form to web, I tried to create a web form data to sql storage. for information storage and servay only in the lan networks.if you can help please give me guidance. tq

example I have my exchange on tables

[Charlie Young]

oh.. thank you..

I really do not know these things, After I received new information from you I try make new one and it run well but i can not link that form to web, I tried to create a web form data to sql storage. for information storage and servay only in the lan networks.if you can help please give me guidance. tq

example I have my exchange on tables

This is not something I know at all well, and since it's really a different question, you should start a new thread, and maybe some of our Base wizards will chime in.

Does this help at all?