Search results

Hi Istvan, thanks for the tip, but there is no such table in the DB (maybe wrong version - 8.2B). Is there another way to find it out?

Hallo, is it possible to find out the number of connected users to a DB from within a program?

Hi Oliver, you can use the DBPARAM function. It returns a comma–separated list of the parameters used to connect to the database. SYNTAX DBPARAM(integer-expression|logical-name|alias)

Hi, you can overcome this problem by moving some code to internal procedures (each has it's own code segment) and/or by optimizing the code i.e. instead of: i = 1. j = 2. k = "x". use: assign i = 1 j = 2 k = "x" . it takes less space in action segment

Hi, how about this solution: DEFINE VARIABLE slSort AS CHARACTER VIEW-AS SELECTION-LIST SINGLE SORT SIZE 1 BY 1 NO-UNDO. DEFINE VARIABLE slRows AS CHARACTER VIEW-AS SELECTION-LIST SINGLE SIZE 1 BY 1 NO-UNDO. DEFINE FRAME xxx slSort slRows. DEFINE BUFFER buf FOR...

Hi Rob, how about this simple solution (there may be better, but this one works (more or less) ) : def var i as int no-undo. do i = asc("c") to asc("z"): file-info:file-name = chr(i) + ":\.". if file-info:full-pathname <> ? and index(file-info:file-type, "d") <> 0 then message "drive "...

No that wouldn't work, because if table.name = "andré" it doesn't match freply("andré"). How about this combined solution: def var x as char no-undo. def var y as char no-undo. x = freply("andré"). y = freply1(x). for each table where table.name matches y no-lock: if...

Unfortunatelly this isn't possible. The attribute exists (selection-list:multiple), but it's read-only (setable only before realization). I think you will just have to do it with two selection-lists.

Hi, no it's not possible directly, but you might want to check this site http://www.global-shared.com/api/ or to be more precise http://www.global-shared.com/api/folder.html for a workaround.

It's almost perfect, but if someone was born on 29 february and this year is not leap year it will not work. See my previous post and take years instead of age as a result.

Maybe the links to the images are broken. Othewise I don't know.

Try this: years = YEAR(TODAY). lastbirthday = DATE(MONTH(birthday), DAY(birthday), years) NO-ERROR. IF ERROR-STATUS:ERROR THEN lastbirthday = DATE(2, 28, years). IF lastbirthday > TODAY THEN DO: lastbirthday = DATE(MONTH(birthday), DAY(birthday), years - 1) NO-ERROR. IF...