| Re: connect item to DB manually [message #79892] |
Mon, 22 July 2002 00:33  |
kat
Messages: 15
Registered: February 2000
|
Junior Member |
|
|
Hi !
I think you talk about forms6i, do you?
Ok, then you have to put the value of the item (e.g. text item) into a variable:
variable := :datablock.itemname;
...then you have to put the value of the variable into the DB:
Insert Into Database.tablename (column1, column2)
Values (variable, variable2);
commit;
Perhaps try to write the item value (:datablock.itemname) directly into the sql statement instead of using a variable, but I am not sure if thats valid...
kat
|
|
|
|
| Re: connect item to DB manually [message #79912 is a reply to message #79892] |
Wed, 24 July 2002 08:27  |
Nasser
Messages: 3
Registered: July 2002
|
Junior Member |
|
|
Bonjour,
if I have understood ,you've choose the manually
method.
All,is in the property palette.
the principals node are:
1-General......item type(text,display,...etc)
2-Data..........Data type(char,number,date,....etc)
3-Database:
a-item datatype......true
b-column name........column's name(that you need to
connect)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
