This is my own writing code don't know what is wrong for help
Real a, b, c, d, e, f, k, l
A=real (sle_3. Text)
B=real (sle_4. Text)
C=real (sle_5. Text)
D=real (sle_6. Text)
L=real (sle_2. Text)
E=0.45 * (b - a)
F=0.88 * (d - c)
K=real (sle_1. Text)
Char g
G=sle_7. Text


INSERT INTO charging center (charging center. Room code, charging center. Project cost, charging center. Charge amount)
Values (' g ', 'basic charge', 'l')
Insert into charging center (charging center. Room code, charging center. Project cost, charging center. Cost date, charging center. Charge amount)
Values (' g ', 'water', e ')
Insert into charging center (charging center. Room code, charging center. Project cost, charging center. Cost date, charging center. Charge amount)
Values (' g ', 'electricity', 'f')
Insert into charging center (charging center. Room code, charging center. Project cost, charging center. Cost date, charging center. Charge amount)
Values (' g ', 'maintenance', 'm')

CodePudding user response:

1. Pb code should fill the blank space on both ends of the minus sign, 2. Insert the columns in the insert statement and values are not corresponding, insert four items, and paid the value only to the third phase,

CodePudding user response:

INSERT INTO charging center (charging center. Room code, charging center. Project cost, charging center. Charge amount)
Values (: g, 'basic charge', : l);
After the article of the SQL should have; , variable reference: g is not a 'g'
The last to submit to save

commit;

CodePudding user response:

You there are a few errors in grammar:
1. Insert statement format is wrong:
Insert into table_name (column1, column2,... , columnn) values (v1, v2,... ,.vn)
This is a standard SQL insert statement
2. PB, referenced in the SQL statement at the end of statements in a ";" Line number, such ability
3. The SQL statements variable reference ":" prefix to be used in the
4. Insert the equal value or total number of variables and the number of fields, and the same type
Useful commit; 5. To submit the transaction
Your statement should write:
INSERT INTO charging center (charging center. Room code, charging center. Project cost, charging center. Charge amount)
Values (: g, 'basic charge, : l)

CodePudding user response:

You there are a few errors in grammar:
1. Insert statement format is wrong:
Insert into table_name (column1, column2,... , columnn) values (v1, v2,... ,.vn)
This is a standard SQL insert statement
2. PB, referenced in the SQL statement at the end of statements in a ";" Line number, such ability
3. The SQL statements variable reference ":" prefix to be used in the
4. Insert the equal value or total number of variables and the number of fields, and the same type
Useful commit; 5. To submit the transaction
Your statement should write:

INSERT INTO charging center (charging center. Room code, charging center. Project cost, charging center. Charge amount)
Values (: g, 'basic charge', : l);

commit;

CodePudding user response:

The original poster is too careless

CodePudding user response:

Alas,,,,

CodePudding user response:

With the fourth floor

CodePudding user response:

Said on the fourth floor of the detailed and clear!

CodePudding user response:

The sqlca. The autocommit=true; Is ok,

CodePudding user response:

Catch up with the grammar!

CodePudding user response:

Friendship under the roof

CodePudding user response:

The building Lord really careless, ha ha, help you under the roof

CodePudding user response:

The original poster to be careful