HI all,

I am trying to insert a new record into a table and got the following
error message

ODBC Error: SQLSTATE = S1000, Native error code = -4977
The data buffer parameter is too short(Btrieve Error 22)

Here is the query I am using.
insert into amgr_user_fields_tbl values
('123456789012345678901234',0,38,0,0,
'2003-11-01',0.0,
'1234567890123456789012345678901234567890123456789 01234567890123456789012345678901234567890123456789 012345678901234567890',
'123456789012','2003-12-10','16:18:13','1234')

Here is the table defination
create table tbl_test(
client_id char(24) not null,
contact_number usmallint not null,
type_id usmallint not null,
code_id usmallint not null,
last_code_id usmallint not null,
datecol date not null,
numericcol double not null,
alphanumbericcol char(120) not null,
creator_id char(12) not null,
create_date date not null,
create_time time not null,
mmdddate char(4) not null)

Could somebody please help me to correct the insert query? Please
provide me a sample .

Thanks in advance.

I ran the Create Table, and the subsequent Insert failed with an invalid table. When I changed the table name in the INSERT
query to tbl_test, it worked just fine. Which version (and patch rev) of Pervasive.SQL are you running?
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: March, 2004: See our web site for details!

MailSurfer wrote: