Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to force a field to be an INTEGER in form ?
Hello everybody, I've got one more problem. it's in a form (a screen) : the probleme is simple : at the beginnig we used a column which was an integer so in the screen we can only enter 10 or 15 or 1000 but never 10.12 15.89 etc.. using this line : f026 = TOTO.qte_disp, AUTONEXT, COMMENTS =...- ziguy
- Thread
- Replies: 2
- Forum: Informix solutions
-
DEFINE DEFAULT VALUE IN sql/4gl STATEMENT
Thank a lot for your help. Effectivly, it's work going like that. I can't understand why it wasn't working initialy ... but here compiler are really special with patch and patch of patch .. etc ... whatever thank !!! I give you the star of the week !!- ziguy
- Post #5
- Forum: Informix solutions
-
DEFINE DEFAULT VALUE IN sql/4gl STATEMENT
Thank you for your reply but it doesn't work . this my 4gl prog: DATABASE mercure MAIN DEFINE TOTO SMALLINT LET TOTO = 0 CREATE TEMP TABLE nico3 ( COL1 SMALLINT DEFAULT 10 NOT NULL , COL2 CHAR(10) ) but I've got the same probleme when compiling : CREATE TEMP TABLE nico3 ( COL1...- ziguy
- Post #3
- Forum: Informix solutions
-
DEFINE DEFAULT VALUE IN sql/4gl STATEMENT
Hello, I really need to know how to use a default value in a sql/4gl statement. With dbaccess I can do: CREATE TABLE table_name ( Col1 smallint NOT NULL DEFAULT 10 , Col2 char(10) ); But when in a 4gl prog. the compiler crash and say error 4373 like this : Col1 smallint NOT...- ziguy
- Thread
- Replies: 4
- Forum: Informix solutions
