Search results

I have a database that I attempted to dump the data in the database admin tools and the .d ended up being LARGER then the actual database files. I've never seen this before...the database files have ALWAYS been larger then the dumped data...and the .d ended up containing several million lines...

Without the Space before the nValue & pValue it works as you would expect. BUT...with the space before the two values it does NOT return the minimum value correctly for the nValue but does for the pValue. If you run the code you will see the difference. Here I forgot the declaration for the...

I would use a Freeform Query in the Browse then load it using a Dynamic Query. DEFINE VARIABLE sQuery AS CHARACTER NO-UNDO. DEFINE VARIABLE qString AS CHARACTER NO-UNDO. DEFINE VARIABLE hQuery AS HANDLE NO-UNDO. qString = SUBSTITUTE("FOR EACH Table &1 NO-LOCK &2...

I found one today that made me to a WTF to. You guys might get a nice chuckle out of. ASSIGN Element[1] = "16" Element[2] = "17" Element[3] = "18". REPEAT loopCT = 1 TO 3: BuiltString1 = BuiltString1 + MIN(" OR ", BuiltString1) + " nValue = " + Element[loopCT]...

;) You guys need to get out more!

I figured it out...inorder to get the ROW number of the row you are in in a browser is DEFINE VAR iTest AS INT. iTEST = br-Test:FOCUSED-ROW. Then you can REPOSITION to ROW iTEST

That really wouldn't get me what I need...I'm actually trying to find out what the row number is of the record I am on in a browser so I could reposition to row n. Where n would be that row. They give the ability to say Reposition to row n: Reposition to ROW 1. //Which would reposition...

Hello everyone, I have a browser and I would like to reposition to the next row in a browser when modifying the record. In many cases the record I am working on is no longer available in the browser when I do the Open Query and repopulate the browser so a Select-Next-Row would not help...

I have a browser that I want to refresh every 5 minutes, so i dropped a PSTimer on the main frame and set the interval to 300,000. On Tick it refeshes the browser. It seems that the Trigger tick is actually going off ever 10 seconds or so. Did I do something wrong? Anyone have any ideas as...

I have a set of Time fields, we will say TableName.ArriveTime Char X(8) TableName.DepartedTime Char X(8) The data inside these fields look like the following (Military Time) 0400 1200 1300 0800 I placed these fields in a Free-Form Query Browser, as editable...

Thanks! I will check this out.

I need to find the current column in a browser. I know I can get the current column by getting the handle, but that is on when you click on the column label. DEFINE VARIABLE h-Column AS HANDLE NO-UNDO. h-Column = br-test:CURRENT-COLUMN...

FOR EACH customer BREAK BY location: IF FIRST(location) THEN DO: // This code will be executed on the first record in the loop. // Will only fire one time. END. IF FIRST-OF(location) THEN DO: // This code will be executed on the first...

What is the actual size (bytes) that progress stores it's integers and devimal values? Jenifer

I am using a product called active PDF to generate PDF files. When generating Report Building files to a PDF it works fine, however when generating a word document to a pdf I have experianced some problems. I have been able to recreate the error EVERY time. The first time I run the procedure...

Never mind I'm just gonna loop through the fields and do an if statment. Wish buffer-compare had the option of not checking the format/type of field.

There's a command called bell

One more thing... Is there a way to validate of a field is in a table? I have a statement myGenericHandle = bufImportTable:BUFFER-FIELD(DynamicTempOrdersAssign.MappingField). I don't really care about the handle, I just want to know if the field exsists in the table. I know I could...

The disadvantage of using the table interface is when you have multiple users you can not tell one print job from another it's a mess. Our products have reporting screens and able to get just about any result needed by using the procedure interface.

Thanks Simon! Perfect!!!!! I appriciate both of your help!