Search results

I think this works: "SELECT * FROM ConRepor WHERE ConRepor.AppDate >= {d '2002-02-21'}"

I had the same problem a while back, however, I can't remember exactly how I solved the problem as I don't have the code at hand. If my memory serves me right I used the {FN} syntax in the SQL statement. What this allows you to do is include functions in the SQL statement as follows...

The code below should help. DEFINE VARIABLE vFile AS CHARACTER EXTENT 3. DEFINE STREAM strInput. INPUT STREAM strInput FROM OS-DIR("c:\"). REPEAT: IMPORT STREAM strInput vFile. DISPLAY vFile[1] vFile[2] vFile[3 ]. END. Each input has three elements: the file name, the...

Set up an ODBC connection to the database using either the progress merant driver or openlink. Then use the ODBC connection in crystal reports to connect to the database.

when you are using {&OUT} to have webspeed output any javascript you have to use ~ in front of the end tag of script. The code below shows this: {&OUT} '<script language="javascript">' 'window.opener.AddItem("' branch.branchname '","' branch.branchcode '",true);'...

It looks to me like you are using the HTML Mapping feature in progress. I don't use this to develop in Webspeed so I can't help you. One question though, how are you finding the record. What is the code you are using as I can only assume it is this which is causing the problem. I don't...

Please let us know what code you are using to find the record that you click on. In my webspeed programs, I use the ROWID to find the record that I want. When you click on the record that you want, submit the ROWID of the record and use this to retrieve the correct record. Depending on how...

Where in my code does it mention storing the password in a cookie. I agree with what you say however, that cookies should not be used to store secure information. However, I totally disagree with people who go on about how others can gain access to cookies on your pc and then use information...

The following code will go through every entry in the outlook contacts folder and message the name and email address. DEFINE VARIABLE hOutlook AS COM-HANDLE NO-UNDO. DEFINE VARIABLE hNameSpace AS COM-HANDLE NO-UNDO. DEFINE VARIABLE hFolder AS COM-HANDLE NO-UNDO. DEFINE...

Try this: for each a no-lock: for each b no-lock where a.field1 = b.field1 and a.field2 = b.field2 and b.field1 = ?: display a.field1 a.field2 b.field1 b.field2. end. If the index fields are in both tables you should be able to use...

You might want to consider using the Openlink driver to connect to a progress database. We have used both Merant & Openlink and found that the Merant driver does not perform as well as the Openlink driver. The Merant driver might be easier to setup than Openlink but it is slower and has...

You can also turn most system prompts off by using the following command: <com-handle>:DisplayAlerts = true/false.

You can do what you want. All you need to do is use the INPUT command. This will allow you to read a file into Progress a line at a time and then search the line of text for your numbers. For example: DEFINE VARIABLE vData AS CHARACTER NO-UNDO. INPUT FROM "c:\samplereport.txt"...