Re: Variable field with 300 characters

Quoting RUCHI@CFRVM.CFR.USF.EDU... > > I have a one problem with INFORMIX/4GL that I don't know how to resolve it. > I have a note field that is 300 characters long so when the form was generated > it splitt into 4 lines. I am using the > > DEFINE item RECORD LIKE project.* > > SQL table has a column ITEM defined as 300 chracters long. I have the following > insert statement which fails. So, how should I write the variable name for > NOTE field in Insert statement? Remeber, I have 4 lines in form. > > INSERT INTO project VALUES (project.project_no, project.note)> Well looking at your example... "project" is not the name of your record, "item" is. Usually if I do a "DEFINE item RECORD LIKE project.*" I also do a "INSERT INTO project VALUES (item.*)" DAS -- David A. Snyder @ Snide Inc. - Folcroft, PA Current Release is db4glgen-3.2 UUCP: ..!uunet!das13!dave INTERNET: Dave.Snyder@snide.com