what is the meaning of this error?

process 7 - Fatal error : Error 205 (out of range) on tdsls400111 in db_insert(51)

Iam trying to insert, and iam sure that all the fields has a value.

db.insert(ttdsls400,db.retry)
commit.transaction()

And what is the meaning of (51)? is it a field?

Help pls

Check the followings
1. All mandatory fields are assigned with value. No field is left over.

2. All the values matche with the domain/datatype of the fields.

-Ganesh

Thanks i already figure it out :), i have a wrong format with my date.:D

Dear Experts..

I still facings the same issue.. with Fatal Error 205 for tiasc7240m000

Please advise. Thanks.

Hi abpbaan,

Please check that you have given the proper inputs e.g. check if the input is int but you giving as double or float, check for date fields.

Dear Nick,

Thanks for replying.. I don't know what causing this.. as the date format already per-formatted in the session itself.

Any advise where I can move forward to resolve the issue?

Hi Abpbaan,

You can try following

1. If you are using table fields, view the table data using ttaad4500, use Shift+* to view the data type, then tally the data you are entering, if the data having any mismatch with what you have entered.
2. If you are using form fields, go to session ttaad3500m000 Forms (Not Sure if you will have access to) in that select your form and VRC Combination and from specific menu choose form fields, Here you will be able to view filed name <--> Data Type, Then tally what you are entering with this.

I think there is mismtach of data type with the information you are entering...

Check if this helps.

Thanks
Nick

Hello all,i insert data's from csv file to baan table ,while doing that ,i got a error
error 205 out of range (tccom9511m000) in db.insert...
this was my code,
choice.add.set:
before.choice:
string sname(50),fname(50),buf(1000)
long fpo
extern domain tcid p
extern domain tcid r
extern domain tcname q
fname = "C:\karthik\aaa.csv"
fpo = seq.open(fname,"r")
while(seq.gets(buf,1028,fpo) = 0)
string.scan(buf,"%d,%s,%d",p,q,r)
message("%s",buf)
message(" %s %s %s ",p,q,r)
tccom911.id = p
|display("tccom911.id")

tccom911.name = q
|display("tccom911.name")
tccom911.rate = r
|display("tccom911.rate")
db.insert(ttccom911,db.retry)
commit.transaction()
message(" %s -- %s --%s",tccom911.id,tccom911.name,tccom911.rate)
endwhile
seq.close(fpo)


pls post quick reply,thanks in advance...

Hello all,i insert data's from csv file to baan table ,while doing that ,i got a error
error 205 out of range (tccom9511m000) in db.insert...
this was my code,
choice.add.set:
before.choice:
string sname(50),fname(50),buf(1000)
long fpo
extern domain tcid p
extern domain tcid r
extern domain tcname q
fname = "C:\karthik\aaa.csv"
fpo = seq.open(fname,"r")
while(seq.gets(buf,1028,fpo) = 0)
string.scan(buf,"%d,%s,%d",p,q,r)
message("%s",buf)
message(" %s %s %s ",p,q,r)
tccom911.id = p
|display("tccom911.id")

tccom911.name = q
|display("tccom911.name")
tccom911.rate = r
|display("tccom911.rate")
db.insert(ttccom911,db.retry)
commit.transaction()
message(" %s -- %s --%s",tccom911.id,tccom911.name,string.scan()


Hello,

string.scan()
Syntax:
function long string.scan (string value, string format [, void ...])

Description
This scans an input string ( value) for one or more fields and stores each individual field found in the first available variable argument. The format argument contains conversion symbols that the function uses to interpret the input string and retrieve the individual field values. The conversion symbols indicate the types of values expected:

%s expects a single-byte or multibyte string
%f expects a double
%d expects a long


I think tccom911.rate is type double.
Is >extern domain tcid r< also double ?
Otherwise use tcmcs.double

Take care of proper assignments.


string.scan(buf,"%d,%s,%d",p,q,r)

---> Long, String, Long is this right ?

Regards

Hello Mr.bdittmar:),
i had a mistake in extracting the heading of csv file,that will not store in long and string variables that's why ,i am getting error ,this was the problem...
Thank you ....