topic Re: Help in Application Development and Automation Discussions

Help

Former Member — Tue, 03 Jul 2007 09:14:57 GMT

Hello Genuis

I m inserting values in database throught screen

i had made a button with SAVE fcode

when 'SAVE'.

select max( empno ) from zsun_emp INTO MM.

MM = MM + 1.

WA_ZSUN_EMP-EMPNO = zsun_emp-empno.

WA_ZSUN_EMP-ENAME = ZSUN_EMP-ENAME.

WA_ZSUN_EMP-DOJ = ZSUN_EMP-DOJ.

WA_ZSUN_EMP-COMM = ZSUN_EMP-COMM.

WA_ZSUN_EMP-SAL = ZSUN_EMP-SAL.

WA_ZSUN_EMP-DEPTNO = ZSUN_EMP-DEPTNO.

INSERT INTO ZSUN_EMP FROM WA_ZSUN_EMP.this code i had written and its giving some error

that error is

"VALUES field.", "CONNECTION ... VALUES field.", "CLIENT SPECIFIED

VALUES field.", or "CLIENT SPECIFIED CONNECTION ..." expected after

"ZSUN_EMP".

please tell me how to solve it

Please reply urgent as i m goin on with that

i m new to Module Pool tooo

With Best Regards

Ruby

Hoping for Quick Reply

Re: Help

Former Member — Tue, 03 Jul 2007 09:16:21 GMT

hi,

U did not give the values extension to the insert statement.Give it and check it ones.

Re: Help

Former Member — Tue, 03 Jul 2007 09:18:58 GMT

Something wrong with syntax, remove INTO and see

INSERT ZSUN_EMP FROM WA_ZSUN_EMP

Keep the Cursor on INSERT keyword and press F1 you will get the help for INSERT

see and correct it

Reward points for useful Answers

Regards

Anji

Re: Help

Former Member — Tue, 03 Jul 2007 09:24:29 GMT

friend

wen i write

INSERT ZSUN_EMP FROM WA_ZSUN_EMP.

then

error comes

The type of the database table and work area (or internal table)

"WA_ZSUN_EMP" are not Unicode convertible. Unicode convertible.

now wats this friend

Ruby

Re: Help

Former Member — Tue, 03 Jul 2007 09:40:10 GMT

for the above error i code like this

INSERT ZSUN_EMP FROM WA_ZSUN_EMP UNICODE ENABLING 'X'. .

but it gives some other error

"." expected after "WA_ZSUN_EMP".

please now tell me how do i solve

Hoping for quick answer

With Best Regards

Ruby

Re: Help

Former Member — Tue, 03 Jul 2007 09:44:03 GMT

declare WA_ZSUN_EMP like zsun_emp. and then insert. one more thing i can not under stand what is the use MM variable here when you are not using it any where. If you are trying to insert the duplicate entries in database then you cannot enter that(i.e duplicate key values).

for avoiding error you can use

INSERT ZSUN_EMP FROM WA_ZSUN_EMP accepting duplicate keys.

here it will not insert your data but it is for just avoiding the error.

regards

shiba dutta

Re: Help

Former Member — Tue, 03 Jul 2007 09:46:31 GMT

friend

i had declared the table

DATA: BEGIN OF WA_ZSUN_EMP OCCURS 0,

EMPNO LIKE ZSUN_EMP-EMPNO,

ENAME LIKE ZSUN_EMP-ENAME,

DOJ LIKE ZSUN_EMP-DOJ,

COMM LIKE ZSUN_EMP-COMM,

SAL LIKE ZSUN_EMP-SAL,

DEPTNO LIKE ZSUN_EMP-DEPTNO,

END OF WA_ZSUN_EMP.

and for mm

DATA: MM LIKE ZSUN_EMP-EMPNO.

now tell how to solve

Hope now u got the problem

With Best Regards

ruby

Re: Help

Former Member — Tue, 03 Jul 2007 09:48:38 GMT

Hi Ruby,

Check with this code.

INSERT <work_area> INTO <internal_table>

INSERT WA_ZSUN_EMP INTO ZSUN_EMP.

Thanks,

Vinay

Re: Help

Former Member — Tue, 03 Jul 2007 09:51:43 GMT

check whether you have declared all the fields of that ztable have you define in the internal table or not ? if not declare all the fields there and check whether you are repeating the key fields in insert or not?

regards

shiba dutta

Re: Help

Former Member — Tue, 03 Jul 2007 09:53:48 GMT

if i go like this

INSERT WA_ZSUN_EMP from ZSUN_EMP .

then error

Field "FROM" is unknown. It is neither in one of the specified tables nor defined by a "DATA" statement. "DATA" statement.

if i go like this

INSERT ZSUN_EMP from WA_ZSUN_EMP.

then error comes

The type of the database table and work area (or internal table)

"WA_ZSUN_EMP" are not Unicode convertible. Unicode convertible.

and if i solve above by

INSERT ZSUN_EMP from WA_ZSUN_EMP UNICODE ENABLING 'X'.

then

error comes

"." expected after "WA_ZSUN_EMP".

Now tell wats the solution

Please for sure as i struct out here.

With Best Regards

ruby

Re: Help

Former Member — Tue, 03 Jul 2007 10:11:24 GMT

Hi Ruby,

Use this code it will execute perfectly.

when 'SAVE'.

select max( empno ) from zsun_emp INTO MM.

MM = MM + 1.

MOVE MM TO ZSUN_EMP-<VARIABLE NAME>.

WA_ZSUN_EMP-EMPNO = zsun_emp-empno.

WA_ZSUN_EMP-ENAME = ZSUN_EMP-ENAME.

WA_ZSUN_EMP-DOJ = ZSUN_EMP-DOJ.

WA_ZSUN_EMP-COMM = ZSUN_EMP-COMM.

WA_ZSUN_EMP-SAL = ZSUN_EMP-SAL.

WA_ZSUN_EMP-DEPTNO = ZSUN_EMP-DEPTNO.

APPEND WA_ZSUN.

INSERT ZSUN_EMP.

IF USEFULL REWARD

Re: Help

Former Member — Tue, 03 Jul 2007 10:27:38 GMT

Friend

i had done

when 'SAVE'.

select max( empno ) from zsun_emp INTO MM.

MM = MM + 1.

MOVE MM TO ZSUN_EMP-empno.

WA_ZSUN_EMP-EMPNO = zsun_emp-empno.

WA_ZSUN_EMP-ENAME = ZSUN_EMP-ENAME.

WA_ZSUN_EMP-DOJ = ZSUN_EMP-DOJ.

WA_ZSUN_EMP-COMM = ZSUN_EMP-COMM.

WA_ZSUN_EMP-SAL = ZSUN_EMP-SAL.

WA_ZSUN_EMP-DEPTNO = ZSUN_EMP-DEPTNO.

APPEND WA_ZSUN_emp.

INSERT ZSUN_EMP.

but its not inserting values in database

errors are removed

Please tell me how could i insert the values

Hoping for earlier and apprpiate answer

With Best Regards

Ruby