Recent content by DevTeam

I think the dump process excludes _hidden tables (SYS tables & metaschema tables)

I don't know if there's a way to display the table as easily as with a "static" buffer, but you can loop on each field and display its value (with NUM-FIELDS / BUFFER-FIELD(i):BUFFER-VALUE). EDIT : and I think you could avoid lots of GET-CURRENT in your example by replacing your REPEAT loop by...

_field._extent ...

Hi, It works for directories too. And you can know whether that's a file or a folder with http://www.progresstalk.com/showthread.php?t=114488 :)

Hi, You can also test the value of _EXTENT (available on _FIELD). EDIT : I also think that you can find all that you need inside _FIELD (_DATA-TYPE, _FORMAT, _WIDTH, ...)

I tried a limited version for 30 days, when the 10.1B was released. It was quite interesting to get syntax highlighting, completion and debugging. But I do not develop via appbuilder, so maybe those features are'nt new to you. Debugging was also made quite easier. And maybe the fact of using...

You may achieve this with the use of dynamic buffer & query : DEF INPUT PARAMETER mytable AS CHAR NO-UNDO. OUTPUT TO VALUE(mytable + ".sql"). DEF VAR bh AS HANDLE NO-UNDO. DEF VAR qh AS HANDLE NO-UNDO. DEF VAR lstChp AS CHAR NO-UNDO. DEF VAR cpt AS INT NO-UNDO. CREATE BUFFER bh FOR TABLE...

Hi, What about using a query, with "EXCLUSIVE-LOCK" on your GET FIRST / GET NEXT ? This may work the same way as your FOR EACH, but with the possibility of making your transaction smaller. Won't it return you always the same record ?

:lol: Thanks ! However I'm sure it is far slower than querying _file and _file.

What kind of object is TableCustomer ? A physical table ? A Temp-Table ?

You can achieve it through BUFFER-FIELD attributes : DEFINE VARIABLE columnName AS CHARACTER. DEFINE VAR bh AS WIDGET-HANDLE. DEFINE VARIABLE typeResult AS CHARACTER. columnName = "myTable.myField". CREATE BUFFER bh FOR TABLE ENTRY(1, columnName, "."). typeResult = bh:BUFFER-FIELD(ENTRY(2...

Did you try your idea of checking that each character is between "a" and "z" ? I seems to be correct, but it may not be the most efficient in response time... FUNCTION is_A_Z RETURNS LOGICAL (INPUT VarCh AS CHAR) : DEF VAR tmp AS CHAR NO-UNDO. DEF VAR cpt AS INTEGER NO-UNDO. DO cpt =...

Hi, Does anyone know what do "S", "V" and "T" values of this field stand for ? It isn't even mentioned in the documentation... Thanks in advance. Julien EDIT : Could it stand for "table", "systable" and "view" ?

I'd like to add to Thomas' post the fact that I had to deal with ROWID on the right side of the join (Java / JDBC) : SELECT * FROM pub.\"_field\" WHERE \"_file-recid\" = (SELECT ROWID FROM pub.\"_file\" WHERE \"_file-name\" = YourTableName)

Here you could use the OF statement FOR EACH table1 NO-LOCK WHERE table1.col1 = "hello", EACH table2 OF table1: /* blah. */ END.