Recent content by terry9636

I need to be liittle more explicit in what I am trying to accomplish. I would like to store tt.y = "string(month(today)) + string(day(today))" or i might want tt.y = "<dbtable.fieldname> format "99999"" or tt.y might need to be "space(40) + <dbfield> format "X"". So it needs to evaluate the...

I am looking to write code that generates output based on user-define values and formatting. I am using a dynamic query with dynamic temp-tables. I will be storing format statements, fill() expressions, if..then..else, etc as it is user defined. I am having difficulty getting the code to...

I am encountering the same issue on a OE 10.1 database using a 4gl application. Data type = decimal with 4 positions. Initial Value = 100.0000. When add-record fires, the field-value is all ?????????. When the record is viewed in the DB, it is 1000000.0000.

With SQL, use "in" for your operator. Ie, select zipcd, city from stateList where state in ('ND','SD','MN')

I have figured out a way to implement Progress can-find statements into my Query. The Problem: I needed to query a table display results, but in order for the result to be valid, It could not exist in another table. A direct can-find or a User-defined function would have been...