Home » Developer & Programmer » Forms » Re: connect item to DB manually
Re: connect item to DB manually [message #79892] Mon, 22 July 2002 00:33 Go to next message
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 Go to previous message
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)
Previous Topic: reports:table name generated at runtime
Next Topic: Re: Run_product error
Goto Forum:
  


Current Time: Tue Nov 30 12:37:22 CST 2021